Metadata driven reporting and editing of databases

• US 10,169,389 B2
• Filed: 06/15/2016
• Issued: 01/01/2019
• Est. Priority Date: 10/26/2007
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Bloesch, Anthony Christopher, Jayadevan, Siddharth, Flynn, James R., Williams, Antony Scott
• Primary Examiner(s): Channavajjala, Srirama
• Application Number:
  US15/182,935
• Publication Number:
  US 20160299930A1
• Time in Patent Office: 930 Days
• CPC Class Codes: G06F 11/1435 using file system or storage system metadata
• CPC Class Codes: G06F 16/14 Details of searching files based on file metadata
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/2291 User-Defined Types; Storage management thereof
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2386 Bulk updating operations data conversion details G06F16/258
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/282 Hierarchical databases, e.g. IMS, LDAP data stores or Lotus Notes

Abstract

A computer system identifies an information set stored at a data store. The computer system then identifies first metadata that includes first instructions indicating how the information set is to present a plurality of data items, and second pre-existing metadata that includes second instructions indicating how the information set is to present the plurality of data items. The computer system determines that a portion of the first metadata will override a portion of the second metadata, to create combined metadata. The computer system provides the combined metadata to the information set, including combining the second metadata with the first metadata by at least overriding the second instructions of the second metadata with the first instructions of the first metadata. The computer system presents the plurality of data items in accordance with the second metadata, at least as modified by the first instructions of the first metadata.

Claims

1. A computer system, comprising:

one or more processors;

system memory; 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 link database metadata for reporting data items in a customizable manner, the computer-executable instructions including instructions that are executable to cause the computer system to perform at least the following;

receive a user request that indicates one or more requested data items that are stored in a data store and that are to be reported in response to the request;

based at least on receiving the request, identify one or more information sets that are stored at the data store and that define one or more queries for accessing the one or more requested data items from the data store using at least one of;

one or more scripts, one or more read/write messages, or one or more code portions;

report to the user a list of the identified one or more information sets, the list of the identified information sets usable to determine how the one or more requested data items will be reported according to pre-existing metadata stored at the data store, the pre-existing metadata comprising one or more first instructions indicating how the one or more information sets are to present the one or more requested data items;

based at least on reporting the list of the identified information sets to the user, receive input metadata that includes one or more second instructions altering how the one or more information sets are to present the one or more requested data items according to the pre-existing metadata;

link the pre-existing metadata with the input metadata to create combined metadata, the linking causing at least one of the one or more first instructions of the pre-existing metadata to override at least one of the one or more second instructions of the input metadata, while preserving the overridden at least one of the one or more second instructions;

store the combined metadata in the data store for use by subsequent requests for reporting the one or more requested data items; and

present the one or more requested data items according to the combined metadata.

2. The computer system of claim 1, wherein the data store comprises a structured query language (SQL) database.

3. The computer system of claim 1, wherein at least one of the one or more data items comprises a schema.

4. The computer system of claim 1, wherein the input metadata is specified by the user.

5. The computer system of claim 1, wherein the data store comprises one or more of a directory, a registry, or a database.

6. The computer system of claim 1, wherein the one or more information sets comprises relational data sets.

7. A method, implemented at a computer system that includes one or more processors, for linking database metadata for reporting data items in a customizable manner, the method comprising:

receiving a user request that indicates one or more requested data items that are stored in a data store and that are to be reported in response to the request;

based at least on receiving the request, identifying one or more information sets that are stored at the data store and that define one or more queries for accessing the one or more requested data items from the data store using at least one of;

one or more scripts, one or more read/write messages, or one or more code portions;

reporting to the user a list of the identified one or more information sets, the list of the identified information sets usable to determine how the one or more requested data items will be reported according to pre-existing metadata stored at the data store, the pre-existing metadata comprising one or more first instructions indicating how the one or more information sets are to present the one or more requested data items;

based at least on reporting the list of the identified information sets to the user, receiving input metadata that includes one or more second instructions altering how the one or more information sets are to present the one or more requested data items according to the pre-existing metadata;

linking the pre-existing metadata with the input metadata to create combined metadata, the linking causing at least one the one or more first instructions of the pre-existing metadata to override at least one of the one or more second instructions of the input metadata, while preserving the overridden at least one of the one or more second instructions;

storing the combined metadata in the data store for use by subsequent requests for reporting the one or more requested data items; and

presenting the one or more requested data items according to the combined metadata.

8. The method of claim 7, wherein the data store comprises a structured query language (SQL) database.

9. The method of claim 7, wherein at least one of the one or more data items comprises a schema.

10. The method of claim 7, wherein the input metadata is specified by the user.

11. The method of claim 7, wherein the data store comprises one or more of a directory, a registry, or a database.

12. The method of claim 7, wherein the one or more information sets comprises relational data sets.

13. 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 cause the computer system to link database metadata for reporting data items in a customizable manner, the computer-executable instructions including instructions that are executable to cause the computer system to perform at least the following:

receive a user request that indicates one or more requested data items that are stored in a data store and that are to be reported in response to the request;

based at least on receiving the request, identify one or more information sets that are stored at the data store and that define one or more queries for accessing the one or more requested data items from the data store using at least one of;

one or more scripts, one or more read/write messages, or one or more code portions;

report to the user a list of the identified one or more information sets, the list of the identified information sets usable to determine how the one or more requested data items will be reported according to pre-existing metadata stored at the data store, the pre-existing metadata comprising one or more first instructions indicating how the one or more information sets are to present the one or more requested data items;

based at least on reporting the list of the identified information sets to the user, receive input metadata that includes one or more second instructions altering how the one or more information sets are to present the one or more requested data items according to the pre-existing metadata;

link the pre-existing metadata with the input metadata to create combined metadata, the linking causing at least one of the one or more first instructions of the pre-existing metadata to override at least one of the one or more second instructions of the input metadata, while preserving the overridden at least one of the one or more second instructions;

store the combined metadata in the data store for use by subsequent requests for reporting the one or more requested data items; and

present the one or more requested data items according to the combined metadata.

14. The computer program product of claim 13, wherein the data store comprises a relational data store, and wherein the one or more information sets comprise relational data sets.