US Patent Application 18325765. MEASURING AND IMPROVING INDEX QUALITY IN A DISTRUBUTED DATA SYSTEM simplified abstract

MEASURING AND IMPROVING INDEX QUALITY IN A DISTRUBUTED DATA SYSTEM

Organization Name

Microsoft Technology Licensing, LLC

Inventor(s)

Babatunde Micheal Okutubo of Bellevue WA (US)

MEASURING AND IMPROVING INDEX QUALITY IN A DISTRUBUTED DATA SYSTEM - A simplified explanation of the abstract

• This abstract for appeared for US patent application number 18325765 Titled 'MEASURING AND IMPROVING INDEX QUALITY IN A DISTRUBUTED DATA SYSTEM'

Simplified Explanation

This abstract describes a method for measuring and improving the quality of an index in a distributed data system. The method involves determining various quality metrics for each partition of the data system, which indicate the quality of specific properties of each partition. These metrics are then combined to generate an overall index quality score, which measures the performance of the index. This score is used to automatically identify inefficiencies in the index and determine appropriate maintenance actions to improve its performance. Additionally, the individual analysis of each quality metric helps identify which specific database property is impacting the index's performance the most.

Original Abstract Submitted

Embodiments described herein are directed to measuring and improving an index quality of a distributed data system. For example, various quality metrics are determined on a per partition basis of the distributed data system. Each of the quality metrics are indicative of a quality of a particular property of a partition. The quality metrics are aggregated to generate an overall index quality score, which provides a measure of the performance of the index. The index quality score is utilized to automatically detect an inefficiency of the index and automatically determine that certain index maintenance actions should be automatically performed to improve the performance of the index. Each quality metric may also be individually analyzed to determine which database property is affecting the performance of the index the most.