Try OpenEdge Now
skip to main content
Database Essentials
OpenEdge RDBMS : Storage design overview
 

Storage design overview

The storage design of the OpenEdge RDBMS is divided into a physical model and a logical model. You manipulate the physical storage model through ABL, OpenEdge SQL, and database administration utility interfaces. The following figure shows how areas can be stored on and span different file slices. Observe that although an area's extents are comprised of many disk files, an extent can only be associated with one storage area.
Figure 13. Physical storage model
The logical storage model overlays the physical model. Logical database objects are described in the database schema and include tables, indexes, and sequences that your application manipulates. The following figure illustrates how logical objects can span physical extents.
Figure 14. Logical storage model
* Mapping objects to areas