US 10,311,062 B2Granted

Filtering structured data using inexact, culture-dependent terms

AssigneeMicrosoft Technology Licensing, LLC

InventorsJonathan McPherson, Cameron Elliot Smith, David Michael Jade, Joseph Milan Filcik, Juventino Rojas Arredondo

Life of this patent

Estimating the term…

Loading patent…

Abstract

Technologies are described herein for filtering data in a result set using inexact and/or culture dependent terms. A user provides one or more filter terms for filtering a result set being viewed. One or more data type interpretations are determined for each filter term based on the value of the term. The data type interpretations may further be based on a locale associated with the user. For each filter term, the columns of the result set to which the filter term is to be applied is selected based on the data type interpretations determined for the filter term and the data types of the columns. The filter terms are then applied to the selected columns of the result set, thus causing the rows of the result set as displayed to the user to be limited to rows wherein at least one column value satisfies a filter term.

Claims18

Dependent claims

A computer-implemented method for filtering data in a result set comprising:

receiving, at a computer system, a filter term specified by a user of the computer system for filtering the result set being viewed on a display, the result set comprising a plurality of rows of data;
determining, by the computer system, a locale from a geographical location of the computer system associated with the user;
determining, by the computer system, two or more data types corresponding to the filter term using the locale and a set of rules, wherein a first of the two or more data types is text and a second of two or more data types is a data type different from text;
determining, by the computer system, a range of values based on the filter term and the second of the two or more data types determined for the filter term;
selecting, from the result set by the computer system, one or more columns having a data type matching one of the two or more data types corresponding to the filter term;
and
displaying, in a user interface, a limited plurality of rows of data of the result set based on filtering by the filter term, wherein at least one of the one or more columns satisfy the filter term, and wherein filtering by the filter term includes determining a value of a column is within the range of values.

4 more elements

A computer-readable storage medium encoded with computer-executable instructions that, when executed in a computer system, cause the computer system to:

receive a filter term from a user for filtering a result set being viewed on a display, the result set comprising a plurality of rows of data;
determine a locale from a geographical location of a computer associated with the user;
determine two or more data types corresponding to the filter term using the locale and a set of rules, wherein a first of the two or more data types is text and a second of two or more data types is a data type different from text;
determine a range of values based on the filter term and the second of the two or more data types corresponding to the filter term;
select, from the result set, one or more columns having a data type matching one of the two or more data types corresponding to the filter term;
filter by the filter term, wherein at least one of the one or more columns satisfy the filter term, and wherein a value of a column having an associated data type is within the range of values in the result set;
and
display the limited plurality of rows of data to the user on a display device.

5 more elements

A system for filtering data in a result set, the system comprising:

one or more processing units;
a memory operatively coupled to the one or more processing units;
and
a data access application residing in the memory and configured to cause the one or more processing units to:
receive a filter term for filtering the result set displayed to a user;
determine two or more data types corresponding to the filter term using the locale and a set of rules, wherein a first of the two or more data types is text and a second of two or more data types is a data type different from text;
determine a range of values based on the filter term and the second of the two or more data types corresponding to the filter term;
select, from the result set, one or more columns having a data type matching one of the two or more data types corresponding to the filter term;
and
display, in a user interface, a limited plurality of rows of data of the result set based on filtering by the filter term, wherein at least one of the one or more columns satisfy the filter term and wherein a value of a column having an associated data type is within the range of values in the result set.

7 more elements

Dependencies are inferred from the claim text.