Object Platform for Relational Database Operations
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional relational databases do not support object-based operations, limiting the ability to perform complex operations such as searching, loading, and modifying data in an object-oriented manner.
Innovation Solution
A system that defines objects based on datasets stored in relational databases, allowing objects to be associated with information, stored in a cache, and modified through APIs, with changes propagated to the underlying datasets, and conflict resolution using commit logs and configurable rules.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If data is stored in relational databases using conventional approaches, then data can be stored and retrieved, but object-based operations such as searching, loading, and modifying cannot be performed
Solution Approach 1:
The patent introduces an intermediary layer between the relational database and the object-oriented application. This intermediary translates object-based operations into database queries and updates, enabling object-oriented operations on relational data without requiring changes to the database schema or requiring complex direct database manipulation in the application layer.
Solution Approach 2:
The system segments the data access layer into distinct components: an object store for object-based operations, a cache for performance optimization, and a relational database for persistent storage. This segmentation allows each component to be optimized independently while working together to provide full object-based operation capability.
2Productivity
If entire datasets are loaded to perform operations, then all data is available for processing, but system performance degrades and time consumption increases
Solution Approach 1:
The patent extracts only the necessary object data from the larger relational database into a cache store. Instead of loading entire datasets, the system extracts and caches only the specific objects needed for operations, significantly reducing data transfer time and improving operation speed while maintaining access to the full database when needed.
3Ease of operation
If multiple users modify objects simultaneously, then system responsiveness is maintained, but data conflicts arise and integrity is compromised
Solution Approach 1:
The system implements feedback mechanisms through commit logs that track all modifications to objects. When conflicts are detected during concurrent operations, the system uses the commit log information to resolve conflicts and maintain data integrity, providing feedback about the state of data modifications to ensure consistent results.
Solution Approach 2:
The patent implements beforehand cushioning by using commit logs to record modification states before conflicts occur. This allows the system to prepare conflict resolution strategies in advance and ensures that concurrent modifications are coordinated to maintain data integrity without requiring complex real-time locking mechanisms.
Data Source
AI summary
Systems and methods are provided for providing an object platform for datasets A definition of an object may be obtained. The object may be associated with information stored in one or more datasets. The information may be determined based at least in part on the definition of the object. The object may be stored in a cache such that the information associated with the object is also stored in the cache. One or more interfaces through which requests to perform one or more operations on the object are able to be submitted may be provided.