Try OpenEdge Now
skip to main content
Database Essentials
OpenEdge RDBMS : OpenEdge database file structure

OpenEdge database file structure

The OpenEdge database contains more than data. The following figure illustrates the components of an OpenEdge database. Descriptions of the files follow the table.
Figure 11. OpenEdge RDBMS
As shown in the above figure, a typical OpenEdge database consists of:
*A structure description (.st) file, which defines the structure of the database. The .st file is a text file with a .st filename extension. The administration utility PROSTRCT CREATE uses the information in the .st file to create the areas and extents of the database. It is the database administrator's responsibility to create the .st file. For detailed information about structure description files, see OpenEdge Data Management: Database Management.
*A log (.lg) file, which is a text file. The .lg file contains a history of significant database events, including server startup and shutdown, client login and logout, and maintenance activity.
*One database (.db) control area, which is a binary file containing a database structure extent. The control area and its .db file act as a table of contents for the database engine, listing the name and location of every area and extent in the database.
*One primary recovery (before-image) area, which contains one or more extents with a .bn filename extension. The .bn files store notes about data changes. In the event of hardware failure, the database engine uses these notes to undo any incomplete transactions and maintain data integrity.
*One schema area, which contains at least one variable-length extent with a .dn filename extension. The schema area contains the master and sequence blocks, as well as schema tables and indexes. Progress Software Corporation recommends that you place all your application data in additional data areas, but if you do not create application data areas, the schema area contains your user data.
*Optionally, application data areas, which contain at least one variable-length extent with a .dn filename extension. Application data areas contain user data, indexes, CLOBs and BLOBs.
*Optionally, one after-image area when after-imaging is enabled. The after-image area can contain many fixed-length and variable-length extents with the .an filename extension. In the event of hardware failure, the database engine uses the .an file and the most recent backup to reconstruct the database.
*Optionally, one transaction log area when two-phase commit is in use. The transaction log area contains one or more fixed-length extents with the .tn filename extension; variable-length extents are not allowed. The transaction log lists committed two-phase commit transactions.
An OpenEdge database is collectively all the files described above: the control area, schema area, data areas, recovery files, and log files. You should treat these files as an indivisible unit. For example, the phrase "back up the database" means "back up the database data: .db, .dn, .lg, .dn, .tn, .an, and .bn files together."
* Other database-related files