Method and device for accessing monofile database

A single-file, database technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of easy data damage, easy blocking or error in read and write operations, etc. Effect

Active Publication Date: 2010-05-26
BEIJING HIGH WAY TELECOMMUNICTION TECH CO LTD
View PDF2 Cites 10 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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 acce

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and device for accessing monofile database
  • Method and device for accessing monofile database
  • Method and device for accessing monofile database

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0018] A specific embodiment of the present invention provides a method for accessing a single-file database. The method includes establishing corresponding virtual files for data tables in the single-file database according to business relationships, and establishing a mapping relationship between the data tables and the corresponding virtual files. The mapping relationship is stored in the log file; and according to the mapping relationship of the data table requested to be accessed by the user in the log file, a virtual file corresponding to the data table requested to be accessed by the user is provided to the user for access.

[0019] Further, the corresponding mapping relationship of the data table accessed according to the user request in the log file includes searching for the mapping relationship of the data table requested to be accessed in the log file for each access request.

[0020] In addition, the method further includes that if multiple users request to access ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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 ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30
Inventor 陈曦
Owner BEIJING HIGH WAY TELECOMMUNICTION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap