Jukebox Optical Disk Database Storage System
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database storage systems using magnetic disks face challenges in managing and accessing large-scale databases due to security concerns, data integrity issues, and high power consumption, making them unsuitable for long-term data preservation and high-security applications.
Innovation Solution
A database storage system based on a jukebox that directly creates and manages databases on optical disks, utilizing a server, jukebox, and magnetic disk storage with a database management system that includes modules for field structure generation, record indexing, and search-term indexing to enable efficient data storage and retrieval on optical disks.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If magnetic disk storage is used for database storage, then high speed response performance is achieved, but data security and integrity are compromised due to real-time writability and magnetic impact susceptibility
Solution Approach 1:
The patent divides the database storage system into two distinct parts: magnetic disk storage for the database management system and frequent access data, and optical disk storage for archival and long-term preservation. This segmentation allows each storage medium to be optimized for its specific function, with magnetic disks providing fast access and optical disks providing secure, write-once preservation.
Solution Approach 2:
The patent introduces an intermediary conversion system that translates database data into a format suitable for optical disk storage. This intermediary layer enables seamless integration between the magnetic disk-based database system and the optical disk archival system, allowing data to be preserved securely without requiring changes to the original database operations.
2Ease of operation
If magnetic disk arrays are used for data storage, then high accessibility is achieved, but power consumption and carbon emissions increase
Solution Approach 1:
The patent implements a periodic data movement strategy where data is initially stored on magnetic disks for frequent access, then archived to optical disks when access frequency decreases. This periodic transition optimizes power consumption by moving data to lower-power storage media when high-speed access is no longer required, while maintaining accessibility during the transition period.
3Reliability
If real-time backup systems are configured for magnetic disk storage, then data security is improved, but equipment investment and power consumption increase
Solution Approach 1:
The patent uses optical disks as write-once copies for archival purposes, eliminating the need for complex real-time backup systems. The optical disks serve as permanent, immutable copies of the data, providing security without requiring additional backup hardware or software complexity.
4Quantity of substance
If incremental backup to magnetic tape is used, then storage cost is reduced, but restoration time increases and database operation is affected
Solution Approach 1:
The patent performs preliminary data conversion and formatting during the archiving process, preparing data in advance for rapid retrieval. By pre-organizing data on optical disks with proper indexing and structure, the system enables fast restoration without requiring time-consuming incremental backup processes.
Data Source
AI summary
A database storage system based on Jukebox comprises a server, a jukebox and a magnetic disk storage. The database management system comprises a field structure generation module, a record index generation module, a storage space allocation module, a storage space status module, a record linkage module, a record split module; further comprises a database creation and input on optical disk module, a search-term storage module, a search-term index generation module. By means of the present invention, a database is directly created on a write-once optical disk or an optical disk of other types, data is input into the database on the optical disk; full-text search for the databases on the optical disks in the jukebox can be performed within seconds, an original file of a database file on an optical disk can be retrieved within seconds, solving effectively the technical problems of managing and accessing large-scale optical disks with databases.