Data Warehousing - PowerPoint PPT Presentation

data warehousing n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehousing PowerPoint Presentation
Download Presentation
Data Warehousing

play fullscreen
1 / 17
Data Warehousing
224 Views
Download Presentation
rian
Download Presentation

Data Warehousing

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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