Design of object-oriented relational database

One, the distinction of the concept

Some people confuse object-oriented database design (i.e. database schema) with object-oriented database management system (OODBMS) theory. In fact, the former is a database user-defined database mode of thinking, the latter is the idea of database management program. User-oriented methodology can be used to define any DBMS database, that is, network type, hierarchical type, relational type, object oriented, and even file system design can follow the object-oriented approach.

Object-oriented ideas or specifications can be used for system analysis, system design, programming, and data structure design, database design. Oose from top to bottom, throughout the implementation of object-oriented ideas, is a coherent unity. Object-oriented database design is only one link of oose.

Second, the importance of database design

There are two kinds of general database design methods, namely attribute-dominant and entity-dominant. The attribute-dominant type, starting from the attributes applied by the inductive database, maintains the function dependencies between attributes when merging the attribute collection (entity). The entity-dominant type starts by looking for a meaningful entity to apply to the database, and then defines the entity by defining the attribute. The entity-Dominant design method should be used when the number of entities in the real world is below 1/10. Object-oriented database design is based on object model, which belongs to entity-oriented design.

General database application Systems follow the following related development steps:

1, the design application system structure;

2. Choose a DBMS architecture, such as an RDBMS, that facilitates the integration of applications with DBMS;

3, according to the application of the Environment platform, select the appropriate DBMS (such as Oracle) and development tools (such as PB);

4, design the database, write the SQL program that defines the database schema;

5, the preparation of data to ensure the correct input database user interface application;

6, input database data;

7 run a variety of database-related applications to confirm and correct the contents of the database.