Object Cache Architecture for Database Record Access
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Relational databases face inefficiencies in accessing certain subsets of data due to their structured nature, which can hinder performance and scalability.
Innovation Solution
A computing platform instantiates objects corresponding to database records and fields, allowing for efficient data retrieval and storage by populating objects with values and timestamps, and utilizing these objects to handle requests for data access and modification.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If relational databases are used to maintain data integrity and support expansion, then data integrity and scalability are improved, but data access efficiency deteriorates
Solution Approach 1:
The patent segments data access operations by creating a cache layer that separates frequently accessed data from the main relational database. The cache stores data in a format optimized for rapid retrieval, while the relational database maintains data integrity. This segmentation allows the system to serve read requests from the cache without querying the relational database, thus improving data access efficiency while preserving data integrity in the relational database structure.
2Adaptability or versatility
If relational databases are structured to support expansion, then adaptability is improved, but data access performance deteriorates
Solution Approach 1:
The patent introduces a cache as an intermediary layer between the application and the relational database. This cache mediator handles data access requests, providing rapid retrieval for frequently accessed data while allowing the relational database to maintain its expanded, flexible structure for supporting new data types and growth. The cache acts as a buffer that improves performance without constraining the database's ability to expand and adapt.
Data Source
AI summary
A computing platform may receive data identifying one or more sets of fields of a database. The computing platform may, for each record of a plurality of records of the database, instantiate one or more objects corresponding to the one or more sets and comprising values stored in the fields for the record, and may store, amongst a plurality of objects associated with the database, the one or more objects. In addition, the computing platform may instantiate: an object for the record; for each set of the one or more sets, an object for the set; and for each field of the set, an object for the field.