Multidimensional Cube Viewer Data Separation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current OLAP systems face performance issues due to frequent queries and complete re-rendering of cube data, leading to increased burden on multidimensional database servers and poor user experience, especially in network environments.
Innovation Solution
A novel multidimensional data storage (MDDS) cube viewer that separates cube data and presentation data, using intelligent caching and querying to efficiently retrieve and update only necessary data, reducing redundant queries and re-rendering by storing presentation data in a cube configuration structure and cube data in a separate storage structure.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If complete re-rendering of cube data is performed each time a query is made, then data accuracy is maintained, but system performance deteriorates and server burden increases
Solution Approach 1:
The patent segments the cube rendering process into two parts: (1) initial complete rendering to establish accurate baseline data, and (2) subsequent incremental updates that only re-render affected portions based on query changes. This segmentation allows the system to maintain data accuracy while avoiding the performance penalty of complete re-rendering on every query.
Solution Approach 2:
The patent performs preliminary rendering of the complete cube data structure before user queries are executed. This preliminary action creates a cached representation that can be quickly updated later, eliminating the need to perform time-consuming complete re-rendering operations for every subsequent query while maintaining data accuracy.
2Loss of information
If frequent queries are performed to retrieve cube data, then data freshness is improved, but network burden increases and user experience deteriorates
Solution Approach 1:
The patent performs preliminary retrieval and caching of cube data structures, metadata, and configuration information before users execute queries. This preliminary action stores data locally in the cube viewer, enabling fast local rendering and eliminating repeated network round trips for every query operation, thus maintaining data freshness while reducing network burden and improving user experience.
Solution Approach 2:
The patent creates local copies of cube data structures, metadata, and presentation information in the cube viewer's memory or storage. These copies enable the system to serve queries from local resources rather than repeatedly accessing the remote multidimensional database server, reducing network traffic and response time while maintaining data accessibility.
3Device complexity
If cube data and presentation data are stored together, then data structure simplicity is maintained, but rendering efficiency deteriorates
Solution Approach 1:
The patent segments the stored data into distinct components: cube data structures (metadata, dimensions, measures), presentation data (configuration, formatting, layout), and cached query results. This segmentation allows the system to independently manage and update each component, improving rendering efficiency by only re-processing relevant portions while maintaining organized data structure through clear separation of concerns.
Solution Approach 2:
The patent extracts presentation data (such as formatting rules, layout configurations, and visual styling) from the core cube data structure and stores it separately. This extraction enables the system to modify presentation aspects without re-processing the underlying cube data, significantly improving rendering efficiency while maintaining data organization through structured separation of data and presentation layers.
Data Source
AI summary
Some embodiments provide a cube viewer that renders a view for a cube stored in a multidimensional data storage (MDDS). The cube viewer separately stores cube data and the presentation data that relates to the presentation of the cube. The cube viewer uses the separated cube and presentation data to generate the view of the cube.