SYSTEM AND METHOD TO CUSTOMIZE METADATA FOR DIFFERENT USERS RUNNING ON THE SAME INFRASTRUCTURE

• US 20110078204A1
• Filed: 09/25/2009
• Published: 03/31/2011
• Est. Priority Date: 09/25/2009
• Status: Active Grant

• Current Assignee: Daedalus Blue LLC
• Original Assignee: International Business Machines Corporation
• Inventors: Srivastava, Biplav, Ratakonda, Krishna C., Oppenheim, Daniel V., Lotikar, Rohit M., Polavarapu, Ramana V., Ma, Qian
• Granted Patent: US 9,286,362 B2
• Time in Patent Office: Days
• US Class Current: 707/794
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/28 Databases characterised by their database models, e.g. relational or object models
• CPC Class Codes: G06F 16/907 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually

Abstract

A metadata management system and method enables complex query searches by users, e.g., different users having different query needs, using the same infrastructure. For querying metadata, the metadata management system provides functionality for aggregating all the concepts (metadata items) and relationships of the metadata across one or more users in a common format; extracting concepts and storing them in a metadata store (e.g., a relational database); extracting relationships and modeling them in a standard semantic representation. The system and method further records users'"'"' different needs on relationships into user-specific configuration files. The system is configured for retrieving, in response to a user query, relevant data items by using the meta-data selectively. In one embodiment, a selection of meta-data used in the retrieving is determined according to captured context information,

Claims

1. A system for retrieving data comprising:

a memory storage device defining a meta-data repository that stores at least one meta-data item belonging to each of an element and a relationship type meta-data;

a processor device in communications with the memory storage device, wherein the system is capable of performing a method comprising;

storing, in a meta-data repository, at least one meta-data item belonging to each of an element type and a relationship type meta-data;

storing at least one data item in a data repository;

capturing a relationship between the at least one meta-data item and a data item including the context in which the relationship was generated; and

,

retrieving, in response to a user query, relevant data items by using the meta-data selectively, a selection of meta-data used in the retrieving is determined according to the captured context information.

2. The system as claimed in claim 1, where the selection of meta-data further includes contextual information about the retrieval query.

3. The system as claimed in claim 2, where the contextual information about the retrieval query further includes a description of one or more of:

by who, when or where the query was generated.

4. The system as claimed in claim 1, further comprising:

a user interface via which a user customizes the relationships among the meta-data items, said user customizes the relationships among the meta-data items via said user interface in real-time.

5. The system as claimed in claim 4, wherein, via said user interface, said user is enabled to change the customization on relationships by re-configuring the user'"'"'s selection without disrupting the meta-data repository.

6. The system as claimed in claim 4, wherein the system is capable of further performing:

extracting, from data items stored in said data repository, said metadata items;

aggregating data and metadata items and relationships thereof across one or more users in a structured file format;

parsing the structured file format to extract data representing concepts, and to extract relationships, and,

storing, said extracted concepts in said the meta-data repository and, storing a relationship type meta-data item in a semantic support representation.

7. The system as claimed in claim 1, wherein a relationship among one or more meta-data items includes EQUAL_TO, CONTAINS, INVERSE_OF, SUBTYPE_OF, LARGER_THAN, and SMALLER_THAN.

8. The system as claimed in claim 6, wherein said semantic support representation is based on a Resource Description Framework specification.

9. The system as claimed in claim 8, wherein said structured file format includes an extensible markup language format.

10. The system as claimed in claim 1, wherein said metadata store includes a relational data store.

11. A method for retrieving data comprising:

storing, in a meta-data repository, at least one meta-data item belonging to each of an element type and a relationship type meta-data;

storing at least one data item in a data repository;

capturing a relationship between the at least one meta-data item and a data item including the context in which the said relationship was generated;

retrieving, in response to a user query, relevant data items by using the meta-data selectively, a selection of meta-data used in the retrieving is determined according to the captured context information,

wherein a processor unit runs a program to execute one or more of said storing, capturing and retrieving.

12. The method as claimed in claim 11, further comprising:

providing a user interface via which a user customizes the relationships among the concepts.

13. The method as claimed in claim 12, wherein a user customizes the relationships among the meta-data via said user interface in real-time.

14. The method as claimed in claim 11, further comprising:

enabling, via said user interface, said user to change the customization on relationships by re-configuring the user'"'"'s selection without disrupting the meta-data repository.

15. The method as claimed in claim 11, further comprising:

extracting, from data items stored in said data repository, said metadata items;

aggregating data and metadata items and relationships thereof across one or more users in a structured file format;

parsing the structured file format to extract data representing concepts, and to extract relationships, and,

storing, said extracted concepts in a metadata store and, storing a relationship type meta-data item in a semantic support representation.

16. The method as claimed in claim 11, wherein a relationship among one or more meta-data items includes EQUAL_TO, CONTAINS, INVERSE_OF, SUBTYPE_OF, LARGER_THAN, and SMALLER_THAN.

17. The method as claimed in claim 15, wherein said semantic support representation is based on a Resource Description Framework specification.

18. The method as claimed in claim 15, wherein said structured file format includes an extensible markup language format.

19. The method as claimed in claim 15, wherein said metadata store includes a relational data store.

20. A computer program product for retrieving data, the computer program product comprising:

a storage medium readable by a processing circuit and storing instructions for execution by the processing circuit for performing a method comprising;

storing, in a meta-data repository, at least one meta-data item belonging to each of an element type and a relationship type meta-data;

storing at least one data item in a data repository;

capturing a relationship between the at least one meta-data item and a data item including the context in which the said relationship was generated;

retrieving, in response to a user query, relevant data items by using the meta-data selectively, a selection of meta-data used in the retrieving is determined according to the captured context information,

wherein a processor unit runs a program to execute one or more of said storing, capturing and retrieving.