Data Warehousing. Lecture-4 Introduction and Background. Introduction and Background. How is it Different?. Starts with a 6x12 availability requirement ... but 7x24 usually becomes the goal. Decision makers typically don’t work 24 hrs a day and 7 days a week. An ATM system does.
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.
Introduction and Background
OLTP (On Line Transaction Processing)
Select tx_date, balance from tx_table
Where account_ID = 23876;
Select balance, age, sal, gender from customer_table, tx_table
Where age between (30 and 40) and
Education = ‘graduate’ and
CustID.customer_table = Customer_ID.tx_table;
OLTP: OnLine Transaction Processing (MIS or Database System)
Data Warehouse Server