KR20220151534A - Blockchain database mapping method and blockchain system to drive them - Google Patents

Abstract

Provided are a blockchain database operating method and a blockchain system for performing the same so that an RDB-style lattice model data management method can be easily used on the blockchain system. A blockchain database mapping method according to an embodiment of the present invention comprises: a step of generating a table structure by using a user-defined tag by a client; a step of receiving an input of a target blockchain to be set and used by the client; a step of constructing a smart contract corresponding to the table structure by a migrator; a step of installing the smart contract constructed by the migrator on an abstract blockchain unit which provides a common API; and a step of transmitting data between the abstract blockchain unit and the target blockchain by an interface corresponding to the received target blockchain.

Description

Blockchain database mapping method and blockchain system for driving it {BLOCKCHAIN DATABASE MAPPING METHOD AND BLOCKCHAIN SYSTEM TO DRIVE THEM}

The present invention relates to a block chain database mapping method and a block chain system for driving the same, and specifically, a block chain database that allows an existing block chain to be easily used as a database in a common way regardless of the type of block chain It relates to a mapping method and a blockchain system for driving it.

As various types of blockchain platforms emerged, starting with Bitcoin, consortium-type blockchains that could be used in the enterprise area followed suit. Blockchain in an enterprise system aims to reduce the cost of trust between organizations as a distributed data sharing rather than the original purpose of Bitcoin, which is money transfer. In order to use this kind of distributed database in enterprises, the RDB-style lattice model data management method has been used.

Therefore, in the conventional system, the storage of ledgers using smart contracts was made into a table structure with rows/columns/indexes in a lattice form, and as a technology for inserting and querying data in the table structure, recently directly inputting SQL statements JPA technology, which directly maps objects from forms to tables, is in the limelight.

On the other hand, in order for a company to use the RDB-style lattice model data management method on a blockchain system for reliability, it is necessary to learn the language and build system for each blockchain system. There is a problem that it is difficult to apply the RDB-style lattice model data management method on the blockchain system unless you have

According to Patent Registration No. 10-2354736, which is a prior art, a method and apparatus for providing a styling service using a blockchain-based database construction are disclosed, but there is a problem in that an expert familiar with the blockchain system must be mobilized to build such a database.

Provides a blockchain-based database operation method and a blockchain system to drive it so that you can easily use the RDB-style lattice model data management method on the blockchain system.

In order to solve the above problems, a block chain database mapping method according to an embodiment of the present invention includes the steps of generating a table structure using a user-defined tag by a client; Step of receiving an input of a target blockchain to be set and used by a client; Forming a smart contract corresponding to the table structure by the migrator; Installing a smart contract configured by the migrator in an abstract blockchain unit that provides a common API; and transmitting data between the abstract block chain unit and the target block chain by an interface corresponding to the received target block chain.

In an embodiment, the user-defined tag includes a create tag for creating a table, an input tag for inputting data into the table, a change tag for changing data stored in the table, and a delete tag for deleting data stored in the table.

In an embodiment, the migrator installs a smart contract in the abstract block chain unit, generates a smart contract address corresponding to a table structure configured by the client, and transmits it to the abstract block chain unit.

In an embodiment, the table structure includes table names, column names, indexes, and constraints, and the smart contract generates a hash code using table names and column names corresponding to data stored in the target blockchain. .

In another embodiment, the table structure includes one primary column name among a plurality of column names, and the smart contract uses data corresponding to a first index among the primary column names as a root node, and the primary column The position of the child node is determined by comparing the size of the data belonging to .

A blockchain system according to an embodiment of the present invention includes a migrator configuring a smart contract corresponding to a table structure generated using a user-defined tag input by a client; An abstract blockchain unit in which a smart contract configured by the migrator is installed, and data is transmitted between the abstract blockchain unit and the target blockchain by an interface corresponding to the target blockchain input by the client. do.

In the present invention, blockchain users can easily utilize and distribute complex tables by using simple Java classes without having to acquire a high level of blockchain knowledge, so companies can reduce the cost of trust between business logic and companies, which is the main purpose, and manage them. By making it possible to focus, you can expand the scope of use of blockchain.

1 is a diagram for explaining a blockchain system according to an embodiment of the present invention.
2 is a flowchart for explaining a method for mapping a blockchain database according to an embodiment of the present invention.

The above objects, features and advantages will become more apparent through the following detailed description in conjunction with the accompanying drawings, and accordingly, those skilled in the art to which the present invention belongs can easily implement the technical idea of the present invention. There will be. In addition, in describing the present invention, if it is determined that a detailed description of a known technology related to the present invention may unnecessarily obscure the subject matter of the present invention, the detailed description will be omitted. Hereinafter, a preferred embodiment according to the present invention will be described in detail with reference to the accompanying drawings.

