Database View Generation via Parameterized Templates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database management systems face challenges in generating reports due to high levels of aggregation and limited dimensions, requiring significant resources and making it difficult to handle customizations in large and complex database systems.
Innovation Solution
A system that uses a view generator to create database views through generation templates, which are code structures that describe how to build SQL statements without referencing specific database names, allowing for dynamic generation of views that can handle customizations and reduce resource usage.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If conventional approaches import transactional data into a business warehouse and set up defined queries, then reporting functionality is achieved, but memory and hardware resources are significantly consumed
Solution Approach 1:
The patent introduces a view generator as an intermediary component that creates virtual database views without physically importing data into a business warehouse. The view generator translates custom database table structures into standardized SQL views, enabling reporting functionality while avoiding the resource-intensive data import process. This intermediary layer allows queries to be executed directly on the source database through generated views, eliminating the need for large warehouse infrastructure.
2Adaptability or versatility
If customers make many different types of customizations to database tables, then system flexibility is improved, but reporting complexity increases significantly
Solution Approach 1:
The view generator implements a universal solution that handles multiple types of database table customizations through a single code template mechanism. The generation template uses parameters and placeholders that can adapt to various table structures, columns, and relationships without requiring separate reporting logic for each customization scenario. This universal approach simplifies reporting complexity by providing a unified method to work with diverse customizations.
Solution Approach 2:
The system uses parameterized code templates where database table names, column names, and relationship definitions are substituted as parameters during view generation. This allows the same template structure to accommodate different customization scenarios by simply changing the parameter values, rather than modifying the underlying reporting logic for each customization.
3Quantity of substance
If the database management system stores millions of transactions, then data completeness is improved, but processing speed decreases
Solution Approach 1:
The view generator segments the large transactional database into virtual views that present only the necessary data subsets for specific reporting needs. By generating targeted SQL views that filter and aggregate data at the query level rather than physically dividing the database, the system maintains access to millions of transactions while enabling faster processing for specific reporting scenarios through optimized view definitions.
Data Source
AI summary
In some embodiments, a system for database view generation may include a view generator configured to generate a database view for one or more database tables. The view generator includes a generation module configured to determine a generation template for the database view, where the generation template is a code structure describing a manner in which the database view is created. The code structure does not reference a database name of the one or more database tables. The generation module is configured to invoke a code composer to insert code commands into the generation template to build a structured query language (SQL) statement for the database view, where the SQL statement references the database name of the one or more database tables. The view generator is configured to create the database view based on the SQL statement.