ITM 102 Lecture Notes - Data Manipulation Language, Sql, Data Warehouse
Document Summary
6. 1 - organizing data in traditional file environment. Program-data dependence: the coupling of data stored in files and the specfic programs required to update and maintain those files so that changes in programs require changes to the data. 6. 2- the database approach to management database management system (dbms): software that permiits an organization to centralize data, manage them efficiently, and provide access to the stored data by application programs. Dbms relieves the programmer or end user from the task of understanding where and how the data are actually stored by separating the logical and physical views of the data. Logical: presents data as they would be perceived by end users or business specialists. Physical: shows how the data are actually organized and structured on physical storage media. How a dbms solves the problems of the traditional file environment. Enables the organization to centrally manage their data.