_webenabling_the warehouse 数据仓库英文oracle99版 教学课件

Web-Enabling the Warehouse,Overview,Project Management (Methodology, Maintaining Metadata),Defining DW Concepts & Terminology,Planning for a Successful Warehouse,Analyzing User Query Needs,Choosing a Computing Architecture,Modeling the Data Warehouse,Planning Warehouse Storage,ETT (Building the Warehouse),Meeting a Business Need,Managing the Data Warehouse,Supporting End User Access,Objectives,After completing this lesson, you should be able to do the following: Explain how the Web can expand data warehouse usage Describe the issues involved in putting a data warehouse on the Web Outline the requirements for evaluation Web-based query and analysis tools,Benefits of Web-Enabling a Data Warehouse,Better-informed decision making Lower costs of deployment and management Lower training costs Remote access Enhanced customer service and improved image as a technology leader Greater collaboration among users,Challenges of Web-Enabling a Data Warehouse,Security Business value Impact assessment Setup and management Tools and support for global requirements,Common Web Data Warehouse Architecture,Gateway program,Warehouse database,Common Gateway Interface,Web server,Client browser,HTML,Common Web Data Warehouse Architecture,Warehouse server,Windows clients,World Wide Web Client,Client browser,Web server,Common Gateway Interface (CGI) Object Request Broker Cartridge Servlets Netscape Server API (NSAPI) Internet Server API (ISAPI),Issues in Deploying a Data Warehouse on the Web,Security: Authentication and authorization Communication confidentiality Access and restriction management Scalability Availability,Security,Authentication and authorization: Password Digital certificates Authentication tokens Communication confidentiality Access and restriction management,Security,Authentication and authorization: Password Digital certificates Authentication tokens Communication confidentiality Access and restriction management,Security,Authentication and authorization: Password Digital certificates Authentication tokens Communication confidentiality Access and restriction management,Scalability,Main concerns are: Amount of data Complexity of queries Number of areas Number of users Potential bottlenecks are: Storage capacity Memory Computational cycles Limits on OS resources Network bandwidth,Availability,The Internet extends the reach of database applications throughout the enterprise, organizations, and communities. More and more data warehouses require 24 X 7 availability Maintenance windows for batch extract, process, and refresh information for the data warehouse are shrinking.,Evaluating Web-Based Tools,Requirements: Interactivity Does the tool provide interactivity that covers tables, charts, and quadrants? Functionality Calculations, SQL generation, formatting, navigation techniques, layout controls,Evaluating Web-Based Tools,Requirements: Architecture What generation of Web architecture does the tool require? Performance How quickly can users access the data they need? How long does it take to download dynamic client-side programs? What trade-off does the tool make between interactivity and performance?,Evaluating Web-Based Tools,Requirements: Design Does the tool require designers to do coding in HTML or CGI scripts to create sophisticated HTML reports? Administration Does the tool control access to reports by user, group, and role? Output Can the tool output data in a variety of formats and languages?,Evaluating Web-Based Tools,Requirements: Scalability What platforms does the tools main execution engine run on? Does it support load-balancing? Databases What databases and native drivers does the tool support? Pricing How much does the tool cost? Does the tool support Web pricing?,Summary,This lesson covered the following topics: Highlighting the main benefits of Web-enabling the data warehouse Discussing the main issues in deploying a data warehou