# US 7,610,265 B2 · Data query verification > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 7,610,265 B2 - Document ID: US7610265B2 - Status: Granted - Kind: B2 - Application number: 11/117,895 - Filed: 2005-04-29 - Published: 2006-11-02 - Granted: 2009-10-27 - Earliest claimed: 2005-04-29 - Assignees: Sap SE - Inventors: Thomas Zurek - Web page: https://patentgrep.com/patent/US7610265B2 ## CPC - G06F 16/24558: {Binary matching operations} - G06F 16/245: Query processing - Y10S 707/99932: Access augmentation or optimizing - Y10S 707/99935: Query augmenting and refining, e.g. inexact access - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS ## Abstract A method determines whether a structural indicator of a first table of results generated from a first data repository query matches a corresponding structural indicator of a second table of results generated from a substantially identical second data repository query. If the first and second table structural indicators match, then values from at least two corresponding cells from each of the first and second tables are aggregated. If the aggregated values from the first and second tables are identical, then an indication is provided indicating that the first data repository query results are accurate. Related apparatuses, computer program products, and computer systems are also described. ## Claims ### Claim 1 A computer-implemented method comprising: determining whether a structural indicator of a first table of results generated from a first data repository query of a data warehouse matches a corresponding structural indicator of a second table of results generated from a substantially identical second data repository query of the data warehouse, the structural indicators consisting of: one or more of a number of rows, a number of columns, or a number of cells in the corresponding table, the first data repository query occurring being run against the data warehouse prior in time to the second data repository query; aggregating values from at least two corresponding cells from each of the first and second tables if the first and second table structural indicators match; and providing an indication that the first data repository query results are accurate if the aggregated values from the first and second tables are identical. ### Claim 2 (depends on 1) A method as in claim 1, wherein the results of the first data repository query are generated using a first execution procedure and the results of the second data repository query are generated using a second execution procedure. ### Claim 3 (depends on 1) A method as in claim 1, further comprising converting non-numerical values in each table into integer values prior to the aggregating. ### Claim 4 (depends on 2) A method as in claim 2, wherein the converting comprises: mapping each non-numerical value into a hexadecimal format value; and converting each hexadecimal format value into an integer value. ### Claim 5 (depends on 3) A method as in claim 3, wherein the converting comprises mapping each non-numerical value into an integer value. ### Claim 6 (depends on 1) A method as in claim 1, wherein the aggregating uses a single change sensitive aggregating function that is based on every value in a table. ### Claim 7 (depends on 1) A method as in claim 1, wherein the at least one aggregated value is a statistical value chosen from a group comprising: a sum of at least a portion of the cells in each table, a minimum value in at least a portion of the cells in each table, a maximum value in at least a portion of the cells in each table, an average value in at least a portion of the cells in each table, and a median value in at least a portion of the cells in each table. ### Claim 8 A computer program product, tangibly embodied on computer readable-material, said computer program product including executable instructions that cause a computer system to conduct one or more of operations comprising: determining whether a structural indicator of a first table of results generated from a first data repository query of a data warehouse matches a corresponding structural indicator of a second table of results generated from a substantially identical second data repository query of the data warehouse, the structural indicators consisting of one or more of a number of rows, a number of columns, or a number of cells in the corresponding table, the first data repository query being run against the data warehouse prior in time to the second data repository query, at least one cell in each table of results comprising a non-numerical value and at least one cell in each table comprising an integer value; converting non-numerical values into a corresponding integer value for each table of results; aggregating integer values from at least two corresponding cells from each of the first and second tables if the first and second table structural indicators match; and providing an indication that the first data repository query results are accurate if the aggregated values from the first and second tables are identical. ### Claim 9 (depends on 8) An article as in claim 8, wherein the results of the first data repository query are generated using a first execution procedure and the results of the second data repository query are generated using a second execution procedure. ### Claim 10 (depends on 8) An article as in claim 8, wherein the converting comprises mapping each non-numerical value into an integer value. ### Claim 11 (depends on 10) An article as in claim 10, wherein the converting comprises: mapping each non-numerical value into a hexadecimal format value; and converting each hexadecimal format value into an integer value. ### Claim 12 (depends on 8) An article as in claim 8, wherein the aggregating uses a single change sensitive aggregating function that is based on every value in a table. ### Claim 13 (depends on 8) An article as in claim 8, wherein the at least one aggregated value is a statistical value chosen from a group comprising: a sum of at least a portion of the cells in each table, a minimum value in at least a portion of the cells in each table, a maximum value in at least a portion of the cells in each table, an average value in at least a portion of the cells in each table, and a median value in at least a portion of the cells in each table. ### Claim 14 A computer program product, tangibly embodied on computer readable-material, said computer program product including executable instructions that cause a computer system to conduct one or more of operations comprising: determining whether a structural indicator of a first table of results generated from a first data repository query of a data warehouse matches a corresponding structural indicator of a second table of results generated from a substantially identical second data repository query of the data warehouse, the structural indicators consisting of one or more of a number of rows, a number of columns, or a number of cells in the corresponding table, the first data repository query occurring being run against the data warehouse prior in time to the second data repository query, at least one cell in each table of results comprising a non-numerical value and at least one cell in each table comprising an integer value; converting non-numerical values into a corresponding integer value for each table of results; aggregating integer values from at least two corresponding cells from each of the first and second tables if the first and second table structural indicators match; and providing an indication that the first data repository query results are accurate if the aggregated values from the first and second tables are identical.