A technical Architecture for Data Warehousing

1
A technical Architecture for Data Warehousing

• Summary
• A data warehousing system should provide a
  complete solution for managing the flow of
  information from existing corporate databases and
  external sources into end-user decision support
  system.
• It should make it easy for business users to
  find out what information exists in the
  warehouse, and provide tools for accessing and
  manipulating that information.

2

• Key components of a data warehouse
• Design component
• Data acquisition component
• Data manager component
• Management component
• Information directory component
• Data access component
• Middleware component
• Data delivery component

3
Design Component

• functionality design and define data warehouse
  database (special consideration handle summary
  and temporal data)
• tool W-CASE

4
Data Acquisition Component

• functionality develop and run data acquisition
  applications that capture data from source
  systems for applying to warehouse database, data
  cleanup and enhancement.
• tool Code generators, Data replication tools,
  Data pumps, Data reengineering tools, Generalized
  data acquisition tools and utilities.

5
Data Manager Component

• functionality create, manage, and access
  warehouse data (and possibly meta data).
• Data manager employed by data warehousing system
  is usually either RDBMS(large or small), or
  MDBMS(small departmental data warehouses)

6
Management Component

• functionality provide management services for
  maintaining the data warehousing environment,
  including managing data acquisition operations,
  archiving warehouse data, backing up and
  recovering data, securing and authorizing access
  to warehouse data, and managing and tuning data
  access operations.

7
Information Directory Component

• functionality help technical and business users
  access and exploit the power of a data
  warehousing system by providing a set of tools
  for the maintenance and viewing of warehouse
  metadata.
• Main elements
• Metadata manager maintain, export, and improve
  warehouse metadata.
• Technical metadata contains information about
  warehouse data for use by warehouse designers and
  administrators.
• Business metadata contains information that
  gives end users an easy-to-understand business
  perspective of the warehouse data.
• information assistant provides warehouse end
  user with easy access to the business and
  technical metadata.

8
Data Access Component

• Functionality provide the data access tools that
  enable end user to access and analyze warehouse
  data.
• Tool Query, reporting and data analysis tool
• Multidimensional data analysis tools that access
  a relation DBMS
• Multidimensional data analysis tools that access
  a multidimensional relation DBMS
• DSS application development tools employing a 4GL
  or visual programming language.

9
Middleware Component

• Functionality provide connectivity to warehouse
  databases from end-user data tools.
• Specialized middleware
• intelligent data warehousing middleware,
• Analytical server

10
Data Delivery Component

• Functionality distribute data collections to
  other data warehouse, and end-user products.