Method for assembly of personalized enterprise information integrators over conjunctive queries
First Claim
Patent Images
1. A method for assembly of personalized enterprise information integrators over conjunctive queries, said method comprising the steps of:
- providing a system, wherein said system comprises a memory, at least one hardware processor coupled to said memory, a software module loadable into said memory and executable on said at least one hardware processor;
registering a plurality of sources from one or more enterprise databases, wherein registering the plurality of sources is performed by said software module executing on said at least one hardware processor;
constructing a plurality of schemas based on said plurality of sources, wherein constructing the plurality of schemas is performed by said software module executing on said at least one hardware processor;
obtaining a desired output as a conjunctive query, wherein said obtaining step is performed by said software module executing on said at least one hardware processor;
automatically providing a list of potential connections between at least selected ones of said sources based on said conjunctive query, wherein said providing step is performed by said software module executing on said at least one hardware processor;
automatically developing a plurality of alternative join plans based on said connections, wherein each alternative join plan identifies a unique set of one or more joins between said at least selected ones of said sources, wherein said developing step is performed by said software module executing on said at least one hardware processor; and
automatically updating the plurality of alternative join plans as one or more additional sources are added to the one or more enterprise databases, wherein automatically updating the plurality of alternative join plans is performed by said software module executing on said at least one hardware processor.
1 Assignment
0 Petitions
Accused Products
Abstract
A plurality of sources are registered. A plurality of schemas are constructed, based on the plurality of sources. A desired output is obtained as a conjunctive query. A list of potential connections between at least selected ones of the sources is provided. A plurality of join plans are developed, based on the connections.
212 Citations
14 Claims
-
1. A method for assembly of personalized enterprise information integrators over conjunctive queries, said method comprising the steps of:
-
providing a system, wherein said system comprises a memory, at least one hardware processor coupled to said memory, a software module loadable into said memory and executable on said at least one hardware processor; registering a plurality of sources from one or more enterprise databases, wherein registering the plurality of sources is performed by said software module executing on said at least one hardware processor; constructing a plurality of schemas based on said plurality of sources, wherein constructing the plurality of schemas is performed by said software module executing on said at least one hardware processor; obtaining a desired output as a conjunctive query, wherein said obtaining step is performed by said software module executing on said at least one hardware processor; automatically providing a list of potential connections between at least selected ones of said sources based on said conjunctive query, wherein said providing step is performed by said software module executing on said at least one hardware processor; automatically developing a plurality of alternative join plans based on said connections, wherein each alternative join plan identifies a unique set of one or more joins between said at least selected ones of said sources, wherein said developing step is performed by said software module executing on said at least one hardware processor; and automatically updating the plurality of alternative join plans as one or more additional sources are added to the one or more enterprise databases, wherein automatically updating the plurality of alternative join plans is performed by said software module executing on said at least one hardware processor. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
Specification