Primary InterBase Features

From InterBase
Jump to: navigation, search

Go Up to Introduction to Operations


InterBase offers all the benefits of a full-featured RDBMS. The following table lists some of the key InterBase features:

Feature Description

Network protocol support

  • All platforms of InterBase support TCP/IP
  • InterBase servers and clients for Windows support NetBEUI/named pipes

SQL-92 entry-level conformance

ANSI standard SQL, available through an Interactive SQL tool and Embarcadero desktop applications.

Simultaneous access to multiple databases

One application can access many databases at the same time.

multigenerational
architecture

Server maintains older versions of records (as needed) so that transactions can see a consistent view of data.

Optimistic row-level locking

Server locks only the individual records that a client updates, instead of locking an entire database page.

Query optimization

Server optimizes queries automatically, or you can manually specify a query plan.

Blob data type and Blob filters

Dynamically sizeable data types that can contain unformatted data such as graphics and text.

Declarative referential integrity

Automatic enforcement of cross-table relationships (between ­FOREIGN and PRIMARY KEY constraints).

Stored procedures

Programmatic elements in the database for advanced queries and data manipulation actions.

Triggers

Self-contained program modules that are activated when data in a specific table is inserted, updated, or deleted.

Event alerters

Messages passed from the database to an application; enables applications to receive asynchronous notification of database changes.

Updatable views

Views can reflect data changes as they occur.

User-defined functions (UDFs)

Program modules that run on the server.

Outer joins

Relational construct between two tables that enables complex operations.

Explicit transaction
management

Full control of transaction start, commit, and rollback, including named transactions.

Concurrent multiple application access to data.

One client reading a table does not block others from it.

multidimensional arrays

Column data types arranged in an indexed list of elements.

Automatic two-phase commit

Multi-database transactions check that changes to all databases happen before committing (InterBase Server only).

InterBase API

Functions that enable applications to construct SQL/DSQL statements directly to the InterBase engine and receive results back.

gpre

Preprocessor for converting embedded SQL/DSQL statements and variables into a format that can be read by a host-language compiler; included with the InterBase server license.

IBConsole

Windows tool for data definition, query, database backup, restoration, maintenance, and security.

isql

Command-line version of the InterBase interactive SQL tool; can be used instead of IBConsole for interactive queries.

Command-line database administrator utilities

Command-line version of the InterBase database administration tools; can be used instead of IBConsole.

Header files

Files included at the beginning of application programs that define InterBase data types and function calls.

Example make files

Files that demonstrate how to invoke the makefiles to compile and link InterBase applications.

Example programs

C programs, ready to compile and link, which you can use to query standard InterBase example databases on the server.

Message file

interbase.msg, containing messages presented to the user.

Topics