ๅฐŠๆ•ฌ็š„ ๅพฎไฟกๆฑ‡็Ž‡๏ผš1ๅ†† โ‰ˆ 0.046078 ๅ…ƒ ๆ”ฏไป˜ๅฎๆฑ‡็Ž‡๏ผš1ๅ†† โ‰ˆ 0.046168ๅ…ƒ [้€€ๅ‡บ็™ปๅฝ•]
SlideShare a Scribd company logo

Data warehouse architecture

โ€ขDownload as PPT, PDFโ€ข
โ€ข
U
uncleRhyme

The document discusses different data warehouse architectures that can vary based on the layers included. A basic data warehouse architecture contains five main layers: the system operation layer, metadata layer, data source layer, ETL layer, and data warehouse/storage layer. Other common layers seen in more complex architectures include the staging layer, extraction layer, data mart layer, data logic layer, and data presentation layer.

Education
1 of 7
Data warehouse Architecture
Data warehouse Architecture Different data warehousing systems have different structures. Some may have an ODS (operational data store), while some may have multiple data marts. Some may have a small number of data sources, while some may have dozens of data sources. A data warehouse architecture will differ mainly on the layers included in the architecture.
Basic Data warehouse Data WarehouseData Warehouse MarketingMarketing Sales and Inventory Sales and Inventory Social MediaSocial Media Data Source Layer ETL Layer Data Warehouse Layer Metadata layer System Operation layer
Data warehouse W/ Staging Data WarehouseData Warehouse MarketingMarketing Sales and Inventory Sales and Inventory Social MediaSocial Media Data Source Layer ETL Layer Data Warehouse Layer Staging DB Staging DB Staging Layer Metadata layer System Operation layer
Data warehouse W/ Staging and data Mart Data WarehouseData Warehouse MarketingMarketing Sales and Inventory Sales and Inventory Social MediaSocial Media Data Source Layer ETL Layer Data Warehouse Layer Staging DB Staging DB Staging Layer Data MartData Mart Data MartData Mart Data MartData Mart Data Mart Layer Metadata layer System Operation layer
Data Warehouse Architecture layers Basic: โ€ขSystem Operation Layer โ€ขMetadata Layer โ€ขData Source Layer โ€ขETL Layer โ€ขData Warehouse / Storage Layer
Data Warehouse Architecture layers Other Layers: โ€ขStaging Layer โ€ขExtraction Layer โ€ขData Mart Layer โ€ขData Logic Layer โ€ขData Presentation Layer

Recommended

Data Warehouse Architectures
Data Warehouse ArchitecturesData Warehouse Architectures
Data Warehouse Architectures
Theju Paul
ย 
1.4 data warehouse
1.4 data warehouse1.4 data warehouse
1.4 data warehouse
Krish_ver2
ย 
Ppt
PptPpt
Ppt
bullsrockr666
ย 
Data warehouse architecture
Data warehouse architecture Data warehouse architecture
Data warehouse architecture
janani thirupathi
ย 
Data Warehousing and Data Mining
Data Warehousing and Data MiningData Warehousing and Data Mining
Data Warehousing and Data Mining
idnats
ย 
Data warehouse architecture
Data warehouse architectureData warehouse architecture
Data warehouse architecture
pcherukumalla
ย 
Introduction to Data Warehouse
Introduction to Data WarehouseIntroduction to Data Warehouse
Introduction to Data Warehouse
Shanthi Mukkavilli
ย 
Multidimentional data model
Multidimentional data modelMultidimentional data model
Multidimentional data model
jagdish_93
ย 

Recommended

