Database Cluster Nodes for Real-Time Data Visualization Updates
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Multi-tenant database systems face challenges in providing timely updates to users due to conventional system architectures that rely on worker nodes for indexing and querying, leading to periodic updates rather than real-time or near-real-time data availability.
Innovation Solution
Implementing cluster nodes provided by a cloud computing service to perform database functions, allowing users to select real-time, near-real-time, or periodic updates by updating metadata and timestamp information, and providing updated data based on user-selected synchronization options.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If conventional worker nodes are used for indexing and querying in multi-tenant database systems, then system architecture simplicity is maintained, but data update timeliness deteriorates (periodic updates instead of real-time)
Solution Approach 1:
The patent divides the database system into multiple cluster nodes, each responsible for specific data partitions and index maintenance. This segmentation enables parallel processing of data updates across nodes, transforming the single-worker-node periodic update model into a distributed real-time update system, thereby reducing data update latency while distributing system complexity across modular components
Solution Approach 2:
The patent introduces a new dimensional approach by implementing cluster nodes that operate independently alongside worker nodes, creating a multi-dimensional processing architecture. This adds a parallel dimension to data access and index maintenance operations, enabling real-time updates without interfering with the existing worker node periodic processing model
2Productivity
If real-time or near-real-time updates are implemented, then data accessibility improves, but system resource consumption increases
Solution Approach 1:
The patent implements dynamic update mechanisms where cluster nodes provide real-time or near-real-time updates based on user-selected synchronization options. The system dynamically adjusts update frequency and timing according to user needs and system conditions, enabling high data accessibility while optimizing resource consumption by avoiding unnecessary continuous updates for all users
Solution Approach 2:
The patent applies local quality by allowing different users to select different synchronization options (real-time, near-real-time, or periodic updates) based on their specific needs. This enables the system to provide high-quality real-time updates to users who require them while using lower-resource periodic updates for users who don't need immediate data, thereby optimizing overall system resource consumption
Data Source
AI summary
Systems, methods, and computer-readable media for providing/obtaining database visualization updates in real-time are described. In embodiments, a user system may obtain a user input indicating a selection of a synchronization (sync) option of a set of sync options. Each sync option may indicate a desired timing for obtaining updated data for a visual representation of a dataset by a database system. The user system may send a request to obtain updated data for the visual representation of the dataset in accordance with the selected sync option. In embodiments, the selected sync option may include a real-time sync option, which when selected, the user system may obtain the updated data as the dataset is updated at the database system without sending additional requests for updates. Other embodiments may be described and/or claimed.