1 / 25

DATA WARE HOUSING AND DATA MINING……

DATA WARE HOUSING AND DATA MINING……. REPRESENTED BY PILLAL’S HOC POLYTECHNIC, RASAYANI. Prepared by: SAGAR KAMBLE& SNEHESH BHOIR. CONTENTS: . DATA WARE HOUSING & DATA MINING ABSTRACT INTRODUCTION DESCRIPTION ADVANTAGE & DISADVANTAGE RESULT CONCLUSION. DATA WAREHOUSING.

tryna
Download Presentation

DATA WARE HOUSING AND DATA MINING……

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. DATA WARE HOUSING AND DATA MINING…… REPRESENTED BY PILLAL’S HOC POLYTECHNIC, RASAYANI. Prepared by: SAGAR KAMBLE& SNEHESH BHOIR.

  2. CONTENTS: DATA WARE HOUSING & DATA MINING • ABSTRACT • INTRODUCTION • DESCRIPTION • ADVANTAGE & DISADVANTAGE • RESULT • CONCLUSION

  3. DATA WAREHOUSING • WHAT IS DATA WAREHOUSING? • WHAT IS MECHANISM OF IT ? • WHAT ARE THE FEATURES OF ITS? • ADVANTAGE AND DISADVANTAGE • RESULT AND CONCLUSION. • REFERENCES.

  4. WHAT IS DATA WAREHOUSING? • A data warehouse is -Subject-oriented, -Integrated, -Time-variant, -Non-volatile -Collection of data in support of management -Decision making process.

  5. RelationalDatabases ExtractionCleansing Optimized Loader ERP Systems Data Warehouse Engine AnalyzeQuery Purchased Data LegacyData Metadata Repository WHAT IS THE MECHANISH OF IT?

  6. WHAT ARE THE FEATURES OF IT? Finding Source Data Cleaning Data Managing WareHouse Non-Volatile Data Granularity

  7. ADVANTAGE & DISADVANTAGE • ADVANTAGE: • High query performance • But not necessarily most current information • Doesn’t interfere with local processing at sources • Complex queries at warehouse • OLTP at information sources • Information copied at warehouse • Can modify, annotate, summarize, restructure, etc. • Can store historical information • Security, no auditing • Has caught on in industry

  8. DISADVANTAGE: COMPLETE MAINTENCE IS REQUIRED.

  9. USES. IN BANKING IN BIG INSTITUTION Etc.

  10. EXAMPLES. Harrah’s Entertainment’s Data Warehouse holds 30 terabytes, or 30 trillion bytes of data, roughly three times the number of printed characters in the Library of Congress Casinos, retailers, airlines, and banks are piling up data so vast, it would have been unthinkable years ago; result from the curse of cheap storage

  11. RESULT & CONCLUSION RESULT: It is a platform for consolidated historical data for analysis. It stores data of good quality so that knowledge worker can make correct decisions.

  12. Warehouses are Very Large Databases(result) 35% 30% 25% 20% 15% 10% 5% 0% Respondents Initial Projected 2Q96 Source: META Group, Inc. 5GB 10-19GB 50-99GB 250-499GB 5-9GB 20-49GB 100-249GB 500GB-1TB

  13. CONCLUSION: A Data Warehouse is a collection of integrated subject-oriented databases designed. The metadata is information that is kept about the warehouse.

  14. REFERANCES. IIT BOMBAY PPT. WWW.WIKIPEDIA.COM LOCAL SITES DATA WAREHOUSING BY EnriconFranconi

  15. DATA MINING

  16. DATA MINING WHAT IS DATA MINING WHAT IS THE MECHANISM OF IT? WHAT ARE THE USES WHAT MAKES DATA MINING POSSIBLE RESULTS AND CONCLUSION REFERENCES

  17. WHAT IS DATA MINING Data mining refers to extracting or ‘mining’ knowledge from large amounts of data . It is process of discovering interesting knowledge from large amounts of data stored either in databases ,data warehouses, or other information

  18. WHAT IS THE MECHANISM OF IT? Data Mining provides the Enterprise with intelligence

  19. Data Mining works with Warehouse Data • Data Mining provides the Enterprise with intelligence

  20. USES The US Government uses Data Mining to track fraud A Supermarket becomes an information broker Basketball teams use it to track game strategy Cross Selling Warranty Claims Routing Holding on to Good Customers Weeding out Bad Customers

  21. WHAT MAKES DATA MINING POSSIBLE • Advances in the following areas are making data mining deployable: • data warehousing • better and more data • the advent of new data mining techniques

  22. RESULT-KNOWLEDGE DISCOVERY IN DATABASE Geology Physical Geography Geophysics Soil science Oceanography Glaciology Atmospheric science

  23. CONCLUSION FETCHING DATA WITH RULES

  24. REFERENCES WWW.WIKIPEDIA.COM DATA MINING BOOKS-TATA MCGRAW HILL,

  25. Questions?

More Related