Data Warehouse Architectures
Data Warehouse ArchitecturesData Warehouse Architectures
Data Warehouse Architectures
Theju Paul
ย 
1.4 data warehouse
1.4 data warehouse1.4 data warehouse
1.4 data warehouse
Krish_ver2
ย 
Ppt
PptPpt
Ppt
bullsrockr666
ย 
Data warehouse architecture
Data warehouse architecture Data warehouse architecture
Data warehouse architecture
janani thirupathi
ย 
Data Warehousing and Data Mining
Data Warehousing and Data MiningData Warehousing and Data Mining
Data Warehousing and Data Mining
idnats
ย 
Data warehouse architecture
Data warehouse architectureData warehouse architecture
Data warehouse architecture
pcherukumalla
ย 
Introduction to Data Warehouse
Introduction to Data WarehouseIntroduction to Data Warehouse
Introduction to Data Warehouse
Shanthi Mukkavilli
ย 
Multidimentional data model
Multidimentional data modelMultidimentional data model
Multidimentional data model
jagdish_93
ย 
Date warehousing concepts
Date warehousing conceptsDate warehousing concepts
Date warehousing concepts
pcherukumalla
ย 
Building a modern data warehouse
Building a modern data warehouseBuilding a modern data warehouse
Building a modern data warehouse
James Serra
ย 
Centralised and distributed database
Centralised and distributed databaseCentralised and distributed database
Centralised and distributed database
Santosh Singh
ย 
Data partitioning
Data partitioningData partitioning
Data partitioning
Vinod Wilson
ย 
Data Warehouse Basic Guide
Data Warehouse Basic GuideData Warehouse Basic Guide
Data Warehouse Basic Guide
thomasmary607
ย 
Data Warehouse Architecture.pptx
Data Warehouse Architecture.pptxData Warehouse Architecture.pptx
Data Warehouse Architecture.pptx
22PCS007ANBUF
ย 
Data warehousing and data mart
Data warehousing and data martData warehousing and data mart
Data warehousing and data mart
Amit Sarkar
ย 
Clustering in data Mining (Data Mining)
Clustering in data Mining (Data Mining)Clustering in data Mining (Data Mining)
Clustering in data Mining (Data Mining)
Mustafa Sherazi
ย 
Etl techniques
Etl techniquesEtl techniques
Etl techniques
mahezabeenIlkal
ย 
1.2 steps and functionalities
1.2 steps and functionalities1.2 steps and functionalities
1.2 steps and functionalities
Krish_ver2
ย 
ETL Process
ETL ProcessETL Process
ETL Process
Rashmi Bhat
ย 
Data warehouse
Data warehouseData warehouse
Data warehouse
krishna kumar singh
ย 
3. mining frequent patterns
3. mining frequent patterns3. mining frequent patterns
3. mining frequent patterns
Azad public school
ย 
Exploratory data analysis
Exploratory data analysis Exploratory data analysis
Exploratory data analysis
Peter Reimann
ย 
Data warehousing and online analytical processing
Data warehousing and online analytical processingData warehousing and online analytical processing
Data warehousing and online analytical processing
VijayasankariS
ย 
Data Warehouse 101
Data Warehouse 101Data Warehouse 101
Data Warehouse 101
PanaEk Warawit
ย 
Data Modeling PPT
Data Modeling PPTData Modeling PPT
Data Modeling PPT
Trinath
ย 
Data Vault Introduction
Data Vault IntroductionData Vault Introduction
Data Vault Introduction
Patrick Van Renterghem
ย 
Data warehouse
Data warehouseData warehouse
Data warehouse
shachibattar
ย 
Data mining
Data miningData mining
Data mining
Ritesh Tiwari
ย 
Data ware housing- Introduction to data ware housing
Data ware housing- Introduction to data ware housingData ware housing- Introduction to data ware housing
Data ware housing- Introduction to data ware housing
Vibrant Technologies & Computers
ย 
Microblogging
MicrobloggingMicroblogging
Microblogging
uday p
ย 

More Related Content

What's hot

