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

Data storage method and system and data inquiry method

A data storage system and data query technology, applied in the field of network communication, can solve problems such as high data consistency requirements and large database query volume

Active Publication Date: 2016-07-20
CHINA MOBILE GROUP SHANDONG
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Embodiments of the present invention provide a data storage system, method, and query method to solve the problems of large database queries and high data consistency requirements in the prior art

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
  • Data storage method and system and data inquiry method
  • Data storage method and system and data inquiry method
  • Data storage method and system and data inquiry method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0041] figure 1 , is a schematic structural diagram of the data storage system provided by Embodiment 1 of the present invention. Such as figure 1 As shown, the data storage system may include:

[0042] Master physical database 11 , first memory database 12 , slave physical database 13 , and second memory database 14 . The first in-memory database 12, the slave physical database 13 and the second in-memory database 14 are only used for queries.

[0043] Wherein, the main physical database 11 is used to store the first type of data, the second type of data and the third type of data.

[0044] The slave physical database 13 is used to asynchronously replicate the data stored in the master physical database 11 .

[0045] The first in-memory database 12 is used to store the first type of data in the main physical database 11 by the main physical database 11; the second in-memory database 14 stores the second type of data in the main physical database 11 from the physical datab...

Embodiment 2

[0060] Based on the same technical concept, Embodiment 2 of the present invention also provides a data storage method, which can be applied to the data storage system provided in Embodiment 1 above.

[0061] figure 2 , is a flow chart of the data storage method provided in Embodiment 2 of the present invention. As shown, the data storage method may include:

[0062] S201. Receive a data writing request.

[0063] S202. Write the received data into the primary physical database, and trigger asynchronous writing from the physical database.

[0064] S203. Determine whether the received data belongs to the first type of data. If the received data belongs to the first type of data, go to step S204; otherwise, go to step S205.

[0065] S204. Synchronously write the received data into the first memory database.

[0066] S205. Determine whether the received data belongs to the second type of data. If the received data belongs to the second type of data, go to step S206, otherwis...

Embodiment 3

[0074] Based on the data storage system provided in the first embodiment above, the third embodiment of the present invention also provides a data query method.

[0075] image 3 , is a flow chart of the data query method provided in Embodiment 3 of the present invention. like image 3 As shown, the method may include:

[0076] S301. Receive a data query request.

[0077] S302. Determine the type of query data according to the data query request. If the query data is the first type of data, go to step S303; if the query data is the second type of data, go to step S304; if the query data is the third type of data, then go to step S305 .

[0078] S303. Query the first memory database.

[0079] S304. Query the second memory database.

[0080] S305. Query the secondary physical database.

[0081] After receiving the data query request, the proxy layer can perform business encapsulation on the table name and data type in the received data query request. The data type may b...

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 data storage method and system and a data inquiry method. The system comprises a master physical database, a first memory database, a slave physical database and a second memory database. The master physical database is used for storing a first kind of data, a second kind of data and a third kind of data; the first memory database is used for storing the first kind of data in the master physical database through the master physical database, wherein the read-write consistency demands of the first kind of data are higher than those of the second kind of data. Through classifying the data stored in the master physical database according to the degrees of the consistency demands, storing the data with high consistency demands in the first memory database and synchronously copying the first kind of data in the master physical database by the first memory database, the consistency of the data with the high consistency demands is ensured.

Description

technical field [0001] The invention relates to the field of network communication, in particular to a data storage method, system and query method. Background technique [0002] With the development of various businesses of operators and the expansion of Internet channels and services, the CRM (Customer Relationship Management) system of operators is changing from a system oriented to thousands of operators to a system oriented to tens of millions of operators. end user's system. This puts higher and higher requirements on the experience and performance of the CRM system. In particular, the CRM business system that carries core user data is under increasing pressure. Traditional performance optimization methods, such as host expansion and database expansion, cannot keep up. The growth rate of business demand pressure is high, and the expansion cost is high, and the investment is huge. [0003] The existing technology faces the following problems: data replication adopts a...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 朱祥磊田力王新安廉红吉高向阳徐丽娜程进陈丕海王鹤霖陈刚
Owner CHINA MOBILE GROUP SHANDONG
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