CN110059102A - The method for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD - Google Patents
The method for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD Download PDFInfo
- Publication number
- CN110059102A CN110059102A CN201910340262.5A CN201910340262A CN110059102A CN 110059102 A CN110059102 A CN 110059102A CN 201910340262 A CN201910340262 A CN 201910340262A CN 110059102 A CN110059102 A CN 110059102A
- Authority
- CN
- China
- Prior art keywords
- data source
- crud
- resolver
- data base
- distributed data
- 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
Links
- 230000006978 adaptation Effects 0.000 title claims abstract description 18
- 238000000034 method Methods 0.000 title claims abstract description 14
- 230000010354 integration Effects 0.000 title claims abstract description 12
- 239000012634 fragment Substances 0.000 claims abstract description 28
- 230000004048 modification Effects 0.000 claims description 5
- 238000012986 modification Methods 0.000 claims description 5
- 230000009471 action Effects 0.000 abstract description 8
- 206010033799 Paralysis Diseases 0.000 description 2
- 239000006185 dispersion Substances 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
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/242—Query formulation
- G06F16/2433—Query languages
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of methods for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD, comprising the following steps: S1, configuration distributed data base system, the distributed data base system are made of primary data source and multiple data source nodes；S2, the character string that called side transmits is intercepted by adaptation resolver, parses associated data source and the orientation SQL of CRUD；S3, the data source to be connected is obtained according to parsing result, is connected with corresponding primary data source or data source nodes, orientation executes related command；S4, called side is returned after the CRUD operation result that directional data source executes is merged specification via adapter.The present invention is by the CRUD action statement of acquisition, the primary data source of distributed data base system or the data source nodes under it are routed to by being adapted to resolver, CRUD operation for single fragment keyword or multiple same slice keywords, can directly it be connected with corresponding data source nodes, it is effectively reduced the operating pressure of primary data source, alleviates the operating pressure of primary data source.
Description
Technical field
The present invention relates to distributed data base resolver technical fields, it particularly relates to which a kind of be distributed based on isomorphism type
The method of formula database integration CRUD manipulation adaptation resolver.
Background technique
Isomorphism type distributed data base is to solve the unified manipulation of the lower data of data storage of database volume deficiency or dispersion
One of effective settling mode, wherein the primary data source of distributed data base is responsible for the behaviour to data source nodes data multiple under it
Control.Under normal circumstances, the CRUD transmitted from the background, which (increases, read, update, delete) action statement, must all pass through primary data source pair
Its lower node is operated.But under the growing background of data volume, the operating pressure of primary data source constantly increases, and needs to lead to
Cross the operating pressure of resolver dispersion primary data source.
Summary of the invention
To solve problems of the prior art, the object of the present invention is to provide one kind to be based on isomorphism type distributed data
The method of library integration CRUD manipulation adaptation resolver, has the advantages that mitigate primary data source operating pressure.
To achieve the above object, the technical solution adopted by the present invention is that: one kind based on isomorphism type distributed data base one
Change the method for CRUD manipulation adaptation resolver, the following steps are included:
S1, configuration distributed data base system, the distributed data base system is by primary data source and multiple data source nodes
It constitutes；
S2, the character string that called side transmits is intercepted by adaptation resolver, parses associated data source and the orientation of CRUD
SQL；
S3, the data source to be connected is obtained according to parsing result, is connected with corresponding primary data source or data source nodes,
Orientation executes related command；
S4, called side is returned after the CRUD operation result that directional data source executes is merged specification via adapter.
Preferably, further comprising the steps of in step S2:
S21, it is operated according to different CRUD, SQL statement is classified；
S22, each of parameter character string parameter value is put into SQL in corresponding placeholder, obtains complete SQL
Sentence；
S23, from complete SQL statement, intercept fragment keyword.
Preferably, further comprising the steps of in step S3:
S31, according to fragment keyword, different CRUD operations is routed by adaptation resolver respectively.
Preferably, further comprising the steps of in step S31:
S311, the operation of a fragment keyword or multiple identical fragment keywords will be related only to by fragment keyword
The alias of corresponding data source nodes is directly obtained by routing, to connect with corresponding data source, is added data
Operation.
Preferably, further comprising the steps of in step S31:
S312, reading, modification, delete operation are related to the operation of multiple and different fragment keywords, are obtained by routing
The alias of primary data source is read accordingly, is modified, delete operation to obtain the connection of primary data source.
The beneficial effects of the present invention are:
(1) present invention will obtain the CRUD action statement on backstage, be routed to distributed data base system by being adapted to resolver
The primary data source of system or the data source nodes under it, for the CRUD of single fragment keyword or multiple same slice keywords
Make, can directly be connected with corresponding data source nodes, and without primary data source, primary data source is effectively alleviated in this way
Operating pressure avoids whole CRUD operations all by primary data source, alleviates the operating pressure of primary data source；
(2) present invention intercepts the fragment keyword in complete S QL sentence by adaptation resolver, obtains its corresponding data
Source alias obtains the connection in corresponding data source by data source alias, carries out CRUD operation；
(3) whole CRUD operation all passes through primary data source, and any one place, which breaks down, in whole system will lead to entire system
System paralysis is directly connected to by adaptation resolver with corresponding data source nodes, and breaking down at one in system will not shadow
It rings to other operations in system, avoids whole system paralysis bring loss；
(4) action statement that backstage is transmitted is optimized by being adapted to resolver, the fragment intercepted in action statement is crucial
Word, saves data resource, effectively alleviates the operating pressure of subsequent operation.
Detailed description of the invention
Fig. 1, which is that the embodiment of the present invention is a kind of, manipulates adaptation resolver based on isomorphism type distributed data base integration CRUD
Method schematic diagram.
Specific embodiment
The embodiment of the present invention is described in detail with reference to the accompanying drawing.
Embodiment 1:
As shown in Figure 1, a kind of method for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD, packet
Include following steps:
S1, configuration distributed data base system, the distributed data base system is by primary data source and multiple data source nodes
It constitutes；
S2, the character string that called side transmits is intercepted by adaptation resolver, parses associated data source and the orientation of CRUD
SQL；
S3, the data source to be connected is obtained according to parsing result, is connected with corresponding primary data source or data source nodes,
Orientation executes related command；
S4, called side is returned after the CRUD operation result that directional data source executes is merged specification via adapter.
The present invention will obtain the CRUD action statement on backstage, be routed to distributed data base system by being adapted to resolver
Primary data source or the data source nodes under it, according to the CRUD of fragment keyword operate, can directly with corresponding data source nodes
It is connected, without effectively alleviating the operating pressure of primary data source in this way merely through primary data source, avoids whole CRUD behaviour
Make all to alleviate the operating pressure of primary data source by primary data source.
Embodiment 2:
As shown in Figure 1, the present embodiment improves on the basis of embodiment 1, it is further comprising the steps of in step S2:
S21, it is operated according to different CRUD, SQL statement is classified；
S22, each of parameter character string parameter value is put into SQL in corresponding placeholder, obtains complete SQL
Sentence；
S23, from complete SQL statement, intercept fragment keyword.
The action statement that backstage is transmitted is optimized by being adapted to resolver, has intercepted the fragment keyword in action statement,
Data resource is saved, the operating pressure of subsequent operation is effectively alleviated.
Embodiment 3:
As shown in Figure 1, the present embodiment improves on the basis of embodiment 1, it is further comprising the steps of in step S3:
S31, according to fragment keyword, different CRUD operations is routed by adaptation resolver respectively.
Embodiment 4:
As shown in Figure 1, the present embodiment improves on the basis of embodiment 1, it is further comprising the steps of in step S31:
S311, the operation of a fragment keyword or multiple identical fragment keywords will be related only to by fragment keyword
The alias of corresponding data source nodes is directly obtained by routing, to connect with corresponding data source, is added data
Operation.
It, can be straight by routing by fragment keyword because the operation of the single addition data in CRUD is not related to multiple databases
It connects to obtain the alias of corresponding data source nodes, to obtain corresponding data source connection, is added the operation of data, avoids
It is connect with primary data source, consumes the resource of primary data source.Operation for multiple addition data in CRUD, because of operation every time
It is related to a database, so the operation of its addition data is identical as the single addition operation of data.
Embodiment 5:
As shown in Figure 1, the present embodiment improves on the basis of embodiment 1, it is further comprising the steps of in step S31:
S312, reading, modification, delete operation are related to the operation of multiple and different fragment keywords, are obtained by routing
The alias of primary data source is read accordingly, is modified, delete operation to obtain the connection of primary data source.
Because the reading in CRUD, modification, delete operation do not know to be related to single or multiple databases, so being involved in more
The operation of a different fragment keyword obtains the alias of primary data source by routing, so that the connection of primary data source is obtained, into
Row is corresponding to be read, modifies, delete operation, and the behaviour of a fragment keyword or multiple identical fragment keywords will be related only to
Make, the alias of corresponding data source nodes is obtained by routing, so that corresponding data source connection is obtained, and without master data
Source effectively alleviates the operating pressure of primary data source in this way.
A specific embodiment of the invention above described embodiment only expresses, the description thereof is more specific and detailed, but simultaneously
Limitations on the scope of the patent of the present invention therefore cannot be interpreted as.It should be pointed out that for those of ordinary skill in the art
For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to guarantor of the invention
Protect range.
Claims (5)
1. a kind of method for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD, which is characterized in that packet
Include following steps:
S1, configuration distributed data base system, the distributed data base system are made of primary data source and multiple data source nodes；
S2, the character string that called side transmits is intercepted by adaptation resolver, parses associated data source and the orientation SQL of CRUD；
S3, the data source to be connected is obtained according to parsing result, is connected with corresponding primary data source or data source nodes, orientation
Execute related command；
S4, called side is returned after the CRUD operation result that directional data source executes is merged specification via adapter.
2. a kind of according to claim 1 manipulated based on isomorphism type distributed data base integration CRUD is adapted to resolver
Method, which is characterized in that further comprising the steps of in step S2:
S21, it is operated according to different CRUD, SQL statement is classified；
S22, each of parameter character string parameter value is put into SQL in corresponding placeholder, obtains complete SQL language
Sentence；
S23, from complete SQL statement, intercept fragment keyword.
3. a kind of according to claim 1 manipulated based on isomorphism type distributed data base integration CRUD is adapted to resolver
Method, which is characterized in that further comprising the steps of in step S3:
S31, according to fragment keyword, different CRUD operations is routed by adaptation resolver respectively.
4. a kind of according to claim 3 manipulated based on isomorphism type distributed data base integration CRUD is adapted to resolver
Method, which is characterized in that further comprising the steps of in step S31:
S311, the operation for relating only to a fragment keyword or multiple identical fragment keywords is passed through by fragment keyword
Routing directly obtains the alias of corresponding data source nodes, to connect with corresponding data source, is added the operation of data.
5. a kind of according to claim 3 manipulated based on isomorphism type distributed data base integration CRUD is adapted to resolver
Method, which is characterized in that further comprising the steps of in step S31:
S312, reading, modification, delete operation are related to the operation of multiple and different fragment keywords, obtain main number by routing
According to the alias in source, to obtain the connection of primary data source, is read, modified accordingly, delete operation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910340262.5A CN110059102A (en) | 2019-04-25 | 2019-04-25 | The method for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910340262.5A CN110059102A (en) | 2019-04-25 | 2019-04-25 | The method for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110059102A true CN110059102A (en) | 2019-07-26 |
Family
ID=67320906
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910340262.5A Pending CN110059102A (en) | 2019-04-25 | 2019-04-25 | The method for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110059102A (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104036007A (en) * | 2014-06-23 | 2014-09-10 | 北京京东尚科信息技术有限公司 | Method and device for querying distributed databases |
| CN105426396A (en) * | 2015-10-28 | 2016-03-23 | 深圳市万姓宗祠网络科技股份有限公司 | Routing algorithm based database sharding method, system and middleware system |
| CN106407302A (en) * | 2016-08-30 | 2017-02-15 | 东华大学 | Method for supporting function of calling specific functions of middleware database through simple SQL |
| US20170161327A1 (en) * | 2015-12-04 | 2017-06-08 | Dell Software, Inc. | Distributed database driver middleware |
| CN107180081A (en) * | 2017-04-28 | 2017-09-19 | 广东亿迅科技有限公司 | The call method and device of massive relation type database |
| CN107729370A (en) * | 2017-09-12 | 2018-02-23 | 上海艾融软件股份有限公司 | Micro services multi-data source connects implementation method |
| CN107943870A (en) * | 2017-11-10 | 2018-04-20 | 顺丰科技有限公司 | For improving the method and its equipment of distributed data base middleware stability |
| CN108334620A (en) * | 2018-02-08 | 2018-07-27 | 苏州蜗牛数字科技股份有限公司 | A kind of method and device operating Cluster Database based on ORM frames |
| CN108628986A (en) * | 2018-04-27 | 2018-10-09 | 深圳市牛鼎丰科技有限公司 | Data query method, apparatus, computer equipment and storage medium |
-
2019
- 2019-04-25 CN CN201910340262.5A patent/CN110059102A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104036007A (en) * | 2014-06-23 | 2014-09-10 | 北京京东尚科信息技术有限公司 | Method and device for querying distributed databases |
| CN105426396A (en) * | 2015-10-28 | 2016-03-23 | 深圳市万姓宗祠网络科技股份有限公司 | Routing algorithm based database sharding method, system and middleware system |
| US20170161327A1 (en) * | 2015-12-04 | 2017-06-08 | Dell Software, Inc. | Distributed database driver middleware |
| CN106407302A (en) * | 2016-08-30 | 2017-02-15 | 东华大学 | Method for supporting function of calling specific functions of middleware database through simple SQL |
| CN107180081A (en) * | 2017-04-28 | 2017-09-19 | 广东亿迅科技有限公司 | The call method and device of massive relation type database |
| CN107729370A (en) * | 2017-09-12 | 2018-02-23 | 上海艾融软件股份有限公司 | Micro services multi-data source connects implementation method |
| CN107943870A (en) * | 2017-11-10 | 2018-04-20 | 顺丰科技有限公司 | For improving the method and its equipment of distributed data base middleware stability |
| CN108334620A (en) * | 2018-02-08 | 2018-07-27 | 苏州蜗牛数字科技股份有限公司 | A kind of method and device operating Cluster Database based on ORM frames |
| CN108628986A (en) * | 2018-04-27 | 2018-10-09 | 深圳市牛鼎丰科技有限公司 | Data query method, apparatus, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10691682B2 (en) | Storing and processing JSON documents in a SQL database table | |
| US11055287B2 (en) | Eigenvalue-based data query | |
| US10209695B2 (en) | Method and a system for replacing and commissioning of a field device | |
| CN106126540B (en) | Data base access system and its access method | |
| CN109508355A (en) | A kind of data pick-up method, system and terminal device | |
| CN109376196A (en) | Method and device for batch synchronization of redo logs | |
| WO2016019772A1 (en) | Method and apparatus for shielding heterogeneous data source | |
| CN107665216A (en) | A kind of data bank access method and middleware | |
| US20150058267A1 (en) | Method of designing business logic, server performing the same and storage medium storing the same | |
| CN112069176B (en) | Database design method, device and equipment of communication protocol and storage medium | |
| CN102915344B (en) | SQL (structured query language) statement processing method and device | |
| CN108829884A (en) | data mapping method and device | |
| CN102087594A (en) | Management method and device for extension point and plugins | |
| CN108536745A (en) | Tables of data extracting method, terminal, equipment and storage medium based on Shell | |
| WO2019015364A1 (en) | Method and device for executing structured query language (sql) instruction | |
| CN108255837A (en) | A kind of SQL resolvers and method | |
| CN105426305A (en) | Control attribute analysis system and method | |
| CN104461929B (en) | Distributed data cache method based on blocker | |
| US8341652B2 (en) | Method for programmatic editing of configuration files | |
| CN109815240A (en) | For managing method, apparatus, equipment and the storage medium of index | |
| US9665601B1 (en) | Using a member attribute to perform a database operation on a computing device | |
| CN109683923A (en) | A kind of check method and system of electrical power distribution automatization system configuration file version | |
| CN102929853A (en) | DCS (Data Communication System) project data generating system and method based on Excel sheet association | |
| CN100440803C (en) | Gridding information model system and method for modeling processing gridding information | |
| CN110059102A (en) | The method for manipulating adaptation resolver based on isomorphism type distributed data base integration CRUD |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190726 |
|
| RJ01 | Rejection of invention patent application after publication |