1 / 17

Data Warehousing

Virtual University of Pakistan. Data Warehousing . Lecture-1 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.

rian
Download Presentation

Data Warehousing

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Virtual University of Pakistan Data Warehousing Lecture-1 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 DWH-Ahsan Abdullah

  2. Introduction and Background DWH-Ahsan Abdullah

  3. Reference Books • W. H. Inmon, Building the Data Warehouse (Second Edition), John Wiley & Sons Inc., NY. • A. Abdullah, “Data Warehousing for beginners: Concepts & Issues” (First Edition). • Paulraj Ponniah, Data Warehousing Fundamentals, John Wiley & Sons Inc., NY. DWH-Ahsan Abdullah

  4. Additional Material • Research Papers • Magazine Articles DWH-Ahsan Abdullah

  5. Summary of course DWH-Ahsan Abdullah

  6. Summary of course DWH-Ahsan Abdullah

  7. Summary of course DWH-Ahsan Abdullah

  8. Summary of course DWH-Ahsan Abdullah

  9. Semester Project Develop an application for an organization of your choice. A case study and coding based approach to be followed. Use 4GL or a high level programming language. You MUST collect the necessary data and should have a first draft of the project description approved by the instructor BEFORE initiating on detailed work. DWH-Ahsan Abdullah

  10. Semester Project (Cont…) The project report to include, but is not limited to, the following as documentation: • Narrative description of business and tables of appropriate data. • Descriptions of decisions to be supported by information produced by system. • Summary narrative of results produced. • Structure charts, dataflow diagrams and/or other diagrams to document the structure of the system. • Listings of computer models/programs utilized. • Reports displaying results. • Recommended decision from results. • User instructions. DWH-Ahsan Abdullah

  11. Approach of the course • Develop an understanding of underlying RDBMS concepts. • Apply these concepts to VLDB DSS environments and understand where and why they break down? • Expose the differences between RDBMS and Data Warehouse in the context of VLDB. • Provide the basics of DSS tools such as OLAP, Data Mining and demonstrate their application. • Demonstrate the application of DSS concepts and limitations of the OLTP concepts through lab exercises. DWH-Ahsan Abdullah

  12. Why this course? • The world is changing (actually changed), either change or be left behind. • Missing the opportunities or going in the wrong direction has prevented us from growing. • What is the right direction? • Harnessing the data, in a knowledge driven economy. DWH-Ahsan Abdullah

  13. The need “Drowning in data and starving for information” Knowledge is power, Intelligence is absolute power! DWH-Ahsan Abdullah

  14. The need $ POWER INTELLIGENCE KNOWLEDGE INFORMATION DATA DWH-Ahsan Abdullah

  15. Historical overview  1960 Master Files & Reports 1965 Lots of Master files! 1970 Direct Access Memory & DBMS 1975 Online high performance transaction processing DWH-Ahsan Abdullah

  16. Historical overview  1980 PCs and 4GL Technology (MIS/DSS) 1985 & 1990 Extract programs, extract processing, The legacy system’s web  DWH-Ahsan Abdullah

  17. Historical overview: Crisis of Credibility  ??  -10% +10% What is the financial health of our company?       DWH-Ahsan Abdullah

More Related