CN107436903A - A kind of data base management method based on NoSQL - Google Patents

A kind of data base management method based on NoSQL Download PDF

Info

Publication number
CN107436903A
CN107436903A CN201610365362.XA CN201610365362A CN107436903A CN 107436903 A CN107436903 A CN 107436903A CN 201610365362 A CN201610365362 A CN 201610365362A CN 107436903 A CN107436903 A CN 107436903A
Authority
CN
China
Prior art keywords
nosql
databases
data
management method
base management
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201610365362.XA
Other languages
Chinese (zh)
Inventor
娈蜂寒
殷亮
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Boshen Network Science And Technology Ltd Co
Original Assignee
Shanghai Boshen Network Science And Technology Ltd Co
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shanghai Boshen Network Science And Technology Ltd Co filed Critical Shanghai Boshen Network Science And Technology Ltd Co
Priority to CN201610365362.XA priority Critical patent/CN107436903A/en
Publication of CN107436903A publication Critical patent/CN107436903A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24552—Database cache management
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a kind of data base management method based on NoSQL, including：NoSQL non-relational databases are created based on MySQL relational databases and carry out data buffer storage；Network request is initiated by APP clients；Whether belong to the request of NoSQL categorical data storage classes in the request post analysis for receiving APP clients, if then being inquired about by NoSQL databases；If existence value in NoSQL databases, the value is returned as a result；If value is not present in NoSQL databases, is inquired about by relational database and by result deposit NoSQL databases cache while return to the Query Result.The efficiency of MySQL relational databases is improved, reduces the load repeatedly inquired about and brought, while also improve the response time of network request and more preferable Consumer's Experience；Realize simple cost is low, reliability is high and easy maintenance.

Description