Date warehousing concepts
Date warehousing conceptsDate warehousing concepts
Date warehousing concepts
pcherukumalla
ย 
Building a modern data warehouse
Building a modern data warehouseBuilding a modern data warehouse
Building a modern data warehouse
James Serra
ย 
Centralised and distributed database
Centralised and distributed databaseCentralised and distributed database
Centralised and distributed database
Santosh Singh
ย 
Data partitioning
Data partitioningData partitioning
Data partitioning
Vinod Wilson
ย 
Data Warehouse Basic Guide
Data Warehouse Basic GuideData Warehouse Basic Guide
Data Warehouse Basic Guide
thomasmary607
ย 
Data Warehouse Architecture.pptx
Data Warehouse Architecture.pptxData Warehouse Architecture.pptx
Data Warehouse Architecture.pptx
22PCS007ANBUF
ย 
Data warehousing and data mart
Data warehousing and data martData warehousing and data mart
Data warehousing and data mart
Amit Sarkar
ย 
Clustering in data Mining (Data Mining)
Clustering in data Mining (Data Mining)Clustering in data Mining (Data Mining)
Clustering in data Mining (Data Mining)
Mustafa Sherazi
ย 
Etl techniques
Etl techniquesEtl techniques
Etl techniques
mahezabeenIlkal
ย 
1.2 steps and functionalities
1.2 steps and functionalities1.2 steps and functionalities
1.2 steps and functionalities
Krish_ver2
ย 
ETL Process
ETL ProcessETL Process
ETL Process
Rashmi Bhat
ย 
Data warehouse
Data warehouseData warehouse
Data warehouse
krishna kumar singh
ย 
3. mining frequent patterns
3. mining frequent patterns3. mining frequent patterns
3. mining frequent patterns
Azad public school
ย 
Exploratory data analysis
Exploratory data analysis Exploratory data analysis
Exploratory data analysis
Peter Reimann
ย 
Data warehousing and online analytical processing
Data warehousing and online analytical processingData warehousing and online analytical processing
Data warehousing and online analytical processing
VijayasankariS
ย 
Data Warehouse 101
Data Warehouse 101Data Warehouse 101
Data Warehouse 101
PanaEk Warawit
ย 
Data Modeling PPT
Data Modeling PPTData Modeling PPT
Data Modeling PPT
Trinath
ย 
Data Vault Introduction
Data Vault IntroductionData Vault Introduction
Data Vault Introduction
Patrick Van Renterghem
ย 
Data warehouse
Data warehouseData warehouse
Data warehouse
shachibattar
ย 
Data mining
Data miningData mining
Data mining
Ritesh Tiwari
ย 

What's hot (20)

Date warehousing concepts
Date warehousing conceptsDate warehousing concepts
Date warehousing concepts
ย 
Building a modern data warehouse
Building a modern data warehouseBuilding a modern data warehouse
Building a modern data warehouse
ย 
Centralised and distributed database
Centralised and distributed databaseCentralised and distributed database
Centralised and distributed database
ย 
Data partitioning
Data partitioningData partitioning
Data partitioning
ย 
Data Warehouse Basic Guide
Data Warehouse Basic GuideData Warehouse Basic Guide
Data Warehouse Basic Guide
ย 
Data Warehouse Architecture.pptx
Data Warehouse Architecture.pptxData Warehouse Architecture.pptx
Data Warehouse Architecture.pptx
ย 
Data warehousing and data mart
Data warehousing and data martData warehousing and data mart
Data warehousing and data mart
ย 
Clustering in data Mining (Data Mining)
Clustering in data Mining (Data Mining)Clustering in data Mining (Data Mining)
Clustering in data Mining (Data Mining)
ย 
Etl techniques
Etl techniquesEtl techniques
Etl techniques
ย 
1.2 steps and functionalities
1.2 steps and functionalities1.2 steps and functionalities
1.2 steps and functionalities
ย 
ETL Process
ETL ProcessETL Process
ETL Process
ย 
Data warehouse
Data warehouseData warehouse
Data warehouse
ย 
3. mining frequent patterns
3. mining frequent patterns3. mining frequent patterns
3. mining frequent patterns
ย 
Exploratory data analysis
Exploratory data analysis Exploratory data analysis
Exploratory data analysis
ย 
Data warehousing and online analytical processing
Data warehousing and online analytical processingData warehousing and online analytical processing
Data warehousing and online analytical processing
ย 
Data Warehouse 101
Data Warehouse 101Data Warehouse 101
Data Warehouse 101
ย 
Data Modeling PPT
Data Modeling PPTData Modeling PPT
Data Modeling PPT
ย 
Data Vault Introduction
Data Vault IntroductionData Vault Introduction
Data Vault Introduction
ย 
Data warehouse
Data warehouseData warehouse
Data warehouse
ย 
Data mining
Data miningData mining
Data mining
ย 

Viewers also liked