1 is a diagram for explaining a blockchain system according to an embodiment of the present invention. Referring to FIG. 1 , a blockchain system according to an embodiment of the present invention includes a client 100, a middleware system 200, an abstract blockchain unit 230, and a blockchain 300.

The client 100 creates a table structure using a user-defined tag set by a user, and receives a target block chain to know which block chain the target block chain is targeting.

The table structure set by the user includes table configuration such as table name meaning table name, column name indicating table item, index indicating order in table, and constraints such as input text type of table item. At this time, processing such as B TREE and HASH INDEX is performed based on the table name and column name on the blockchain.

User-defined tags include various tags such as a create tag to create a table, an input tag to input data into a table, a change tag to change data stored in a table, and a delete tag to delete data stored in a table. These tags are in XML format. can be made with

The middleware system 200 includes a migrator 210 and a leisure master 220 .

The migrator 210 installs a smart contract in the abstract blockchain unit 230, and the migrator 210 generates the address of the smart contract corresponding to the table structure configured by the client 100, and the abstract blockchain unit 230 ) is sent to In addition, matters transmitted to the abstract block chain 230 by the migrator 210 further include settings such as block size and block generation cycle.

First, the migrator 210 creates a table structure based on user-defined tags in XML, and configures a smart contract corresponding to the table structure by mapping the table structure to a smart contract. At this time, the address of at least one smart contract can be mapped to the table structure created based on the XML user-defined tag. In the case of the present invention, the table structure can be created using XML defined by the user, so it has the advantage that it can be easily used without acquiring a high level of blockchain knowledge.

The migrator 210 installs the infrastructure smart contract on the blockchain based on the columns, indexes, and constraints defined by the user in XML, and configures the smart contract for the user-defined table format. Accordingly, in the abstract blockchain 230 to be described later, when the target blockchains are different, user convenience can be increased by not requiring modification according to each target block chain.

The Ledger Master unit 220 makes it possible to create an object having columns such as a table stored in a smart contract.

The Ledger Master 220 includes an object mapper unit 221 and a query DSL unit 222.

The object mapper unit 221 enables the Ledger Master to create an object having the same columns as a table stored in a smart contract using an API at the request of the client 100 . Based on a plurality of defined classes, at the time of execution, a table with the same columns as the properties of the corresponding class is automatically created as a table by a series of smart contract groups stored inside.

In addition, the object mapper 221 has a data management API in the form of Java methods such as insert, query, count, findBy, addColumn, and addIndex to perform various functions such as table form and content and search.

The object mapper 221 can store or retrieve data from the target blockchain at the request of a client using the data management API as described above. Users can easily manage the data on the blockchain ledger through commands using the data management API prepared in advance without knowledge of a separate program.

The query DSL unit 222 generates a query through a user-defined functional query. When the query string provided by the query DSL unit 222 is transmitted by the client 100, the query DSL unit 222 parses the query string and passes it to the smart contract as an argument, and the smart contract responds to the argument to the target block. You can store data on the chain or retrieve that data.

The query DSL unit 120 is for utilizing something other than the prescribed API used in the object mapper 110, and can identify problems in the query at the time of compilation through a user-defined functional query, and can perform various combinations of queries. be able to

If only the object mapper 110 is used, it becomes difficult to utilize anything other than the designated API, and in the case of other than the API, there is a problem in that it must be directly manipulated. On the other hand, if a query is written directly, a string is used, and the problem exists that the string can be verified only at the time of execution. Through the user-defined functional query through the query DSL unit 120 of the present invention, it is possible to identify the problem of the corresponding query at the time of compilation, and to perform queries in various combinations.

The abstract block chain unit 230 is not a target block chain, but is for performing DB-related functions, and includes a test server function and an interface function.

When a command using the API is transmitted from the Ledger Master 220, the abstract block chain unit 230 that receives the command transmitted using the API, for example, a command to search the index C of item B of table A, It interprets the command using the API provided in and transmits it to the blockchain 300 according to the interpreted command. If the abstract block chain unit 230 does not exist, a command must be issued using a specialized program that can be applied to the target block chain 300, but in the case of the present invention, the abstract block chain unit 230 interprets DB-related commands. Since it is transmitted to the target block chain 300, there is no need to use a specific programming language for manipulating the target block chain 300.

The abstract blockchain unit includes a common API unit that provides a common API regardless of the type of blockchain, an individual API unit that provides an API of a target blockchain, and an API matching unit, and the API matching unit can respond appropriately to the common API. Detect and respond to the API of the target blockchain that can be used. At this time, the number of APIs of the target blockchain to be detected may be plural.

In addition, the abstract blockchain unit 230 provides a coding test function. A developer may perform a coding test on both the abstract block chain unit 230 and the block chain 300 during an overall test that tests the entire coding. Meanwhile, in the case of a unit test in which a test is performed for each line of coding, a developer may perform a coding test only for the abstract block chain unit 230, not for the block chain. In the case of blockchain, the setting file must be installed for each unit test, but in the case of the abstract block chain unit 230, installation of the setting file by the migrator 210 can be omitted during successive unit tests. Accordingly, unit tests of coding can be quickly performed by the abstract block chain unit 230 .

