Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Memory database system for realizing distributed storage and application thereof

A distributed storage and database technology, applied in special data processing applications, electrical digital data processing, instruments, etc., can solve the problems of memory database performance waste and lack of versatility, and achieve low cost and simple implementation.

Active Publication Date: 2009-11-25
ZTE CORP
View PDF0 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Due to the need to parse the sql statement of its own database intact, the performance of the memory database is wasteful;
[0005] Only supports the database products produced by itself, no versatility

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 system for realizing distributed storage and application thereof
  • Memory database system for realizing distributed storage and application thereof
  • Memory database system for realizing distributed storage and application thereof

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] Preferred embodiments of the present invention will be specifically described below in conjunction with the accompanying drawings, wherein the accompanying drawings constitute a part of the application and are used together with the embodiments of the present invention to explain the principles of the present invention.

[0035] Firstly, the in-memory database system according to the embodiment of the present invention will be described in detail with reference to the accompanying drawings.

[0036] Such as figure 1 as shown, figure 1 It is a schematic structural diagram of the memory database system described in the embodiment of the present invention, which may specifically include: an interface machine, a console, and multiple memory databases, and each part will be described in detail below.

[0037] The interface machine is mainly responsible for the distribution of sql messages, the realization of stored procedures, and the management of the entire memory databas...

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 discloses a memory database system for realizing distributed storage and an application thereof. The system comprises an interface message processor and a plurality of memory databases, wherein the interface message processor is used for storing each database table in real databases and a corresponding relation of the memory databases and distributing an sq1 request to corresponding memory databases according to a database table in the sq1 request after receiving the sq1 request of an access client; the memory databases are used for inquiring the information of the database tables responded by the memory databases from the interface message processor and then reading data in the database tables from the corresponding real databases; and when the sq1 request distributed by the interface message processor is received, the memory databases execute an corresponding inquiring or non inquiring operation according to the sq1 request distributed by the interface message processor. The invention realizes the distributed storage of the memory databases by introducing the interface message processor and has simpler realization and lower cost.

Description

technical field [0001] The invention relates to the field of computer communication, in particular to the technical field of memory database. Background technique [0002] Now in the field of communication information, the database is more and more important. However, with the increase of business volume, the performance of the database cannot meet the requirements, which is becoming more and more a headache. Several mainstream databases: Oracle, DB2, Sqlserver, Sybase, etc., will encounter the problem that the performance cannot meet the requirements. Because their database access can only be done in milliseconds. Optimizing the database contributes at most only 30% to the improvement of the database access rate. Many times, you are forced to modify business processes to reduce the number of times you access the database. [0003] In order to improve performance, everyone agrees that using an in-memory database is a good way. Because the access to the memory database c...

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 ZTE CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products