Borland Database Engine

Borland Database Engine

Borland Database Engine (BDE) is the Windows-based core database engine and connectivity software behind Borland Delphi, C++Builder, IntraBuilder, Paradox for Windows, and Visual dBASE for Windows.

History

Borland’s Turbo Pascal included a "database" Toolbox, it was the beginning of the Borland compiler add-ons that facilitated database connectivity. Then came the Paradox Engine for Windows – PXENGWIN – which could be compiled into a program to facilitate connectivity to Paradox tables.

The first DLL-based connectivity engine was ODAPI (Open Database API). It represented Borland’s attempt to centralise connectivity in its suite of applications which included the brand-new Paradox for Windows 4 and Quattro. With version 4.5 / 5.0 of Paradox for Windows, this database engine was crystallised as IDAPI.

In 2000, Borland introduced a new SQL driver architecture called dbExpress, which deprecated BDE SQL links technology.

Design

The included set of database drivers enables consistent access to standard data sources: Paradox, dBASE, FoxPro, Access, and text databases. You can add Microsoft ODBC drivers as needed to the built-in ODBC socket. Optionally, Borland's SQL Links product provides access to a range of database management systems (DBMS), including Informix, DB2, InterBase, Oracle, and Sybase.

BDE is object-oriented in design. At runtime, application developers interact with BDE by creating various BDE objects. These runtime objects are then used to manipulate database entities, such as tables and queries. BDE's application program interface (API) provides direct C and C++ optimized access to the database engine, as well as BDE's built-in drivers for dBASE, Paradox, FoxPro, Access, and text databases.

The core database engine files consist of a set of DLLs that are fully re-entrant and thread-safe. Included with BDE are a set of supplemental tools and examples with sample code.

BDE system is configured using the BDE Administrator (BDEADMIN.EXE).

Included with BDE is Borland's Local SQL, a subset of ANSI-92 SQL enhanced to support Paradox and dBASE (standard) naming conventions for tables and fields (called "columns" in SQL). Local SQL lets you use SQL to query "local" standard database tables that do not reside on a database server as well as "remote" DBMS servers. Local SQL is also essential to make multi-table queries across both local standard tables and those on remote SQL servers.

The older name for the BDE API is the "Integrated Database Application Program Interface" or "IDAPI".


Wikimedia Foundation. 2010.

Игры ⚽ Поможем сделать НИР

Look at other dictionaries:

  • Borland Database Engine — Die Borland Database Engine (kurz BDE) ist eine universelle Schnittstelle zum Zugriff auf relationale Datenbanken, die von der Firma Borland für Windows Systeme entwickelt wurde. Sie bietet Zugang zu Desktop Datenbanken wie Paradox, dBASE/FoxPro… …   Deutsch Wikipedia

  • Borland (Begriffsklärung) — Borland ist der Familienname folgender Personen: Adrian Borland (1957–1999), britischer Songtexter und Sänger Charles Borland (1786–1852), US amerikanischer Politiker Hal Borland (1900–1978), US amerikanischer Schriftsteller James Borland… …   Deutsch Wikipedia

  • Borland Paradox — Paradox ist eine Datenbankentwicklungsumgebung bzw. ein dateibasiertes Datenbankformat der Firma Borland bzw. Corel, welches dBASE III, dBASE 3+ und dBASE IV sehr ähnlich und seit den 1980er Jahren auf dem Markt erhältlich ist. Inhaltsverzeichnis …   Deutsch Wikipedia

  • Borland — Logo des Unternehmens Borland ist ein Softwareunternehmen (NASDAQ NM: BORL) mit Hauptsitz in Austin, Texas, in der USA.[1]. Seit 2009 ist es ein Tochterunternehmen von Micro Focus International. Inhaltsverzeichnis …   Deutsch Wikipedia

  • Borland — Infobox Company company name = Borland Software Corporation company company type = Public (nasdaq|BORL) company slogan = The Open ALM Company foundation = California (1983) location = Austin, Texas (previously Cupertino, California) key people =… …   Wikipedia

  • Paradox (database) — Paradox is a relational database management system currently published by Corel Corporation. It was originally released for DOS by Ansa Software, and then by Borland after it bought the company. A Windows version was released by Borland in 1992.… …   Wikipedia

  • Mobile database — A mobile database is a database that can be connected to by a mobile computing device over a mobile network. The client and server have wireless connections. A cache is maintained to hold frequent data and transactions so that they are not lost… …   Wikipedia

  • Flat file database — A flat file database describes any of various means to encode a data model (most commonly a table) as a plain text file. Flat filesA flat file is a plain text file which usually contains one record per line. [Citation last = Fowler first = Glenn… …   Wikipedia

  • Firebird (database server) — Infobox Software name = Firebird caption = developer = [http://www.firebirdsql.org Firebird Project] latest release version = 2.1.1 latest release date = 16 July 2008 latest preview version = 2.5 Alpha 1| latest preview date = 12 July 2008… …   Wikipedia

  • Comparison of relational database management systems — Programming language comparisons General comparison Basic syntax Basic instructions Arrays Associative arrays String operations …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”