🛠️ Data Warehousing Tools

📄 Metadata → Describe the structure and some meaning about data
📌 Metadata is “data about data”, describing its source, structure, transformation rules, etc.

🧩 Data Marts → Subset of a data warehouse, typically consisting of a single subject area
📌 Data Marts are a summarized or highly focused portion of an organization’s database for a specific population of users

🛠️ Operational Data Store (ODS) → Provides a fairly recent form of customer information file and is used as an interim staging area
📌 ODS is used for operational reporting and supports current or near real-time decision-making.

🏢 Enterprise Data Warehouse (EDW) → Provides integration of data from many sources into a standard format
📌 EDW is a centralized repository for all organizational data, fully integrated and standardized.

📊 OLAP → Supports multidimensional data and enables users to view the same data in different ways using multiple dimensions
📌 OLAP allows users to perform operations like drill-down, roll-up, and slice & dice on multidimensional data.

🧱 Hadoop → Breaks a big data problem down into sub-problems, distributes them among thousands of inexpensive processing nodes, and combines results
📌 Hadoop uses the MapReduce model and is ideal for processing huge datasets across distributed systems.