Progress
DataServer
for ORACLE Guide


ORACLE and Progress Objects and Terminology

ORACLE and Progress databases share the structural elements common to relational databases, but each system has its own elements. These structural elements are called schema objects in ORACLE and database objects in Progress. Schema objects or database objects are components of the database’s logical structure. The two database management systems have different terminology for referring to these objects, as shown in Table 2–1.

Table 2–1: ORACLE and Progress Objects
ORACLE Schema Object
Progress Equivalent
Table
Table
Column
Field
Row
Record
Index
Index
Sequences
Sequences
Integrity constraint1
Validation expression
No equivalent
Validation message
Trigger
Trigger
Stored procedures
Stored procedures ( SQL Engine)
View
View (SQL Engine)
Clusters
No equivalent
ORACLE8 Object methods
No equivalent
Synonyms
Synonyms (SQL Engine)
  1. The ORACLE Integrity constraint enforces data integrity and business rules. However, unlike the Progress validation expression, you cannot include code in the integrity constraint. You choose one of the following checks: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095