GRID QUERIES
First Claim
Patent Images
1. A method implemented at least in part by a computer, the method comprising:
- from a requestor, receiving search criteria that indicates a base query, one or more column queries, and one or more row queries;
obtaining base identifiers that identify data items that satisfy the base query;
obtaining column identifiers that identify data items that satisfy the one or more column queries;
obtaining row identifiers that identify data items that satisfy the one or more row queries;
for each data cell of a data grid that has a column for each of the one or more column queries and a row for each of the one or more row queries, performing an intersection operation on the base identifiers, a set of column identifiers that correspond to the data cell, and a set of row identifiers that correspond to the data cell to obtain a value for the data cell and placing the value for the data cell in the data grid; and
sending the data grid to the requestor.
3 Assignments
0 Petitions
Accused Products
Abstract
Aspects of the subject matter described herein relate to grid queries. In aspects, a client sends search criteria that represent two or more dimensions to a service. The service obtains results that satisfy the search criteria and performs intersection operations to populate a data grid. The data grid is then returned to the client for output on an output device of the client. The client may provide a user interface that allows quick updating of the search criteria to obtain a new data grid.
-
Citations
20 Claims
-
1. A method implemented at least in part by a computer, the method comprising:
-
from a requestor, receiving search criteria that indicates a base query, one or more column queries, and one or more row queries; obtaining base identifiers that identify data items that satisfy the base query; obtaining column identifiers that identify data items that satisfy the one or more column queries; obtaining row identifiers that identify data items that satisfy the one or more row queries; for each data cell of a data grid that has a column for each of the one or more column queries and a row for each of the one or more row queries, performing an intersection operation on the base identifiers, a set of column identifiers that correspond to the data cell, and a set of row identifiers that correspond to the data cell to obtain a value for the data cell and placing the value for the data cell in the data grid; and sending the data grid to the requestor. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A computer storage medium having computer-executable instructions, which when executed perform actions, comprising:
-
sending search criteria to a service, the search criteria indicating a base query, one or more column queries, and one or more row queries, the service structured to populate a data grid using the search criteria to obtain base identifiers that identify data items that satisfy the base query, column identifiers that identify data items that satisfy the one or more column queries, and row identifiers that identify data items that satisfy the one or more row queries and to fill in each data cell of the data grid by performing an intersection operation on the base identifiers, a set of column identifiers that correspond to the data cell, and a set of row identifiers that correspond to the data cell to obtain a value for the data cell; receiving the data grid from the service; and providing output data corresponding to the data grid on an output device. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18)
-
-
19. In a computing environment, a system, comprising:
-
a memory structured to store search data; and a processor coupled to the memory, the processor configured to perform actions, the actions comprising; from a requestor, receiving search criteria that indicates a base query, one or more column queries, and one or more row queries, obtaining base identifiers that identify data items from the search data that satisfy the base query, obtaining column identifiers that identify data items from the search data that satisfy the one or more column queries, obtaining row identifiers that identify data items from the search data that satisfy the one or more row queries, for each data cell of a data grid that has a column for each of the one or more column queries and a row for each of the one or more row queries, performing an intersection operation on the base identifiers, a set of column identifiers that correspond to the data cell, and a set of row identifiers that correspond to the data cell to obtain a value for the data cell and placing the value for the data cell in the data grid, and sending the data grid to the requestor. - View Dependent Claims (20)
-
Specification