ITEC 1010 Lecture 2: Data Warehouses

• School: York University
• Department: Information Technology
• Course: ITEC 1010
• Professor: Colin Coates

Document Summary

You want concise, reliable information about current operations, trends and changes across the company. If you worked in a large company, obtaining this might be difficult, because data are often maintained in separate systems, such as: sales, manufacturing, or accounting. Some of the data you need might be found in the sales system and other pieces in the manufacturing system. Many of these systems are older legacy systems that use outdated data management technologies or file systems in which in which information is difficult to access. You might need to spend an inordinate amount of time locating and gathering the data you need. Be forced to make your decision on the basis of incomplete knowledge. If you want information about trends, you might have trouble finding data about past events because most firms only make their current data immediately available. Data warehouse: a database that stores current and historical data of potential interest to decision makers throughout the company.