Method and device for accessing monofile database

Abstract

The invention relates to a method and a device for accessing a monofile database, belongs to the technical field of data storage, and aims to solve the problems that in the conventional monofile database storage technology, when a plurality of users simultaneously access the database or the memory content of the database is larger, a read-write operation is easy to be blocked or mistaken and the stored data is easy to be damaged. The method comprises the following steps: according to service relations, respectively establishing corresponding virtual files for data tables in the monofile database, establishing mapping relations for the data tables and the corresponding virtual files, and storing the mapping relations in a log file; and according to the mapping relation of the data table that the user requests to access in the log file, providing the virtual file corresponding to the data table that the user requests to access for the user to access. Through the method and the device, when the plurality of users simultaneously access the database or the memory content of the database is larger, the read-write operation is not easy to be blocked or mistaken and the stored data is also not easy to be damaged.

Description

technical field [0001] The invention relates to a method and device for accessing a single-file database, belonging to the technical field of data storage. Background technique [0002] A single-file database is a lightweight, cross-platform relational database. The so-called single file means that all the information in the database (such as tables, views, triggers, etc.) Features. [0003] A database is a shared resource that can be shared by multiple applications. These programs can run serially, but in many cases, due to the potentially large amount of data involved in the application, the exchange of input and output is often involved. In order to effectively utilize database resources, multiple programs or multiple processes of a program may run at the same time. In a single-file database environment, because only a single file is used to store data, multiple users access the database at the same time, or when the amount of data in the database is large, incorrect ...

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a method and device for accessing a single-file database to solve the problem that in the existing single-database storage technology, when multiple users access the database at the same time or the storage capacity of the database is large, the read and write operations are easy to block or make mistakes, The problem that stored data is easily corrupted

Images