Data ware housing- Introduction to data ware housing
Data ware housing- Introduction to data ware housingData ware housing- Introduction to data ware housing
Data ware housing- Introduction to data ware housing
Vibrant Technologies & Computers
ย 
Microblogging
MicrobloggingMicroblogging
Microblogging
uday p
ย 
Data Mining and Data Warehousing (MAKAUT)
Data Mining and Data Warehousing (MAKAUT)Data Mining and Data Warehousing (MAKAUT)
Data Mining and Data Warehousing (MAKAUT)
Bikramjit Sarkar, Ph.D.
ย 
Neural networks
Neural networksNeural networks
Neural networks
Jagjit Wilku
ย 
Data-ware Housing
Data-ware HousingData-ware Housing
Data-ware Housing
Prof.Nilesh Magar
ย 
Main MeMory Data Base
Main MeMory Data BaseMain MeMory Data Base
Main MeMory Data Base
Siva Rushi
ย 
Decision trees
Decision treesDecision trees
Decision trees
Jagjit Wilku
ย 

Viewers also liked (7)

Data ware housing- Introduction to data ware housing
Data ware housing- Introduction to data ware housingData ware housing- Introduction to data ware housing
Data ware housing- Introduction to data ware housing
ย 
Microblogging
MicrobloggingMicroblogging
Microblogging
ย 
Data Mining and Data Warehousing (MAKAUT)
Data Mining and Data Warehousing (MAKAUT)Data Mining and Data Warehousing (MAKAUT)
Data Mining and Data Warehousing (MAKAUT)
ย 
Neural networks
Neural networksNeural networks
Neural networks
ย 
Data-ware Housing
Data-ware HousingData-ware Housing
Data-ware Housing
ย 
Main MeMory Data Base
Main MeMory Data BaseMain MeMory Data Base
Main MeMory Data Base
ย 
Decision trees
Decision treesDecision trees
Decision trees
ย 

Similar to Data warehouse architecture

What is a Data Warehouse and How Do I Test It?
What is a Data Warehouse and How Do I Test It?What is a Data Warehouse and How Do I Test It?
What is a Data Warehouse and How Do I Test It?
RTTS
ย 
Datawarehousing & DSS
Datawarehousing & DSSDatawarehousing & DSS
Datawarehousing & DSS
Deepali Raut
ย 
Lesson 2.docx
Lesson 2.docxLesson 2.docx
Lesson 2.docx
calf_ville86
ย 
BI Chapter 03.pdf business business business business business business
BI Chapter 03.pdf business business business business business businessBI Chapter 03.pdf business business business business business business
BI Chapter 03.pdf business business business business business business
JawaherAlbaddawi
ย 
UNIT 2 DATA WAREHOUSING AND DATA MINING PRESENTATION.pptx
UNIT 2 DATA WAREHOUSING AND DATA MINING PRESENTATION.pptxUNIT 2 DATA WAREHOUSING AND DATA MINING PRESENTATION.pptx
UNIT 2 DATA WAREHOUSING AND DATA MINING PRESENTATION.pptx
shruthisweety4
ย 
Oracle: Fundamental Of Dw
Oracle: Fundamental Of DwOracle: Fundamental Of Dw
Oracle: Fundamental Of Dw
oracle content
ย 
Oracle: Fundamental Of DW
Oracle: Fundamental Of DWOracle: Fundamental Of DW
Oracle: Fundamental Of DW
DataminingTools Inc
ย 
Warehouse chapter3
Warehouse chapter3 Warehouse chapter3
Warehouse chapter3
fika sweety
ย 
20IT501_DWDM_PPT_Unit_I.ppt
20IT501_DWDM_PPT_Unit_I.ppt20IT501_DWDM_PPT_Unit_I.ppt
20IT501_DWDM_PPT_Unit_I.ppt
PalaniKumarR2
ย 
1-_Intro_to_Data_Minning__DWH.ppt
1-_Intro_to_Data_Minning__DWH.ppt1-_Intro_to_Data_Minning__DWH.ppt
1-_Intro_to_Data_Minning__DWH.ppt
BsMath3rdsem
ย 
Data warehousing
Data warehousingData warehousing
Data warehousing
Gaurav Khatri
ย 
8 crm data warehouse
8 crm data warehouse8 crm data warehouse
8 crm data warehouse
ajitjoshiin
ย 
Data Lakehouse, Data Mesh, and Data Fabric (r1)
Data Lakehouse, Data Mesh, and Data Fabric (r1)Data Lakehouse, Data Mesh, and Data Fabric (r1)
Data Lakehouse, Data Mesh, and Data Fabric (r1)
James Serra
ย 
UNIT-5 DATA WAREHOUSING.docx
UNIT-5 DATA WAREHOUSING.docxUNIT-5 DATA WAREHOUSING.docx
UNIT-5 DATA WAREHOUSING.docx
DURGADEVIL
ย 
11667 Bitt I 2008 Lect4
11667 Bitt I 2008 Lect411667 Bitt I 2008 Lect4
11667 Bitt I 2008 Lect4
ambujm
ย 
Oracle Database 12c - Features for Big Data
Oracle Database 12c - Features for Big DataOracle Database 12c - Features for Big Data
Oracle Database 12c - Features for Big Data
Abishek V S
ย 
Top 60+ Data Warehouse Interview Questions and Answers.pdf
Top 60+ Data Warehouse Interview Questions and Answers.pdfTop 60+ Data Warehouse Interview Questions and Answers.pdf
Top 60+ Data Warehouse Interview Questions and Answers.pdf
Datacademy.ai
ย 
DWH_Session_1.pptx
DWH_Session_1.pptxDWH_Session_1.pptx
DWH_Session_1.pptx
umashanker manthena
ย 
Data Warehouse Architecture: All You Need To Know
Data Warehouse Architecture: All You Need To KnowData Warehouse Architecture: All You Need To Know
Data Warehouse Architecture: All You Need To Know
Quell Soft
ย 
20IT501_DWDM_PPT_Unit_I.ppt
20IT501_DWDM_PPT_Unit_I.ppt20IT501_DWDM_PPT_Unit_I.ppt
20IT501_DWDM_PPT_Unit_I.ppt
SamPrem3
ย 

