A technical Architecture for Data Warehousing

Document Sample
A technical Architecture for Data Warehousing Powered By Docstoc
					        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.
• 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
Design Component

• functionality: design and define data
  warehouse database (special consideration:
  handle summary and temporal data)
• tool: W-CASE
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.
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)
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.
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.
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.
Middleware Component

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

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