ระบบฐานข้อมูลขั้นสูง (Advanced Database Systems) Lecturer...
-
Upload
rosamund-dean -
Category
Documents
-
view
232 -
download
2
Transcript of ระบบฐานข้อมูลขั้นสูง (Advanced Database Systems) Lecturer...
CHAPTER 12Databases for Online AnalyticalProcessing
ระบบฐานข้�อมู�ลข้ �นสู�ง(Advanced Database Systems)
LecturerAJ. Suwan Janin
Phone: 089-148-3993E-mail: [email protected]
Outline
Introduction on Chapter 12Data WarehousesOLTP Systems Compared with Data Warehouse Systems
Data Warehouse ArchitectureData MartsData Mining
2
Introduction
3
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.”