Heterogeneous Database Report Normalization via Intermediary Templates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing information management systems face challenges in graphically representing data from heterogeneous databases with different formats, requiring complex programming and making it difficult to generate unified reports across various database types.
Innovation Solution
A system that translates content from different database types into a uniform format, allowing users to generate custom reports and graphical representations without database programming skills through a graphical user interface, using an acquisition module to normalize query results and store them in an interim database for graphical representation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If fixed charts or graphs are used to represent database contents, then visual representation is provided, but complexity increases and requires programming skills to modify
Solution Approach 1:
The patent introduces an intermediary layer between the database and the graphical representation. This intermediary consists of template definitions that specify how database fields map to graphical elements. Users can modify templates without writing code, as the system automatically handles the translation between database queries and graphical output based on the template definitions.
Solution Approach 2:
The system segments the graphical representation system into independent template definitions for each chart or graph. Each template is a self-contained unit that defines its own data sources, visual elements, and formatting. This segmentation allows users to modify individual templates without affecting other charts, reducing overall system complexity.
2Adaptability or versatility
If multiple heterogeneous database types are used, then data diversity is improved, but ability to graphically represent information from all databases in a single representation is lost
Solution Approach 1:
The patent creates a universal template system that can work with multiple heterogeneous database types. The templates are designed to be database-agnostic, using standardized field references that can map to different database schemas. This universality allows the same template to query and represent data from relational databases, object-oriented databases, or other data sources without requiring separate template definitions for each database type.
Data Source
AI summary
Systems and methods for generating customized reports from data storage databases and other information management system databases. The methods include normalizing queried information from different types of information management system databases to enable system-wide report generation. Other implementations are disclosed.