1 / 13

Chapter 13

Chapter 13. The Data Warehouse Database Systems: Design, Implementation, and Management, Seventh Edition, Rob and Coronel. Multidimensional Data Analysis Techniques (continued). Multidimensional Data Analysis Techniques (continued). Advanced Database Support.

lew
Download Presentation

Chapter 13

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 13 The Data Warehouse Database Systems: Design, Implementation, and Management, Seventh Edition, Rob and Coronel

  2. Multidimensional Data Analysis Techniques (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  3. Multidimensional Data Analysis Techniques (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  4. Advanced Database Support • Advanced data access features include: • Access to many different kinds of DBMSs, flat files, and internal and external data sources • Access to aggregated data warehouse data as well as to detail data found in operational databases • Advanced data navigation • Rapid and consistent query response times • Ability to map end-user requests to appropriate data source and then to proper data access language (usually SQL) • Support for very large databases Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  5. Easy-to-Use End-User Interface • Many of interface features are “borrowed” from previous generations of data analysis tools that are already familiar to end users • Makes OLAP easily accepted and readily used Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  6. Client/Server Architecture • Provides framework within which new systems can be designed, developed, and implemented • Enables OLAP system to be divided into several components that define its architecture • OLAP is designed to meet ease-of-use as well as system flexibility requirements Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  7. OLAP Architecture Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  8. OLAP Architecture (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  9. OLAP Architecture (continued) • Designed to use both operational and data warehouse data • Defined as an “advanced data analysis environment that supports decision making, business modeling, and an operation’s research activities” • In most implementations, data warehouse and OLAP are interrelated and complementary environments Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  10. OLAP Architecture (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  11. OLAP Architecture (continued) Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  12. Relational OLAP • Provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data • Adds following extensions to traditional RDBMS: • Multidimensional data schema support within RDBMS • Data access language and query performance optimized for multidimensional data Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

  13. Relational OLAP Database Systems: Design, Implementation, & Management, 7th Edition, Rob & Coronel

More Related