Systems and user interfaces for dynamic and interactive simultaneous querying of multiple data stores
First Claim
1. A method comprising:
- generating a table graph comprising;
a first node associated with a first data table;
a second node associated with a second data table;
a first link between the first node and the second node, wherein the first link indicates a first field of the first data table is associated with a first field of the second data table; and
a second link between the first node and the second node, wherein the second link indicates a second field of the first data table is associated with a second field of the second data table;
executing a search query on the table graph by at least;
looking up first information in the first data table, wherein the first information is associated with the search query;
looking up second information in the second data table by reference to the first link, wherein the second information is associated with the first information, and wherein the first and second information together comprise a direct hit of the search query; and
looking up third information in the first data table by reference to the second link, wherein the third information is different from the first information, and wherein the third information comprises an indirect hit of the search query; and
providing, for display by a computing device;
the third information, andan indication that the third information comprises the indirect hit of the search query.
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.
-
Citations
20 Claims
-
1. A method comprising:
-
generating a table graph comprising; a first node associated with a first data table; a second node associated with a second data table; a first link between the first node and the second node, wherein the first link indicates a first field of the first data table is associated with a first field of the second data table; and a second link between the first node and the second node, wherein the second link indicates a second field of the first data table is associated with a second field of the second data table; executing a search query on the table graph by at least; looking up first information in the first data table, wherein the first information is associated with the search query; looking up second information in the second data table by reference to the first link, wherein the second information is associated with the first information, and wherein the first and second information together comprise a direct hit of the search query; and looking up third information in the first data table by reference to the second link, wherein the third information is different from the first information, and wherein the third information comprises an indirect hit of the search query; and providing, for display by a computing device; the third information, and an indication that the third information comprises the indirect hit of the search query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A system comprising:
-
a first database storing a first data table; a second database storing a second data table; a non-transitory computer readable storage medium storing a table graph comprising; a first node associated with a first data table; a second node associated with a second data table; a first link between the first node and the second node, wherein the first link indicates a first field of the first data table is associated with a first field of the second data table; and a second link between the first node and the second node, wherein the second link indicates a second field of the first data table is associated with a second field of the second data table; and one or more hardware processors configured to execute software instructions in order to; execute a search query on the table graph by at least; looking up first information in the first data table, wherein the first information is associated with the search query; looking up second information in the second data table by reference to the first link, wherein the second information is associated with the first information, and wherein the first and second information together comprise a direct hit of the search query; and looking up third information in the first data table by reference to the second link, wherein the third information is different from the first information, and wherein the third information comprises an indirect hit of the search query; and provide, for display by the system; the third information, and an indication that the third information comprises the indirect hit of the search query. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification