Transcript การเขียนโปรแกรมและการประ

ระบบฐานข้อมูลขัน้ สูง
(Advanced Database Systems)
Lecturer
AJ. Suwan Janin
Phone: 089-148-3993
E-mail: [email protected]
 Introduction on Chapter 12
 Data Warehouses
 OLTP Systems Compared with Data
Warehouse Systems
 Data Warehouse Architecture
 Data Marts
 Data Mining
2
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.”
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
THANK YOU FOR
YOUR KIND ATTENTION !!!
Lecturer
AJ. Suwan Janin
19