Virtual University of Pakistan. Data Warehousing. Lecture-4 Introduction and Background. Ahsan Abdullah Assoc. Prof. & Head Center for Agro-Informatics Research www.nu.edu.pk/cairindex.asp FAST National University of Computers & Emerging Sciences, Islamabad. Introduction and Background.
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
Assoc. Prof. & Head
Center for Agro-Informatics Research
FAST National University of Computers & Emerging Sciences, Islamabad
How is it Different?
RequirementsHow is it Different?
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