Browse Prior Art Database

Dynamic SQL Transformation

IP.com Disclosure Number: IPCOM000035553D
Original Publication Date: 2005-Jan-24
Included in the Prior Art Database: 2005-Jan-24

Publishing Venue

IBM

Abstract

Database products today do not necessarily implement an entire language standard; therefore applications may require product-specific persistence logic which would be bound to that application. Proposed is a method for separating product-specific persistence logic from the application and utilizing a generic language transformer that would allow any application whose persistence layer adheres to a standard to utilize the offerings of any database product without having to modify application code. Since the language transformer is generic, there is no tight relationship to the application; generic database queries made by an application could be transformed to product-specific queries dynamically at runtime.