Accessing an Oracle Server via Database Object

<< 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

Communication between Elipse E3 and Oracle

Was this page useful?