ADMS 2511 Chapter Notes - Chapter 4: Intellectual Capital, Online Analytical Processing, Customer Relationship Management
Document Summary
Companies are using data warehousing, and data mining tools to make it easier and faster for users to access, analyze and query data. Data mining tools allow users to search for valuable business information in a large database or data warehouse. Data warehouse: is a repository of historical data organized by subject to support decision makers in the organization. Data warehouses facilitate business intelligence activities such as data mining, decision support and querying applications. Organized by business dimension or subject: data organized by subject and contain information relevant for decision support and data analysis. Consistent: all data must be coded in a consistent manner. Historical: data kept for many years, so it can be used for trends, forecasting and making comparisons over time. Nonvolatile: data is not updated after it is entered into the warehouse. Has the ability to use online analytical processing: databases use online.