The technical architecture of data warehouses is somewhat similar to other systems, but does have some special characteristics. There are two border areas in data warehouse architecture - the single-layer architecture and the N-layer architecture. The difference here is the number of middleware between the operational systems and the analytical tools.The data warehouse architecture described here is a high level architecture and the parts in the architectures mentioned are full bodied systems and not system-parts. Components of Data Warehouse Architecture ° Source Data Component

Property Value
dbo:abstract
  • The technical architecture of data warehouses is somewhat similar to other systems, but does have some special characteristics. There are two border areas in data warehouse architecture - the single-layer architecture and the N-layer architecture. The difference here is the number of middleware between the operational systems and the analytical tools.The data warehouse architecture described here is a high level architecture and the parts in the architectures mentioned are full bodied systems and not system-parts. Components of Data Warehouse Architecture ° Source Data Component 1. Production Data 2. Internal Data 3. Archived Data 4. External Data ° Data Staging Component 1. Data Extraction 2. Data Transformation 3. Data Loading ° Data Storage Component ° Information Deliver Component ° Metadata Component ° Management and Control Component (en)
dbo:wikiPageID
  • 25107050 (xsd:integer)
dbo:wikiPageRevisionID
  • 628280486 (xsd:integer)
dct:subject
rdfs:comment
  • The technical architecture of data warehouses is somewhat similar to other systems, but does have some special characteristics. There are two border areas in data warehouse architecture - the single-layer architecture and the N-layer architecture. The difference here is the number of middleware between the operational systems and the analytical tools.The data warehouse architecture described here is a high level architecture and the parts in the architectures mentioned are full bodied systems and not system-parts. Components of Data Warehouse Architecture ° Source Data Component (en)
rdfs:label
  • Data warehouse architectures (en)
owl:sameAs
prov:wasDerivedFrom
foaf:isPrimaryTopicOf
is foaf:primaryTopic of