Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Method And System For Verifying The Correctness Of Changes To A Database Through Automated Testing

IP.com Disclosure Number: IPCOM000200548D
Publication Date: 2010-Oct-19
Document File: 3 page(s) / 25K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system for verifying the correctness of changes to a database through automated testing is disclosed.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 01 of 3

Method And System For Verifying The Correctness Of Changes To A Database Through Automated Testing

Changes made to a database may cause inconsistencies such as invalid or missing database objects, data loss, etc. Hence, it is essential to ensure integrity of data after changes have been made to a database.

The method and system disclosed herein automatically runs multiple tests on objects that may have been affected due to changes in a database.

A user specifies the changes that are to be made to a database. The changes that are

specified by the user are subsequently deployed. Thereafter, multiple tests are run to validate the changes made to the database as shown in Fig. 1.

(This page contains 00 pictures or other non-text object)

Figure 1

The multiple tests may include a Row Counting Test, a Database (DB) Objects Validity Test, and a Missing DB Objects Test. Results obtained from each of the multiple tests may be used to create a HTML report as shown in Fig. 2. The scope of the multiple tests may be restricted to multiple schemas that are affected during the deployment of destructive changes.

1


Page 02 of 3

(This page contains 00 pictures or other non-text object)

Figure 2

A Row Count Test checks for the number of rows in multiple tables in the database

before and after the specified changes have been deployed. Further, Row Count Test

checks for destructive changes that have occurred due to the specified changes in the

database.

A Base Model and a Target Model may be utilized for checking for the

destructive changes. The Base Model is a memory representation model of the database before the specified changes are deployed. The Target model is a memory representation model of the database before the changes along with the specified changes. The Base Model and the Target Model of the database are compared to determine the tables that have undergone destructive changes....