ITM 100 Lecture Notes - Lecture 6: Online Analytical Processing, Data Governance, Business Intelligence

• School: Ryerson University
• Department: Information Technology Management
• Course: ITM 100
• Professor: Xiao Ping Zhang

Document Summary

Field: group of words or a complete number. Bit: smallest unit of data; binary digit (0,1) Byte: group of bits that represents a single character. Entity: person, place, thing, event about which information is maintained. Key field: identifier field used to retrieve, update, sort a record. Program-data dependence: the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data. Lack of flexibility: a traditional file system can deliver routine scheduled reports after extensive programming efforts, but it cannot deliver ad-hoc reports or respond to unanticipated information requirements in a timely fashion. Poor security: management may have no knowledge of who is accessing or making cha(cid:374)ges to the o(cid:396)ga(cid:374)izatio(cid:374)"s data. Lack of data sharing and availability: information cannot flow freely across different functional areas or different parts of the organization.