Demystifying Relational Database Management System
Keywords:
Introductory Concepts of DBMS, Advantages of DBMS over File System, Database Applications, Database ApplicationsData Abstraction in DBMS, DBMS Instance, Relational Query Languages, Relational Algebra, Relational Calculus, SQL Commands, Open Source And Commercial DBMS, Relational Database Design, Functional Dependency, Normalization, Translating SQL Queries into Relational Algebra, Transactions, Concurrency Control, Conflict Serializable Schedule, Storage System in DBMS, Indexing In DBMS, Database Security, Access Control in Database Security, Object-Oriented Database, Data WarehouseSynopsis
Data is raw fact and it has to be stored in Computers in form of Tables and Databases. There is data everywhere and role of Database Management System is to allow users to add data, delete data, search data and arrange data easily. It all started with simple and economical packages like dBASE and FoxPro. These packages were adopted by the Industries for maintaining their databases. Programming and handling databases in these two packages was simple and easy. With the advancements in technology, Oracle and DB2 became popular Relational Database Management systems. Other RDBMS products were MS-Access, Sybase and Informix. This compelling presence of Relational Database Management systems has made it necessary for everyone to have knowledge of the RDBMS.
