<< Click to Display Table of Contents >>
Accessing an Oracle Server via Database Object |
Elipse E3's Database object uses OCI (Oracle Call Interface) to communicate with an Oracle server, that is, it uses the native form to improve communication performance with a database.
A good example on how Elipse E3's Database object communication with an Oracle server works is the Historic object. First, data acquisition is performed by a Historic that, with this data, immediately sends it as a request to a database. These requests can be for creating a table, creating indexes and keys, or adding data, among others. Elipse E3's Database object contains a separated process specially designed to receive them. Depending on the type of operation to perform, data is formatted and saved in a temporary file or in memory.
At the same time, a Database object has another process, responsible for retrieving requests and sending them to a database as SQL commands, by using OCI.
Communication between Elipse E3 and Oracle