US Patent 11874810 Measuring data quality in a structured database through SQL

Some implementations of the present disclosure provide a method that include: accessing a plurality of tables that describe a relational data model for a hierarch of exploration data assets, wherein the relational data model defines the hierarchy of exploration data assets and attributes at each level of the hierarchy, and wherein multiple databases encode the hierarchy of exploration data assets; querying the hierarch of exploration data assets according to one or more data quality rules capable of identifying defects in the hierarchy of exploration data assets; identifying instances of data records that fail to meet the one or more data quality rules; based on the identified instances, calculating one or more data quality metrics for the hierarchy of exploration data assets; and generating an alert that includes: the identified instances of data records, or the calculated one or more data quality metrics.