The DevpartnerDB 4.1 for Oracle targets Oracle's Procedural Language extension to the Structured Query Language (PL/SQL), the original programming environment for the database before the company adopted Java as an alternative. The tools allow procedures to be examined and stepped through allowing time-wasting system calls to be isolated and improved.
Compuware has worked to make the environment more visual with a user interface that can be customised. Developers can modify the toolbar to add direct links to online help sites and buttons can be created to allow one-click access to commonly used features. Another visual aid is the database monitor which shows what resources are being used to help the user to identify causes of data access problems.
SQL statements used within an application can be phrased and rephrased until the optimum command is discovered. Tuning wizards track each version and graph the results. The graphs can then be compared to reveal the best performer before the statement is moved into the production model.
Shari Zedeck, director of product management at Compuware, said, "DevpartnerDB helps developers spot problems early in the development application cycle and react immediately to database SQL performance problems, saving time and money."