18536483. AUTOMATIC CORRECTNESS VALIDATION OF DATABASE MANAGEMENT SYSTEMS simplified abstract (Microsoft Technology Licensing, LLC)

From WikiPatents
Jump to navigation Jump to search

AUTOMATIC CORRECTNESS VALIDATION OF DATABASE MANAGEMENT SYSTEMS

Organization Name

Microsoft Technology Licensing, LLC

Inventor(s)

Mathieu Baptiste Demarne of Seattle WA (US)

Timothy Underwood Johnson of La Mesa CA (US)

Miso Cilimdzic of Laguna Niguel CA (US)

AUTOMATIC CORRECTNESS VALIDATION OF DATABASE MANAGEMENT SYSTEMS - A simplified explanation of the abstract

This abstract first appeared for US patent application 18536483 titled 'AUTOMATIC CORRECTNESS VALIDATION OF DATABASE MANAGEMENT SYSTEMS

Simplified Explanation

The automatic detection of inconsistencies in a database system is described in the patent application.

  • A first signature and a second signature are received, representing the results of executing a query against a database using different versions of the database engine program code.
  • A determination is made to check if the two signatures match. If they do not match, an inconsistency report is generated and remediation is performed on the database engine program code.

Potential Applications

This technology can be applied in various industries where database consistency is crucial, such as finance, healthcare, and e-commerce.

Problems Solved

1. Ensuring data consistency in database systems. 2. Identifying and resolving discrepancies between different versions of database engine program code.

Benefits

1. Improved data integrity and accuracy. 2. Automated detection and remediation of inconsistencies. 3. Enhanced reliability of database systems.

Potential Commercial Applications

"Automated Database Inconsistency Detection and Remediation Technology in Database Systems"

Possible Prior Art

There may be existing technologies or methods for detecting inconsistencies in databases, but the specific approach outlined in this patent application may be novel and innovative.

Unanswered Questions

How does the system handle large-scale databases with millions of records?

The patent application does not provide details on the scalability of the system and how it performs when dealing with massive amounts of data.

What are the potential limitations or challenges of implementing this technology in legacy database systems?

The application does not address the compatibility or integration issues that may arise when trying to implement this technology in older database systems.


Original Abstract Submitted

The automatic detection of inconsistencies in a database system is described. A first signature and a second signature are received. The first signature is a signature of a result of a first execution of the query against a database by a first version of database engine program code. The second signature is a signature of a result of a second execution of the query by a second version of the database engine program code. A determination is made of whether the first signature and the second signature match. In response to the first signature and the second signature failing to match, an inconsistency report regarding at least one of the first or second versions of the database engine program code is generated and remediation regarding at least one of the first or second versions of the database engine program code is performed.