Ephemeral Graph Database via BLOB Storage
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing relational database management systems (RDBMSs) face challenges when performing graph analytics, as they require replicating data in persistent storage, leading to increased storage needs and costs, as well as higher frequencies of data quality errors.
Innovation Solution
The implementation of an ephemeral graph database that is stored for a limited duration in binary large object (BLOB) storage instead of in the RDBMS, allowing for reduced overhead and enabling the generation of an ephemeral graph database specifically for graph analytics, which is deleted after the analysis is complete.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is replicated in persistent storage for graph analytics, then graph analytics can be performed, but storage requirements and costs increase
Solution Approach 1:
The patent creates ephemeral graph database instances that are temporary and disposable, stored in volatile memory rather than persistent storage. These ephemeral instances are created on-demand for graph analytics operations and automatically deleted afterward, eliminating the need for long-term data replication in persistent storage while maintaining graph analytics capability.
2Reliability
If data is replicated in persistent storage for graph analytics, then graph analytics can be performed, but data quality errors increase
Solution Approach 1:
The patent creates temporary copies of graph data in volatile memory for analytics operations. These copies are ephemeral and discarded after use, preventing the accumulation and propagation of data quality errors that occur with persistent replication. The original relational database remains the single source of truth, maintaining data quality while enabling graph analytics through temporary copying.
Data Source
AI summary
A server computing device including one or more server memory devices storing a relational database. The server computing device further includes one or more server processing devices configured to receive an ephemeral graph database request. The ephemeral graph database request indicates a selection of data stored in the relational database. The processing devices generate an ephemeral graph database that encodes the selected data in a graph structure and store the ephemeral graph database in binary large object (BLOB) storage at the one or more memory devices. The processing devices receive instructions to apply a graph analytics algorithm at the ephemeral graph database. The processing devices read the ephemeral graph database from the BLOB storage and apply the graph analytics algorithm to the ephemeral graph database to generate a graph analytics result. The processing devices output the graph analytics result and delete the ephemeral graph database from the BLOB storage.