Dynamic SQL Transformation
Original Publication Date: 2005-Jan-24
Included in the Prior Art Database: 2005-Jan-24
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.