A kind of data base management method based on NoSQL
Technical field
The present invention relates to database management technology field, more particularly to a kind of data base management method based on NoSQL.
Background technology
At present, in many network AP P application systems, mainly with the relational data library database such as MySQL Based on (Relational Database Management System), it completely assume responsibility for whole project system business number According to storage and service logic calculating.But in the longtime running of system, there is speed for the inquiry for Database Systems The problem of degree is slow, efficiency is low, and load is heavy.Such as：
Scene 1：During the personal information of the same user of multiple acquisition request, just needed often using MySQL relational databases It is secondary to inquire about once, the execution speed so not only influenceed, while also increase the load of database and the pressure of server.It is common Modification method be：The result cache for carrying out specific data query conditions is addressed that need by professional and technical personnel, allows and holds The result of the same querying condition of row avoids inquiring about again directly using the result of caching in the caching term of validity.This mode is present Following defect：First, having crossed after the term of validity of caching still needs to perform inquiry and data cached again.Secondly as the caching phase Can not upgrade in time the result of appearance of interior data will be wrong.
Scene 2：The counting statistics problem commonly used in application system, need each operand using MySQL relational databases Increasing or decreasing for counting statistics is carried out according to storehouse, it is same to ask counting statistics result to be also required to carry out data base querying.Therefore adopt It is difficult to improve speed in this way and reduces the load of database.
The content of the invention
In view of the above-mentioned deficiency that presently, there are, the present invention provides a kind of data base management method based on NoSQL, Neng Gouti The efficiency of high MySQL relational databases, reduce the load repeatedly inquired about and brought.
To reach above-mentioned purpose, embodiments of the invention adopt the following technical scheme that：
A kind of data base management method based on NoSQL, the data base management method based on NoSQL include following step Suddenly：
NoSQL non-relational databases are created based on MySQL relational databases and carry out data buffer storage；
Network request is initiated by APP clients；
Whether belong to the request of NoSQL categorical data storage classes in the request post analysis for receiving APP clients, if Then inquired about by NoSQL databases；
If existence value in NoSQL databases, the value is returned as a result；
If value is not present in NoSQL databases, is inquired about by relational database and result is stored in NoSQL data Storehouse cache while returns to the Query Result.
According to one aspect of the present invention, data storage and logic management are carried out by MySQL relational databases.
According to one aspect of the present invention, customize corresponding NoSQL non-relational databases for relevant database and deposit Store up data cached.
According to one aspect of the present invention, the data of the NoSQL non-relational databases storage are according to certain condition The value or result for being inquired about to obtain to relational database.
According to one aspect of the present invention, the data base management method based on NoSQL includes：Establish various types of Simple data statistics storage.
The advantages of present invention is implemented：Data base management method of the present invention based on NoSQL, including：Based on MySQL Relational database creates NoSQL non-relational databases and carries out data buffer storage；Network request is initiated by APP clients；Receiving Whether the request post analysis to APP clients belong to the request of NoSQL categorical data storage classes, if then passing through NoSQL numbers Inquired about according to storehouse；If existence value in NoSQL databases, the value is returned as a result；If it is not present in NoSQL databases Value, then inquired about by relational database and by result deposit NoSQL databases cache while return the Query Result Return.Corresponding NoSQL (non-relational database) data storage is customized for relevant database, improves MySQL relation numbers According to the efficiency in storehouse, the load repeatedly inquired about and brought is reduced, while also improve the response time of network request and more preferable user's body Test；Realize simple cost is low, reliability is high and easy maintenance.
Brief description of the drawings
Technical scheme in order to illustrate the embodiments of the present invention more clearly, it will use below required in embodiment Accompanying drawing is briefly described, it should be apparent that, drawings in the following description are only some embodiments of the present invention, for ability For the those of ordinary skill of domain, on the premise of not paying creative work, it can also be obtained according to these accompanying drawings other attached Figure.
Fig. 1 is a kind of data base management method schematic diagram based on NoSQL of the present invention；
Fig. 2 is the inquiry phase flow chart described in the embodiment of the present invention；
Fig. 3 is the database operational flow diagram described in the embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not made Embodiment, belong to the scope of protection of the invention.
As shown in Figure 1, Figure 2 and Figure 3, a kind of data base management method based on NoSQL, the data based on NoSQL Library management method comprises the following steps：
Step S1：NoSQL non-relational databases are created based on MySQL relational databases and carry out data buffer storage；
The step S1 creates the tool of NoSQL non-relational databases progress data buffer storage based on MySQL relational databases Body embodiment can be：First, the basis of data base administration is to carry out data storage and logic by MySQL relational databases Management, has larger memory data output；Secondly, data storage and logic management are being carried out by MySQL relational databases On the basis of, a NoSQL non-relational database is created, is preserved data cached.
In actual applications, deposited according to for the corresponding NoSQL non-relational databases of MySQL relevant databases customization Store up it is data cached, the data stored in NoSQL non-relational databases be by according to certain condition inquire about MySQL relationship type numbers The value or result obtained according to storehouse.
Step S2：Network request is initiated by APP clients；
The step S2 by APP clients initiate network request embodiment be：APP clients are passed through by user Network request is initiated, the network request can be to search for some key words contents, can be to browse some data.
Step S3：Whether belong to asking for NoSQL categorical data storage classes in the request post analysis for receiving APP clients Ask, if then being inquired about by NoSQL databases；
Whether the step S3 belongs to NoSQL categorical data storage classes in the request post analysis for receiving APP clients Request, if the embodiment then inquired about by NoSQL databases can be：Receiving asking for APP clients Post analysis are asked whether to belong to the request of NoSQL categorical data storage classes, if belonging to asking for NoSQL categorical data storage classes Ask, then directly inquired about by NoSQL databases.If being not belonging to the request of NoSQL categorical data storage classes, return APP clients, the request of APP clients is received again.
Step S4：If existence value in NoSQL databases, the value is returned as a result；
If existence value in the step S4 NoSQL databases, the embodiment that the value is returned as a result can For：If the value for needing to inquire about in NoSQL databases be present, directly the value is returned as a result.
Step S5：If value is not present in NoSQL databases, is inquired about by relational database and be stored in result NoSQL databases cache while the Query Result are returned into APP clients.
If value is not present in the step S5 NoSQL databases, is inquired about by relational database and deposited result Entering the embodiment that NoSQL databases cache while return to the Query Result can be：If in NoSQL databases not The value inquired about in the presence of needs, then inquired about by MySQL relational databases, and Query Result deposit NoSQL databases are entered Row caching, while the Query Result is returned into APP clients.
In actual applications, in addition to：Establish various types of simple data statistics storages.
In actual applications, inquiry phase may include following flow：
1. start；
2. judge receive request whether the inquiry of NoSQL database purchase types；
3. if it is not, then return 1.；
4. if so, then judge whether the data cached of NoSQL be present；
If 5. exist, direct returning result；
If 6. being not present, carry out MySQL inquiries and store the result into NoSQL.
In actual applications, whole database operational process can be：
1) APP applications are initiated to ask；
2) server is analyzed request；
3) inquiry of NoSQL database purchase types is judged whether；
4) if so, then performing step 5), step 2) is performed if not then returning；
5) judge whether the data cached of NoSQL be present；
If 6) in the presence of returning data to server；If the execution step 7) in the absence of if；
7) MySQL inquiries are carried out and store the result into NoSQL；
8) MySQL is passed back through to inquire about and store NoSQL result to server；
9) server returns data to APP applications.
The advantages of present invention is implemented：Data base management method of the present invention based on NoSQL, including：Based on MySQL Relational database creates NoSQL non-relational databases and carries out data buffer storage；Network request is initiated by APP clients；Receiving Whether the request post analysis to APP clients belong to the request of NoSQL categorical data storage classes, if then passing through NoSQL numbers Inquired about according to storehouse；If existence value in NoSQL databases, the value is returned as a result；If it is not present in NoSQL databases Value, then inquired about by relational database and by result deposit NoSQL databases cache while return the Query Result Return.Corresponding NoSQL (non-relational database) data storage is customized for relevant database, improves MySQL relation numbers According to the efficiency in storehouse, the load repeatedly inquired about and brought is reduced, while also improve the response time of network request and more preferable user's body Test；Realize simple cost is low, reliability is high and easy maintenance.
The foregoing is only a specific embodiment of the invention, but protection scope of the present invention is not limited thereto, any Those skilled in the art is in technical scope disclosed by the invention, the change or replacement that can readily occur in, all should It is included within the scope of the present invention.Therefore, protection scope of the present invention should using the scope of the claims as It is accurate.

