OLAP and Data MiningOLAP和数据挖掘.pptVIP

Chapter 17 OLAP and Data Mining OLTP Compared With OLAP On Line Transaction Processing – OLTP Maintains a database that is an accurate model of some real-world enterprise. Supports day-to-day operations. Characteristics: Short simple transactions Relatively frequent updates Transactions access only a small fraction of the database On Line Analytic Processing – OLAP Uses information in database to guide strategic decisions. Characteristics: Complex queries Infrequent updates Transactions access a large fraction of the database Data need not be up-to-date The Internet Grocer OLTP-style transaction: John Smith, from Schenectady, N.Y., just bought a box of tomatoes; charge his account; deliver the tomatoes from our Schenectady warehouse; decrease our inventory of tomatoes from that warehouse OLAP-style transaction: How many cases of tomatoes were sold in all northeast warehouses in the years 2000 and 2001? OLAP: Traditional Compared with Newer Applications Traditional OLAP queries Uses data the enterprise gathers in its usual activities, perhaps in its OLTP system Queries are ad hoc, perhaps designed and carried out by non-professionals (managers) Newer Applications (e.g., Internet companies) Enterprise actively gathers data it wants, perhaps purchasing it Queries are sophisticated, designed by professionals, and used in more sophisticated ways The Internet Grocer Traditional How many cases of tomatoes were sold in all northeast warehouses in the years 2000 and 2001? Newer Prepare a profile of the grocery purchases of John Smith for the years 2000 and 2001 (so that we can customize our marketing to him and get more of his business) Data Mining Data Mining is an attempt at knowledge discovery – to extract knowledge from a database Comparison with OLAP OLAP: What percentage of people who make over $50,000 defaulted on their mortgage in the year 2000? Data Mining: How can information about salary, net worth, and other historical data be used to predict who will defau