ITM 102 Lecture Notes - Lecture 6: Online Analytical Processing, Root Mean Square, Business Intelligence
Document Summary
Data redundancy: the presence of duplicate data in multiple data les so that the same data are stored in more than one place or location. Data inconsistency: the same attribute may have different values. The coupling of data stored in les and the speci c programs required to updated and maintain those les such that changes in programs require changes to the data. Traditional le system can deliver routine scheduled reports after extensive programming efforts but 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 changes to the organization"s data. Lack of data sharing and availability information cannot ow freely across different functional areas or different parts of the organization. How a dmbs solves the problems of the traditional le environment. Represent data as two-dimensional tables called relations. Relates data across tables based on common data element.