Claims (5)

  1. A kind of 1. data base management method based on NoSQL, it is characterised in that the data base management method based on NoSQL Comprise the following steps：
    NoSQL non-relational databases are created based on MySQL relational databases and carry out data buffer storage；
    Network request is initiated by APP clients；
    Whether belong to the request of NoSQL categorical data storage classes in the request post analysis for receiving APP clients, if then leading to NoSQL databases are crossed to be inquired about；
    If existence value in NoSQL databases, the value is returned as a result；
    If value is not present in NoSQL databases, is inquired about by relational database and entered result deposit NoSQL databases Row caching simultaneously returns to the Query Result.
  2. 2. the data base management method according to claim 1 based on NoSQL, it is characterised in that pass through MySQL relation numbers Data storage and logic management are carried out according to storehouse.
  3. 3. the data base management method according to claim 1 based on NoSQL, it is characterised in that for relational data Storehouse customizes corresponding NoSQL non-relational databases memory buffers data.
  4. 4. the data base management method according to claim 1 based on NoSQL, it is characterised in that the non-relations of NoSQL The data of type database purchase are the value or result for being inquired about to obtain to relational database according to certain condition.
  5. 5. the data base management method based on NoSQL according to claim to one of 4, it is characterised in that described to be based on NoSQL data base management method includes：Establish various types of simple data statistics storages.
CN201610365362.XA 2016-05-27 2016-05-27 A kind of data base management method based on NoSQL Pending CN107436903A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610365362.XA CN107436903A (en) 2016-05-27 2016-05-27 A kind of data base management method based on NoSQL

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610365362.XA CN107436903A (en) 2016-05-27 2016-05-27 A kind of data base management method based on NoSQL

Publications (1)

Publication Number Publication Date
CN107436903A true CN107436903A (en) 2017-12-05

Family

ID=60453348

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610365362.XA Pending CN107436903A (en) 2016-05-27 2016-05-27 A kind of data base management method based on NoSQL

Country Status (1)

Country Link
CN (1) CN107436903A (en)

Similar Documents

Publication Publication Date Title
US11755575B2 (en) Processing database queries using format conversion
CN103729471B (en) Data base query method and device
CN102831122B (en) Data storage method, inquiring method and inquiring device for workflow table
CN101901242A (en) Federated configuration data management
CN101566986A (en) Method and device for processing data in online business processing
CN104182405A (en) Method and device for connection query
CN108446305A (en) The system and method for various dimensions service data statistics
CN108875042A (en) A kind of mixing on-line analysing processing system and data query method
CN111881221A (en) Method, device and equipment for customer portrait in logistics service
CN109308296A (en) A kind of generation method, device and the computer readable storage medium of business datum table
CN109241384A (en) A kind of method for visualizing and device of scientific research information
CN103455335A (en) Multilevel classification Web implementation method
CN107480262A (en) A kind of general management system of database based on webpage
US9652740B2 (en) Fan identity data integration and unification
CN108280082A (en) A kind of extemporaneous querying method and system of statistical data
CN104731969A (en) Mass data join aggregation query method, device and system in distributed environment
CN109002470A (en) Knowledge mapping construction method and device, client
CN107491549A (en) A kind of data processing method and system
KR101955376B1 (en) Processing method for a relational query in distributed stream processing engine based on shared-nothing architecture, recording medium and device for performing the method
CN107220363B (en) Cross-region query method and system supporting global complex retrieval
CN109189873A (en) A kind of Meteorological Services big data monitoring analysis system platform
US20230153286A1 (en) Method and system for hybrid query based on cloud analysis scene, and storage medium
CN107436903A (en) A kind of data base management method based on NoSQL
US8270612B2 (en) Mapping compound keys
CN105302818A (en) Query processing method and apparatus

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
WD01 Invention patent application deemed withdrawn after publication
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20171205