数据仓库解决方案概述.ppt

* * * * * * * THIS BUILD SLIDE EXPLAINS THE PROCESS INVOLVED IN BUILDING A DATA MART - IT HAS SOME SIMILARITIES TO THE PRODUCT ARCHITECTURE SLIDE. You typically start with (CLICK) a source and target database. When you buy PowerMart, you get (CLICK) the Informatica Server and Client Tools. The Repository Manager (CLICK) is used to build the Metadata Repository, where all of the dynamically generated metadata will be stored. Within the Designer, (CLICK) there are four tools to facilitate the Design process. The Source Analyzer (CLICK) is used to analyze source definitions, which are stored in the metadata repository. The next step is to use the Warehouse Designer (CLICK) to read and store the target definitions. The Transformation Developer and Mapping Designer are used to create re-usable transformations and to build the transformation pipeline. Once you’ve done that, you can use Server Manager (CLICK) to create a load session and set the properties and schedule for extracting, transforming and loading your data. At the scheduled time, the server engine is invoked (CLICK) and data is extracted from the source system, transformed within the engine, and loaded into the target warehouse. * * * * * * * * * * For the state column of a table, a LowFast index would be appropriate since there are only 50 distinct values. Sybase IQ will build 50 bitmaps, one for each state. For processing this query, Sybase IQ will select the bitmap for “AL” and count the “1”s. * * Typical storage is 10-20% of size of raw data. Ideal data structure for range searches and aggregation of numeric values. * * * * * * * * Traditional database systems have limited numbers of definitions of data and objects. Users and analysts now want access to the meta data to determine things such as: * subject areas that will be used in the analysis. * what time frame of data is appropriate? * the level of detail required (cover this in a minute)? * what span of time will be covered in the analysis (w