InterBase implements Multi-Version Concurrency Control (MVCC) and refers to it as Multi-Generational Architecture.
InterBase uses an optimizer to estimate costs of different joining orders and to generate data retrieval plan. Merge-Sort Join and Nested Loop Join are supported. InterBase also allows users to specify customized plan by using PLAN clause.
Three isolation levels are supported: SNAPSHOT, SNAPSHOT TABLE STABILITY, READ COMMITTED.
InterBase uses a variant of B-tree for index structure. Indices are automatically created for PRIMARY KEY, FOREIGN KEY and UNIQUE attributes.
InterBase supports foreign keys and creates indices for foreign keys by default. Referential integrity is enforced for foreign keys.
InterBase is a relational database management system (RDBMS) and it complies with SQL-92 standard.
In index, data values are compressed via pre and postfix compression.
Embarcadero Technologies, Inc.
Groton Database Systems, Yaffil