CS 3430 Lecture 3: DBMS Cont

• School: App State
• Department: Computer Science
• Course: CS 3430
• Professor: Mohammad Mohebbi

Document Summary

Advantages of using dbms continues : efficient query processing by dbms advanced algorithms implemented in a dbms software, to retrieve stored data faster from the disk, dbms provide backup and recovery functionalities. System crash => go back to last persistent state (a correct database state). correct database state: providing multiple ways of accessing a database. Db admins: applying constraints on data, i. e. rules related to the mini-world that we model. For example, every course section record, must be related to a course record. Simple and data is not going to change at all, for example a bilanguage dictionary! Real time applications and software that need fast response time. No need for multi-user access to data. End users; those who use database on daily basis and for their job. Defining users, access level of each user, maintaining database up, running and secure. Setting up the hardware and software needed for a dbms.