Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

Data Mart

Lesson 4 of 32 in the free Data Warehousing and Data Mining(Elective-II) notes on Siksha Sarovar, written by Rohit Jangra.

---

4. Data Mart

4.1 Definition

A Data Mart is a subset of a Data Warehouse. While a Data Warehouse serves the entire enterprise, a Data Mart is designed to serve the needs of a specific department or a distinct user group (e.g., the Marketing Data Mart, Finance Data Mart).

4.2 Types of Data Marts

  1. Dependent Data Mart: Data is sourced directly from the central Enterprise Data Warehouse. This ensures data consistency across the organization.
  2. Independent Data Mart: Data is sourced directly from operational systems or external sources, bypassing the central Data Warehouse. (This is generally discouraged as it leads to "silos" and inconsistent data).
  3. Hybrid Data Mart: Combines inputs from both the central Data Warehouse and other operational systems.

4.3 Data Warehouse vs. Data Mart

ParameterData WarehouseData Mart
ScopeEnterprise-wide (Multiple departments).Department-wide (Single business unit).
SizeVery Large (Terabytes).Smaller (Gigabytes).
ComplexityHigh complexity in design and maintenance.Lower complexity; easier to implement.
Time to BuildLong duration (Months to Years).Short duration (Weeks to Months).
SourceHeterogeneous sources (ERP, CRM, Flat files).Data Warehouse (Dependent) or Operational sources.
CostExpensive to build and maintain.Cheaper.