System and method for database migration and validation

摘要

A system and method for database migration and validation is provided. In an embodiment, the database migration and validation system may include a migration framework which analyzes a relational database and its associated access coding and preprocessing/post-processing coding, and based on these analyzes generates an in-memory database, access coding, and database coding in a computer system. The database migration and validation system may also include a validation framework which presents validation queries to the relational database and the in-memory database, compares the results of the queries, and reports the outcome of the comparison.

主权项

1. A database migration and validation system contained within a first computing device including a processor, a main memory, and a secondary storage device, comprising:
a relational database stored in the secondary storage device; relational database access coding to call the relational database, read and write to the relational database, and receive calls from the relational database; a migration framework to analyze the relational database access coding, including calls made by and to the relational database access coding and reading and writing performed by the relational database access coding, to analyze the data structures of the relational database, and to generate an in-memory database; and a validation framework to test the in-memory database generated by the migration framework; wherein the migration framework is to write the relational database into a second computing device to generate the in-memory database, the second computing device including at least a processor and a main memory; the migration framework is to generate in-memory access coding and in-memory database coding; the migration framework is to generate data structures of the in-memory database and write data from the relational database into the in-memory database; the validation framework is to query the relational database by calling the relational database access coding and query the in-memory database by calling the in-memory access coding; and the validation framework is to compare the results of the queries and report the outcome of the comparison.