Database change verifier

Details Database change verifier Database change verifier

2011-05-31

2011-05-31

Lee, Wilson (Department: 2163)

Data processing: database and file management or data structures

Database and file access

Record, file, and data search and comparisons

C707S761000

Reexamination Certificate

active

07953744

ABSTRACT:
A method and system for automatically verifying a change to a database. An input file including a test query for the database and an expected output from executing the test query is received. The test query is automatically executed on the database. An actual output resulting from executing the test query is retrieved. Based on a comparison between the actual output and the expected output, a match or mismatch between the actual output and the expected output is automatically identified. If a mismatch is identified, a failure indication is stored that indicates that the database change is invalid and that the database change may initiate a defect in an application coupled to the database. In one embodiment, the change to the database is a change in a services engagement. In one embodiment, the test query is automatically generated in the method and system described above.

REFERENCES:
patent: 5499365 (1996-03-01), Anderson et al.
patent: 6286001 (2001-09-01), Walker et al.
patent: 6460036 (2002-10-01), Herz
patent: 7373365 (2008-05-01), Varadarajan et al.
patent: 2010/0318806 (2010-12-01), Hardt
patent: 20030035336 (2003-05-01), None
patent: WO2007-068279 (2007-06-01), None
Teniente et al.; SVT: Schema Validation Tool for Microsoft SQL-Server; Proceedings of the 30th VLDB Conference, Toronto, Canada, 2004; pp. 1349-1352.
David Martinenghi; Advanced Techniques for Efficient Data Integrity Checking; Ph. D. Dissertation; Roskilde University, Department of Computer Science, Oct. 2005; < URL: http://www.rucsdigitaleprojektbibliotek.dk/bitstream/1800/1594/1/Adanced—techniques—for.pdf >; 152 pages.
Thomas Kyte; Summary of “Optimizer Plan Stability”; Expert Oracle [online], 2005; [Retrieved Aug. 28, 2008]; Retrieved from the Internet: < URL: http://www.springerlink.com/index/v488u34274h09255.pdf >; 2 pages.
Jason Hunter; Updating XQuery; Oracle Technology Network [online]; [Retrieved Aug. 28, 2008]; Retrieved from the Internet < URL: http://www.oracle.com/technology/oramag/oracle/03-nov/o63dev—vml.html >; 14 pages.
Guo et al.; Abstract of LUBM: A benchmark for OWL knowledge base systems; Web Semantics: Science, Services and Agents on the World Wide Web, vol. 3, issues 2-3, Oct. 2005, Selected Papers from the International Semantic Web Conference, 2004—ISWC, 2004; Elsevier B.V. 2005 [online]; [Retrieved Aug. 28, 2008]; Retrieved from the Internet < URL: http://linkinghub.elsevier.com/retrieve/pii/S157086805000132 >; 3 pages.

Affiliated with

Also associated with

Rating

Database change verifier does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database change verifier, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database change verifier will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2630264