Automatic Object Inference in Relational Database Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Developing and maintaining data-centric applications is costly and complex due to the need to manage multiple data modeling frameworks, leading to inefficient and hard-to-maintain code, especially when using relational database management systems (RDBMS) in conjunction with object-oriented models.
Innovation Solution
A binary relational model is introduced where application-layer object structures are automatically inferred from queries, allowing for simpler query formulation and direct expression of relationships between non-primitive entities, reducing the need for join tables and complex programming.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple data modeling frameworks (object-oriented and relational) are used together, then data can be stored and manipulated in both paradigms, but the complexity and effort required to develop and maintain applications significantly increases
Solution Approach 1:
The patent merges object-oriented and relational data modeling frameworks into a unified system where object structures are automatically inferred from relational queries. The query result structures serve as the object model, eliminating the need for separate class definitions while maintaining both paradigms' advantages.
Solution Approach 2:
The patent creates a universal data access interface that works with both object-oriented and relational models through a single query language. The same query mechanism can retrieve data in both paradigms, making the system multi-functional without requiring separate development paths.
2Productivity
If object-relational mapping tools are used to reduce development effort, then code generation is automated, but the code becomes hard to read and write, and developers often abandon these tools
Solution Approach 1:
The system allows developers to write natural relational queries without needing ORM annotations or configurations. The object structures are self-inferred from the query results themselves, eliminating the need for developers to maintain separate object model definitions while preserving code clarity.
Solution Approach 2:
Instead of generating object code from class definitions (traditional ORM approach), the patent inverts the process by inferring object structures directly from query results. This reversal eliminates the complexity of mapping configurations while maintaining automatic object creation.
3Reliability
If join tables are created to store relationships between entities with multiple attributes, then data can be stored in the relational database, but the model duplication and coding complexity increase
Solution Approach 1:
The patent extracts the object structure definition from the physical database schema and join tables. By inferring object models directly from query results, it removes the need for explicit join table definitions and complex relationship mappings, keeping only the essential data storage structure.
Data Source
AI summary
A binary relational database model is described whereby application-layer object structures are easily inferred from database query templates. The object structures take the form of acyclic hypergraphs, which are induced from primal graphs representing query templates. Database applications may iterate through the collection of returned object structures, accessing the data in each structure. The returned object structures are not based on a fixed object model, thereby permitting rich structures with greater applicability than traditional ORM systems. A relationship between non-primitive entities may be directly expressed without the need for alternative join tables. Development and maintenance costs are thus substantially reduced, and data is more efficiently stored and manipulated for database applications.