A technical architecture for data warehousing
This presentation is the property of its rightful owner.
Sponsored Links
1 / 10

A technical Architecture for Data Warehousing PowerPoint PPT Presentation


  • 205 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

A technical Architecture for Data Warehousing

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


A technical architecture for data warehousing

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.


A technical architecture for data warehousing

  • 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

Design Component

  • functionality: design and define data warehouse database (special consideration: handle summary and temporal data)

  • tool: W-CASE


Data acquisition component

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

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

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

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

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

Middleware Component

  • Functionality: provide connectivity to warehouse databases from end-user data tools.

  • Specialized middleware

    • intelligent data warehousing middleware,

    • Analytical server


Data delivery component

Data Delivery Component

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


  • Login