Multi-faceted metadata storage

• US 8,990,167 B2
• Filed: 06/11/2010
• Issued: 03/24/2015
• Est. Priority Date: 06/11/2010
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Noor, David
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US12/813,523
• Publication Number:
  US 20110307493A1
• Time in Patent Office: 1,747 Days
• Field of Search: 707/607, 707/609, 707/661, 707/687, 707/705, 707/790, 707/818
• US Class Current: 707/687
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/2477 Temporal data queries

Abstract

A system and method for storing and providing metadata. Metadata may be retrieved from multiple sources. The metadata is stored in facets in a repository and tagged to indicate one or more of the source, a time frame, or an associated data object. In response to receiving a request for metadata, a system selects metadata based on the specified object, source, or time frame. Access permissions corresponding to the requester are used to select and provide metadata for which the requester has permissions.

Claims

1. A computer-based method of storing and providing metadata items corresponding to a plurality of data objects, the method comprising:

a) receiving, from each of a plurality of sources, a corresponding set of metadata items, each metadata item of the set of metadata items corresponding to one or more data objects of the plurality of data objects;

b) storing each metadata item as a facet in a repository;

c) tagging each facet with an identifier of a source corresponding to the facet, an identifier of a time frame corresponding to the facet, and a data object corresponding to the facet, wherein at least two facets corresponding to a data object have different corresponding time frames from each other;

d) receiving, from a requester, a request for metadata, the request including a specification of a requested time frame representative of a time, prior to the request, that the metadata was received, retrieved, or extracted;

e) in response to receiving the request, providing first metadata stored as a facet corresponding to a time frame that matches the requested time frame, and not providing second metadata stored as a facet corresponding to a time frame that does not match the requested time frame; and

f) in response to receiving the request, selectively providing the requested metadata to the requester based on whether access permissions corresponding to the requester indicate that the requester has permissions corresponding to the specified time frame.

4. The computer-based method of claim 1, retrieving the response set of facets comprising determining the response set of facets based on a source corresponding to each facet and access permissions of the requester corresponding to each of the sources.

5. The computer-based method of claim 1, retrieving the response set of facets comprising determining an accessible set of sources based on the access permissions corresponding to the requester, and excluding facets having corresponding sources outside of the accessible set of sources.

6. The computer-based method of claim 1, further comprising receiving the access permissions corresponding to the requester after storing each item of data.

7. The computer-based method of claim 1, the plurality of data objects including a data object corresponding to a server, at least one metadata item representing a dependency of the server, the request including a specification of the server.

8. The computer-based method of claim 1, each of the first metadata item and the second metadata item descriptive of a corresponding data table or a data table column.

9. The computer-based method of claim 1, further comprising employing the provided metadata to determine an impact of modifying a column specification of a data table.

2. A computer-based system for storing and providing metadata items corresponding to a plurality of data objects, the system comprising:

a) a metadata facet repository that stores each of the metadata items as a metadata facet tagged with identification of a corresponding data object, a corresponding source, and a corresponding time frame representative of a time that the corresponding metadata item was received or extracted and wherein a first facet corresponding to a data object has a different corresponding time frame from a second facet corresponding to the data object;

b) an access permissions repository that stores information representing permission to access metadata facets having specified sources and time frames, each permission representative of a permission to access metadata facets having a corresponding source or time frame, the permissions of a requester varying across different time frames;

c) a data storage processor that receives a set of metadata items from each of a plurality of sources and stores each metadata item as a facet in the metadata facet repository; and

d) a data provider processor that performs actions including;

i. receiving, from a requester, a request for metadata, the request including a specification of the data object and a specified time frame representative of a time that a metadata item was received or extracted; and

ii. in response to receiving the request, retrieving access permissions corresponding to the requester from the access permissions repository and retrieving a response set of facets based on the specification of the data object, a source and time frame corresponding to each metadata facet, and whether the access permissions indicate that the requester has permission to retrieve facets having a corresponding time frame, the response set of facets including a first facet corresponding to a first time frame that matches the specified time frame and excluding a second facet corresponding to a second time frame that does not match the specified time frame.

10. The computer-based system of claim 2, further comprising one or more processors that execute computer program instructions of the data storage processor and the data provider processor.

11. The computer-based system of claim 2, the data storage processor performing additional actions including storing each metadata facet in a configuration that is not based on access permissions associated with the metadata facet.

12. The computer-based system of claim 2, the access permissions including a specification of a combination of a data source and a time frame corresponding to the requester.

13. The computer-based system of claim 2, the access permission repository storing information representing access permissions for a combination of a source and a time period, the time period representative of a time that the source received a corresponding facet.

3. A computer-readable storage medium comprising computer program instructions for managing storage and retrieval of metadata, the program instructions executable by one or more processors to perform actions including:

a) receiving a plurality of metadata items, each metadata item having a corresponding source and a corresponding time frame, the time frame representative of a time that the metadata item was extracted or received;

b) storing each received metadata item as a facet tagged with its corresponding source and time frame in a repository;

c) receiving, from a requester, a request for metadata, the request specifying a time frame; and

d) in response to receiving the request, performing actions including;

i. retrieving a response set of facets based on one or more sources for which the requester has access rights, including facets having a corresponding time frame for which the requester has access rights and excluding facets having a corresponding time frame for which the requester lacks access rights; and

ii. aggregating metadata corresponding to the response set of facets, and providing the aggregated metadata.

14. The computer-readable storage medium of claim 3, storing each received metadata item comprises storing each facet in a configuration that is not based on access permissions.

15. The computer-readable storage medium of claim 3, the actions further including storing the facets in a denormalized structure having a plurality of facets corresponding to common data objects and different sources.

16. The computer-readable storage medium of claim 3, the actions further comprising in response to receiving the request, retrieving a set of access permissions corresponding to the requester, the access permissions indicating the one or more sources for which the requester has access rights, and indicating for each of the one or more sources at least one time frame for which the requester lacks access rights and at least one other time frame for which the requester has access rights.

17. The computer-readable storage medium of claim 3, the time frame corresponding to each metadata item representing a time provided by a source of the metadata item.