Distributed Workbook Storage for Multi-Dimensional Database Systems
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing retail database systems face performance issues due to contentions and disk space problems when multiple users access the same disk, leading to slowed performance and potential out-of-space issues, especially with large workbook data constituting a significant portion of the domain size.
Innovation Solution
Implementing a distributed workbook storage system that uses a round-robin algorithm to balance the load and usage across multiple file system mount points, providing additional storage locations outside the domain's root directory, and allowing for flexible storage configuration to manage workbook distribution and storage efficiently.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If workbooks are stored in a single domain directory, then data access is simplified, but disk space runs out and performance degrades due to contentions
Solution Approach 1:
The patent segments the workbook storage by creating multiple domain directories organized in a tree structure, where each domain has its own directory and workbooks are distributed across subdirectories based on domain hierarchy. This segmentation increases available disk space by utilizing multiple storage locations while maintaining organized access patterns.
2Device complexity
If workbooks are stored in a single domain directory, then storage management is simplified, but performance degrades due to disk contentions from multiple user operations
Solution Approach 1:
The patent segments workbook storage across multiple domain directories in a tree structure, distributing user workbooks to different directories based on their domain hierarchy. This spatial distribution reduces disk contentions from concurrent user operations while the systematic organization method keeps management complexity reasonable.
Solution Approach 2:
The patent introduces a hierarchical directory dimension based on domain tree structure, organizing workbooks not just in a single flat directory but across multiple levels of domain directories. This dimensional organization allows systematic distribution of workbooks to reduce contentions while maintaining manageable access patterns through the hierarchy.
3Reliability
If workbook data constitutes a large percentage of domain size, then data locality is improved, but disk space runs out and out-of-space issues occur
Solution Approach 1:
The patent segments the storage space by creating multiple domain directories under a parent directory, distributing workbooks across these segmented locations based on domain hierarchy. This approach maintains data locality within domain contexts while preventing any single directory from consuming excessive disk space, thereby avoiding out-of-space issues.
Solution Approach 2:
The patent adds a hierarchical directory dimension to the storage structure, organizing workbooks across multiple levels of domain directories rather than concentrating them in a single location. This dimensional expansion provides additional storage capacity while maintaining organized access patterns that preserve data locality.
Data Source
AI summary
Systems, methods, and other embodiments are disclosed that are configured to provide distributed workbook storage for a multi-dimensional database system. In one embodiment, a workbook is created where the workbook is a personal data repository which is a subset of a domain of persistent multi-dimensional data cache of the multi-dimensional database system. A distributed storage location is selected for the workbook from multiple distributed storage locations of the data cache. A round robin selection process is used that promotes balanced loading and usage of multiple workbooks stored across the multiple distributed storage locations. A workbook directory structure is created for the workbook within the selected distributed storage location. The workbook directory structure reflects a same directory structure provided by a common global domain of the multi-dimensional database system up to a root directory of the selected distributed storage location.