advanced database systems n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
CHAPTER 12 Databases for Online Analytical Processing PowerPoint Presentation
Download Presentation
CHAPTER 12 Databases for Online Analytical Processing

Loading in 2 Seconds...

play fullscreen
1 / 19

CHAPTER 12 Databases for Online Analytical Processing - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

ระบบฐานข้อมูลขั้นสูง (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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'CHAPTER 12 Databases for Online Analytical Processing' - beau-johnson


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
advanced database systems
ระบบฐานข้อมูลขั้นสูง(Advanced Database Systems)

CHAPTER12Databases for Online AnalyticalProcessing

Lecturer

AJ. SuwanJanin

Phone: 089-148-3993

E-mail: suwanjanin@gmail.com

outline
Outline
  • Introduction on Chapter 12
  • Data Warehouses
  • OLTP Systems Compared with Data Warehouse Systems
  • Data Warehouse Architecture
  • Data Marts
  • Data Mining
introduction
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.”

slide19
Q&A???????

THANK YOU FOR

YOUR KIND ATTENTION !!!

Lecturer

AJ. SuwanJanin