Metadata driven reporting and editing of databases

Patent metadata

Field	Value
Publication number	US-10169389-B2
Application number	US-201615182935-A
Country	US
Kind code	B2
Filing date	Jun 15, 2016
Priority date	Oct 26, 2007
Publication date	Jan 1, 2019
Grant date	Jan 1, 2019

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.

First claim

We claim:

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

Assignees

• Microsoft Technology Licensing Llc

Inventors

• Bloesch Anthony Christopher
• Jayadevan Siddharth
• Flynn James R
• Williams Antony Scott

Classifications

• G06F16/23

  Updating · CPC title

• G06F17/30589

  Physics · mapped topic

• G06F17/3038

  Physics · mapped topic

• G06F17/30563

  Physics · mapped topic

• G06F17/30342 Primary

  Physics · mapped topic