logo资料库

数据仓库最全ppt.ppt

发布时间：2022-06-24 发布人：admin 分类：说明书 资料大小：3.02M 资料格式：ppt 举报 版权申诉
第1页 / 共376页
第2页 / 共376页
第3页 / 共376页
第4页 / 共376页
第5页 / 共376页
第6页 / 共376页
第7页 / 共376页
第8页 / 共376页
资料共376页，剩余部分请下载后查看
    Data Warehousing Fundamentals D16310GC10 Edition 1.0 ® Copyright © Oracle Corporation, 2002. All rights reserved.
    Introductions Tell us about yourself: • What is your name and company? • What is your role in the organization? • What is your level of Oracle expertise? • Why are you considering building a data warehouse? • What is your data warehouse experience? • What are your expectations for this class? Copyright © Oracle Corporation, 2002. All rights reserved.
    Course Objectives After completing this course, you should be able to do the following: • Describe the role of business intelligence (BI) and data warehousing in today’s marketplace • Describe data warehousing terminology and the various technologies that are required to implement a data warehouse • Explain the implementation and organizational issues surrounding a data warehouse project Identify data warehouse modeling concepts • • Explain the extraction, transformation, and loading processes for building a data warehouse Copyright © Oracle Corporation, 2002. All rights reserved.
    Course Objectives • Identify management and maintenance processes that are associated with a data warehouse project • Describe methods for refreshing warehouse data • Explain warehouse metadata concepts • Identify tools that can be employed at each stage of the data warehouse project • Describe user profiles and techniques for querying the warehouse Identify methods and tools for accessing and analyzing warehouse data • Copyright © Oracle Corporation, 2002. All rights reserved.
    Lessons 1. Business Intelligence and Data Warehousing 2. Defining Data Warehouse Concepts and Terminology 3. Planning and Managing the Data Warehouse Project 4. Modeling the Data Warehouse 5. Building the Data Warehouse: Extracting Data 6. Building the Data Warehouse: Transforming Data 7. Building the Data Warehouse: Loading Warehouse Data Copyright © Oracle Corporation, 2002. All rights reserved.
    Lessons 8. Refreshing Warehouse Data 9. Leaving a Metadata Trail 10. Managing and Maintaining the Data Warehouse 11. 附录（OWB） Copyright © Oracle Corporation, 2002. All rights reserved.
    Let’s Get Started Lesson 1 Copyright © Oracle Corporation, 2002. All rights reserved.
    Lesson 1 Objectives After completing this lesson, you should be able to do the following: • Describe the role of business intelligence in today’s marketplace • Describe why an online transaction processing system (OLTP) is not suitable for analytical reporting • Describe how extract processing for decision support querying led to data warehouse solutions that are employed today • Explain why businesses are driven to employ data warehouse technology Copyright © Oracle Corporation, 2002. All rights reserved.
    分享到：
    赞 收藏

    相关推荐

    资料库

    数据库

    共收录1218份资料，累计14个分类，关注成员有19位，主要包括：NoSQL,MongoDB,Redis,SQLite,Memcached,DB2,Sybase,Informix,PostgreSQL,MySQL,SQLServer,Access,Oracle,其它

    热门标签

    NoSQL MongoDB Redis SQLite Memcached DB2 Sybase Informix PostgreSQL MySQL SQLServer Access Oracle 其它

    最新资料