Querying one or more databases
First Claim
Patent Images
1. A method for querying one or more databases, comprising:
- receiving, at a computing device, a selection of a starting node, wherein the starting node represents a database table and is included in a model that corresponds to one or more database tables;
receiving, at the computing device, a selection of a first set of one or more leaves, wherein each leaf is connected to a node in the model and represents a column in a database table represented by the node to which the leaf is connected;
generating a first database query based on the starting node and the first set of leaves;
providing a first results output based on the first database query executing on the one or more databases;
receiving a selection of a result in the first results output;
generating a second database query based on the selection of the result in the first results output, wherein the second database query is associated with a detail set associated with the result, wherein the detail set associated with the result identifies a second starting node and a second set of leaves, wherein the second starting node represents a database table and each leaf of the second set of leaves is connected to a node in the model and represents a column in a database table represented by the node to which the leaf is connected;
wherein generating the second database query comprises generating the second database query based on the second starting node and the second set of leaves, and wherein the second database query is filtered by one or more values included in a row in the first results output corresponding to the selected result; and
providing a second results output based on the second database query executing on the one or more databases.
3 Assignments
0 Petitions
Accused Products
Abstract
A system and method for querying a database is disclosed. Database tables are represented as nodes in a model. Each node is associated with at least one leaf. The nodes can be interconnected with one another. A model input is received by a server from a client device, the model input including a starting node, one or more leaves, and optionally one or more filters. A query is executed against a database based on the model input. A subsequent query can be generated by selecting a result of the first query. Also disclosed is a technique for cancelling queries.
19 Citations
13 Claims
-
1. A method for querying one or more databases, comprising:
-
receiving, at a computing device, a selection of a starting node, wherein the starting node represents a database table and is included in a model that corresponds to one or more database tables; receiving, at the computing device, a selection of a first set of one or more leaves, wherein each leaf is connected to a node in the model and represents a column in a database table represented by the node to which the leaf is connected; generating a first database query based on the starting node and the first set of leaves; providing a first results output based on the first database query executing on the one or more databases; receiving a selection of a result in the first results output; generating a second database query based on the selection of the result in the first results output, wherein the second database query is associated with a detail set associated with the result, wherein the detail set associated with the result identifies a second starting node and a second set of leaves, wherein the second starting node represents a database table and each leaf of the second set of leaves is connected to a node in the model and represents a column in a database table represented by the node to which the leaf is connected;
wherein generating the second database query comprises generating the second database query based on the second starting node and the second set of leaves, and wherein the second database query is filtered by one or more values included in a row in the first results output corresponding to the selected result; andproviding a second results output based on the second database query executing on the one or more databases. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A method for querying one or more databases, comprising:
-
receiving, at a computing device, a selection of a starting node, wherein the starting node is included in a model that corresponds to one or more database tables; receiving, at the computing device, a selection of a first set of one or more leaves, wherein each leaf is connected to a node in the model; generating a first database query based on the starting node and the first set of leaves, wherein generating the first database query comprises generating five data sets to store database query fragments, for each leaf in the first set, adding one or more database query fragments to one or more of the five data sets based on attributes of the leaf, and constructing the first database query by appending together the database query fragments from the five data sets; providing a first results output based on the first database query executing on the one or more databases; receiving a selection of a result in the first results output; generating a second database query based on the selection of the result in the first results output, wherein the second database query is associated with a detail set associated with the result; and providing a second results output based on the second database query executing on the one or more databases.
-
Specification