Dual-Core Database Storage for Optical Disk Data Management
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems face challenges in storing all format data and large capacity files efficiently, particularly with unstructured data, leading to performance degradation and difficulties in managing and accessing data stored on optical disks.
Innovation Solution
A database dual-core storage system based on optical disks, comprising a server, magnetic disk storage, optical disk storage, a database management system, data processor, and data connector, which divides record fields into a database base core for structured data and a database extension core for large capacity files, enabling unified management and storage on both magnetic and optical disks.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If all unstructured data is stored directly in the database on optical disk, then data integrity is guaranteed, but database performance degrades and response time increases
Solution Approach 1:
The patent divides the database into two separate cores: a base core for structured data and an extension core for unstructured data. This segmentation allows structured data operations to remain fast and efficient in the base core, while unstructured data is stored in the extension core with appropriate management mechanisms, thus maintaining overall data integrity without degrading database performance.
Solution Approach 2:
The patent introduces a data manager as an intermediary component that handles data storage, retrieval, and management operations between the user and the dual-core database system. This intermediary optimizes data access paths, ensuring that queries involving structured data efficiently access only the base core, while unstructured data operations are directed to the extension core, thereby maintaining performance while guaranteeing integrity.
2Quantity of substance
If unstructured data is stored outside the database on optical disk, then storage capacity is improved, but data management and access efficiency deteriorates
Solution Approach 1:
The patent merges the advantages of external storage with database management by integrating the extension core into the database system architecture. The extension core provides enhanced storage capacity for unstructured data while maintaining unified management through the data manager, which handles data organization, indexing, and retrieval operations, thus achieving both high storage capacity and efficient data management.
Solution Approach 2:
The patent adds a new dimension to data storage by creating a two-core architecture (base core and extension core) rather than using a single flat storage structure. This dimensional change allows the system to handle different types of data with appropriate storage strategies, improving both storage capacity and management efficiency through specialized handling of structured and unstructured data.
3Quantity of substance
If database size expands to accommodate large capacity files, then data completeness is improved, but access speed and response time worsen
Solution Approach 1:
The patent applies local quality by creating different storage environments for different types of data within the same database system. The base core provides fast access for structured data, while the extension core provides high-capacity storage for unstructured data. This localized optimization ensures that access speed is maintained for time-critical structured data operations while accommodating large capacity files in the extension core, thus achieving data completeness without sacrificing access speed.
Data Source
AI summary
A database dual-core storage system based on optical disk comprises a server, a magnetic disk storage device and an optical disk storage device connecting to the server via data connection, a database management system, a data processor and a data connector installed on the server, wherein the database management system is arranged for completing database management and data management of the magnetic disk storage device and the optical disk storage device in response to data requests; the data processor is arranged for configuring fields of a database base core and fields of a database extension core, writing data of corresponding fields into the database base core and the database extension core respectively in response to data requests; the data connector is arranged for creating data connection between the database base core and the database extension core in response to data requests. The integrity and safety of data are guaranteed.