EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Data Warehouse Tutorial Types of Data Warehouse
Secondary Sidebar
Data Warehouse Tutorial
  • Basic
    • What is Data Warehouse
    • Data Warehouse tools
    • Career in Data Warehousing
    • Benefits of Data Warehouse
    • Data Warehouse Architecture
    • Data Warehouse Design
    • Data Warehouse Implementation
    • Data Warehouse Features
    • Data Warehouse Modeling
    • Data Warehouse Software
    • Data Warehousing
    • Types of Data Warehouse
    • 10 Popular Data Warehouse Tools
    • Data Lake Architecture
    • Three Tier Data Warehouse Architecture
    • Data Warehouse Process
    • Database Parallelism
    • What is OLTP
    • What is OLAP
    • OLAP Tools
    • Types of OLAP
    • Operations in OLAP
    • MOLAP
    • HOLAP
    • Data Warehouse Schema
    • Data Warehouse Components
    • Snowflake Schema
    • Snowflake Architecture
    • What is Star Schema
    • Galaxy Schema
    • What is Fact Table
    • Kimball Methodology
    • Data Warehouse Testing
    • Operational Data Stores
  • ETL
    • What is Data Mart
    • What is Data Cube
    • What is a Data Lake
    • What is Data Integration
    • What is ETL
    • What is ETL Testing
    • ETL Testing Tools
    • ETL architecture
    • Dimension Table
    • Multidimensional Data Model
    • Fact Constellation Schema
    • ETL Process
  • Interview Questions
    • Data Warehouse Interview Questions
    • ETL Interview Questions
    • ETL Testing Interview Questions
    • Data Warehousing Interview Questions

Related Courses

Business Intelligence Course

All in One Data Science Course

Data Visualization Certification Courses

Types of Data Warehouse

By Aanchal SinghAanchal Singh

types of data warehouse

Introduction to Types of Data Warehouse

Different types of Data Warehouse is nothing but the implementation of a Data Warehouse in various ways such as, namely Data Marts, Enterprise Data Warehouse & Operational Data Stores, which allows the Data Warehouse to be the vital module for Business Intelligence (BI) systems, by performing the process of constructing, managing and performing functional changes on the data from numerous data source that helps in generating reports and Analytical results for significant decision making measures essential for the Business professionals.

Data Warehouse Types

There are three types of data warehouse:

  • Enterprise Data Warehouse.
  • Operational Data Store.
  • Data Mart.

Enterprise Data Warehouse

1. Enterprise Data Warehouse

An Enterprise database is a database that brings together varied functional areas of an organization and brings them together in a unified manner. It is a centralized place where all business information from different sources and applications are made available. Once it is stored they can be used for analytics and can be used by all the people across the organization. The data can be classified according to the subject and it gives access as per the necessary division. An Enterprise Datawarehouse will already have the steps of extracting, transforming and conforming already handled.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

The goal of EDW is to provide a complete overview of any particular object in the data model. This is accomplished by identifying and wrangling the data from different systems. This is then loaded into a consistent and conformed model. After all the information is gathered by EDW which has the capability of providing access to a single location where different tools can be used to perform analytical functions and create different predictions. The research teams can identify new trends or patterns and focus on them to help the business grow.

Data Marts can be built which make it easier to segregate the data, Relationships between entities can be established and enforced as a part of loading data into EDW. In addition to this slicing and dicing of codes as per different categories can also be done. Also, it helps in reducing costly downtime which may occur due to error-prone configurations with adaptive and machine learning approaches as well. It structures data which helps in operating on a relatively small scale, organization and structure it. The data is stored in a logical and consistent manner.

Operational Data Store

2. Operational Data Store

As an alternative to having an operational decision support system application an operational data store is used. It helps in accessing data directly from the database which also supports transaction processing. The data which is present in the Operational Data Store can be scrubbed and the redundancy which is present can be checked and resolved by checking the corresponding business rules. It also helps in integrating contrasting data from multiple sources so that business operations, analysis, and reporting can be easily carried out and help the business while the process is still in continuation.

Here most of the operations which are currently being performed are stored before they are moved to the data warehouse for a longer duration. It helps effectively on simple queries and small amounts of data. It acts as a short term or temporary memory which stores the recent information. The data warehouse stores the data for a comparatively long time and also stores relatively permanent information.

It helps in storing transactional data from one or more production systems and loosely integrates it. It is sometimes subject oriented and time variant. The integration is achieved by making use of EDW structures and contents. The integration of data can involve cleansing, resolving redundancy, checking business rules for integrity. It is usually designed to contain low-level atomic data that stores limited data.

data mart

3. Data Mart

Data Mart focuses on storing data for a particular functional area and it contains a subset of data that is stored in a data warehouse. Data Marts help in enhancing user responses and also reduces the volume of data for data analysis. It makes it easier to go ahead with the research. Data Mart being a subset of Datawarehouse is easy to implement. It is cost-effective when compared with a complete data warehouse. It is more open to change, and a single subject matter expert can define its structure and configuration. The data is partitioned, and the granularity can be easily controlled. Data Mart has three types. These types are:

  • Dependent
  • Independent
  • Hybrid

Dependent Data Mart

By getting data from operational, external or both sources a dependent data mart can be created. It allows the sourcing organization’s data from a single data warehouse. All data is centralized and can help in developing more data marts.

Independent Data Mart

This data mart does not require a central data warehouse. This is usually created for smaller groups which are present within an organization. It does not have any relationship with Enterprise Data Warehouse or any other data mart. All data is independent and can be used separately. Also, the analysis can be performed autonomously. To have a consistent and centralized store of data is very important so that multiple users can use it.

Hybrid Data Mart

As the name suggests a hybrid data mart is used when inputs from different sources are a part of a data warehouse. It is useful when a user wants an ad hoc integration. Whenever an organization needs multiple database environments and fast implementation then this setup can be used. It requires the least data cleansing effort and the data mart supports large storage structures. The best usage of a data mart is when smaller data-centric applications are being used.

Conclusion

A data warehouse is thus a very important component in the data industry. As database helps in storing and processing data, a data warehouse helps in analyzing it. Data warehouse thus helps in getting business trends and patterns which can later be presented in the form of reports which provide insight for how to go ahead in the process of business growth. Data warehouse thus plays a vital role in creating a touch base in the data industry.

Recommended Articles

This has been a guide to Types of Data Warehouse. Here we discussed the basic concepts, with different types of DataWarehouse. You can also go through our other suggested articles to learn more –

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,527 ratings)
  1. What is Data Analyst?
  2. Introduction to What is SQL Server?
  3. What is MapReduce? | How it Works
  4. Tutorials on What is Cognos?
  5. Testing Methodologies of Data Warehouse Testing
Popular Course in this category
All in One Data Science Bundle (360+ Courses, 50+ projects)
  360+ Online Courses |  1500+ Hours |  Verifiable Certificates |  Lifetime Access
4.7
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more