CN108959591A - Method, system, equipment and the storage medium that database and block chain integrate - Google Patents
Method, system, equipment and the storage medium that database and block chain integrate Download PDFInfo
- Publication number
- CN108959591A CN108959591A CN201810758945.8A CN201810758945A CN108959591A CN 108959591 A CN108959591 A CN 108959591A CN 201810758945 A CN201810758945 A CN 201810758945A CN 108959591 A CN108959591 A CN 108959591A
- Authority
- CN
- China
- Prior art keywords
- block chain
- database
- data base
- query language
- integrate
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides method, system, equipment and storage mediums that database and block chain integrate, method includes the following steps: the mapping table of the query language for establishing at least one database database management tasks to be executed and the operation of block chain；Judge to receive is the operation of block chain or native database operation, if block chain operates, data base query language is then resolved into database management tasks and relevant parameter, it calls corresponding block chain operation to generate block chain operation task in mapping table according to database management tasks, the operation of block chain is carried out to target block chain according to block chain operation task；If native database operates, then native database operation is carried out to target database.Business information across multiple entities in realization of the existing application scenarios based on centralization database can be entered chain, and change of the energy minimization to the database of existing business by the present invention.
Description
Technical field
The present invention relates to field of database management, specifically, be related to method, system that database and block chain integrate,
Equipment and storage medium.
Background technique
2008, assumed name was the scholar of " in this acute hearing " (Satoshi Nakamoto), had delivered a kind of " bit coin: point pair
Point-like electron cash system " paper, established the basis of block chain technology.For narrow sense, block chain is a kind of suitable according to the time
A kind of linked data structure that data block is combined by sequence in such a way that sequence is connected, and guarantee to usurp in a manner of cryptography
Change the distributed account book that can not be forged.For broadly, block chain technology is verified and is stored using block linked data structure
Data know together algorithm using distributed node to generate update data, guarantee that data transmission and side are asked in the way of cryptography
Safety programs the distributed basis completely new with one kind of operation data using the intelligent contract being made of automatized script code
Framework and calculation paradigm.
Current block chain applies, the existing system urgency of application scenarios suitable for block chain very crucial for commercial contract
A kind of scheme of rapid abutting joint block chain is needed, in addition, it is desirable to shared information and need to guarantee that the data of information privacy are being applied
It is generally existed simultaneously in scene.
Summary of the invention
For the problems of the prior art, the method integrated the purpose of the present invention is to provide database with block chain is
System, equipment and storage medium can will be realized between centralization database that existing application scenarios are established based on multiple entities
Business information across multiple analogue's entities enters chain, and change of the energy minimization to existing business system.It can be by original
The driver of the Database Systems for the single analogue having is extended, so that driver is identified and executes existing business
It needs to trigger the related service transaction that intelligent contract executes in the data base query language of logic, synchronizes corresponding related side and all close
The Asset State or operation flow logic of note.
The embodiment of the present invention provides a kind of method that database is integrated with block chain, comprising the following steps:
S101, it establishes at least one wide area information server query language database management tasks to be executed and is based on
The mapping table of the block chain operation of target block chain；
The data base query language that S102, judgement receive is the operation of block chain or native database operation, if area
The operation of block chain, thens follow the steps S103, if native database operates, thens follow the steps S106；
S103, the data base query language is resolved into database management tasks and relevant parameter；
S104, called according to the database management tasks in the mapping table it is corresponding based on target block chain
The operation of block chain；
S105, the block chain operation and relevant parameter generation block chain operation task will be found, according to block
Chain operation task carries out the operation of block chain to target block chain, terminates；
S106, native database operation is carried out to target database, terminated.
Preferably, wide area information server query language described in the step S101 has included at least correspondence database
Insertion task, delete task, more new task and query task, establish respectively insertion task, deletion task, more new task and
The mapping relations that query task is operated based on the block chain of target block chain, form mapping table.
Preferably, the step S102 judges that the data base query language is the operation of block chain by expression formula matching
Or native database operation.
Preferably, the operation of block chain is carried out to target block chain using block chain client in the step S106.
Preferably, data base querying language is executed using native database driver to target database in the step S106
Speech.
Preferably, in the step S102, when receiving multinomial data base query language, the multinomial database is looked into
It askes language and carries out parallel work-flow.
The embodiment of the present invention also provides a kind of system that database is integrated with block chain, for realizing above-mentioned database
The method integrated with block chain, the system that the database is integrated with block chain include:
Mapping table establishes module, establishes at least one wide area information server query language database to be executed
The mapping table of management role and the block chain operation based on target block chain；
Data base query language judgment module, judge the data base query language received be block chain operation or it is primary
Database manipulation then executes data base query language parsing module if block chain operates, if native database operates, then
Execute native database operation executing module；
The data base query language is resolved to database management tasks and corresponding by data base query language parsing module
Parameter；
Block chain operation module, it is corresponding based on mesh in mapping table calling according to the database management tasks
Mark the block chain operation of block chain；
Block chain operation executing module, will find the block chain operation and the relevant parameter generates the operation of block chain
Task carries out the operation of block chain to target block chain according to block chain operation task, terminates；
Native database operation executing module carries out native database operation to target database, terminates.
Preferably, the data base query language judgment module judges the data base querying language by expression formula matching
Speech is the operation of block chain or native database operation.
Preferably, the block chain operation executing module carries out block chain behaviour to target block chain using block chain client
Make.
Preferably, when the data base query language judgment module receives multinomial data base query language, to described more
Association database query language carries out parallel work-flow.
The embodiment of the present invention also provides a kind of equipment that database is integrated with block chain, comprising:
Processor；
Memory, wherein being stored with the executable instruction of the processor；
Wherein, the processor is configured to execute above-mentioned database and block chain collection via the executable instruction is executed
At method the step of.
The embodiment of the present invention also provides a kind of computer readable storage medium, and for storing program, described program is held
The step of method that above-mentioned database and block chain integrate is realized when row.
Method, system, equipment and the storage medium integrated the purpose of the present invention is to provide database and block chain can
Business information across multiple analogue's entities in realization of the existing application scenarios based on centralization database is entered into chain, and can be most
Change of smallization to the database of existing business.
Detailed description of the invention
Upon reading the detailed description of non-limiting embodiments with reference to the following drawings, other feature of the invention,
Objects and advantages will become more apparent upon.
Fig. 1 is the flow chart for the method that database and block chain of the invention integrate.
Fig. 2 is the module diagram for the system that database and block chain of the invention integrate.
Fig. 3 is the structural schematic diagram for the equipment that database and block chain of the invention integrate.And
Fig. 4 is the structural schematic diagram of the computer readable storage medium of one embodiment of the invention.
Specific embodiment
Example embodiment is described more fully with reference to the drawings.However, example embodiment can be with a variety of shapes
Formula is implemented, and is not understood as limited to embodiment set forth herein.On the contrary, thesing embodiments are provided so that the present invention will
Fully and completely, and by the design of example embodiment comprehensively it is communicated to those skilled in the art.It is identical attached in figure
Icon note indicates same or similar structure, thus will omit repetition thereof.
Fig. 1 is the flow chart for the method that database and block chain of the invention integrate.As shown in Figure 1, implementation of the invention
Example provides a kind of method that database is integrated with block chain, comprising the following steps:
S101, it establishes at least one wide area information server query language database management tasks to be executed and is based on
The mapping table of the block chain operation of target block chain.Wherein, the wide area information server query language includes at least
The insertion task of correspondence database deletes task, more new task and query task, establish respectively insertion task, deletion task,
The mapping relations of the respective different block chain operation of more new task and query task based on target block chain, form these and reflect
The set for penetrating relationship forms mapping table, and but not limited to this.
The data base query language that S102, judgement receive is the operation of block chain or native database operation, if area
The operation of block chain, thens follow the steps S103, if native database operates, thens follow the steps S106.Judgement side in the present embodiment
Formula is to judge that the data base query language is that the operation of block chain or native database are operated by regular expression matching,
But not limited to this.In a preferred embodiment, in the step S102, when receiving multinomial data base query language, to institute
It states multinomial data base query language and carries out parallel work-flow, to accelerate database processing efficiency.
S103, the data base query language is resolved into database management tasks and relevant parameter.
S104, called according to the database management tasks in the mapping table it is corresponding based on target block chain
The operation of block chain.
S105, the block chain operation and relevant parameter generation block chain operation task will be found, according to block
Chain operation task carries out the operation of block chain to target block chain, terminates.In the present embodiment, block chain client can use super
Account book client carries out the operation of block chain to target block chain, and but not limited to this.Wherein, super account book (hyperledger)
It is the open source projects of propulsion block chain digital technology and transaction verification that Linux foundation was initiated in 2015, member's packet is added
Include: more than ten of different interests body, the target such as De Nederlandsche Bank (ABN AMRO), Accenture (Accenture) are that member is allowed to close jointly
Make, open platform of building together, meets and come from the various customer cases of multiple and different industries, and simplify operation flow.Due to point-to-point net
The characteristic of network, distributed account book technology is completely shared, transparent and decentralization, therefore is very suitable for answering in financial industry
With, and other other industries numerous such as manufacture, bank, insurance, Internet of Things.By the public affairs for creating distributed account book
Opening of bid is quasi-, realizes virtually and the exchange of value of digital form, for example, the transaction of assets contract, the energy, marriage certificate, can safely and
High efficiency, low cost being tracked and trading.
S106, native database operation is carried out to target database, terminated.To target database using former in the present embodiment
Raw data base driver executes data base query language, and but not limited to this.Data base driver can be based in the present invention
JDBC (connection of Java database) architecture executes a kind of data base query language SQL statement, and but not limited to this, such as
Also open CNC (Open Database Connectivity, ODBC) can be used.JDBC(Java DataBase
Connectivity, the connection of abbreviation Java database) it is a kind of for executing the Java API of SQL sentence, it can be a variety of passes
It is that database provides unified access, the class and interface that it is write by one group with Java language form.JDBC provides a kind of base
Standard can construct more advanced tool and interface accordingly, database development personnel is enable to write database application.Have
JDBC, sending SQL statement to various relation datas is exactly an easily thing.In other words, there is JDBC API, it is not necessary to be
Access sybase database specially writes a program, specially writes a program again for Accessing Oracle Database, or be access
Informix database writes another program etc. again, and programmer need to only write a program with regard to much of that with JDBC API, it can
SQL is sent to associated databases to call.Meanwhile combining Java language and JDBC makes programmer be not necessarily different put down
Platform writes different application programs, and need only write a program can allow it to run on any platform, this is also Java language
The advantage of " writing primary, operation everywhere ".
In the present invention, data base query language can be structured query language (Structured Query
Language, can abbreviation SQL), but not limited to this (such as the inquiry language for the NoSQL database such as can also be MongoDB
Speech).SQL is a kind of programming language of specific purposes, is a kind of data base querying and programming language, for access data with
And query, update, and manage relational database system；It is simultaneously also the extension name of database script file.Data base query language
It is advanced deproceduring programming language, user is allowed to work in high level data structure.It does not require user specified to data
Deposit method, do not need user yet and understand specific data location mode, so the difference with entirely different fabric
Identical data base query language can be used as interface data input and managed in Database Systems.Data base querying language
Speech can be nested, this makes it have the function of great flexibility and powerful.Wherein, data base query language includes 6 parts:
One, data query language (DQL:Data Query Language):
Its sentence, also referred to as " data retrieval sentence " determine data how in application program to obtain data from table
It provides.Reserved word SELECT is DQL (and all SQL) verb with the most use, and the common reserved word of other DQL has WHERE,
ORDER BY, GROUP BY and HAVING.These DQL reserved words are often used together with other kinds of SQL statement.
Two, data manipulation language (DML:Data Manipulation Language):
Its sentence includes verb INSERT, UPDATE and DELETE.They are respectively used to add, modify and deletion table in
Row.Also referred to as Action query language.
Three, transaction language (TPL):
Its sentence can ensure that all rows by the table that DML statement influences are updated in time.TPL sentence includes BEGIN
TRANSACTION, COMMIT and ROLLBACK.
Four, data control language (DCL):
Its sentence is secured permission by GRANT or REVOKE, determines single user and user group to database object
Access.Certain RDBMS can control the access to table single row with GRANT or REVOKE.
Five, Data Definition Language (DDL):
Its sentence includes verb CREATE and DROP.Create in the database new table or deletion table (CREAT TABLE or
DROP TABLE)；Index etc. is added for table.DDL includes many reserved words related with data are obtained in personal data library directory.It
It is also a part of Action query.
Six, pointer control language (CCL):
Its sentence, as DECLARE CURSOR, FETCH INTO and UPDATE WHERE CURRENT are used for one
Or the operation that multiple lists are walked alone.
Application end of the invention uses database broker drive module, can still provide and original database-driven application
Device accordant interface, thus guarantee application affairs realize it is not necessary to modify.The present invention is in agent drives interior design database
Query language analysis engine, to application layer exposure additional interface support user specified by it is required enter chain data manipulation database
Query language is mapped as the operation to block chain.The number that data base querying analysis module calls dynamic analysis application in the present invention
Native database operation and the operation of block chain are divided into according to database query language.If analysis the result is that if native database operates still
Data base query language is executed using legacy data library driver, is otherwise reflected according to aforementioned user-defined data base query language
It penetrates behavior and triggers corresponding block chain method call.
The present invention can pass through the database of the original service logic of database client (driving) Agent Analysis of application end
Original database client API (such as JDBC, ODBC) is embodied as acting on behalf of by the calling of query language.Wherein, it needs for original
There is the insertion of database primitive, delete, update, inquiry provides the behavior of the realization based on block chain.It can permit database broker
It is without any changes to the operation of all existing databases, only it is responsible for the friendship that analysis is described by data base query language by acting on behalf of
Easy affairs simultaneously trigger corresponding block chain method call.
In step 102, judge that the data base query language received is the operation of block chain or native database operation
In the process, agency determines whether the execution to current data base querying needs by expression formula matching to the calling of data base querying
It is sent to block catenary system.In one example: INSERT INTO ASSETS VALUES, which, which calls, needs to be resolved
For relevant parameter and to the calling of respective block chain method.In another example: createAsset (#1, #2, #3).Upper
In the example of face, the insertion SQL instruction of asset tables of data can be triggered to block chain method createAsset's (#1, #2, #3)
It calls, and reference order can redefine.In the present invention, from SQL into block chain method call conversion process, parameter
Can custom order again, and support incoming constant as parameter.In a preferred embodiment, a kind of script language is finally provided
Speech can extract the parameter transaction in data base query language, and make corresponding modification and be converted to required for block chain method call
Parameter
In existing application scenarios capable of being based on the purpose of the present invention is to provide the method that database and block chain integrate
Business information across multiple analogue's entities in the realization of heart database enters chain, and energy minimization is to the data of existing business
The change in library.
Fig. 2 is the module diagram for the system that database and block chain of the invention integrate.It is of the invention as shown in Fig. 2
Embodiment also provides a kind of system that database is integrated with block chain, the side integrated for realizing above-mentioned database and block chain
Method, the system that the database is integrated with block chain include:
Mapping table establishes module, establishes at least one wide area information server query language database to be executed
The mapping table of management role and the block chain operation based on target block chain.
Data base query language judgment module, judge the data base query language received be block chain operation or it is primary
Database manipulation then executes data base query language parsing module if block chain operates, if native database operates, then
Execute native database operation executing module.
The data base query language is resolved to database management tasks and corresponding by data base query language parsing module
Parameter.
Block chain operates mapping block, calls corresponding base in the mapping table according to the database management tasks
It is operated in the block chain of target block chain.
Block chain operation executing module, will find the block chain operation and the relevant parameter generates the operation of block chain
Task carries out the operation of block chain to target block chain according to block chain operation task, terminates.
Native database operation executing module carries out native database operation to target database, terminates.
In a preferred embodiment, the data base query language judgment module is judged described by regular expression matching
Data base query language is the operation of block chain or native database operation.
In a preferred embodiment, the block chain operation executing module carries out target block chain using block chain client
The operation of block chain.
In a preferred embodiment, when the data base query language judgment module receives multinomial data base query language,
Parallel work-flow is carried out to the multinomial data base query language, to accelerate database processing efficiency.
In existing application scenarios capable of being based on the purpose of the present invention is to provide the system that database and block chain integrate
Business information across multiple analogue's entities in the realization of heart database enters chain, and energy minimization is to the data of existing business
The change in library.
The embodiment of the present invention also provides a kind of equipment that database is integrated with block chain, including processor.Memory, wherein
It is stored with the executable instruction of processor.Wherein, processor be configured to via execute executable instruction be performed database with
The step of method that block chain integrates.
As it appears from the above, the embodiment can by realization of the existing application scenarios based on centralization database across multiple opponents
The business information of Fang Shiti enters chain, and change of the energy minimization to the database of existing business.
Person of ordinary skill in the field it is understood that various aspects of the invention can be implemented as system, method or
Program product.Therefore, various aspects of the invention can be embodied in the following forms, it may be assumed that complete hardware embodiment, complete
The embodiment combined in terms of full Software Implementation (including firmware, microcode etc.) or hardware and software, can unite here
Referred to as " circuit ", " module " or " platform ".
Fig. 3 is the structural schematic diagram for the equipment that database and block chain of the invention integrate.Root is described referring to Fig. 3
According to the electronic equipment 600 of the embodiment of the invention.The electronic equipment 600 that Fig. 3 is shown is only an example, should not be right
The function and use scope of the embodiment of the present invention bring any restrictions.
As shown in figure 3, electronic equipment 600 is showed in the form of universal computing device.The component of electronic equipment 600 can be with
Including but not limited to: at least one processing unit 610, at least one storage unit 620, connection different platform component (including are deposited
Storage unit 620 and processing unit 610) bus 630, display unit 640 etc..
Wherein, storage unit is stored with program code, and program code can be executed with unit 610 processed, so that processing is single
Member 610 executes various exemplary implementations according to the present invention described in this specification above-mentioned electronic prescription circulation processing method part
The step of mode.For example, processing unit 610 can execute step as shown in fig. 1.
Storage unit 620 may include the readable medium of volatile memory cell form, such as Random Access Storage Unit
(RAM) 6201 and/or cache memory unit 6202, it can further include read-only memory unit (ROM) 6203.
Storage unit 620 can also include program/utility with one group of (at least one) program module 6205
6204, such program module 6205 includes but is not limited to: operating system, one or more application program, other program moulds
It may include the realization of network environment in block and program data, each of these examples or certain combination.
Bus 630 can be to indicate one of a few class bus structures or a variety of, including storage unit bus or storage
Cell controller, peripheral bus, graphics acceleration port, processing unit use any bus structures in a variety of bus structures
Local bus.
Electronic equipment 600 can also be with one or more external equipments 700 (such as keyboard, sensing equipment, bluetooth equipment
Deng) communication, can also be enabled a user to one or more equipment interact with the electronic equipment 600 communicate, and/or with make
The electronic equipment 600 any equipment (such as the router, modulatedemodulate that can be communicated with one or more of the other calculating equipment
Adjust device etc.) communication.This communication can be carried out by input/output (I/O) interface 650.Also, electronic equipment 600 may be used also
To pass through network adapter 660 and one or more network (such as local area network (LAN), wide area network (WAN) and/or public network
Network, such as internet) communication.Network adapter 660 can be communicated by bus 630 with other modules of electronic equipment 600.It answers
When understanding, although not shown in the drawings, other hardware and/or software module can be used in conjunction with electronic equipment 600, including but unlimited
In: microcode, device driver, redundant processing unit, external disk drive array, RAID system, tape drive and number
According to backup storage platform etc..
The embodiment of the present invention also provides a kind of computer readable storage medium, and for storing program, program is performed reality
The step of method that existing database and block chain integrates.In some possible embodiments, various aspects of the invention are also
It can be implemented as a kind of form of program product comprising program code, when program product is run on the terminal device, program
Code is for executing terminal device described in this specification above-mentioned electronic prescription circulation processing method part according to the present invention
The step of various illustrative embodiments.
As it appears from the above, the embodiment can by realization of the existing application scenarios based on centralization database across multiple opponents
The business information of Fang Shiti enters chain, and change of the energy minimization to the database of existing business.
Fig. 4 is the structural schematic diagram of computer readable storage medium of the invention.Refering to what is shown in Fig. 4, describing according to this
The program product 800 for realizing the above method of the embodiment of invention can use the read-only storage of portable compact disc
Device (CD-ROM) and including program code, and can be run on terminal device, such as PC.However, journey of the invention
Sequence product is without being limited thereto, and in this document, readable storage medium storing program for executing can be any tangible medium for including or store program, the journey
Sequence can be commanded execution system, device or device use or in connection.
Program product can be using any combination of one or more readable mediums.Readable medium can be readable signal Jie
Matter or readable storage medium storing program for executing.Readable storage medium storing program for executing for example can be but be not limited to electricity, magnetic, optical, electromagnetic, infrared ray or partly lead
System, device or the device of body, or any above combination.More specific example (the non exhaustive column of readable storage medium storing program for executing
Table) it include: the electrical connection with one or more conducting wires, portable disc, hard disk, random access memory (RAM), read-only storage
Device (ROM), erasable programmable read only memory (EPROM or flash memory), optical fiber, portable compact disc read only memory (CD-
ROM), light storage device, magnetic memory device or above-mentioned any appropriate combination.
Computer readable storage medium may include in a base band or as carrier wave a part propagate data-signal,
In carry readable program code.The data-signal of this propagation can take various forms, including but not limited to electromagnetic signal,
Optical signal or above-mentioned any appropriate combination.Readable storage medium storing program for executing can also be any readable Jie other than readable storage medium storing program for executing
Matter, the readable medium can send, propagate or transmit for by instruction execution system, device or device use or and its
The program of combined use.The program code for including on readable storage medium storing program for executing can transmit with any suitable medium, including but not
It is limited to wireless, wired, optical cable, RF etc. or above-mentioned any appropriate combination.
The program for executing operation of the present invention can be write with any combination of one or more programming languages
Code, programming language include object oriented program language-Java, C++ etc., further include conventional process
Formula programming language-such as " C " language or similar programming language.Program code can be calculated fully in user
It executes in equipment, partly execute on a user device, executing, as an independent software package partially in user calculating equipment
Upper part executes on a remote computing or executes in remote computing device or server completely.It is being related to remotely counting
In the situation for calculating equipment, remote computing device can pass through the network of any kind, including local area network (LAN) or wide area network
(WAN), it is connected to user calculating equipment, or, it may be connected to external computing device (such as utilize ISP
To be connected by internet).
To sum up, the purpose of the present invention is to provide method, system, equipment and storages that database and block chain integrate to be situated between
Business information across multiple analogue's entities in realization of the existing application scenarios based on centralization database can be entered chain by matter,
And change of the energy minimization to the database of existing business.
The above content is a further detailed description of the present invention in conjunction with specific preferred embodiments, and it cannot be said that
Specific implementation of the invention is only limited to these instructions.For those of ordinary skill in the art to which the present invention belongs, exist
Under the premise of not departing from present inventive concept, a number of simple deductions or replacements can also be made, all shall be regarded as belonging to of the invention
Protection scope.
Claims (12)
1. a kind of method that database and block chain integrate, which comprises the following steps:
S101, it establishes at least one wide area information server query language database management tasks to be executed and is based on target
The mapping table of the block chain operation of block chain；
The data base query language that S102, judgement receive is the operation of block chain or native database operation, if block chain
Operation, thens follow the steps S103, if native database operates, thens follow the steps S106；
S103, the data base query language is resolved into database management tasks and relevant parameter；
S104, the corresponding block based on target block chain is called in the mapping table according to the database management tasks
Chain operation；
S105, the block chain operation and relevant parameter generation block chain operation task will be found, will be grasped according to block chain
Make task and the operation of block chain is carried out to target block chain, terminates；
S106, native database operation is carried out to target database, terminated.
2. the method that database according to claim 1 and block chain integrate, which is characterized in that institute in the step S101
State wide area information server query language included at least the insertion task of correspondence database, deletion task, more new task and
Query task establishes the block chain of insertion task, deletion task, more new task and query task based on target block chain respectively
The mapping relations of operation form mapping table.
3. the method that database according to claim 1 and block chain integrate, which is characterized in that the step S102 passes through
Regular expression matching come judge the data base query language be block chain operation or native database operation.
4. the method that database according to claim 1 and block chain integrate, which is characterized in that adopted in the step S106
Block chain operation is carried out to target block chain with super account book client.
5. the method that database according to claim 1 and block chain integrate, which is characterized in that right in the step S106
Target database executes data base query language using native database driver.
6. the method that database according to claim 1 and block chain integrate, which is characterized in that in the step S102,
When receiving multinomial data base query language, parallel work-flow is carried out to the multinomial data base query language.
7. the system that a kind of database and block chain integrate, for realizing database described in any one of claims 1 to 6 with
The integrated method of block chain characterized by comprising
Mapping table establishes module, establishes at least one wide area information server query language data base administration to be executed
The mapping table of task and the block chain operation based on target block chain；
Data base query language judgment module judges that the data base query language received is the operation of block chain or native data
Library operation then executes data base query language parsing module if block chain operates, if native database operates, then executes
Native database operation executing module；
The data base query language is resolved to database management tasks and corresponding ginseng by data base query language parsing module
Number；
Block chain operates mapping block, corresponding based on mesh in mapping table calling according to the database management tasks
Mark the block chain operation of block chain；
Block chain operation executing module, will find the block chain operation and the relevant parameter generates the operation of block chain and appoints
Business carries out the operation of block chain to target block chain according to block chain operation task, terminates；
Native database operation executing module carries out native database operation to target database, terminates.
8. the system that database according to claim 7 and block chain integrate, which is characterized in that the data base querying language
Speech judgment module judges that the data base query language is the operation of block chain or native database behaviour by expression formula matching
Make.
9. the system that database according to claim 7 and block chain integrate, which is characterized in that the block chain operation is held
Row module carries out the operation of block chain to target block chain using block chain client.
10. the system that database according to claim 7 and block chain integrate, which is characterized in that the data base querying
When language judgment module receives multinomial data base query language, parallel work-flow is carried out to the multinomial data base query language.
11. the equipment that a kind of database and block chain integrate characterized by comprising
Processor；
Memory, wherein being stored with the executable instruction of the processor；
Wherein, the processor is configured to come any one of perform claim requirement 1 to 6 institute via the execution executable instruction
The step of stating the method that database and block chain integrate.
12. a kind of computer readable storage medium, for storing program, which is characterized in that described program is performed realization power
Benefit require any one of 1 to 6 described in database and block chain integrate method the step of.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810758945.8A CN108959591A (en) | 2018-07-11 | 2018-07-11 | Method, system, equipment and the storage medium that database and block chain integrate |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810758945.8A CN108959591A (en) | 2018-07-11 | 2018-07-11 | Method, system, equipment and the storage medium that database and block chain integrate |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108959591A true CN108959591A (en) | 2018-12-07 |
Family
ID=64482862
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810758945.8A Pending CN108959591A (en) | 2018-07-11 | 2018-07-11 | Method, system, equipment and the storage medium that database and block chain integrate |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108959591A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110209744A (en) * | 2019-05-07 | 2019-09-06 | 深圳壹账通智能科技有限公司 | Relevant database and its operating method and device based on alliance's chain |
| KR20220104871A (en) * | 2021-01-19 | 2022-07-26 | 주식회사 에이비씨 | Hybrid Database System Using Private Blockchain |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105260403A (en) * | 2015-09-22 | 2016-01-20 | 广东同望科技股份有限公司 | Universal cross-database access method |
| US20170214699A1 (en) * | 2016-01-26 | 2017-07-27 | Bank Of America Corporation | System for conversion of an instrument from a non-secured instrument to a secured instrument in a process data network |
| CN107766453A (en) * | 2017-09-26 | 2018-03-06 | 上海策赢网络科技有限公司 | Data base management method, device and storage medium based on block chain |
| US20180083771A1 (en) * | 2016-09-20 | 2018-03-22 | United States Postal Service | Methods and systems for a digital trust architecture |
-
2018
- 2018-07-11 CN CN201810758945.8A patent/CN108959591A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105260403A (en) * | 2015-09-22 | 2016-01-20 | 广东同望科技股份有限公司 | Universal cross-database access method |
| US20170214699A1 (en) * | 2016-01-26 | 2017-07-27 | Bank Of America Corporation | System for conversion of an instrument from a non-secured instrument to a secured instrument in a process data network |
| US20180083771A1 (en) * | 2016-09-20 | 2018-03-22 | United States Postal Service | Methods and systems for a digital trust architecture |
| CN107766453A (en) * | 2017-09-26 | 2018-03-06 | 上海策赢网络科技有限公司 | Data base management method, device and storage medium based on block chain |
Non-Patent Citations (1)
| Title |
|---|
| 沈周科: ""区块链与传统数据库技术概述"", 《数字技术与应用》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110209744A (en) * | 2019-05-07 | 2019-09-06 | 深圳壹账通智能科技有限公司 | Relevant database and its operating method and device based on alliance's chain |
| KR20220104871A (en) * | 2021-01-19 | 2022-07-26 | 주식회사 에이비씨 | Hybrid Database System Using Private Blockchain |
| KR102594377B1 (en) | 2021-01-19 | 2023-10-26 | 주식회사 에이비씨 | Hybrid Database System Using Private Blockchain |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6736173B2 (en) | Method, system, recording medium and computer program for natural language interface to a database | |
| US8260824B2 (en) | Object-relational based data access for nested relational and hierarchical databases | |
| US8423514B2 (en) | Service provisioning | |
| CN105446966B (en) | The method and apparatus that production Methods data are converted to the mapping ruler of RDF format data | |
| CN102770849B (en) | Optimizing a data cache when applying user-based security | |
| US10664498B2 (en) | Interconnected graph structured database for identifying and remediating conflicts in resource deployment | |
| US10140319B2 (en) | System for identifying anomalies by automatically generating and analyzing a structure | |
| US20180218088A1 (en) | Adjacency structures for executing graph algorithms in a relational database | |
| US8881127B2 (en) | Systems and methods to automatically generate classes from API source code | |
| CN103473256B (en) | Method and system for content management | |
| CN105359088B (en) | Use the method for the virtual disk content optimization supply time of dynamic generation | |
| CN104866513A (en) | System and method for cross-tenant data access | |
| CN104160381A (en) | Managing tenant-specific data sets in a multi-tenant environment | |
| US11907184B1 (en) | Collaborative data mapping system | |
| KR20150010655A (en) | System and method for modelling data | |
| US9928257B2 (en) | GINA virtual guid | |
| US11080068B2 (en) | Adaptive user-interface assembling and rendering | |
| WO2006026702A2 (en) | Methods and systems for semantic identification in data systems | |
| CN105556517A (en) | Smart search refinement | |
| CN103207908A (en) | Multi-data-source dynamic isolated access method | |
| CN104252345A (en) | Complex object management method and system in cloud environment | |
| CN112256584B (en) | Internet number making method and system | |
| US10248668B2 (en) | Mapping database structure to software | |
| CN108959591A (en) | Method, system, equipment and the storage medium that database and block chain integrate | |
| CN105138646A (en) | Database operation method based on Hibernate |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20181207 |
|
| WD01 | Invention patent application deemed withdrawn after publication |