BMGT 402 Lecture Notes - Lecture 23: Enterprise Resource Planning, Data Warehouse, Online Transaction Processing

• School: University of Maryland
• Department: Business and Management
• Course: BMGT 402
• Professor: Woei- Jyh Lee

Document Summary

Bmgt402 lecture 23 chapter 12: data warehousing. A consolidated / integrated view of data drawn from disparate operational data sources. A range of end-user access tools supporting queries. Organized around major subject of the enterprise (customers, products, and sales) vs. major applications (customer invoicing, stock control, and product sales) Decision-support data vs. application-oriented data: integrated. Integrates application-oriented data from different source systems that often includes data that is inconsistent. Should be consistent to present a unified view of the data. Non-volatile data: subject oriented data, integrated data, time-variant data. Only accurate and valid at some point in time or over some time interval. Represents a series of snapshots: non-volatile data. Non updated real-time rt but refreshed periodically. New data is added as a supplement to the database rather than a replacement. Benefits of data warehousing: potential high returns on investment (roi) Roi of 400% or more (idc report)