b汁敢瑲匠档慷穲潫-DataWarehousing.pptVIP

Data Warehousing Building a database to support the decision making activities of a department or business unit Data Warehouse A read-only database for decision analysis Subject Oriented Integrated Time variant Nonvolatile consisting of time stamped operational and external data. Data Warehouse Purpose Identify problems in time to avoid them Locate opportunities you might otherwise miss Data Warehouse:New Approach An old idea with a new interest because of: Cheap Computing Power Special Purpose Hardware New Data Structures Intelligent Software Warehousing Problems Business Issues Data Quantity Data Accuracy Maintenance Ownership Cost Warehousing Problems Business Issues Database Issues DBMS Software Technology Complexity Warehousing Problems Business Issues Data Issues Analysis Issues User Interface Intelligent Processing EUC Data Architecture NeededEnvironment Understand DSS technology Understand relational databases Know company data resources Transformation and integration tools Possess DBA skills Install network and telecommunication hardware and software Possess front end software Possess meta-data navigation tools Two Approaches Classical Enterprise Database Typically contains operational data that integrates information from all areas of the organization. Data Mart Extracted and managerial support data designed for departmental or EUC applications Data Warehouse vsOperational Databases Highly tuned Real time Data Detailed records Current values Accesses small amounts of data in a predictable manner Flexible access Consistent timing Summarized as appropriate Historical Access large amounts of data in unexpected ways Separate Read Only Database Operational and decision support processing are fundamentally different. Flexible access Consistent timing Historical data Environmental references Common reference Front End Access Tailored access programs in user form, usually client-server General purpose GUI products (e.g. Access, PowerBuilder) Custom