Business application developers spend an inordinate amount of effort creating and maintaining the mappings between applications and databases. The Gartner Group estimates that this activity accounts for up to 40 percent of a developer's time. Today most application-to-database logic is buried in application code and stored procedures as hard coded Data Manipulation Language (DML). Anytime the database tables or columns change (because of new information requirements or performance tuning), this has an impact on the DML. Developers must manually search for DML and recode it, which can be further complicated when single databases serve multiple applications.
Visualizing the usage of data by applications allows developers to understand and quickly address the impact of database change. Providing new means to locate, maintain, and encapsulate the DML for better reuse leads to productivity breakthroughs.
PLATINUM SQL-Compass is a complete visual modeling tool for managing the interaction between applications and databases. It delivers extraordinary productivity, with easy-to-use visual modeling and impact analysis tools architected to minimize the time spent developing and maintaining these mappings.
The visual mappings that represent native database DML can be modeled from scratch in SQL-Compass, or existing application code can be scanned to visualize where the existing data access mappings are already defined as hard-coded DML. Once modeled, SQL-Compass helps the modeler understand where proposed or actual database changes will impact application DML.
In addition to impact analysis, SQL-Compass can generate encapsulated DML, called SQL Components. SQL Components can be deployed at any tier of an application and support all major middleware connectivity solutions, including: SQL*Net, ODBC, RDO, and JDBC. Cross platform deployment and the reusability of data access across an organization enables SQL Components to be easily deployed as a reusable, consistent, optimized way for programmers to access data. SQL Components' deployed value is further enhanced by the ability to quickly facilitate database changes by simply regenerating the impacted SQL Components.
Features and Benefits
Application Development Language Compatibility:
Operating System Compatibility: