Heterogeneous Type Database Storage System based on Optical Disc, and Method for Using System

A method for improving data processing by performing a creation of a relational database in a magnetic disk storage device of a server in a computer system and a non-relational database directly in an optical disk storage device which comprises one or more optical disks, wherein the creation of the relational database in the magnetic disk storage device and the non-relational database directly in the optical disk storage device are performed in response to a request to the server, wherein the method comprises:

• creating a magnetic disk relational database file in a magnetic disk storage device through the database structure generation module of relational database by the relational database management system,
• configuring fields of the relational database by the filed configuration model,
• writing data of the fields of the corresponding subrecords of the relational database into the relational database by the data input model of relational database according to the command of the relational database management system,
• writing the field structure information of the subrecords into the magnetic disk relational database file by the field structure generation module of relational database,
• writing the index information of the subrecords into the magnetic disk relational database file by the record index generation module of relational database,
• writing the position information of the standard storage units of the subrecords into the magnetic disk relational database file by the storage space allocation module of relational database,
• recording the space information of the standard storage units by the storage space status module of relational database,
• forming database properties data of the magnetic disk relational database by the record linkage module of relational database, and finishing the creation of the relational database and the storage of subrecords in the magnetic disk storage device,
• obtaining capacity parameters of optical disk storage media of an optical disk storage device by the non-relational database management system,
• creating a non-relational database file on the optical disk storage media by the database structure generation module of non-relational database,
• configuring fields of the non-relational database by the filed configuration model,
• increasing subrecords of the non-relational database into the non-relational database file on the optical disk storage media through the data input module of non-relational database, retaining the written field structure information of the corresponding subrecords through the field structure generation module of non-relational database, retaining the index information of the corresponding subrecords through the record index generation module of non-relational database, retaining the position information of the standard storage units of the corresponding subrecords through the storage space allocation module of non-relational database, retaining the recorded space information of the standard storage units through the storage space status module of non-relational database, and retaining the generated database properties data of the corresponding non-relational database through the record linkage module of non-relational database by the non-relational 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 of the non-relational database,
• when the capacity of the non-relational database reaches the capacity value of the storage space of the optical disk, writing the retained database properties data of the non-relational database into the non-relational database on the optical disk by the non-relational database management system, and completing the creation of the non-relational database and the storage of the subrecords on the optical disk,
• connecting a subrecord of the relation database and a corresponding subrecord of the non-relational database to form an integral record through the database connection model according to the command of the relational database management system and the non-relational database management system.

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

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