Database Transaction Generator for Schema Adaptation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database management systems face challenges in supporting changes to underlying data models and migrating applications to alternative data representations, requiring significant effort and specialized skills, and the process of creating and managing database transactions is inefficient and complex.
Innovation Solution
A method and system for generating database transaction statements based on existing statements by parsing fields and attributes, using user input to create transactional statements, and providing interfaces for users to manage transactions without needing technical knowledge of database schemas.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If SQL queries are used to access relational databases, then data retrieval and manipulation are enabled, but the application becomes tightly coupled to the relational data model and schema changes require application modification
Solution Approach 1:
The patent introduces a translation layer that acts as an intermediary between the application and the database. This layer translates abstract data model queries into SQL statements specific to the underlying relational schema, allowing the application to remain independent of schema changes. The translation layer handles the complexity of mapping between abstract and concrete data models, shielding the application from relational model dependencies.
Solution Approach 2:
The patent segments the data access functionality into distinct components: an abstract data model layer, a translation layer, and an implementation layer. This segmentation allows each layer to be developed and modified independently, with the translation layer serving as the interface that handles adaptations to different data models without affecting the application logic.
2Adaptability or versatility
If software encapsulation using EJB is implemented to abstract data access, then data model changes can be isolated, but the approach requires specialized skills and significant development effort
Solution Approach 1:
The patent generates transaction statements dynamically at runtime based on the abstract data model and user input, rather than requiring pre-defined EJB components for each data access scenario. This approach eliminates the need for extensive EJB development and deployment cycles, providing data access flexibility through on-demand statement generation without the overhead of specialized component development.
3Reliability
If database administrators manually manage transaction statements, then data integrity and security can be controlled, but the process becomes inefficient and complex
Solution Approach 1:
The patent implements a system where transaction statements are automatically generated based on the abstract data model, field attributes, and user input. The system self-manages the complexity of transaction statement creation by leveraging metadata about the data model and automated generation logic, eliminating the need for manual database administrator intervention while maintaining data integrity through controlled generation rules.
Data Source
AI summary
The present invention is generally directed providing a method, system and article of manufacture for automatically generating database transaction statements (such as queries, inserts, updates, and deletes) based on fields from existing queries and user input. By identifying fields of existing queries (or statements) and gathering attributes of those fields, a transaction generator can be configured to provide users with a selection of generated transactions that can be performed on data that corresponds to the selected fields. The selection of transactions may be provided to users via a variety of interfaces including graphic interfaces and plug-in components utilized by external applications.