Unlock instant, AI-driven research and patent intelligence for your innovation.

Memory database access method, device and system, server and storage medium

An access method and database technology, applied in database management systems, memory architecture access/allocation, database indexing, etc., can solve problems such as insufficient database efficiency and database system instability, saving access time, improving access efficiency, and avoiding time wasteful effect

Pending Publication Date: 2022-04-15
SHENZHEN ZOLON TECH CO LTD
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present application provides a method and device for accessing an in-memory database, which can solve the problems of insufficient efficiency of accessing the database in the shared memory and instability of the database system

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
  • Memory database access method, device and system, server and storage medium
  • Memory database access method, device and system, server and storage medium
  • Memory database access method, device and system, server and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0070] First, as figure 1 As shown, an embodiment of the present application provides an access method for a shared memory database, which is applied to a server and includes the following steps:

[0071] S100, calling a preset API interface to obtain an access request sent by an external program;

[0072] In this embodiment, the API (Application Programming Interface) interface is an interface installed on the server and provided to an external program application. The API interface can be a C / C++ language API interface, or a standard Structured Query Language (SQL) interface. .

[0073] Specifically, when an external program starts, it needs to access the data in the shared memory database located on the server side, and an access request is sent, and the API interface of the server side receives the access request. In this embodiment, there is no restriction on the access request, and various manners and forms of access requests are applicable.

[0074] S200, based on th...

Embodiment 2

[0148] Corresponding to the access method of the shared memory database described in the above embodiment, Figure 4 A structural block diagram of an apparatus for accessing a shared memory database provided by an embodiment of the present application is shown. For convenience of description, only the part related to the embodiment of the present application is shown.

[0149] Second, as Figure 4 As shown, this embodiment provides a device for accessing a shared memory database, including:

[0150] The acquisition module is used to call the preset API interface to acquire the access request sent by the external program;

[0151] The sending module is used to send the identification file in the database to the external program based on the access request, so that the external program waits to access the shared memory according to the identification value in the identification file;

[0152] The open channel module is used to open the channel for the external program to acces...

Embodiment 3

[0162] Thirdly, such as Figure 5 As shown, this embodiment provides a shared memory database system for access by multiple external programs, including:

[0163] The interface channel module is used to obtain the access request of each external program, and provides the access channel of the shared memory to each external program by means of the identification file;

[0164] The data definition module is used to perform the operations of initial configuration, table creation, table deletion and index creation according to the operation commands output by the interface channel module;

[0165] The data table structure module is used to manage the data table structure information according to the commands output by the data definition module;

[0166] The data operation module performs data read and write operations according to the operation commands output by the interface channel module;

[0167] The index module organizes data according to the operation command output by ...

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 is suitable for the technical field of computers, and provides a memory database access method, device and system, terminal equipment and a storage medium, the method is applied to a server side, and the method comprises the steps that a preset API interface is called to obtain an access request sent by an external program; based on the access request, sending an identification file in a database to the client, so that the client waits for accessing the shared memory according to an identification value in the identification file; based on the identification value in the identification file, opening a channel for the external program to access the shared memory; mapping the shared memory into a virtual address space of an external program, and loading the database into the external program; and controlling the database and the external program to perform data interaction in the shared memory. According to the method and the device, time waste caused by the fact that Socket communication must be carried out when the database is accessed each time is avoided, a memory database service process does not need to be shared online, the access efficiency of the database is integrally improved, and the stability of a database system is also improved.

Description

technical field [0001] The present application belongs to the field of computer technology, and in particular relates to an in-memory database access method, device, shared memory database system, server and storage medium. Background technique [0002] At present, the access to the in-memory database generally adopts the socket communication method, that is, when the application needs to access the in-memory database, it sends the request information to the in-memory database service process through the socket communication port. After the in-memory database service process receives the socket request instruction, the in-memory database service process queries or modifies In-memory data, and then send the processing result to the application program through Socket, the application program receives the processing result and completes an access to the in-memory database. [0003] This Socket communication method seriously restricts the memory access efficiency when deployed w...

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): G06F16/25G06F16/22G06F16/23G06F9/54G06F12/1081
CPCG06F16/252G06F16/2272G06F16/2246G06F16/2282G06F16/2343G06F9/544G06F12/1081G06F2212/1024G06F2212/1016G06F2212/163
Inventor 王剑
Owner SHENZHEN ZOLON TECH CO LTD