DW_Lecture1.

Data Warehouse (DW)

A system used for reporting and data analysis that acts as a central repository for data extracted from various sources.

ETL (Extract-Transform-Load)

The process of extracting data from different sources, transforming it into a suitable format, and loading it into a data warehouse.

OLAP (Online Analytical Processing)

A technology that enables users to analyze multidimensional data from multiple perspectives.

OLTP (Online Transaction Processing)

A class of software applications capable of supporting transaction-oriented programs.

Distributed Data

Data that is stored across multiple locations and formats.

Data Integration

The process of combining data from different sources into a unified view.

Subject-Oriented

A characteristic of data warehouses that organizes data around the key subjects of the business.

Non-Volatile Data

Data in a data warehouse that is not updated or deleted, but can only be appended.

Time-Variant

A characteristic that indicates the data in a warehouse changes over time and allows tracking of historical changes.

Data Cleansing

The process of detecting and correcting corrupt or inaccurate records in a dataset.

Business Intelligence (BI)

Technologies and strategies used by enterprises for data analysis of business information.

DSS (Decision Support System)

An information system that supports business or organizational decisions.

Data Mart

A subset of a data warehouse focused on a specific business line or team.

Data Repository

A central place where data is stored and managed.

Operational Data Store (ODS)

A database designed to integrate data from multiple sources for additional operations on the data.

Analytics

The discovery, interpretation, and communication of meaningful patterns in data.

Data Architecture

The structure of an organization's data assets and how they are organized and utilized.

Data Stewardship

The management and oversight of an organization's data assets.

Data Lifecycle Management

Policy-based approach to managing the flow of data throughout its lifecycle.

Big Data

Extremely large data sets that may be analyzed computationally to reveal patterns, trends, and associations.

Data Visualization

The graphical representation of information and data.

Historical Data

Data that has been collected over time and is maintained for analysis.

Market Analysis

The assessment and evaluation of market conditions.

Data Mining

The practice of examining large databases to generate new information.

Storage Architecture

The design of the data storage system that defines how the data is retained.

Harmonization

The process of aligning data formats and data types across different systems.

Application Systems

Software programs designed to perform specific tasks for users.

Performance Optimization

The process of improving system efficiency and speed during data processing.

Cloud Data Warehousing

Storing data in a cloud-based environment, enabling scalable and flexible access.

Snapshot

A state of system or database at a specific point in time.

Data Governance

The management of data availability, usability, integrity, and security in an enterprise.

Scalability

The ability of a system to handle a growing amount of work or its potential to accommodate growth.

User-Friendly Interface

A design feature that allows users to interact with software or hardware smoothly and intuitively.