Method and apparatus for sharing metadata between multiple data marts through object references

• US 6,044,374 A
• Filed: 11/14/1997
• Issued: 03/28/2000
• Est. Priority Date: 11/14/1997
• Status: Expired due to Term

• Current Assignee: Informatica LLC (Informatica, Inc. (California))
• Original Assignee: Informatica Corporation
• Inventors: Gupta, Sanjeev, Chandra, Parth S., Taylor, Jeffrey B., Nesamoney, Diaz, Pancha, Girish, Zamanian, M S Kiumarse
• Primary Examiner(s): Amsbury, Wayne
• Assistant Examiner(s): TRINH, WILLIAM B
• Application Number:
  US08/970,950
• Time in Patent Office: 865 Days
• Field of Search: 707/1, 707/10, 707/103, 707/200, 707/201
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A method and system for accessing and sharing metadata amongst a number of data marts through the use of object referencing. A global repository is created. Shared folders containing metadata is contained in the global repository. Any number of data marts can be linked to the global repository. Stored within the folders of the linked data marts are references pointing to certain metadata stored in the shared folders of the global repository. Multiple data marts can reference the same metadata in the global repository. Thereby, the same metadata can be accessed, used, and shared by multiple users across different data marts, provided that they have been granted the proper authority. New metadata can be promoted from a linked data mart into the global repository so that it can be shared, and updates to shared metadata can be automatically propagated to all users referencing that metadata.

Claims

1. A database system for storing data, comprising:

a global repository containing metadata;

a shared folder residing within the global repository, wherein the shared folder contains metadata which is to be shared;

a first data mart linked to the global repository;

a reference residing within the first data mart, wherein the reference specifies a link to of the metadata in the shared folder of the global repository and a user accesses the metadata through the first data mart by using the reference to read the metadata residing in the shared folder.

2. The database system of claim 1 further comprising a user account stored in either the global repository or the data mart which grants the user privilege to read from and/or write to the metadata stored in the shared folder.

3. The database system of claim 1, wherein metadata is first created in the data mart and then promoted to the global repository.

4. The database system of claim 1 further comprising:

a second data mart linked to the global repository;

a second reference pointing to the metadata residing within the global repository, wherein a first user has access to the metadata through the first data mart by the first reference and a second user has access to the metadata through the second data mart by the second reference.

5. The database system of claim 1, wherein a change made to the metadata stored in the global repository is propagated to the first data mart.

6. The database system of claim 1, wherein if the metadata is changed, a message is transmitted to the user indicating that the metadata has been modified.

7. A method for sharing metadata between a plurality of databases, comprising the steps of:

creating a first database comprised of a global data mart repository for storing the metadata that is to be shared;

creating a second database comprised of a data mart;

linking the second database to the first database;

creating a reference which specifies a link to where the metadata is stored in the first database;

storing the reference in the second database;

accessing the metadata by using the reference.

8. The method of claim 7 further comprising the step of promoting metadata from the data mart to the global data mart repository.

9. The method of claim 8 further comprising the steps of creating another data mart having a reference to the metadata of the global data mart repository, wherein both data marts have access to the same shared metadata stored in the global data mart repository.

10. The method of claim 9 further comprising the steps of:

a first user changing the metadata stored in the global data mart;

providing a second user with updated metadata when the second user accesses the metadata, wherein the metadata is updated automatically and transparently to the second user.

11. The method of claim 10, wherein the global data mart repository was created from a pre-existing data mart.

12. The method of claim 10 further comprising the step of creating a plurality of user accounts which specify access privileges for a plurality of users with respect to the metadata stored in the global data mart repository.