Patent ID: 7610298
Filing Date: 2009-10-27
Classification: G06F,Y10S

Abstract:
1. A computing device comprising: a processor; a memory; and a database updating application maintained in the memory and executed on the processor to: serialize a first metadata to a common information format, wherein the first metadata describes a current database schema; serialize a second metadata to the common information format, wherein the second metadata describes an updated database schema; deserialize the first metadata in the common information format to a first comparable object; deserialize the second metadata in the common information format to a second comparable object; load the first comparable object into a first cache; load the second comparable object into a second cache; compare the first comparable object and the second comparable object to determine one or more differences between the current database schema and the updated database schema; generate one or more instructions for each of the differences between the current database schema and the updated database schema, each instruction to modify the current database to conform to the updated database schema; and derive a script from the one or more instructions, to be executed by the processor, the script including a first phase to be executed before a second phase, wherein the first phase instructions consist of: adding the updated database entity, updating the current database entity, adding the updated database attribute, and updating the current database attribute, the second phase instructions consist of: deleting the current database entity, deleting the current database attribute, deleting the current database relationship, deleting a current database view, adding the updated database relationship, and creating an updated database view, and the first comparable object and the second comparable object are in an identical file format.