Similar to Data warehouse architecture (20)

What is a Data Warehouse and How Do I Test It?
What is a Data Warehouse and How Do I Test It?What is a Data Warehouse and How Do I Test It?
What is a Data Warehouse and How Do I Test It?
ย 
Datawarehousing & DSS
Datawarehousing & DSSDatawarehousing & DSS
Datawarehousing & DSS
ย 
Lesson 2.docx
Lesson 2.docxLesson 2.docx
Lesson 2.docx
ย 
BI Chapter 03.pdf business business business business business business
BI Chapter 03.pdf business business business business business businessBI Chapter 03.pdf business business business business business business
BI Chapter 03.pdf business business business business business business
ย 
UNIT 2 DATA WAREHOUSING AND DATA MINING PRESENTATION.pptx
UNIT 2 DATA WAREHOUSING AND DATA MINING PRESENTATION.pptxUNIT 2 DATA WAREHOUSING AND DATA MINING PRESENTATION.pptx
UNIT 2 DATA WAREHOUSING AND DATA MINING PRESENTATION.pptx
ย 
Oracle: Fundamental Of Dw
Oracle: Fundamental Of DwOracle: Fundamental Of Dw
Oracle: Fundamental Of Dw
ย 
Oracle: Fundamental Of DW
Oracle: Fundamental Of DWOracle: Fundamental Of DW
Oracle: Fundamental Of DW
ย 
Warehouse chapter3
Warehouse chapter3 Warehouse chapter3
Warehouse chapter3
ย 
20IT501_DWDM_PPT_Unit_I.ppt
20IT501_DWDM_PPT_Unit_I.ppt20IT501_DWDM_PPT_Unit_I.ppt
20IT501_DWDM_PPT_Unit_I.ppt
ย 
1-_Intro_to_Data_Minning__DWH.ppt
1-_Intro_to_Data_Minning__DWH.ppt1-_Intro_to_Data_Minning__DWH.ppt
1-_Intro_to_Data_Minning__DWH.ppt
ย 
Data warehousing
Data warehousingData warehousing
Data warehousing
ย 
8 crm data warehouse
8 crm data warehouse8 crm data warehouse
8 crm data warehouse
ย 
Data Lakehouse, Data Mesh, and Data Fabric (r1)
Data Lakehouse, Data Mesh, and Data Fabric (r1)Data Lakehouse, Data Mesh, and Data Fabric (r1)
Data Lakehouse, Data Mesh, and Data Fabric (r1)
ย 
UNIT-5 DATA WAREHOUSING.docx
UNIT-5 DATA WAREHOUSING.docxUNIT-5 DATA WAREHOUSING.docx
UNIT-5 DATA WAREHOUSING.docx
ย 
11667 Bitt I 2008 Lect4
11667 Bitt I 2008 Lect411667 Bitt I 2008 Lect4
11667 Bitt I 2008 Lect4
ย 
Oracle Database 12c - Features for Big Data
Oracle Database 12c - Features for Big DataOracle Database 12c - Features for Big Data
Oracle Database 12c - Features for Big Data
ย 
Top 60+ Data Warehouse Interview Questions and Answers.pdf
Top 60+ Data Warehouse Interview Questions and Answers.pdfTop 60+ Data Warehouse Interview Questions and Answers.pdf
Top 60+ Data Warehouse Interview Questions and Answers.pdf
ย 
DWH_Session_1.pptx
DWH_Session_1.pptxDWH_Session_1.pptx
DWH_Session_1.pptx
ย 
Data Warehouse Architecture: All You Need To Know
Data Warehouse Architecture: All You Need To KnowData Warehouse Architecture: All You Need To Know
Data Warehouse Architecture: All You Need To Know
ย 
20IT501_DWDM_PPT_Unit_I.ppt
20IT501_DWDM_PPT_Unit_I.ppt20IT501_DWDM_PPT_Unit_I.ppt
20IT501_DWDM_PPT_Unit_I.ppt
ย 

