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

A data storage method, system and query 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: 2019-02-26
CHINA MOBILE GROUP SHANDONG
View PDF4 Cites 0 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
  • A data storage method, system and query method
  • A data storage method, system and query method
  • A data storage method, system and query 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. Such as 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 ma...

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 system, method and query method, comprising a master physical database, a first memory database, a slave physical database, and a second memory database; the master physical database is used to store the first type of data, the second type of data and the third type of data; the first memory database is used to store the first type of data in the main physical database through the main physical database; wherein, the consistency requirements for reading and writing of the first type of data Higher than the consistency requirements for reading and writing of the second type of data, by classifying the data stored in the main physical database according to the level of consistency requirements, and storing the data with high consistency requirements in the first memory database, In addition, the first in-memory database synchronously replicates the first type of data in the main physical database, so as to ensure the consistency of data with high consistency requirements.

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 for thousands of operators to a system for 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 asynchronous repl...

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): G06F16/22G06F16/27
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com