Methods and Systems for Data Integration
First Claim
1. A method for dynamically creating a hierarchy for use in searching one or more databases, each of the one or more databases having a data model, the method comprising:
- extracting a data model from each of the one or more databases, wherein each data model describes two or more data objects stored in a respective database of the one or more databases, and describes at least one relationship between the data objects;
defining a data network comprising a plurality of nodes, a plurality of connectors, and at least one root connector, wherein each of the plurality of connectors describes a relationship between two or more of the plurality of nodes, the plurality of connectors nodes being based on the two or more data objects in the extracted data model, the plurality of connectors being based on relationships in the extracted data model, and the at least one root connector defining an entry point into the data network;
receiving a search query on the data network regarding data stored in the one or more databases, the search query specifying a root connector and at least one of the two or more nodes, wherein the at least one of the two or more nodes is specified in the search query as a member of a hierarchy having the specified root connector at its root level;
translating, using a computer, the search query on the data network into a query that is configured to run on the one or more databases, wherein the translation comprises a dynamic creation of a hierarchy based on the specified root connector and the specified nodes; and
searching the one or more databases with the translated query.
4 Assignments
0 Petitions
Accused Products
Abstract
A preferred method embodiment of the subject invention comprises a method for dynamically creating hierarchies to be used in database searches, comprising the steps of: (a) defining a data network; (b) receiving a query regarding data stored in one or more databases; and (c) based at least in part on said query and on said data network, dynamically building a hierarchy. A preferred system embodiment of the subject invention comprises a system for dynamically creating hierarchies to be used in database searches, comprising: (a) means for defining a data network; (b) means for receiving a query regarding data stored in one or more databases; and (c) means for, based at least in part on said query, dynamically building a hierarchy from said data network.
-
Citations
28 Claims
-
1. A method for dynamically creating a hierarchy for use in searching one or more databases, each of the one or more databases having a data model, the method comprising:
-
extracting a data model from each of the one or more databases, wherein each data model describes two or more data objects stored in a respective database of the one or more databases, and describes at least one relationship between the data objects; defining a data network comprising a plurality of nodes, a plurality of connectors, and at least one root connector, wherein each of the plurality of connectors describes a relationship between two or more of the plurality of nodes, the plurality of connectors nodes being based on the two or more data objects in the extracted data model, the plurality of connectors being based on relationships in the extracted data model, and the at least one root connector defining an entry point into the data network; receiving a search query on the data network regarding data stored in the one or more databases, the search query specifying a root connector and at least one of the two or more nodes, wherein the at least one of the two or more nodes is specified in the search query as a member of a hierarchy having the specified root connector at its root level; translating, using a computer, the search query on the data network into a query that is configured to run on the one or more databases, wherein the translation comprises a dynamic creation of a hierarchy based on the specified root connector and the specified nodes; and searching the one or more databases with the translated query. - View Dependent Claims (2, 3, 4, 5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 21)
-
-
6. (canceled)
-
20. (canceled)
-
22. A system for dynamically creating a hierarchy for use in searching one or more databases, the system comprising:
-
one or more host computers, on which the one or more databases reside; a data model extracted from each of the one or more databases, wherein each data model describes two or more data objects stored in a corresponding one of the one or more databases, and describes at least one relationship between the two or more data objects; a data network, based on the data model, comprising; a plurality of nodes based on the two or more data objects; a plurality of connectors describing a relationship between two or more of the plurality of nodes based on the relationships in the data model; and at least one root connector defining an entry point into the data network; and a query server, in electronic communication with the data network, configured to; search the data network with a query regarding data stored in one or more databases, the query specifying a root connector and at least one of the two or more of the plurality of nodes, and the at least one of the two or more of the plurality of nodes being specified in the query as members of a hierarchy having the specified root connector at its root level; receive and translate the query into a translated query that can run on the one or more databases, the translated query comprising a dynamic creation of a hierarchy based on the specified root connector and the specified nodes; and search the one or more databases with the translated query. - View Dependent Claims (23, 24, 25, 26)
-
-
27. (canceled)
-
28. (canceled)
Specification