More from uncleRhyme

Performance appraisal
Performance appraisalPerformance appraisal
Performance appraisal
uncleRhyme
ย 
Labor managementrelations
Labor managementrelationsLabor managementrelations
Labor managementrelations
uncleRhyme
ย 
Compensation and benefits
Compensation and benefitsCompensation and benefits
Compensation and benefits
uncleRhyme
ย 
Training and developing employees
Training and developing employeesTraining and developing employees
Training and developing employees
uncleRhyme
ย 
Chapter 4
Chapter 4Chapter 4
Chapter 4
uncleRhyme
ย 
Chapter 3
Chapter 3Chapter 3
Chapter 3
uncleRhyme
ย 
Chapter 2
Chapter 2Chapter 2
Chapter 2
uncleRhyme
ย 
Chapter 1
Chapter 1Chapter 1
Chapter 1
uncleRhyme
ย 
02 database oprimization - improving sql performance - ent-db
02 database oprimization - improving sql performance - ent-db02 database oprimization - improving sql performance - ent-db
02 database oprimization - improving sql performance - ent-db
uncleRhyme
ย 
01 database security ent-db
01 database security ent-db01 database security ent-db
01 database security ent-db
uncleRhyme
ย 
networkmedia presentation1
networkmedia presentation1networkmedia presentation1
networkmedia presentation1
uncleRhyme
ย 
Ictinfraosi7 layers tcpipmodel2016e
Ictinfraosi7 layers tcpipmodel2016eIctinfraosi7 layers tcpipmodel2016e
Ictinfraosi7 layers tcpipmodel2016e
uncleRhyme
ย 
Introduction to data warehousing
Introduction to data warehousingIntroduction to data warehousing
Introduction to data warehousing
uncleRhyme
ย 
Introduction to data warehousing
Introduction to data warehousingIntroduction to data warehousing
Introduction to data warehousing
uncleRhyme
ย 
Ictinframodule1
Ictinframodule1Ictinframodule1
Ictinframodule1
uncleRhyme
ย 
Revenue and profit
Revenue and profitRevenue and profit
Revenue and profit
uncleRhyme
ย 

More from uncleRhyme (16)

Performance appraisal
Performance appraisalPerformance appraisal
Performance appraisal
ย 
Labor managementrelations
Labor managementrelationsLabor managementrelations
Labor managementrelations
ย 
Compensation and benefits
Compensation and benefitsCompensation and benefits
Compensation and benefits
ย 
Training and developing employees
Training and developing employeesTraining and developing employees
Training and developing employees
ย 
Chapter 4
Chapter 4Chapter 4
Chapter 4
ย 
Chapter 3
Chapter 3Chapter 3
Chapter 3
ย 
Chapter 2
Chapter 2Chapter 2
Chapter 2
ย 
Chapter 1
Chapter 1Chapter 1
Chapter 1
ย 
02 database oprimization - improving sql performance - ent-db
02 database oprimization - improving sql performance - ent-db02 database oprimization - improving sql performance - ent-db
02 database oprimization - improving sql performance - ent-db
ย 
01 database security ent-db
01 database security ent-db01 database security ent-db
01 database security ent-db
ย 
networkmedia presentation1
networkmedia presentation1networkmedia presentation1
networkmedia presentation1
ย 
Ictinfraosi7 layers tcpipmodel2016e
Ictinfraosi7 layers tcpipmodel2016eIctinfraosi7 layers tcpipmodel2016e
Ictinfraosi7 layers tcpipmodel2016e
ย 
Introduction to data warehousing
Introduction to data warehousingIntroduction to data warehousing
Introduction to data warehousing
ย 
Introduction to data warehousing
Introduction to data warehousingIntroduction to data warehousing
Introduction to data warehousing
ย 
Ictinframodule1
Ictinframodule1Ictinframodule1
Ictinframodule1
ย 
Revenue and profit
Revenue and profitRevenue and profit
Revenue and profit
ย 

Recently uploaded

Environmental science 1.What is environmental science and components of envir...
Environmental science 1.What is environmental science and components of envir...Environmental science 1.What is environmental science and components of envir...
Environmental science 1.What is environmental science and components of envir...
Deepika
ย 
Hospital pharmacy and it's organization (1).pdf
Hospital pharmacy and it's organization (1).pdfHospital pharmacy and it's organization (1).pdf
Hospital pharmacy and it's organization (1).pdf
ShwetaGawande8
ย 
220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science
Kalna College
ย 
Decolonizing Universal Design for Learning
Decolonizing Universal Design for LearningDecolonizing Universal Design for Learning
Decolonizing Universal Design for Learning
Frederic Fovet
ย 
bryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours second semesterbryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours second semester
Sarojini38
ย 
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptxScience-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Catherine Dela Cruz
ย 
Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024
khabri85
ย 
220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology
Kalna College
ย 
How to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRMHow to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRM
Celine George
ย 
The basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptxThe basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptx
heathfieldcps1
ย 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
MJDuyan
ย 
pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
BiplabHalder13
ย 
(T.L.E.) Agriculture: "Ornamental Plants"
(T.L.E.) Agriculture: "Ornamental Plants"(T.L.E.) Agriculture: "Ornamental Plants"
(T.L.E.) Agriculture: "Ornamental Plants"
MJDuyan
ย 
The Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teachingThe Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teaching
Derek Wenmoth
ย 
Art Integrated Project between Maharashtra and Sikkim
Art Integrated Project between Maharashtra and SikkimArt Integrated Project between Maharashtra and Sikkim
Art Integrated Project between Maharashtra and Sikkim
pranavsawarbandhe24
ย 
220711130086 Sukanta Singh E learning and mobile learning EPC 3 Internal Asse...
220711130086 Sukanta Singh E learning and mobile learning EPC 3 Internal Asse...220711130086 Sukanta Singh E learning and mobile learning EPC 3 Internal Asse...
220711130086 Sukanta Singh E learning and mobile learning EPC 3 Internal Asse...
Kalna College
ย 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
Celine George
ย 
Non-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech ProfessionalsNon-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech Professionals
MattVassar1
ย 
Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024
Friends of African Village Libraries
ย 
IoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdfIoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdf
roshanranjit222
ย 

Recently uploaded (20)

