Method for storing and accessing file set under tree directory structure in database

Abstract

The invention relates to a method for storing and accessing file sets under a tree directory structure in a database, which can effectively solve the problems of overall storage and random access when file sets are stored in and extracted from a database system. The technical scheme is as follows: the overall storage extracts the directory structure, file data and attributes of the file sets from a file system to a local memory; organization structure object is serialized; data blocks are stored in the database; the random access recovers the directory structure of the file sets; corresponding files in the database are accessed according to user selection to read out the directory structure data blocks stored in the database; the directory structure data blocks are recovered to data structure objects by reverse serialization; and the information of the directory structure objects are shown to users in the forms of visible file node data structure, directory node data structure and file set directory structure objects. The invention solves the difficult technical problem that files are not supported to be directly stored and randomly accessed in the database in the prior art, thereby having enormous economic and social benefits.

Description

1. Technical field [0001] The invention relates to computer application technology, in particular to a method for storing and accessing a file set under a tree directory structure in a database. 2. Background technology [0002] With the development of computer science and multimedia technology, in the development of practical products with database systems such as computer networks, mobile computers, mobile phones, and satellite navigators, databases must not only deal with simple structured data, but also often deal with a large number of complex ones. Unstructured data, such as graphics, sound files, or large text files, etc. These complex unstructured data are often accessed in the database in units of files. In addition to the database access of a single file, in an application, a collection of multiple files organized according to a certain directory structure in the file system (called a file set) needs to be stored in the database as a whole. [0003] For the access...

AI Technical Summary

Problems solved by technology

[0016] In view of the above situation, in order to overcome the defects of the prior art, the object of the present invention is to provide a method for storing and accessing files in a database under a tree-shaped directory structure, which can effectively solve the problem of accessing files in an existing database system. The problem of supporting the overall storage and random access of the file set, the technical solution is to include the two aspects of the data inventory (storage) and retrieval (access) of the file set. Storage and retrieval are interrelated. The storage of the file set (Storage) refers to saving the file set as a whole in the database; the so-called access, that is, random access, means that when the user accesses a file in the file set stored in the database, it is not necessary to read the entire file set, but You only need to read the data corresponding to the file. The file set contains three types of information: the directory structure of the file set, the file data of the file set, and the file attributes of the file set. The directory structure of the file set refers to all the files in the file set. The relationship between files and directories is a tree structure when only one root directory is considered. The file data of the file set refers to the data of all files in the file set, and the data of each file is fundamentally It is a set of byte sequences, which constitute the content of the file. The file attribute of the file set refers to the information describing the file such as the name, type, size, and creation date of all files in the file set; therefore, when the file set is stored in During the database process, in order to ensure the integrity of the file set information, three types of information, the directory structure, file data, and file attributes of the file set, must be saved to the database at the same time, and the file set is stored in the database. From the perspective of informatics, It is the process of transferring the relevant information of the file set from the file system of the user host to the database of the server through the network

Images