Reporting and data governance management

• US 10,318,524 B2
• Filed: 11/15/2017
• Issued: 06/11/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,664
• Publication Number:
  US 20190147082A1
• Time in Patent Office: 573 Days
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for generating database queries, including receiving an asset template, the asset template associated with an enterprise context and one or more enterprise terms; identifying respective mappings of the one or more enterprise terms to one or more database tables; compiling the asset template based on the mappings to provide a database query; providing for display the database query; verifying the database query based on the displaying; receiving, in response to the verifying, an approval signal associated with the database query; storing the database query; querying a different database utilizing the database query; and in response to the querying, identifying data stored by the different database that is responsive to the database query.

Claims

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

receiving, at a server computer via a network, an asset template of asset templates, the asset template including both an enterprise context and one or more enterprise terms, wherein in a first enterprise context an enterprise term of the one or more enterprise terms corresponds to a single column in a first database of the first enterprise context and in a second enterprise context the enterprise term corresponds to two columns in a second database of the second enterprise context;

parsing and tokenizing, by the server computer, the asset template to identify metadata associated with the asset template;

expanding, by the server computer, the enterprise term into a formula, the formula depending on the two columns of database tables in the second database based on the enterprise context identified from the asset template corresponding to the second enterprise context, and the formula to include in a context-based term;

identifying, by the server computer, respective mappings of the context-based term that includes the formula that depends on the two columns in the second database to one or more database tables of the second database;

compiling, by the server computer and based on input from an application interface, the asset template based on the mappings to create a database query;

providing, by the server computer, the database query to a computing device for display, the displaying for verification of the database query;

verifying, by the server computer, the database query based on the displaying;

receiving, by the server computer, in response to the verifying, an approval signal associated with the database query;

storing, by the server computer, the database query in a memory, the storing based on the approval signal of the verifying;

creating an asset based on the database query, the creating an asset based on receiving the approval signal, the asset including searchable metadata for identifying the asset, and wherein the searchable metadata includes an identifier of a complexity of the asset;

querying, by the server computer, a third database utilizing the database query; and

in response to the querying, identifying, by the server computer and based on the searchable metadata and a resource location of the database query stored in a database model, data stored by the third database that is responsive to the database query.

2. The method of claim 1, wherein the database query is a relational database query.

3. The method of claim 2, wherein the relational database query is a Structure Query Language (SQL) query.

4. The method of claim 1, wherein the database query is a NoSQL query.

5. The method of claim 1, wherein the enterprise term is associated with one or more of a formula value, a scalar value, and a dynamic value.

6. A system comprising:

one or more processors and one or more storage devices storing instructions that are operable, when executed by the one or more processors, to cause the one or more processors to perform operations comprising;

receiving, at a server computer via a network, an asset template of asset templates, the asset template including both an enterprise context and one or more enterprise terms, wherein in a first enterprise context an enterprise term of the one or more enterprise terms corresponds to a single column in a first database of the first enterprise context and in a second enterprise context the enterprise term corresponds to two columns in a second database of the second enterprise context;

parsing and tokenizing, by the server computer, the asset template to identify metadata associated with the asset template;

expanding, by the server computer, the enterprise term into a formula, the formula depending on the two columns in the second database based on the enterprise context identified from the asset template corresponding to the second enterprise context, and the formula to include in a context-based term;

identifying, by the server computer, respective mappings of the context-based term that includes the formula that depends on the two columns in the second database to one or more database tables of the second database;

compiling, by the server computer and based on input from an application interface, the asset template based on the mappings to create a database query;

providing, by the server computer, the database query to a computing device for display, the displaying for verification of the database query;

verifying, by the server computer, the database query based on the displaying;

receiving, by the server computer, in response to the verifying, an approval signal associated with the database query;

storing, by the server computer, the database query in a memory, the storing based on the approval signal of the verifying;

creating an asset based on the database query, the creating an asset based on receiving the approval signal, the asset including searchable metadata for identifying the asset, and wherein the searchable metadata includes an identifier of a complexity of the asset;

querying, by the server computer, a third database utilizing the database query; and

in response to the querying, identifying, by the server computer and based on the searchable metadata and a resource location of the database query stored in a database model, data stored by the third database that is responsive to the database query.

7. The system of claim 6, the operations further comprising:

querying a different database utilizing the database query; and

in response to the querying, identifying data stored by the different database that is responsive to the database query.

8. The system of claim 6, wherein the database query is a relational database query.

9. The system of claim 8, wherein the relational database query is a Structure Query Language (SQL) query.

10. The system of claim 6, wherein the database query is a NoSQL query.

11. The system of claim 6, wherein the enterprise term is associated with one or more of a formula value, a scalar value, and a dynamic value.

12. 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:

receiving, at a server computer via a network, an asset template of asset templates, the asset template including both an enterprise context and one or more enterprise terms, wherein in a first enterprise context an enterprise term of the one or more enterprise terms corresponds to a single column in a first database of the first enterprise context and in a second enterprise context the enterprise term corresponds to two columns in a second database of the second enterprise context;

parsing and tokenizing, by the server computer, the asset template to identify metadata associated with the asset template;

expanding, by the server computer, the enterprise term into a formula, the formula depending on the two columns of database tables in the second database based on the enterprise context identified from the asset template corresponding to the second enterprise context, and the formula to include in a context-based term;

identifying, by the server computer, respective mappings of the context-based term that includes the formula that depends on the two columns in the second database to one or more database tables of the second database;

compiling, by the server computer and based on input from an application interface, the asset template based on the mappings to create a database query;

providing, by the server computer, the database query to a computing device for display, the displaying for verification of the database query;

verifying, by the server computer, the database query based on the displaying;

receiving, by the server computer, in response to the verifying, an approval signal associated with the database query;

storing, by the server computer, the database query in a memory, the storing based on the approval signal of the verifying;

creating an asset based on the database query, the creating an asset based on receiving the approval signal, the asset including searchable metadata for identifying the asset, and wherein the searchable metadata includes an identifier of a complexity of the asset;

querying, by the server computer, a third database utilizing the database query; and

in response to the querying, identifying, by the server computer and based on the searchable metadata and a resource location of the database query stored in a database model, data stored by the third database that is responsive to the database query.

13. The computer-readable medium of claim 12, the operations further comprising:

querying a different database utilizing the database query; and

in response to the querying, identifying data stored by the different database that is responsive to the database query.

14. The computer-readable medium of claim 12, wherein the database query is a relational database query.

15. The computer-readable medium of claim 14, wherein the relational database query is a Structure Query Language (SQL) query.

16. The computer-readable medium of claim 12, wherein the database query is a NoSQL query.