InterBase

View Current Viewing Revision #8 from 12/12/2018 10:10 p.m.

Data Model

InterBase is a relational database management system (RDBMS) and it complies with SQL-92 standard.

Foreign Keys

InterBase supports foreign keys and creates indices for foreign keys by default. Referential integrity is enforced for foreign keys.

Concurrency Control

Multi-version Concurrency Control (MVCC)

InterBase implements Multi-Version Concurrency Control (MVCC) and refers to it as Multi-Generational Architecture.

Indexes

B+Tree

InterBase uses a variant of B-tree for index structure. Indices are automatically created for PRIMARY KEY, FOREIGN KEY and UNIQUE attributes.

Compression

Run-Length Encoding Prefix Compression

In index, data values are compressed via pre and postfix compression.

Joins

Nested Loop Join Sort-Merge Join

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.

Isolation Levels

Read Committed Snapshot Isolation

Three isolation levels are supported: SNAPSHOT, SNAPSHOT TABLE STABILITY, READ COMMITTED.

Revision #8 | Updated 12/12/2018 10:10 p.m.

View Current Viewing Revision #8 from 12/12/2018 10:10 p.m.

Website

http://www.embarcadero.com/products/interbase

Developer

Embarcadero Technologies, Inc.

Country of Origin

Start Year

1984

Former Name

Groton Database Systems, Yaffil

Acquired By

Ashton-Tate, Borland