 |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
Achieving Database Interoperability through SQL Leveling Across Data Access APIs
SQL leveling provides the capability to write a SQL statement that can be executed across multiple databases, regardless of the databases' SQL implementation. For example, a SQL statement written against Oracle will also be interoperable with DB2.
Each of the major database vendors implements certain functionality in a unique proprietary format. The functionality differences from the ANSI SQL standard fall into the following broad categories:
- Date and time literals representation
- Syntax for outer joins
- Syntax for scalar functions
- Methods for invoking stored procedures
- Dynamic SQL statement format corrections
- Empty string and null conversions
- Long character string insertion support
These proprietary SQL implementations impact the interoperability provided by open data access standards. Adoption of open standards has enabled companies to reduce expenditures by delivering a high degree of interoperability among databases. The inability to provide SQL interoperability has hindered some organizations from realizing the full benefits of adopting these open standards.
DataDirect Technologies has long been an industry leader in providing companies the highest level of interoperability between databases. One of the key areas of interoperability is SQL leveling. DataDirect provides SQL leveling across all open data access APIs. This gives developers a common way to implement these types of functionality - using the same code - regardless of the backend DBMS.
