×

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
First Claim
Patent Images

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.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×