Database Query Template Reuse for Reporting Governance
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current systems face challenges in efficiently managing reporting assets and data governance, particularly in creating and reusing database queries across multiple databases without writing specific code for each row or column, and in integrating these processes into existing workflows.
Innovation Solution
A system that identifies and parses assets associated with database queries, analyzes metadata to determine enterprise terms, and generates database models that store relationships between assets and metadata, allowing for the creation of reusable database queries and improved data governance management.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Measurement precision
If database queries are written specifically for each row or column in multiple databases, then query accuracy is improved, but development time and complexity increase significantly
Solution Approach 1:
The patent creates template queries that can be copied and reused across multiple databases. Instead of writing custom queries for each database, the system stores template queries with parameters that can be instantiated for different databases, significantly reducing development time while maintaining query accuracy through parameter substitution.
Solution Approach 2:
The patent implements universal template queries that can serve multiple databases with different schemas. The template queries are designed to be database-agnostic, using parameters to adapt to specific database structures, allowing one query template to fulfill multiple specific query needs across different databases.
2Adaptability or versatility
If reporting assets and data governance processes are managed manually, then flexibility in customization is improved, but process efficiency and automation decrease
Solution Approach 1:
The patent implements self-service capabilities where the system automatically discovers reporting assets, extracts metadata, and generates database models without requiring manual intervention for each task. The system can automatically update enterprise terms and relationships based on changes in the underlying data structures.
Solution Approach 2:
The patent performs preliminary actions by pre-defining template queries and enterprise term relationships before actual reporting needs arise. The system proactively discovers and catalogs reporting assets and their metadata in advance, so that when reporting is needed, the work is already partially completed and can be quickly assembled.
3Reliability
If comprehensive metadata analysis is performed to identify enterprise terms and relationships, then data governance quality is improved, but processing complexity and computational resources increase
Solution Approach 1:
The patent segments the metadata analysis process into distinct components: extracting metadata from reporting assets, identifying enterprise terms, determining relationships between terms, and storing the results in structured database models. This segmentation allows each component to be processed independently and simplifies the overall complexity of the analysis process.
Data Source
AI summary
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.