Database systems: Design and implementation of a production database management system (DBM-2)

The DBM-2 is a transaction-oriented database management system designed to track activities within an organization. Being a production system, DBM-2 has different requirements and design criteria than exploratory database management systems. To support such applications in a production environment, DBM-2 is required to have high performance and flexibility. An extended entity-relationship (E-R) data model provides a basis for DBM-2 in meeting the requirements. The extended E-R data model simplifies the handling of existence dependency between data records by DBM-2. This paper presents the design and implementation of DBM-2. Special attention is given to the implementation of “associations” between records, because the implementation is critical for supporting the E-R model.