Client-Side Grid Calculation for Multidimensional Database Latency
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In multidimensional database environments, users experience performance lag due to round-trip communication between client-side applications and remote server-based databases, especially when frequent changes are made, discouraging the use of server-based structures for complex analyses.
Innovation Solution
Transforming server-side data into a grid for client-side applications, where client-side dynamic parameters are represented as dynamic formulas and server-side parameters outside the grid are represented as constant values, enabling rapid calculations without round-trip performance lag.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data is stored on remote server-based databases, then data centralization and security are improved, but performance lag occurs due to round-trip communication
Solution Approach 1:
The patent segments the database system into server-side components (data storage and management) and client-side components (calculation and analysis). The server provides data through a standardized interface while client applications perform calculations locally, eliminating the need for round-trip communications for each calculation operation and reducing performance lag while maintaining data security.
Solution Approach 2:
The patent introduces an intermediary interface layer that standardizes data access between the server and various client applications. This interface allows client applications to retrieve data efficiently and perform calculations locally without requiring continuous server communication, thus reducing performance lag while maintaining centralized data management.
2Reliability
If calculations are performed on server-side databases, then data integrity is maintained, but calculation speed decreases due to network communication overhead
Solution Approach 1:
The patent divides the computational workload between server and client. The server maintains data integrity by managing the central database, while client applications perform calculations locally using retrieved data. This segmentation allows fast local calculations without network overhead while the server ensures data integrity through centralized management.
Solution Approach 2:
The patent implements preliminary data retrieval and local caching mechanisms. Client applications retrieve necessary data from the server in advance and store it locally, enabling subsequent calculations to be performed without repeated network communications. This preliminary action maintains data integrity while significantly improving calculation speed.
3Productivity
If client-side applications access remote data frequently, then real-time analysis capability is improved, but network bandwidth consumption increases
Solution Approach 1:
The patent enables client applications to retrieve data in advance and perform calculations locally. By preparing data and performing analyses on the client side before needing results, the system reduces the frequency and volume of network communications, thereby maintaining real-time analysis capability while reducing network bandwidth consumption.
Solution Approach 2:
The patent empowers client applications to perform calculations and analyses independently using locally retrieved data. This self-service capability allows clients to conduct real-time analyses without continuous server interaction, reducing network bandwidth consumption while maintaining analytical responsiveness.
Data Source
AI summary
In accordance with an embodiment, described herein are systems and methods that enable client-side calculation with data provided at a multidimensional or other database server. Data provided at the server in accordance with a server-side model, can be transformed/prepared into a grid, for use with a client-side application, for example a client spreadsheet application. During preparation of the grid, one or more portions of the grid that are identified as client-side dynamic parameters, can be represented as dynamic formulas that are modifiable within the client-side application; while parameters of the server-side model that are outside of the grid can be represented as constant values. The grid provided to the client can be used to perform client-side calculations that allow for rapid calculations in response to changes in the client-side model, without introducing a round-trip performance lag between the client-side and server-side.