DB Link Tutorial
DB Link is a comprehensive C++ library that handles the processing of Relational Database Management Systems (RDBMS). It includes several classes of objects that allow efficient development of applications with RDBMS connectivity. The API is simplified to hide the complexity of the Client API of the various RDBMSs. Furthermore, the DB Link API is the same for any RDBMS. Consequently, applications developed with the DB Link library will work with Oracle®, Sybase, or Informix (for example) without any change in the source code.
A schematic representation of the DB Link Architecture is shown in DB Link Architecture.
This tutorial presents the main features of the library through the use of samples. Each significant point is detailed with the corresponding excerpt from the source code. The full code is also provided, if you wish to get a complete view of the mechanism.
The tutorial is divided in 4 sections:
-
DB Link Basic Use - Describes the basic features of DB Link—how to connect and execute queries. It explains the fundamental classes of DB Link: IldDbms, IldRequest, and IldDiagnostic.
-
DB Link Optimization Techniques - Describes the methods used to optimize an application when using DB Link to run queries on an RDBMS.
-
DB Link Portability Considerations - Describes the special considerations to keep in mind when building portable applications.
-
DB Link Access to Object Data Types - Presents how to access the new data types introduced by Object Oriented RDBMS.
