1 / 19

CHAPTER 12 Databases for Online Analytical Processing

ระบบฐานข้อมูลขั้นสูง (Advanced Database Systems). CHAPTER 12 Databases for Online Analytical Processing. Lecturer AJ . Suwan Janin. Phone: 089-148-3993 E-mail: suwanjanin@gmail.com. Outline. Introduction on Chapter 12 Data Warehouses

Download Presentation

CHAPTER 12 Databases for Online Analytical Processing

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. ระบบฐานข้อมูลขั้นสูง(Advanced Database Systems) CHAPTER12Databases for Online AnalyticalProcessing Lecturer AJ. SuwanJanin Phone: 089-148-3993 E-mail: suwanjanin@gmail.com

  2. Outline • Introduction on Chapter 12 • Data Warehouses • OLTP Systems Compared with Data Warehouse Systems • Data Warehouse Architecture • Data Marts • Data Mining

  3. Introduction Starting in the 1980s, businesses recognized the need for keeping historical data and using it for analysis to assist in decision making. It was soon apparent that data organized for use by day-to-day business transactions was not as useful for analysis. In fact, storing significant amounts of history in an operational database (a database designed to support the day-to-day transactions of an organization) could have serious detrimental effects on performance. William H. (Bill) Inmon participated in pioneering work in a concept known as data warehousing, where historical data is periodically trimmed from the operational database and moved to a database specifically designed for analysis. It was Bill Inmon’s dedicated promotion of the concept that earned him the title “father of data warehousing.”

  4. Introduction (cont.)

  5. Data Warehouses

  6. Data Warehouses (Cont.)

  7. OLTP Systems Compared with Data Warehouse Systems

  8. Data Warehouse Architecture

  9. Summary table data warehouse architecture

  10. Summary Table Architecture

  11. Star Schema Data Warehouse Architecture

  12. Star Schema Data Warehouse Architecture

  13. Star Schema Data Warehouse Architecture

  14. Multidimensional Databases

  15. Microsoft Access Implementation

  16. Data Marts

  17. Data Marts (cont.)

  18. Data Mining

  19. Q&A??????? THANK YOU FOR YOUR KIND ATTENTION !!! Lecturer AJ. SuwanJanin

More Related