US 7,890,519 B2Granted

Summarizing data removed from a query result set based on a data quality standard

AssigneeInternational Business Machines Corporation

InventorsRichard Dean Dettinger, Frederick Allyn Kulack, Kevin Glynn Paterson, Shannon Everett Wenzel

Life of this patent

Estimating the term…

Loading patent…

Abstract

A method, article of manufacture and apparatus for graphically summarizing the data in an initial query result set, including when rows are removed from the result set by applying a data quality standard is disclosed. When a user selects to change the data quality standard, a group of target rows are identified and removed from the user's display. A bitmap is generated to graphically represent the location of each row in the initial result set, including removed rows. A bitmap to summarize the data values for one or more columns in the initial result set may also be created. Thus, a user may quickly obtain an intuitive view of what the data looks like, without the need for complex analysis or graphing packages.

Claims21

Dependent claims

A computer-implemented method of graphically summarizing data in a query result, comprising:

receiving a query result set, wherein the query result set includes a plurality of rows and a data quality value assigned to each row, wherein the data quality value indicates a quality of data in the row based on a data quality standard;
receiving a request to remove rows containing data that fails to satisfy a predetermined data quality threshold;
removing one or more rows from the query result set, wherein the assigned data quality value for each removed row fails to satisfy the predetermined data quality threshold;
outputting for display at least a portion of the query result set, wherein the at least a portion of the query result set excludes the removed one or more rows;
generating, by operation of one or more computer processors, a summarization bitmap, wherein the summarization bitmap, bitmap includes a plurality of blocks each having a color and representing one or more rows of the query result set, and wherein for each block in the plurality of blocks, the color is a first color if the corresponding one or more rows are not displayed and were removed from the query result set because the assigned data quality value for at least one of the corresponding one or more rows failed to satisfy the predetermined data quality threshold, and wherein the color is a second color if the corresponding one or more rows are displayed;
and
outputting for display the generated summarization bitmap.

4 more elements

A computer-readable storage medium containing a program which, when executed, performs an operation for graphically summarizing data in a query result set, the operation comprising:

receiving a query result set, wherein the query result set includes a plurality of rows and a data quality value assigned to each row, wherein the data quality value indicates a quality of data in the row based on a data quality standard;
receiving a request to remove rows containing data that fails to satisfy a predetermined data quality threshold;
removing one or more rows from the query result set, wherein the assigned data quality value for each removed row fails to satisfy the predetermined data quality threshold;
outputting for display at least a portion of the query result set, wherein the at least a portion of the query result set excludes the removed one or more rows;
generating a summarization bitmap, wherein the summarization bitmap includes a plurality of blocks each having a color and representing one or more rows of the query result set, and wherein for each block in the plurality of blocks, the color is a first color if the corresponding one or more rows are not displayed and were removed from the query result set because the assigned data quality value for at least one of the corresponding one or more rows failed to satisfy the predetermined data quality threshold, and wherein the color is a second color if the corresponding one or more rows are displayed;
and
outputting for display the generated summarization bitmap.

4 more elements

A system, comprising:

a database;
a processor;
and
a memory containing a database program, which when executed on the processor, performs an operation for graphically summarizing data in a query result, the operation comprising:
receiving a query result set, wherein the query result set includes a plurality of rows and a data quality value assigned to each row, wherein the data quality value indicates a quality of data in the row based on a data quality standard;
receiving a request to remove rows containing data that fails to satisfy a predetermined data quality threshold;
removing one or more rows from the query result set, wherein the assigned data quality value for each removed row fails to satisfy the predetermined data quality threshold;
outputting for display at least a portion of the query result set, wherein the at least a portion of the query result set excludes the removed one or more rows;
generating a summarization bitmap, wherein the summarization bitmap includes a plurality of blocks each having a color and representing one or more rows of the query result set, and wherein for each block in the plurality of blocks, the color is a first color if the corresponding one or more rows are not displayed and were removed from the query result set because the assigned data quality value for at least one of the corresponding one or more rows failed to satisfy the predetermined data quality threshold, and wherein the color is a second color if the corresponding one or more rows are displayed;
and
outputting for display the generated summarization bitmap.

8 more elements

Dependencies are inferred from the claim text.