DBDB.io The Encyclopedia of Database Systems · Est. 2017
Login
Database of Databases

Database Entry

InterBase

Website
http://www.embarcadero.com/products/interbase[01]
Developer
Country of Origin
US
Start Year
1984 [02]
Former Names
Groton Database Systems, Yaffil
Acquired By
Project Type
Commercial
Supported Languages
SQL
License
Proprietary
Wikipedia
https://en.wikipedia.org/wiki/InterBase[02]

Database Entry

InterBase

Checkpoints[03]

Checkpoint (also called Journaling Checkpoint) is supported in InterBase.

Compression[04]

Run-Length Encoding Prefix Compression

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

Concurrency Control[05]

Multi-version Concurrency Control (MVCC)

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

Data Model[06]

Relational

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

Foreign Keys[07]

Supported

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

Indexes[08][04]

B+Tree

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

Isolation Levels[09]

Read Committed Snapshot Isolation

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

Joins[10][11]

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.

Logging[03]

Logging is called Journaling in InterBase.

Query Interface[12]

SQL Stored Procedures

InterBase supports SQL and Stored Procedures.

Storage Architecture[13]

Disk-oriented

InterBase is a disk-oriented DBMS.

Storage Model[13]

N-ary Storage Model (Row/Record)

InterBase adopts N-ary Storage Model.

Stored Procedures[12]

Supported

InterBase supports Stored Procedures.

System Architecture[14]

Shared-Everything Embedded

InterBase is provided in two editions: server edition and deeply embedded library edition.

Views[15]

Virtual Views

InterBase supports virtual views. Views are not materialized.

Derivative Systems
Firebird Firebird
People Also Viewed
SpacetimeDB SpacetimeDB Fjall Fjall HFSQL HFSQL RaimaDB RaimaDB

Citations

15 sources
  1. http://www.embarcadero.com/products/interbase embarcadero.com Dead — Check Archive
  2. InterBase - Wikipedia wikipedia.org
  3. http://docwiki.embarcadero.com/InterBase/XE7/en/How_Journaling_Works embarcadero.com Spam — Check Archive
  4. http://docwiki.embarcadero.com/InterBase/XE7/en/Database_Physical_Properties embarcadero.com Dead — Check Archive
  5. http://docwiki.embarcadero.com/InterBase/XE7/en/Multi-Generational_Architecture embarcadero.com Dead — Check Archive
  6. InterBase - Wikipedia wikipedia.org
  7. https://www.ibphoenix.com/resources/documents/general/doc_70 ibphoenix.com Dead — Check Archive
  8. http://docwiki.embarcadero.com/InterBase/XE7/en/Creating_Indexes embarcadero.com Dead — Check Archive
  9. http://docwiki.embarcadero.com/InterBase/XE7/en/Isolation_Level embarcadero.com Dead — Check Archive
  10. http://docwiki.embarcadero.com/InterBase/XE7/en/IBConsole_-_Performance_Guidelines embarcadero.com Dead — Check Archive
  11. http://docwiki.embarcadero.com/InterBase/XE7/en/Specifying_a_Query_Plan_with_PLAN embarcadero.com Dead — Check Archive
  12. Embarcadero RAD Studio, Delphi, & C++Builder Blogs embarcadero.com Dead — Check Archive
  13. https://edn.embarcadero.com/article/27151 embarcadero.com Dead — Check Archive
  14. InterBase: Supported Platforms - Embarcadero embarcadero.com
  15. http://docwiki.embarcadero.com/InterBase/XE7/en/InterBase_Quick_Start:_Part_II_-_Creating_Views embarcadero.com Dead — Check Archive
Revision #9 Last Updated: