ITM 100 Chapter Notes - Chapter 7: Data Mart, Unique Key, Hierarchical Database Model

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Ron Babin

Document Summary

Data raw facts that describe the characteristics of an event. Information - data converted into a meaningful and useful context. Granularity refers to the extent of detail within the data and information (fine and detailed vs coarse and abstract) Transactional data encompasses all of the data contained within a single business process or unit of work, and its primary purpose is to support performing daily operational tasks. Organizations capture and store transactional data in databases and they use it when performing operational tasks and repetitive decisions such as analyzing daily sales figures and production schedules to determine how much inventory to carry. Analytical information encompasses all organizational information, and its primary purpose is to support the performance of higher level analysis tasks. Real time data- immediate up to date data. Real time information immediate, up to date information. Real time system provides real-time transactional data and/ or real time analytical info in response to query requests.