Method and apparatus for editing metadata, and computer product

• US 20060004815A1
• Filed: 11/24/2004
• Published: 01/05/2006
• Est. Priority Date: 07/01/2004
• Status: Abandoned Application

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Kanemasa, Yasuhiko, Murata, Miho
• Application Number:
  US10/997,042
• Publication Number:
  US 20060004815A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/86 Mapping to a database

Abstract

A method for editing metadata that is used for integration of data in a database-integration reference apparatus that refers to data distributed in a plurality of databases virtually as data in a single integrated database includes displaying a schema of the databases, the schema being formed with a plurality of elements; editing the metadata based on an element that is selected by a creator of the metadata from among the elements in the schema, where the element is arranged in a tree structure; and transmitting the metadata edited to the database-integration reference apparatus.

Claims

1. A computer-readable recording medium that stores a computer program for editing metadata that is used for integration of data in a database-integration reference apparatus that refers to data distributed in a plurality of databases virtually as data in a single integrated database, the computer program making a computer execute:

displaying a schema of the databases, the schema being formed with a plurality of elements;

editing the metadata based on an element that is selected by a creator of the metadata from among the elements in the schema, the element being arranged in a tree structure; and

transmitting the metadata edited to the database-integration reference apparatus.

2. The computer readable recording medium according to claim 1, wherein

the database is a relational database, and

the elements are columns in the relational database.

3. The computer readable recording medium according to claim 1, wherein

the elements are displayed on a screen, and

the element is arranged in the tree structure by drag and drop of the element selected from the elements in the schema displayed on the screen into an editing screen for the metadata.

4. The computer readable recording medium according to claim 1, wherein displaying includes displaying the schema within a range for which the creator possesses an access right.

5. The computer readable recording medium according to claim 2, wherein

the metadata includes a first table, and

when other columns in a second table that is different from the first table are added to the metadata, the editing includes displaying a combination candidate of the columns that can be associated with each other.

6. The computer readable recording medium according to claim 5, wherein when there is an old combination candidate of columns that have been associated in the metadata created before, the editing includes providing information on the old combination candidate.

7. The computer readable recording medium according to claim 5, wherein the combination candidate is formed with columns in which all data types are identical.

8. The computer readable recording medium according to claim 1, wherein when an association between different elements is specified, the editing includes determining whether the association is correct and displaying the determined result.

9. The computer readable recording medium according to claim 8, wherein the editing further includes determining whether the association is correct by statistically analyzing a relation between actual data of the different elements for which the association is specified.

10. The computer readable recording medium according to claim 9, wherein the editing further includes determining whether the association is correct based on significance of a probability that the actual data of one of the different elements is included in the actual data of other of the different elements.

11. The computer readable recording medium according to claim 10, wherein

the editing further includes

sampling the actual data of the one of the different elements;

calculating the probability that the actual data sampled is included in the actual data of the other of the different elements;

calculating a density of a set of a value range of the other of the different elements; and

determining whether the probability is valid based on values of the probability and the density.

12. The computer readable recording medium according to claim 1, wherein when a modification is made in the schema, the editing includes providing information that indicates that a part of the metadata corresponding to the modification is to be corrected.

13. The computer readable recording medium according to claim 12, wherein when the metadata that is to be edited is old metadata that is created before, the editing includes determining whether the modification is made in the schema that is used for creating the old metadata.

14. A computer-readable recording medium that stores a computer program for editing metadata that is used when data distributed in a plurality of databases is to be referenced virtually as data in a single integrated database, the computer program making a computer execute:

displaying a schema of the databases, the schema being formed with a plurality of elements;

editing the metadata based on an element that is selected by a creator of the metadata from among the elements in the schema, the element being arranged in a tree structure; and

storing the metadata edited in a storage unit.

15. The computer readable recording medium according to claim 14, wherein the metadata is stored in an Extensible Markup Language format.

16. The computer readable recording medium according to claim 14, further making the computer execute monitoring the databases to obtain information on the schema from the databases at a predetermined time interval, wherein

the schema is displayed using the information obtained.

17. The computer readable recording medium according to claim 16, wherein

the monitoring includes obtaining the information within a range for which the creator possesses an access right with respect to each of the databases, and

the displaying includes displaying the schema within the range.

18. A method for editing metadata that is used for integration of data in a database-integration reference apparatus that refers to data distributed in a plurality of databases virtually as data in a single integrated database, the method comprising:

displaying a schema of the databases, the schema being formed with a plurality of elements;

editing the metadata based on an element that is selected by a creator of the metadata from among the elements in the schema, the element being arranged in a tree structure; and

transmitting the metadata edited to the database-integration reference apparatus.

19. An apparatus for editing metadata that is used for integration of data in a database-integration reference apparatus that refers to data distributed in a plurality of databases virtually as data in a single integrated database, the apparatus comprising:

a display unit that displays a schema of the databases, the schema being formed with a plurality of elements;

an editing unit that edits the metadata based on an element that is selected by a creator of the metadata from among the elements in the schema, the element being arranged in a tree structure; and

a transmitting unit that transmits the metadata edited to the database-integration reference apparatus.