Reporting and data governance management

• US 10,289,620 B1
• Filed: 11/15/2017
• Issued: 05/14/2019
• Est. Priority Date: 11/15/2017
• Status: Active Grant

• Current Assignee: Accenture Global Solutions Limited (Accenture PLC)
• Original Assignee: Accenture Global Solutions Limited (Accenture PLC)
• Inventors: Cleaver, Melinda Jo, Boone, Ryan Alan J.
• Primary Examiner(s): Truong, Cam Y T
• Application Number:
  US15/813,727
• Publication Number:
  US 20190147088A1
• Time in Patent Office: 545 Days
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/2433 Query languages
• CPC Class Codes: G06F 16/24526 Internal representations for queries
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for generating a database, including identifying a plurality of assets, each asset associated with a database query; parsing the plurality of assets to identify metadata associated with each asset; analyzing the metadata to identify a plurality of enterprise terms; providing, in response to the analyzing, one or more database models, the one or more database models storing relationships between the assets and the metadata, the relationships including, for one or more of the assets of the plurality of assets, a link between the asset and a particular enterprise term of the plurality of enterprise terms that is determined to be associated with the asset; and storing the database models.

Claims

1. A computer-implemented method for generating a database, the method comprising:

identifying, by a computer, a plurality of assets including database table columns stored in memory, wherein the identifying includes identifying an additional asset and comparing parameters of the additional asset with one or more of the assets of the plurality of assets to identify differences of the additional asset with the asset, and wherein the asset is updated based on the differences;

parsing, by the computer, the plurality of assets to identify metadata associated with the asset, the metadata including column metadata that identifies the database table columns included by the asset and an asset complexity of the asset;

analyzing, by the computer, the database table columns to identify mappings between one or more database table columns of database tables and a plurality of enterprise terms, each enterprise term of the enterprise terms mapped to a respective database table column of the database table columns;

creating, by the computer, a database query based on the mappings of the enterprise terms to the database table columns;

providing, by the computer, the database query to a computer device for verification of the database query;

storing, by the computer, the database query in the memory in response to a result of the verification;

providing, by the computer, two database models storing relationships between the assets and the metadata, the two database models including a first database model that stores the asset complexity of the asset and a second database model that stores a resource location of the database query associated with the asset, the relationships including, for the one or more of the assets of the plurality of assets;

a link between the asset and a particular enterprise term of the plurality of enterprise terms that is determined to be associated with the asset;

storing the database models in the memory; and

in response to receiving the database query that is stored in the memory, providing, by the computer, a response to the received database query via an application interface based on the link between the asset and the particular enterprise term, the asset complexity of the asset as stored by the first database model, and the resource location of the database query as stored by the second database model.

2. The method of claim 1, wherein at least one asset of the plurality of assets is associated with a relational database query.

3. The method of claim 2, wherein the at least one asset is associated with a Structured Query Language (SQL) query.

4. The method of claim 1, wherein at least one asset of the plurality of assets is associated with a non-relational database query.

5. The method of claim 1, wherein the database includes multiple tables, each table storing differing datum of the metadata of the plurality of assets.

6. The method of claim 1, wherein the metadata, for at least one asset of the plurality of assets, includes a resource location of the database query associated with the asset, and database tables included by the asset.

7. A system comprising:

one or more computers, a memory, and one or more non-transitory storage devices storing instructions that are operable, when executed by the one or more computers, to cause the one or more computers to perform operations comprising;

identifying a plurality of assets including database table columns stored in the memory, wherein the identifying includes identifying an additional asset and comparing parameters of the additional asset with one or more of the assets of the plurality of assets to identify differences of the additional asset with the asset, and wherein the asset is updated based on the differences;

parsing the plurality of assets to identify metadata associated with the asset, the metadata including column metadata that identifies the database table columns included by the asset and an asset complexity of the asset;

analyzing the database table columns to identify mappings between one or more database table columns of database tables and a plurality of enterprise terms, each enterprise term of the enterprise terms mapped to a respective database table column of the database table columns;

creating a database query based on the mappings of the enterprise terms to the database table columns;

providing the database query to a computer device for verification of the database query;

storing the database query in the memory in response to a result of the verification;

providing two database models storing relationships between the assets and the metadata, the two database models including a first database model that stores the asset complexity of the asset and a second database model that stores a resource location of the database query associated with the asset, the relationships including, for the one or more of the assets of the plurality of assets;

a link between the asset and a particular enterprise term of the plurality of enterprise terms that is determined to be associated with the asset;

storing the database models in the memory; and

in response to receiving the database query that is stored in the memory, providing a response to the received database query via an application interface based on the link between the asset and the particular enterprise term, the asset complexity of the asset as stored by the first database model, and the resource location of the database query as stored by the second database model.

8. The system of claim 7, wherein at least one asset of the plurality of assets is associated with a relational database query.

9. The system of claim 8, wherein the at least one asset is associated with a Structured Query Language (SQL) query.

10. The system of claim 7, wherein at least one asset of the plurality of assets is associated with a non-relational database query.

11. The system of claim 7, wherein the database includes multiple tables, each table storing differing datum of the metadata of the plurality of assets.

12. The system of claim 7, wherein the metadata, for at least one asset of the plurality of assets, includes a resource location of the database query associated with the asset, and database tables included by the asset.

13. A non-transitory computer-readable medium storing software comprising instructions executable by one or more computers which, upon such execution, cause the one or more computers to perform operations comprising:

identifying a plurality of assets including database table columns stored in memory, wherein the identifying includes identifying an additional asset and comparing parameters of the additional asset with one or more of the assets of the plurality of assets to identify differences of the additional asset with the asset, and wherein the asset is updated based on the differences;

parsing the plurality of assets to identify metadata associated with the asset, the metadata including column metadata that identifies the database table columns included by the asset and an asset complexity of the asset;

analyzing the database table columns to identify mappings between one or more database table columns of database tables and a plurality of enterprise terms, each enterprise term of the enterprise terms mapped to a respective database table column of the database table columns;

creating a database query based on the mappings of the enterprise terms to the database table columns;

providing the database query to a computer device for verification of the database query;

storing the database query in the memory in response to a result of the verification;

providing two database models storing relationships between the assets and the metadata, the two database models including a first database model that stores the asset complexity of the asset and a second database model that stores a resource location of the database query associated with the asset, the relationships including, for the one or more of the assets of the plurality of assets;

a link between the asset and a particular enterprise term of the plurality of enterprise terms that is determined to be associated with the asset;

storing the database models in the memory; and

in response to receiving the database query that is stored in the memory, providing a response to the received database query via an application interface based on the link between the asset and the particular enterprise term, the asset complexity of the asset as stored by the first database model, and the resource location of the database query as stored by the second database model.

14. The computer-readable medium of claim 13, wherein at least one asset of the plurality of assets is associated with a relational database query.

15. The computer-readable medium of claim 14, wherein the at least one asset is associated with a Structured Query Language (SQL) query.

16. The computer-readable medium of claim 13, wherein at least one asset of the plurality of assets is associated with a non-relational database query.

17. The computer-readable medium of claim 13, wherein the database includes multiple tables, each table storing differing datum of the metadata of the plurality of assets.

18. The computer-readable medium of claim 13, wherein the metadata, for at least one asset of the plurality of assets, includes a resource location of the database query associated with the asset, and database tables included by the asset.