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.
Pages to are hidden for
"A technical Architecture for Data Warehousing"Please download to view full document