Environmental science 1.What is environmental science and components of envir...
Environmental science 1.What is environmental science and components of envir...Environmental science 1.What is environmental science and components of envir...
Environmental science 1.What is environmental science and components of envir...
ย 
Hospital pharmacy and it's organization (1).pdf
Hospital pharmacy and it's organization (1).pdfHospital pharmacy and it's organization (1).pdf
Hospital pharmacy and it's organization (1).pdf
ย 
220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science220711130082 Srabanti Bag Internet Resources For Natural Science
220711130082 Srabanti Bag Internet Resources For Natural Science
ย 
Decolonizing Universal Design for Learning
Decolonizing Universal Design for LearningDecolonizing Universal Design for Learning
Decolonizing Universal Design for Learning
ย 
bryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours second semesterbryophytes.pptx bsc botany honours second semester
bryophytes.pptx bsc botany honours second semester
ย 
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptxScience-9-Lesson-1-The Bohr Model-NLC.pptx pptx
Science-9-Lesson-1-The Bohr Model-NLC.pptx pptx
ย 
Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024Brand Guideline of Bashundhara A4 Paper - 2024
Brand Guideline of Bashundhara A4 Paper - 2024
ย 
220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology220711130097 Tulip Samanta Concept of Information and Communication Technology
220711130097 Tulip Samanta Concept of Information and Communication Technology
ย 
How to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRMHow to Create a Stage or a Pipeline in Odoo 17 CRM
How to Create a Stage or a Pipeline in Odoo 17 CRM
ย 
The basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptxThe basics of sentences session 8pptx.pptx
The basics of sentences session 8pptx.pptx
ย 
Information and Communication Technology in Education
Information and Communication Technology in EducationInformation and Communication Technology in Education
Information and Communication Technology in Education
ย 
pol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdfpol sci Election and Representation Class 11 Notes.pdf
pol sci Election and Representation Class 11 Notes.pdf
ย 
(T.L.E.) Agriculture: "Ornamental Plants"
(T.L.E.) Agriculture: "Ornamental Plants"(T.L.E.) Agriculture: "Ornamental Plants"
(T.L.E.) Agriculture: "Ornamental Plants"
ย 
The Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teachingThe Science of Learning: implications for modern teaching
The Science of Learning: implications for modern teaching
ย 
Art Integrated Project between Maharashtra and Sikkim
Art Integrated Project between Maharashtra and SikkimArt Integrated Project between Maharashtra and Sikkim
Art Integrated Project between Maharashtra and Sikkim
ย 
220711130086 Sukanta Singh E learning and mobile learning EPC 3 Internal Asse...
220711130086 Sukanta Singh E learning and mobile learning EPC 3 Internal Asse...220711130086 Sukanta Singh E learning and mobile learning EPC 3 Internal Asse...
220711130086 Sukanta Singh E learning and mobile learning EPC 3 Internal Asse...
ย 
What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17What are the new features in the Fleet Odoo 17
What are the new features in the Fleet Odoo 17
ย 
Non-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech ProfessionalsNon-Verbal Communication for Tech Professionals
Non-Verbal Communication for Tech Professionals
ย 
Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024Library news letter Kitengesa Uganda June 2024
Library news letter Kitengesa Uganda June 2024
ย 
IoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdfIoT (Internet of Things) introduction Notes.pdf
IoT (Internet of Things) introduction Notes.pdf
ย 

Data warehouse architecture

  • 2. Data warehouse Architecture Different data warehousing systems have different structures. Some may have an ODS (operational data store), while some may have multiple data marts. Some may have a small number of data sources, while some may have dozens of data sources. A data warehouse architecture will differ mainly on the layers included in the architecture.
  • 3. Basic Data warehouse Data WarehouseData Warehouse MarketingMarketing Sales and Inventory Sales and Inventory Social MediaSocial Media Data Source Layer ETL Layer Data Warehouse Layer Metadata layer System Operation layer
  • 4. Data warehouse W/ Staging Data WarehouseData Warehouse MarketingMarketing Sales and Inventory Sales and Inventory Social MediaSocial Media Data Source Layer ETL Layer Data Warehouse Layer Staging DB Staging DB Staging Layer Metadata layer System Operation layer
  • 5. Data warehouse W/ Staging and data Mart Data WarehouseData Warehouse MarketingMarketing Sales and Inventory Sales and Inventory Social MediaSocial Media Data Source Layer ETL Layer Data Warehouse Layer Staging DB Staging DB Staging Layer Data MartData Mart Data MartData Mart Data MartData Mart Data Mart Layer Metadata layer System Operation layer
  • 6. Data Warehouse Architecture layers Basic: โ€ขSystem Operation Layer โ€ขMetadata Layer โ€ขData Source Layer โ€ขETL Layer โ€ขData Warehouse / Storage Layer
  • 7. Data Warehouse Architecture layers Other Layers: โ€ขStaging Layer โ€ขExtraction Layer โ€ขData Mart Layer โ€ขData Logic Layer โ€ขData Presentation Layer
  ็ฟป่ฏ‘๏ผš