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.
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.
·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:
·Data acquisition component
·Data manager component
·Information directory component
·Data access component
·Data delivery component
functionality: design and define data warehouse database (special consideration: handle summary and temporal data)
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)
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.
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.
Functionality: provide connectivity to warehouse databases from end-user data tools.
intelligent data warehousing middleware,
Data Delivery Component
Functionality: distribute data collections to other data warehouse, and end-user products.