Data query verification
AssigneeSap SE
InventorThomas Zurek
Life of this patent
Estimating the term…
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.
Claims14
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.
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.
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.
Dependencies are inferred from the claim text.