18434127. CONSISTENCY CHECKING FOR DISTRIBUTED ANALYTICAL DATABASE SYSTEMS simplified abstract (Microsoft Technology Licensing, LLC)
Contents
- 1 CONSISTENCY CHECKING FOR DISTRIBUTED ANALYTICAL DATABASE SYSTEMS
- 1.1 Organization Name
- 1.2 Inventor(s)
- 1.3 CONSISTENCY CHECKING FOR DISTRIBUTED ANALYTICAL DATABASE SYSTEMS - A simplified explanation of the abstract
- 1.4 Simplified Explanation
- 1.5 Potential Applications
- 1.6 Problems Solved
- 1.7 Benefits
- 1.8 Potential Commercial Applications
- 1.9 Possible Prior Art
- 1.10 Original Abstract Submitted
CONSISTENCY CHECKING FOR DISTRIBUTED ANALYTICAL DATABASE SYSTEMS
Organization Name
Microsoft Technology Licensing, LLC
Inventor(s)
Maninderjit Singh Parmar of Redmond WA (US)
CONSISTENCY CHECKING FOR DISTRIBUTED ANALYTICAL DATABASE SYSTEMS - A simplified explanation of the abstract
This abstract first appeared for US patent application 18434127 titled 'CONSISTENCY CHECKING FOR DISTRIBUTED ANALYTICAL DATABASE SYSTEMS
Simplified Explanation
The embodiments described in the abstract focus on detecting data inconsistencies within a distributed database and identifying the cause of these inconsistencies. A consistency checking engine analyzes lineage events emitted from different components of the distributed system to detect inconsistencies in data files. This process helps in checking the integrity of the database, understanding the root cause of corruption, providing a timeline for the corruption, and determining if it is repairable. In case of repairable corruption, the correct compensating repair actions can be applied.
- Detecting data inconsistencies within a distributed database
- Analyzing lineage events emitted from different components of the system
- Checking the integrity of the database
- Understanding the root cause of corruption
- Providing a timeline for the corruption
- Determining if the corruption is repairable
- Applying correct compensating repair actions in case of repairable corruption
Potential Applications
This technology can be applied in various industries such as finance, healthcare, and e-commerce where maintaining data integrity is crucial.
Problems Solved
This technology solves the problem of detecting and identifying data inconsistencies within a distributed database, helping in maintaining data integrity and ensuring the reliability of the database.
Benefits
The benefits of this technology include improved data quality, faster identification of data inconsistencies, and efficient resolution of data corruption issues.
Potential Commercial Applications
Potential commercial applications of this technology include data management systems, database security solutions, and data quality assurance tools.
Possible Prior Art
One possible prior art in this field is the use of checksums and data validation techniques to ensure data integrity in databases.
What are the specific components of the distributed system that emit lineage events for analysis?
The abstract mentions that lineage events are emitted from different components of the distributed system. However, it does not specify the exact components involved in emitting these events.
How does the consistency checking engine determine the repairability of the detected corruption?
The abstract mentions that the consistency checking engine determines whether the corruption is repairable or not, but it does not elaborate on the specific criteria or methods used for making this determination.
Original Abstract Submitted
Embodiments described herein are directed to detecting data inconsistencies within a distributed database and identifying the cause thereof. For example, lineage events are emitted from different components of the distributed system that operate on various data files. A consistency checking engine analyzes these events and detects inconsistencies with respect to the data files. The embodiments described herein checks the integrity of the database and assists in understanding the root cause in case of a corruption. Moreover, it provides the timeline for the corruption and whether it is repairable or not. These properties enable determining the right time to restore the customer's database or the right set of actions to repair the corruption. In case of repairable corruption, the correct compensating repair actions may be applied.
