Providing enhanced connection data for shared resources

• US 9,547,699 B2
• Filed: 11/18/2013
• Issued: 01/17/2017
• Est. Priority Date: 09/09/2013
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Roche, Matthew, Liensberger, Christian, Kasperski, Ziv, Nyombayire, Stphane
• Primary Examiner(s): BOWEN, RICHARD L
• Application Number:
  US14/082,451
• Publication Number:
  US 20150074078A1
• Time in Patent Office: 1,156 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/3328 using graphical result space presentation or visualisation
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence

Abstract

Embodiments are directed to establishing a metadata repository that aggregates metadata for a plurality of data sources, inferring data source metadata at a metadata repository and to providing recommendations to data managers based on aggregated inputs. In one scenario, a computer system establishes a reference to one or more data sources, where each data source includes data elements. The computer system receives a data request for specified data elements stored on the data sources and accesses the established references to determine which data source the specified data elements are stored on. The computer system then retrieves at least one of the specified data elements from its determined data source and sends the retrieved data elements to a specified computer system, along with an indication of additional data elements that are relevant to the received data request, and a further indication of how those additional data elements are to be accessed.

Claims

1. A computer system, comprising:

one or more processors; and

one or more computer-readable storage media having stored thereon computer-executable instructions that are executable by the one or more processors to cause the computer system to establish a metadata repository that aggregates metadata for a plurality of data sources, the computer-executable instructions including instructions that are executable to cause the computer system to perform at least the following;

establish a reference to one or more data sources, each data source including one or more data elements;

receive a data request for one or more specified data elements stored on the one or more data sources;

access at least one of the established references to determine upon which data source the specified data elements are stored;

retrieve at least one of the specified data elements from its determined data source; and

send, to a specified computer system, (i) the retrieved data elements, (ii) a first indication comprising one or more additional data elements that are relevant to the received data request, and (iii) a second indication comprising how those additional data elements are to be accessed, wherein at least one of the one or more additional data elements associated with the first indication comprises a container that includes a first data element hosted within a second data element.

2. The computer system of claim 1, wherein the additional data elements are stored on one or more different data sources.

3. The computer system of claim 1, wherein lineage information is determined for one or more of the data elements, the lineage information indicating the data elements'"'"' relationships with other data elements.

4. The computer system of claim 3, wherein the lineage information is described in metadata associated with the data elements.

5. The computer system of claim 4, wherein at least one of the data elements also comprises a container that includes a child data element hosted within a parent data element, wherein lineage information included within the container is used to determine at least one of the one or more additional data elements associated with the first indication.

6. The computer system of claim 1, wherein inputs are received from one or more data managers with regard to data elements owned or managed by the one or more data managers, the one or more data managers comprising users that are authorized to modify the metadata repository, wherein the inputs received from the one or more data managers over a specified period of time are aggregated to determine how the one or more data managers are interacting with their data elements.

7. The computer system of claim 6, wherein one or more data element management recommendations are generated for at least one other data manager based on the received, aggregated inputs and the recommendation is sent to the at least one other data manager.

8. The computer system of claim 1, wherein one or more relationships between data elements is inferred based on an indication of where the data elements are stored and which other data elements are related to the data elements.

9. The computer system of claim 1, wherein a data manager specifies one or more relationships between data elements, the data manager comprising a user that is authorized to modify the metadata repository.

10. A method, implemented at a computer system that includes one or more processors, for establishing a metadata repository that aggregates metadata for a plurality of data sources, the method comprising:

establishing a reference to one or more data sources, each data source including one or more data elements;

receiving a data request for one or more specified data elements stored on the one or more data sources;

accessing at least one of the established references to determine upon which data source the specified data elements are stored;

retrieving at least one of the specified data elements from its determined data source; and

sending, to a specified computer system, (i) the retrieved data elements, (ii) a first indication comprising one or more additional data elements that are relevant to the received data request, and (iii) a second indication comprising how those additional data elements are to be accessed, wherein at least one of the one or more additional data elements associated with the first indication comprises a container that includes a first data element hosted within a second data element.

11. The method of claim 10, further comprising:

accessing the established reference to at least one of the one or more data sources;

accessing at least one of the following;

data elements stored on the at least one data source, data lineage information, data relationships, or one or more portions of metadata associated with the at least one data source; and

inferring, from at least one of the data elements stored on the at least one data source, the data lineage information, the data relationships and the one or more portions of metadata associated with the data source, one or more attributes that are to be associated with the at least one data source.

12. The method of claim 11, further comprising appending the one or more inferred attributes to metadata of the at least one data source within the metadata repository.

13. The method of claim 12, wherein the metadata repository includes one or more of the following for each data source:

metadata, documentation, or a workflow access point.

14. The method of claim 13, wherein the metadata repository learns from user inputs, such that subsequent metadata repository accesses are alterable based on learned user behavior.

15. The method of claim 13, wherein the metadata repository allows users to specify at least one of access type, credential type, or credential overrides for each data source linked by the metadata repository.

16. The method of claim 13, wherein the metadata repository is hostable in a plurality of locations including at least one of the following:

on-premises, on cloud, or on a federated space.

17. The method of claim 13, wherein a data manager is notified of any changes made to the metadata repository, the data manager comprising a user that is authorized to modify the metadata repository.

18. The method of claim 12, wherein the appended metadata is filtered such that only relevant data elements are displayed.

19. The method of claim 11, wherein user-provided information is accessed when inferring the one or more attributes that are to be associated with the at least one data source, the user-provided information comprising one or more of the following:

suggestions, hints, or annotations.

20. A computer program product comprising one or more hardware storage devices having stored thereon computer-executable instructions that are executable by one or more processors of a computer system to establish a metadata repository that aggregates metadata for a plurality of data sources, the computer-executable instructions including instructions that are executable to cause the computer system to perform at least the following:

establish a reference to one or more data sources, each data source including one or more data elements;

receive a data request for one or more specified data elements stored on the one or more data sources;

access at least one of the established references to determine upon which data source the specified data elements are stored;

retrieve at least one of the specified data elements from its determined data source; and

send, to a specified computer system, (i) the retrieved data elements, (ii) a first indication comprising one or more additional data elements that are relevant to the received data request, and (iii) a second indication comprising how those additional data elements are to be accessed, wherein at least one of the one or more additional data elements associated with the first indication comprises a container that includes a first data element hosted within a second data element.