Database Management Systems

BIS 315 Semester 1, 2012/2013



    



 



Some common uses of database systems. Characteristics of file-based systems. Problems with file-based approach. Meaning of the term database. Meaning of the term Database Management System (DBMS). Typical functions of a DBMS. Major components of the DBMS environment. Personnel involved in the DBMS environment. History of the development of DBMSs. Advantages and disadvantages of DBMSs.

2 / 66



The importance of DB System has increased with the significant developments in:

◦ Hardware capability ◦ Hardware capacity ◦ Communication

     Emergence of the Internet Electronic Commerce Business Intelligence Mobile Communications Grid Computing

3 / 66



 





The DB system is arguably the most important development in the field of SE. The DB is now the underlying framework of the IS. DB is fundamentally changing the way that many organizations operate. DB technology has been the catalyst for many important development in SE. We are only at the end of the beginning of the development.

4 / 66



 





DB is now an integral part of our day-to-day life that often we are not aware we are using one. DB is a collection of related data. DBMS is the software that manages and controls access to the DB. DB application is a program that interacts with the DB at some point in its execution. DB system is a collection of application programs that interact with the DB along with the DBMS and DB itself.

5 / 66



Purchases from the supermarket

◦ ◦ ◦ ◦ ◦ ◦ ◦ Bar code reader Linked to an application program Find out the price Product DB Reduce the number of such items in stock Display the price Automatically place an order

6 / 66



Purchases using your credit card

◦ ◦ ◦ ◦ ◦ Sufficient credit left to make the purchase DB application program The price is within the credit limit The credit card is not on the list of stolen or lost cards Monthly statement...