Database dual-core storage system based on optical disk and method using the system

A method for improving data processing by performing direct creation of a database in an optical disk storage device which comprises one or more optical disks and storage of data into a database dual-core, wherein the direct creation of the database in the optical disk storage device and the storage of data into the database dual-core are performed in response to a request to the server, wherein the method comprises:

• obtaining capacity parameters of optical disk storage media by the database management system;
• creating a database file on the optical disk storage media by the database structure generation module;
• creating a database base core and a database extension core in a database on the optical disk storage media by the dual-core generation model;
• configuring fields of the database base core and fields of the database extension core by the filed configuration model;
• adding subrecords of the base core and subrecords of the extension core into the database file on the optical disk storage media through the data input module, retaining written field structure information of the corresponding subrecords of the base core and the corresponding subrecords of the extension core through the field structure generation module, retaining index information of the corresponding subrecords of the base core and the corresponding subrecords of the extension core through the record index generation module, retaining position information of standard storage units of the corresponding subrecords of the base core and the corresponding subrecords of the extension core through the storage space allocation module, retaining space information of the standard storage units of the subrecords of the base core and the subrecords of the extension core through the storage space status module, and retaining corresponding database properties data generated through the record linkage module by the database management system;
• determining whether to reach the capacity value of the storage space of the optical disk, if no, repeating the above operation, updating the retained database properties data;
• when the capacity of the database reaches the capacity value of the storage space of the optical disk, writing the retained database properties data into the database on the optical disk by the database management system, and completing the creation of the database on the optical disk and the storage of the subrecords of the base core and the subrecords of the extension core;
• connecting the subrecords of the base core and the corresponding subrecords of the extension core to form integral records through the dual-core connection model according to the command of the database management system.

A method for improving data processing by performing transfer of a database created in a magnetic disk storage device of a server in a computer system and data stored in a database dual-core into an optical disk storage device which comprises one or more optical disks, wherein the transfer of the database created in the magnetic disk storage device and the data stored in the database dual-core into the optical disk storage device are performed in response to a request to the server, wherein the method comprises:

• obtaining capacity parameters of optical disk storage media by the database management system;
• splitting a database in a magnetic disk according to the capacity of the optical disk storage media through the record split module by the database management system, and forming marked information of subdatabases;
• creating a database file on a corresponding optical disk by the database structure generation module;
• creating a database base core and a database extension core in the database on the optical disk by the dual-core generation model;
• configuring fields of the database base core and fields of the database extension core on the optical disk according to the fields of the database base core and the fields of the database extension core in the magnetic disk by the filed configuration model;
• writing data of the fields of the corresponding subrecords of the base core and the corresponding subrecords of the extension core into the database base core and the database extension core on the corresponding optical disk by the data input module;
• writing field structure information of the corresponding subrecords of the base core and the corresponding subrecords of the extension core into the database file on each optical disk through the field structure generation module;
• writing index information of the corresponding subrecords of the base core and the corresponding subrecords of the extension core into the database file on each optical disk through the record index generation module;
• writing position information of standard storage units of the corresponding subrecords of the base core and the corresponding subrecords of the extension core into the database file on each optical disk through the storage space allocation module;
• recording space information of the standard storage units through the storage space status module;
• forming corresponding database properties data of the database on each optical disk through the record linkage module, and completing the creation of the database on each optical disk and the storage of the subrecords of the base core and the subrecords of the extension core;
• connecting the subrecords of the base core and the corresponding subrecords of the extension core to form integral records through the dual-core connection model according to the command of the database management system.