ITM 100 Chapter Notes - Chapter 6: Best Western, Online Analytical Processing, Data Warehouse

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Jim Tam

Document Summary

File organization terms and concepts: bite: smallest unit of data a computer can handle, byte: is a group of bits, represents a single character, ex. Problems with the traditional file environment: data redundancy and inconsistency, data redundancy: is the presence of duplicate data in multiple data files so that the same data are stored in more than one place of location. When different groups of an organization save the same data/waste storage: data inconsistency: where the same attribute many have different values. Information cannot flow freely across different functional areas or different parts of the organization. Dbms: software that permits an organizations to centralize data, manage them efficiently, and provide access to the stored data by application programs. Acts as an interface between application programs and the physical data files. Logical view: presents data as they would be perceived by end users or business specialists. Physical view: shows how data are actually organized and structured on physical storage media.