Systems and user interfaces for dynamic and interactive simultaneous querying of multiple data stores
First Claim
1. A computer system configured to link data tables, the computer system comprising:
- one or more hardware computer processors configured to execute code in order to cause the one or more hardware computer processors to;
provide a user interface configured to simultaneously display at least a first panel and a second panel, wherein;
the first panel is configured to provide selectable indications of data tables,the second panel is configured to provide visual indications of relationships among data tables, andin the second panel, tables are indicated by nodes and relationships between tables are indicated by edges connecting nodes;
in response to a first user input from a user selecting a first data table in the first panel, add a first node to the second panel, wherein the first node represents the first data table;
in response to a second user input from the user selecting a second data table in the first panel, add a second node to the second panel, wherein the second node represents the second data table;
in response to a third user input from the user indicating a relationship between the first data table and the second data table, provide, in the second panel of the user interface, a first edge connecting the first node and the second node, wherein;
the first edge indicates a relationship between at least one field of the first data table and at least one field of the second data table,a type of the relationship between the at least one field of the first data table and the at least one field of the second data table is indicated in the second panel by way of the first edge,the first node, second node, and first edge provided in the second panel are representative of a table graph, andthe table graph is executable in order to access data stored in the first data table and subsequently data in the second data table based at least partly on the data stored in the first data table; and
in response to a fourth user input, execute a search query based at least in part on executing the table graph including the relationship between the at least one field of the first data table and the at least one field of the second data table represented by the first edge.
8 Assignments
0 Petitions
Accused Products
Abstract
Embodiments of the present disclosure relate to a computer system and interactive user interfaces configured to enable efficient and rapid access to multiple different data sources simultaneously, and by an unskilled user. The unskilled user may provide simple and intuitive search terms to the system, and the system may thereby automatically query multiple related data sources of different types and present results to the user. Data sources in the system may be efficiently interrelated with one another by way of a mathematical graph in which nodes represent data sources and/or portions of data sources (for example, database tables), and edges represent relationships among the data sources and/or portions of data sources. For example, edges may indicate relationships between particular rows and/or columns of various tables. The table graph enables a compact and memory efficient storage of relationships among various disparate data sources.
956 Citations
8 Claims
-
1. A computer system configured to link data tables, the computer system comprising:
one or more hardware computer processors configured to execute code in order to cause the one or more hardware computer processors to; provide a user interface configured to simultaneously display at least a first panel and a second panel, wherein; the first panel is configured to provide selectable indications of data tables, the second panel is configured to provide visual indications of relationships among data tables, and in the second panel, tables are indicated by nodes and relationships between tables are indicated by edges connecting nodes; in response to a first user input from a user selecting a first data table in the first panel, add a first node to the second panel, wherein the first node represents the first data table; in response to a second user input from the user selecting a second data table in the first panel, add a second node to the second panel, wherein the second node represents the second data table; in response to a third user input from the user indicating a relationship between the first data table and the second data table, provide, in the second panel of the user interface, a first edge connecting the first node and the second node, wherein; the first edge indicates a relationship between at least one field of the first data table and at least one field of the second data table, a type of the relationship between the at least one field of the first data table and the at least one field of the second data table is indicated in the second panel by way of the first edge, the first node, second node, and first edge provided in the second panel are representative of a table graph, and the table graph is executable in order to access data stored in the first data table and subsequently data in the second data table based at least partly on the data stored in the first data table; and in response to a fourth user input, execute a search query based at least in part on executing the table graph including the relationship between the at least one field of the first data table and the at least one field of the second data table represented by the first edge. - View Dependent Claims (2, 3, 4)
-
5. A computer-implemented method for linking data tables, the method comprising:
by one or more hardware processors executing program instructions; providing a user interface configured to simultaneously display at least a first panel and a second panel, wherein; the first panel is configured to provide selectable indications of data tables, the second panel is configured to provide visual indications of relationships among data tables, and in the second panel, tables are indicated by nodes and relationships between tables are indicated by edges connecting nodes; in response to a first user input from a user selecting a first data table in the first panel, adding a first node to the second panel, wherein the first node represents the first data table; in response to a second user input from the user selecting a second data table in the first panel, adding a second node to the second panel, wherein the second node represents the second data table; in response to a third user input from the user indicating a relationship between the first data table and the second data table, providing, in the second panel of the user interface, a first edge connecting the first node and the second node, wherein; the first edge indicates a relationship between at least one field of the first data table and at least one field of the second data table, a type of the relationship between the at least one field of the first data table and the at least one field of the second data table is indicated in the second panel by way of the first edge, the first node, second node, and first edge provided in the second panel are representative of a table graph, and the table graph is executable in order to access data stored in the first data table and subsequently data in the second data table based at least partly on the data stored in the first data table; and in response to a fourth user input, executing a search query based at least in part on executing the table graph including the relationship between the at least one field of the first data table and the at least one field of the second data table represented by the first edge. - View Dependent Claims (6, 7, 8)
Specification