SQL Extraction

Optimize applications by extracting code to the database

Database applications contain many different interactions with the database. Some of these interactions are pure business logic, even though they are neither identified or positioned as such. In Web applications, frequent interactions with the database can also slow down the performance of the application, whilst connections are opened and closed.

ATX has developed a semi-automated way to analyze Oracle Forms source code and identify blocks of code that include database interactions. Such blocks can be isolated from any presentation logic and moved to the database layer, thus improving the operational efficiency of the application.

The result of the service is dependent upon customer need, but can include:

  • A report identifying the position and size of each block;
  • Extraction of the code blocks to separate files;
  • Replacement of the code blocks with calls to database functions;

For more information, please contact us on sales@atxsoftware.com