Data Warehouse Architecture

  • Data warehousing indicates the whole set of interrelated activities involved in designing, implementing, and using a data warehouse.
  • The data warehouse itself, together with additional data marts. Data marts contain the data and the functions that allow the data to be accessed visualized and perhaps modified.
  • The top-down methodology is based on the overall design of the data warehouse.
  • It is time-consuming and more time required for the initial set up.
  • This model contains consistent data marts and these data marts can be delivered quickly.
  • Data is cleansed, transformed, and loaded into this layer using back-end tools.
  • The mixed methodology is based on the overall design of the data warehouse within a prototyping approach.
  • This approach is highly practical and usually preferable.
  • ETL performs three main functions Extraction Transformation and Loading of data into the data warehouse.
  • Extraction- Data are extracted from the available internal and external sources.
  • Transformation- The goal of the cleaning and transformation phase is to improve the quality of data extracted from the different sources.
  • Loading- After extraction and transformation, data are loaded into the tables of the data warehouse.
  • Metadata is simply defined as data about data. The data that is used to represent other data is known as metadata.
  • In the Data Warehouse Architecture, meta-data plays an important role as it specifies the source, usage, values, and features of data warehouse data. It also defines how data can be changed and processed. It is closely connected to the data warehouse.
  • Metadata helps in the decision support system for the mapping of data when data is transformed from the operational environment to the data warehouse environment.
  • Metadata also helps in summarization between lightly detailed data and highly summarized data.




Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

In-Sprint test automation even possible? Try these 5 easy steps.

The need for change (at Qxf2)

SingularityNET — Q1 2022 Operations Update

What’s RDS Multi-AZ?

Basic HTTP methods that are essential in IT

Linux Ansible Playbooks 01

How to sleep Arduino Nano BLE 33…

How to Improve Programming Skills by Understanding Top 4 Qualities of a 10x Programmer!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Vaishali Goilkar

Vaishali Goilkar

More from Medium

Data Warehouse / ETL jobs are changing ? Are you ready ?

Basics of Data Modeling in Relational Data Base Management System

Data Modeling

Data Mesh Architecture: Roles and Strategies