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

Method and system for improving processing performance of memory database

A processing performance and database technology, applied in the direction of electrical digital data processing, special data processing applications, digital data information retrieval, etc., to achieve the effect of improving performance

Active Publication Date: 2013-08-07
南京泛盈信息科技有限公司
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For an indexed table, the data structure for indexing is generally a B-tree, and the complexity of the algorithm is O(logN). Also just O(logN)

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 system for improving processing performance of memory database
  • Method and system for improving processing performance of memory database
  • Method and system for improving processing performance of memory database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] The present invention will be further described in detail below through specific embodiments in conjunction with the accompanying drawings.

[0026] Considering the business characteristics of message products in the telecommunications business field, and the records in each data table in the memory database have definite addresses in the memory, the method embodiments of the present invention make command extensions for the standard SQL interface provided by the memory database For processing, keep the original command interface unchanged, expand insert, select, update, and delete without affecting the original operation interface, and add four new commands insertEx, selectEx, updateEx, and deleteEx. Because updateEx and deleteEx depend on the complexity of selectEx; therefore, the problem is simplified to the algorithm optimization of insertEx and selectEx.

[0027] Since ordinary insert only returns whether the operation is successful or failed, the return value of i...

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

A processing method for a memory database and the memory database are disclosed, the method involves: an insertion type operation command is extended, and the extension requires to feed back address information after the extended insertion type operation command is performed, and the address information includes a storage address where a business record is stored in the memory database; a client of the memory database sends the extended insertion type operation command to a server of the memory database; the server of the memory database receives and performs the extended insertion type operation command, and feeds back the storage address where the business record is stored in the memory database to the client of the memory database; the client of the memory database storages the storage address where the business record is stored in the memory database. With the invention, the SQL operation algorithm of the memory database is changed from normal algorithm complexity O (log N) to algorithm complexity O (1), and the performance of the memory database is greatly improved.

Description

technical field [0001] The invention relates to the field of telecommunication value-added services, in particular to a method and system for processing performance of an internal memory database. Background technique [0002] In the field of telecom value-added services, due to the high performance requirements of the business itself, memory databases are widely used. Generally, an in-memory database is used to store the intermediate state data of the business. For example, for messaging services, after the source user successfully initiates a service request, it is generally necessary to generate an O bill in the message center, and at the same time insert the service status data into the memory database as a record for storage, so that it can be used in subsequent processes. The message center then forwards the message to the intended user. If the message is forwarded successfully, the service state data in the memory database is updated, and a correct T bill is generat...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F17/30457G06F16/24539
Inventor 张恒生
Owner 南京泛盈信息科技有限公司