Patent ID: 8738569

Claim:
A method for verifying a distributed database system upgrade, comprising: upgrading a first database system to produce an upgraded database system comprising a master node, a plurality of segment nodes, and a master node catalog; executing a set of queries on metadata in said master node catalog to produce a first file containing first information about logical attributes of database objects of said upgraded database system, said first file excluding information contained in said master node catalog that is unrelated to said logical attributes of database objects of said upgraded database system; initializing a new database system corresponding to said upgraded database system, the new database system having a new master node, a plurality of new segment nodes, and a new master node catalog; executing the same set of said queries on metadata in said new master node catalog to produce a second file containing information about second logical attributes of database objects of said new database system, said second file excluding information contained in said new master node catalog that is unrelated to said second logical attributes of database objects; first comparing the first and second files for an initial verification of said new database system; replicating said new master node catalog on said plurality of new segment nodes of said new database system; executing said same set of queries on metadata in a segment catalog of each of said plurality of new segment nodes, the segment catalog containing information about logical attributes of database objects of said segment, to produce a plurality of corresponding segment result files that exclude information unrelated to such logical attributes; and second comparing each of the plurality of segment result files with said second file to produce a second verification of said new database system.