The abstract blockchain unit 230 includes an interface 231 capable of transmitting data corresponding to a target blockchain. The interface 231 corresponding to the received target block chain performs data transmission between the abstract block chain unit and the target block chain.

Although the use method of each of the enterprise blockchain, Ethereum-based Quorom and Hyperledger Fabric is different, each usage method is different, but the present invention manages through the abstract block chain unit 230 so that the migrator 210 and the ledger master ( 230) can be commonized and provided as a common API.

Convex chain 300 is more related to a consortium-type block chain that can be used in the enterprise area than Bitcoin, which is money transfer, and is for reliable distributed data sharing, that is, for use as a distributed database.

On the other hand, in order to efficiently manage data stored in the distributed ledger, processing such as B tree/Hash Index may be included in order to efficiently search and update large-capacity files.

In this regard, in the blockchain 300, the smart contract sets the data corresponding to the first index of the primary column names in the table structure as the root node, and compares the size of data (size) belonging to the primary column to determine the location of the child node. can decide In the above case, an equal search speed can be guaranteed and the efficiency of the storage device can be increased.

2 is a flowchart for explaining a method of operating a blockchain-based database according to an embodiment of the present invention.

Referring to FIG. 2, the blockchain database mapping method includes the steps of creating a table structure by using a user-defined tag by a client (S110); Step of receiving an input of the target blockchain set and used by the client (S120); A step of constructing a smart contract corresponding to the table structure by the migrator (S130); Installing the smart contract configured by the migrator in the abstract blockchain unit (S140); and transmitting data between the abstract block chain unit and the target block chain through an interface corresponding to the received target block chain (S150).

In the step of generating a table structure by inputting a user-defined tag by the client (S110), the table structure set by the user includes a table name indicating a table name, a column name indicating an item in the table, an index indicating an order in the table, Includes table configuration such as constraints such as input text type of table item.

On the other hand, these user-defined tags include various tags such as a create tag for creating a table, an input tag for inputting data into a table, a change tag for changing data stored in a table, and a delete tag for deleting data stored in a table. These may be made in XML format.

As a user-defined tag defined by the user, a table structure can be created using XML, so it has the advantage of being easy to use without acquiring a high level of blockchain knowledge.

In step S120 of inputting the target block chain to be set and used by the client, the block chain set as the target among various block chains is input by the user.

In the step of configuring the smart contract corresponding to the table structure by the migrator (S130), the table structure is created based on the user-defined tags of XML, and the smart contract corresponding to the table structure is mapped to the smart contract. make up

The smart contract configured by the migrator is installed in the abstract block chain unit (S140), and data is transmitted between the abstract block chain unit and the target block chain by an interface corresponding to the received target block chain (S150). ), the smart contract is not installed directly on the target blockchain, but on the abstract blockchain. In this regard, the abstract block chain unit 230 includes an interface 231 capable of transmitting data corresponding to the target block chain. The interface 231 corresponding to the received target block chain performs data transmission between the abstract block chain unit and the target block chain. Although the use method of each of the enterprise blockchain, Ethereum-based Quorom and Hyperledger Fabric is different, each usage method is different, but the present invention manages through the abstract block chain unit 230 so that the migrator 210 and the ledger master ( 230), it is possible to commonize and provide the blockchain API required.

100: client
200: middleware system
210: migrator
220: leisure master
230: abstraction blockchain
300: Blockchain

Claims (5)

creating a table structure using user-defined tags by a client;
Step of receiving an input of a target blockchain to be set and used by the client;
Forming a smart contract corresponding to the table structure by the migrator;
Installing a smart contract configured by the migrator in an abstract blockchain unit that provides a common API;
A block chain database mapping method for performing a step of transmitting data between the abstract block chain unit and the target block chain by an interface corresponding to the input target block chain.
According to claim 1,
The user-defined tag includes a create tag for creating a table, an input tag for inputting data into the table, a change tag for changing data stored in the table, and a delete tag for deleting data stored in the table. mapping method.
According to claim 1,
The migrator installs a smart contract in the abstract blockchain unit, generates a smart contract address corresponding to a table structure configured by the client, and transmits it to the abstract blockchain unit. .
According to claim 1,
The table structure includes table names, column names, indexes, and constraints,
The smart contract generates a hash code using table names and column names corresponding to data stored in the target blockchain.
According to claim 4,
The table structure includes one primary column name among a plurality of column names,
Wherein the smart contract sets the data corresponding to the first index of the primary column names as a root node, and compares the size of data belonging to the primary column to determine the position of the child node.

Images