SYSTEM AND COMPUTER PROGRAM PRODUCT FOR ASSEMBLY OF PERSONALIZED ENTERPRISE INFORMATION INTEGRATORS OVER CONJUNCTIVE QUERIES

• US 20090138431A1
• Filed: 11/28/2007
• Published: 05/28/2009
• Est. Priority Date: 11/28/2007
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Srivastava, Biplav, Nambiar, Ullas B.
• Granted Patent: US 8,145,684 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation

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.

Claims

1. An apparatus for assembly of personalized enterprise information integrators over conjunctive queries, said apparatus comprising:

a memory; and

at least one processor, coupled to said memory, and operative to register a plurality of sources;

construct a plurality of schemas based on said plurality of sources;

obtain a desired output as a conjunctive query;

provide a list of potential connections between at least selected ones of said sources; and

develop a plurality of join plans based on said connections.

2. The apparatus of claim 1, wherein said processor is operative to register said plurality of sources via a user providing an access path to said source, and wherein said processor is further operative to select an appropriate one of said schemas to publish said source.

3. The apparatus of claim 2, wherein said processor is further operative to;

said user contributing at least one new source during said registration step; and

enhancing attributes of said appropriate one of said schemas by providing metadata.

4. The apparatus of claim 3, wherein said metadata comprises at least one of an attribute type for at least one of said attributes and a sample instance.

5. A computer program product comprising a computer useable medium including computer usable program code for assembly of personalized enterprise information integrators over conjunctive queries, said computer program product including:

computer usable program code for registering a plurality of sources;

computer usable program code for constructing a plurality of schemas based on said plurality of sources;

computer usable program code for obtaining a desired output as a conjunctive query;

computer usable program code for providing a list of potential connections between at least selected ones of said sources; and

computer usable program code for developing a plurality of join plans based on said connections.

6. The computer program product of claim 5, wherein said computer usable program code for registering said plurality of sources comprises computer usable program code for facilitating a user to provide an access path to said source, further comprising computer usable program code for selecting an appropriate one of said schemas to publish said source.

7. The computer program product of claim 6, further comprising computer usable program code for:

said user contributing at least one new source during said registration step; and

enhancing attributes of said appropriate one of said schemas by providing metadata.

8. The computer program product of claim 7, wherein said metadata comprises at least one of an attribute type for at least one of said attributes and a sample instance.

9. An apparatus for assembly of personalized enterprise information integrators over conjunctive queries, said apparatus comprising:

means for registering a plurality of sources;

means for constructing a plurality of schemas based on said plurality of sources;

means for obtaining a desired output as a conjunctive query;

means for providing a list of potential connections between at least selected ones of said sources; and

means for developing a plurality of join plans based on said connections.

10. The apparatus of claim 9, wherein said means for registering said plurality of sources comprises means for facilitating a user to provide an access path to said source, further comprising means for selecting an appropriate one of said schemas to publish said source.

11. The apparatus of claim 10, further comprising;

means for said user contributing at least one new source during said registration step; and

means for enhancing attributes of said appropriate one of said schemas by providing metadata.