Database File System Configuration for Parallel Query Processing
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems face limitations in processing speed due to hardware constraints, data storage methods, and restricted co-processing options, often leading to deadlocks when multiple operating systems share resources, which can hinder the execution of operations.
Innovation Solution
A database system architecture that employs a parallelized data input, storage, and query processing system, utilizing multiple computing devices and operating systems to manage data partitioning, storage instructions, and query optimization, allowing for independent operation of nodes and processing core resources to enhance processing efficiency and reduce execution time.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If multiple operating systems share resources of a computing device, then resource utilization is improved, but system reliability deteriorates due to potential deadlocks
Solution Approach 1:
The patent divides the computing device resources into separate segments, each dedicated to a specific operating system. The first operating system is assigned first computing device resources while the second operating system is assigned second computing device resources. This segmentation prevents deadlocks by ensuring that operating systems do not compete for the same resources, thereby maintaining system stability while allowing multiple OS to run concurrently and utilize resources efficiently.
2Device complexity
If database system uses traditional hardware-limited architecture, then device complexity is reduced, but processing speed deteriorates
Solution Approach 1:
The patent transitions from a single-threaded, sequential processing model to a parallel processing model by utilizing multiple computing device resources (multiple cores, multiple operating systems). This dimensional change from one-dimensional sequential execution to multi-dimensional parallel execution dramatically increases processing speed for database operations without requiring a fundamental redesign of the database system architecture.
3Device complexity
If database system uses centralized resource management, then device complexity is minimized, but productivity deteriorates due to sequential processing
Solution Approach 1:
The patent merges multiple computing device resources under a unified database system architecture. Multiple operating systems, each with their own resource allocations, work together to process database queries in parallel. This merging approach maintains architectural simplicity while dramatically improving productivity by enabling concurrent query processing across multiple resource segments.
Data Source
AI summary
A database system includes a plurality of computing devices. Each computing device includes a plurality of processing modules, a computing device operating system, and an application specific operating system. The computing device operating system includes a computing device operating system file system management instruction set. The application specific operating system includes at least one custom file system management instruction set operable to configure operation of a configurable set of processing modules of the plurality of processing modules based on generating a corresponding file system management configuration signal for each processing module of the configurable set of processing modules indicating a selected file system management instruction set of the computing device operating system or the application specific operating system.