Several database engines in Delphi

The frequently used words in Delphi are ado, BDE, and dbexpress. What are the similarities and differences between them? What are the types of database engines in Delphi? Maybe we should take a look at the whole to get targeted.
Delphi provides four Data Program Design Standards: borland database engine (BDE), ActiveX Data Object (ADO), dbexpress, and InterBase Express.
(1) Delphi's BDE is a 32-bit database engine in a window environment. it also provides a set of API functions that can be called by dynamically linking files in any language, or you can directly use the BDE component provided by Delphi to use these Apis. BDE provides SQL links to link six types of background databases Sybase, Interbase, Oracle, MS-SQL, Informix, DB2. If the background database is not the six types mentioned above, you can also purchase ODBC drivers to link other types of data libraries. In the local (local desktop database) Section, paradox (*. DB), DBASE (*. DBF), Microsoft FoxPro, Microsoft Access, and so on. It also provides a click version of INTERBASE, allowing you to simulate the development of a master-slave database in a standalone environment. if BDE is used in programs developed using Delphi, BDE must be installed on your computer. Inprise does not charge any fee.
(2) The ole db implemented by Microsoft Based on COM is used to replace the ODBC role as the intermediate software for accessing the database, while ADO is the top layer of ole db, it is an interface for Windows applications to call (inteface). In fact, ADO is only a small part of MDAC. The full name of MDAC is Microsoft Data Access Components, MDAC has completed all Microsoft database access technologies, such as ADO, ole db, ODBC, and RDS (Remote Data Service). Therefore, after installing MDAC, the above mentioned various database access technology will be installed in, with the software developed by ADO, you must install the corresponding version of MDAC on the user's computer, can be free download (http://www.microsoft.com)
(3) due to the poor access efficiency of BDE, and the difficulty in writing the SQL Link driver, and the difficulty in porting the platform, Delphi weighs another database access standard dbexpress, borland writes dbexpress native driver for various database programming and encapsulates a group of dbexress components. dbexpress has the advantages of fast data access and easy platform transfer. Because BDE itself has a set of database engines, it maintains the database query cursor, so the access efficiency is poor, dbexpress's dataset extracted from the database fetch is undirectional cursor, so the access efficiency is much better than BDE. in addition, dbexpress provides native driver standards that are easy to write and highly portable. Currently, dbexpress is available in Linux.
(4) Delphi also provides a set of native components, Interbase Express, so that you can directly and quickly use the Interbase database. This group of ibx components encapsulates the APIS provided by InterBase, its access efficiency is even higher than that of BDE and dbexpress. The only drawback is that it is dedicated to InterBase Server and does not apply to access by other database servers. the Delphi CD contains a relational database system: Interbase, which must be installed on Windows NT operating systems. Borland provides this database system for free, you only need to purchase the Enterprise Edition of Delphi to create a complete master-slave architecture system. After you develop a complete set of applications, you can purchase other types of background database systems. this set of InterBase Server is used by developers rather than users. Therefore, if you distribute this set of INTERBASE directly to multiple users, it will violate the copyright law. If you use the truth
Interbase is a back-end database running on the master and slave systems. You can purchase the correct version from Borland.
Note: Delphi built-in Database Maintenance Tool Database Desktop can not modify the SQL database table structure (such as MS-SQL, Oracle, Sybase), it can only modify the local database table structure (such as dBase, paradox, Foxpro, access ).