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