Now since we are done with the history and overview of the Openedge Database.Let's move into the technical aspect of the Openedge Database,which i guess would intrest more to a DBA aspirant than my previous boring post;)When administering a Progress database, it is important to understand its architecture and theconfiguration options it supports.The architecture would comprise of the various components which ensure the functioning of the database system.
Let's first discuss about how the storage structure is designed in a progress database.The storage design of a Progress database is divided into :1. Logical model: here databases contain logical database objects that are updated through language statements, and queried by applications that need information.The logical storage model can be manipulated through the 4GL and SQL-92 interfaces
2. Physical model: The physical storage model is manipulated through 4GL, SQL-92, and database administration utility interfaces.
Now Let us dig deep into the storage design overview
Storage objects are collections of space associated with one or more specific database objects.Each storage object is an instance of a database object described in the schema. Types of storage objects include: