Patent ID: 7478111

Claim:
A method for the transition of a legacy application to a new application, the legacy application being defined to access a legacy relational database having a legacy schema and the new application being defined to access a transitioned relational database having a new schema, said method comprising the steps of: a. selecting a set of transition schema changes corresponding to the transition of the legacy schema to the new schema, and b. generating one or more relational database views for the transitioned relational database using a pre-defined set of relational database views relating to schema changes and selecting views in the pre-defined set that correspond to the set of transition schema changes; wherein the one or more relational database views map the new schema to the legacy schema, and database queries originally defined for the legacy database are executed against the transitioned relational database; wherein the pre-defined set of relational database views includes views relating to schema changes selected from the set of column-wise splits, row-wise splits, column-wise merges, row-wise merges, column name changes, column type changes, nullable to not-nullable transitions, value maps, column splits, and column merges; wherein said step of determining a set of transition schema changes further comprises defining an XML file representing the transition schema changes; and wherein said step of generating one or more relational database views for the transitioned relational database further comprises accepting the XML file as input and generating the one or more relational database views based on the content of the XML file.