Patent ID: 9372671
Filing Date: 2016-06-21
CPC Classification: G06F

Claim Text:
1. A system comprising: a processor and a non-transitory memory operatively coupled to the processor; a model viewer when executed by the processor is configured to receive a selection, by a user, of a component to include in a visual representation of a data transformation model (DTM) for a database; a model builder when executed by the processor is configured to arrange logic corresponding to the selected component in the DTM, wherein the selected component and the logic are compatible with a plurality of different implementations of SQL (structured query language) wherein the different implementations of SQL comprise at least one or more SQL code features specific to each implementation, and wherein the logic comprises at least one custom-written SQL component including SQL code specific to a particular implementation of SQL; a code generator configured to: wherein the generated SQL code, when executed, performs one or more data transformation on data of the database; and the model viewer being further configured to provide the generated SQL code for rendering substantially simultaneously with the visual representation of the DTM including the selected component.