Patent ID: 8190596

Claim:
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.