KR20200102293A - Blockchain software capable of operation corresponding sql query, blockchain system, and method of thereof - Google Patents

Abstract

Disclosed is an operating method of a blockchain system including nodes connected to each other through a blockchain network. The operating method comprises the steps of: receiving, by a first node of the nodes, an operation generated by a smart contract executed in a computer, and transmitting the received operation to the remaining nodes among the nodes; writing, by a second node, corresponding to the turn to generate a block to be included in a blockchain, among the nodes, the operation on the block, and transmitting the block including the operation to nodes other than the second node among the nodes; and determining, by each of the nodes, whether the operation included in the block includes an SQL query, processing the block according to the operation when the operation does not include the SQL query, and performing an operation corresponding to the SQL query on an SQL database when the operation includes the SQL query.

Description

Blockchain software that can perform an operation corresponding to an SQL query, a blockchain system, and its operation method {BLOCKCHAIN SOFTWARE CAPABLE OF OPERATION CORRESPONDING SQL QUERY, BLOCKCHAIN SYSTEM, AND METHOD OF THEREOF}

The present invention relates to blockchain technology, and in particular, to a blockchain software capable of performing an operation corresponding to an SQL query, a blockchain system, and an operation method thereof.

Blockchain is a linked list that starts with the first block (Genesis Block) and has links to the block immediately preceding it. Blockchain is distributed across multiple nodes, stored and managed, and since each of the blocks contains transaction information (transaction), the block chain, an aggregate of blocks, can be said to be a huge distributed ledger containing all transaction information. have. In other words, a block is an element of a blockchain, and conceptually, it means a bundle of a number of transaction information (transactions). The block consists of a block header, transaction information, and other information.

US Patent Publication: US20170236121 (2017.08.17 publication) Registered Patent Publication: Registration No. 10-1395737 (announced on May 16, 2014) Registered Patent Publication: Registration No. 10-1816653 (announced on February 21, 2018)

The technical problem to be achieved by the present invention is a computer program stored in a storage medium capable of storing data in a blockchain or retrieving data from the blockchain using SQL queries output from a smart contract (or DAPP), the computer A block chain node capable of executing a program, a block chain system including the block chain node, and a method of providing a service using the block chain system are provided.

The block chain system according to the embodiments of the present invention includes a block chain network and a first node, a second node, and a third node connected to each other through the block chain network. The first node receives an operation generated by a smart contract executed in a computer, and transmits the operation to the second node and the third node. Among the second node and the third node, the second node corresponding to the turn of generating a block to be included in the block chain writes the operation to the block, and the block including the operation is written to the first node and the block. Transfer to the third node. Each of the first node and the third node determines whether the operation included in the block is an SQL query operation, and when the operation is the SQL query operation, an operation corresponding to the SQL query operation is stored in a volatile memory. After performing the database, an operation corresponding to the SQL query operation is performed on a file database stored in a nonvolatile memory, and the memory database is created from the file database.

An operating method of a blockchain system including nodes connected to each other through a blockchain network according to embodiments of the present invention includes the steps of: among the nodes, a first node receiving an operation generated by a smart contract executed on a computer; Transmitting the operation received by the first node to the remaining nodes among the nodes; Among the nodes, a second node corresponding to the turn of generating a block to be included in the block chain writes the operation to the block, and the block including the operation from among the nodes other than the second node Transferring to; Determining whether the operation included in the block by each of the nodes includes an SQL query; When the operation does not include the SQL query, each of the nodes processing the block according to the operation; And when the operation includes the SQL query, each of the nodes performing an operation corresponding to the SQL query on the SQL database.

According to embodiments of the present invention, a computer program stored in a computer-readable storage medium for processing an operation including an SQL query, coupled with the first node, receives the operation generated by a smart contract running on the computer. step; Transmitting the operation to second nodes; Receiving a block including the operation transmitted from a node corresponding to a turn to generate a block to be included in the block chain among the second nodes; Determining whether the operation included in the received block includes an SQL query; Processing the block according to the operation when the operation included in the block does not include the SQL query; And performing an operation corresponding to the SQL query on the SQL database when the operation included in the block includes the SQL query.

According to embodiments of the present invention, a method of providing a block chain service and an SQL service using a computer running a smart contract that generates an operation and nodes included in the block chain system includes each of the nodes included in the block. Determining whether the operation is a block chain operation or an SQL query operation; And when the operation is the block chain operation, each of the nodes performs an operation corresponding to the block chain operation, and when the operation is the SQL query operation, each of the nodes performs an operation corresponding to the SQL query operation. Including steps to perform against the SQL database.

A computer program stored in a storage medium of a blockchain node according to an embodiment of the present invention has the effect of storing data in the blockchain or retrieving data from the blockchain using SQL queries output from a smart contract (or DAPP). There is.

According to an embodiment of the present invention, each of the blockchain nodes includes a memory database and a file database, i.e., two databases, uses the memory database for quick search, and the blockchain node to ensure data integrity. There is an effect of being able to apply the data agreed upon by them to the file database.

A detailed description of each drawing is provided in order to more fully understand the drawings cited in the detailed description of the present invention.
1 shows a block chain system including nodes according to an embodiment of the present invention connected to each other through a block chain network.
FIG. 2 shows hardware and software included in each of the nodes shown in FIG. 1.
FIG. 3 shows a basic structure of a block used in software included in each of the nodes shown in FIG. 1.
4 is a conceptual diagram illustrating an operation of a computer program according to an embodiment of the present invention.
5 is a conceptual diagram illustrating an operation of a node operated by a computer program according to an embodiment of the present invention.
6 is a flowchart illustrating a process of loading a memory database into a volatile memory in each of the nodes shown in FIG. 1.
7 is a flowchart illustrating the operation of the block chain system shown in FIG. 1.

1 shows a block chain system including nodes according to an embodiment of the present invention connected to each other through a block chain network.

Referring to FIG. 1, since the blockchain system 100 or the blockchain network is a peer-to-peer (P2P) network, nodes 110-1 to 110-8 are connected to each other through the blockchain network 101. Has been.

In FIG. 1, for convenience of explanation, the computer 200 is illustrated as being connected to the first node 110-1, but according to embodiments, the computer 200 is at least among the nodes 110-1 to 110-8. Hana can be connected to each other through the blockchain network 101.

The computer 200 may generate an operation using a smart contract executed therein, and transmit the operation to the first node 110-1.

A node (or blockchain node) is a device on the blockchain network 101. The node may be an active electronic device connected to the Internet and having an IP address (eg, a computer, a mobile device, an Internet of Things (IoT) device, an electric vehicle, and a printer). The role of the node is to support the network by maintaining a copy of the blockchain and processing transactions. In addition, the node may be a communication endpoint or a communication redistribution point that is linked to other nodes.

FIG. 2 shows hardware and software included in each of the nodes shown in FIG. 1. 1 and 2, it is assumed that the structure and function of each of the nodes 110-1 to 110-8 are the same or substantially the same, and for convenience of explanation, the structure and function of the first node 110-1 The structure of the second node 110-2 is shown.

The first node 110-1 includes a hardware 120-1 and a processor 130-1 that executes an operating system (OS).

Hardware 120-1 is a volatile memory 125-1 and Including the nonvolatile memory 127-1, the volatile memory 125-1 may be implemented as a dynamic random access memory (DRAM) or SRAM, and the nonvolatile memory 127-1 is a hard disk drive (hard disc drive). drive (HDD)) or a solid state drive (SSD). Further, the hardware 120-1 may include a transceiver capable of exchanging data with the computer 200 and each node 110-2 to 110-8.

The processor 130-1 may execute an OS, and the OS may execute software 140-1, 145-1, 150-1, 155-1, and 160-1. The software is a computer stored in a storage medium 125-1 and/or 127-1 readable by the first node 110-1, coupled with a computer (or computing device). It can mean a program. Each module represents a computer program.

The remote procedure control (RPC) module 140-1 refers to a module for receiving an external command (eg, a command output from the computer 200) and transmitting a result of executing the command to the outside.

The P2P module 140-2 is a module for software (S/W) and data synchronization of each of the nodes 110-2 to 110-8 connected through the blockchain network 101. Software (S/W) installed on each node (110-12 ~ 110-8) means blockchain software.

The data storage 150-1 refers to data storage in the form of a file-based key and/or value, and is a data storage for storing data of a blockchain software (S/W). The extension of the data storage 150-1 may be bin.

The plug-in 155-1 may be a sub-module of blockchain software.

The SQL database plug-in 160-1 provides two databases (e.g., a memory database and a file database), and a platform capable of processing SQL queries (or SQL commands) for at least one of the two databases. Log in.

The SQL database plug-in 160-1 is used to store data used by a dapp (decentralized application) of an external device (eg, 200).

The second node 110-2 includes a hardware 120-2 and a processor 130-2 that executes an operating system (OS). The hardware 120-2 includes a volatile memory 125- 2) and a nonvolatile memory 127-2.

The configuration included in the second node 110-2 having the same name as the configuration included in the first node 110-1 has the same function (or operation) as the configuration included in the first node 110-1. ), a detailed description of each of the components 140-2, 145-2, 150-2, 155-2, and 160-2 included in the second node 110-2 will be omitted.

FIG. 3 shows a basic structure of a block used in software included in each of the nodes shown in FIG. 1.

Referring to FIGS. 1 to 3, a block 200 is generated by blockchain software running on one node corresponding to a randomly determined order among nodes 110-1 to 110-8. One block 200 is generated every predetermined time (eg, 3 seconds). The block 200 may be a bundle of verified transactions transmitted from the outside for a certain period of time (eg, 3 seconds), and there may be empty blocks that do not contain any verified transactions.

Each blockchain software synchronizes data on a block basis, and each blockchain software verifies the validity of each transmitted block.

Each of the transactions 210 and 220 included in the block 200 performs a function of transmitting an operation transmitted from the outside to the blockchain software. Each of the transactions 210 and 220 may include information for data integrity and data security in addition to the operation 215.

The operation 215 included in each transaction 210 and 220 refers to an instruction to be transmitted from the outside and executed (or executed) in the blockchain software. For example, SQL queries to be executed in the SQL database plug-in are included in the operation.

However, among SQL commands (SELECT, INSERT, DELETE, UPDATE, CREATE TABLE, ALTER TABLE, and DROP TABLE, etc.), SELECT is not included in the block. SQL query refers to a query containing at least one SQL command. For example, a GET command input from the outside is directly executed as an API (Application Programming Interface) through an RPC module installed in each node 110-1 to 110-8.

4 is a conceptual diagram illustrating an operation of a computer program according to an embodiment of the present invention. In FIG. 4, blocks BLOCK10, BLOCK11, BLOCK12, and BLOCK13 generated in a corresponding node at a predetermined time are sequentially shown.

Data storage (DS) means data storage in the form of a file-based key and/or value as described with reference to FIG. 2, and stores data of blockchain software (S/W). For data storage.

The SQL database (SDB) is a database used by the SQL database plug-in described with reference to FIG. 2. SQL database (SDB) is used to store data used by smart contracts or dapps. As will be described with reference to FIG. 5, the SQL database (SDB) includes a memory database (MDB) and a file database (FDB).

The computer program executed in each node (110-1 to 110-8) determines whether an SQL query is included in the operation included in each block (BLOCK10, BLOCK11, BLOCK12, and BLOCK13), and the SQL query is the operation. When included in, the operation including the SQL query is transmitted to the SQL database plug-in. The SQL database plug-in performs an operation corresponding to each operation (SQL QUERY 10 and SQL QUERY 12) including an SQL query to the SQL database (SDB).

When the SQL query is not included in the operation, the computer program performs each operation (OPERATION 11 and OPERATION 13) that does not include the SQL query, that is, an operation corresponding to a block chain operation, to the data storage (DS). do.

5 is a conceptual diagram illustrating an operation of a node operated by a computer program according to an embodiment of the present invention. 1 to 5, it is assumed that each node 110-1 to 110-8 sequentially receives or generates each block BLOCK10, BLOCK11, BLOCK12, and BLOCK13.

The SQL database plug-in running on each node (110-1 to 110-8) is used for each operation included in each block (BLOCK10, BLOCK11, BLOCK12, and BLOCK13) (SQL QUERY 10, SQL QUERY 11, SQL QUERY 12, and SQL The validity of each SQL query (or a query including an SQL command or a query including an SQL statement) included in QUERY 13) is checked (S250). The validity determines whether the SQL query is an SQL command defined in SQL and the SQL command is a valid SQL statement.

When the SQL query is invalid (INVALID in S250), the SQL database plug-in does not prepare the operation corresponding to the SQL query or returns an error message to the device (eg, node or computer 200) that transmitted the block. do.

When the SQL query is valid (VALID in S250), the SQL database plug-in performs an operation corresponding to the SQL query or an operation including the SQL query to the memory database (MDB).

For example, when an SQL query is an INSERT command or an INSERT statement, the SQL database plug-in inserts a tuple (eg, row or record) into an existing table stored in a memory database (MDB) according to the SQL query. . In addition, when the SQL query is a DELETE command or a DELETE statement, the SQL database plug-in deletes a tuple (eg, row or record) from an existing table stored in a memory database (MDB) according to the SQL query. .

In addition, when the SQL query is a CREATE TABLE command or a CREATE TABLE statement, the SQL database plugin defines and creates a new table in the memory database (MDB) according to the SQL query.

However, when a smart contract or dapp executed in the computer 200 generates an operation including a SELECT query (or a SELECT command or a SELECT statement) and transmits the operation to the first node 110-1, the first node ( The SQL database plug-in executed in 110-1) retrieves (or extracts) the tuple corresponding to the SELECT query (or SELECT command or SELECT statement) from the table stored in the database (MDB), and retrieves (or extracts) the tuple (RESULT ) Can be transferred to the computer 200.

The SQL database plug-in transfers the operation corresponding to each operation (SQL QUERY 10, SQL QUERY 11, SQL QUERY 12, and SQL QUERY 13) contained in each block (BLOCK10, BLOCK11, BLOCK12, and BLOCK13) to the memory database (MDB). Do about it.

The SQL database plug-in pushes each operation (SQL QUERY 10, SQL QUERY 11, SQL QUERY 12, and SQL QUERY 13) to the queue for storage after a certain period of time.

The SQL database plug-in reads (or pops) each operation (SQL QUERY 10, SQL QUERY 11, SQL QUERY 12, and SQL QUERY 13) stored in the queue in sequence, and reads (or pops) each operation (SQL QUERY 10, SQL QUERY 11, SQL QUERY 12, and SQL QUERY 13) are performed on the file database (FDB). Accordingly, data included in the memory database may be more recent than data stored in the file database.

For example, data stored in the file database by the SQL database plug-in may be updated with data stored in the memory database.

As described above, when the SQL query is an INSERT command, the SQL database plug-in inserts tuples according to the SQL query into an existing table stored in the memory database (MDB), and then the existing stored in the file database (FDB). An operation of inserting a tuple (eg, a tuple identical to a tuple inserted in a table of a memory database (MDB)) into a table according to the SQL query may be performed.

The reasons for operating (or operating) the SQL database as two databases, a memory database and a file database are as follows.

For example, the blockchain software running on each node included in the blockchain system guarantees the integrity of the data contained in the block through a process called agreement with the blockchain software running on each of the other nodes included in the blockchain system. do.

Since the above consensus requires a certain amount of time (e.g., the time it takes for 15 to 21 blocks to be generated), the SQL database plug-in uses a memory database for fast search or fast processing, and to finally apply the agreed content. The SQL database plug-in uses a file database.

The memory database is stored in the volatile memory of each node, and the file database is stored in the nonvolatile memory of each node. When each node is started up or booted, the file database stored in the nonvolatile memory is loaded into the volatile memory to become the memory database. That is, the memory database is created from the file database.

6 is a flowchart illustrating a process of loading a memory database into a volatile memory in each of the nodes shown in FIG. 1.

Referring to Figures 1 and 6, the block chain software or SQL database plug-in running on each node (110-1 ~ 110-8) when each node (110-1 ~ 110-8) startup or boot, It is determined whether a file database exists in the nonvolatile memory (S110).

When the file database does not exist in the nonvolatile memory (NO in S110), the blockchain software or the SQL database plug-in creates the file database (S115), and stores the generated file database at each node 110-1. A memory database is created by loading into the volatile memory included in ~110-8) (S120). That is, the memory database is created from the file database (S120).

When the file database exists in the nonvolatile memory (YES in S110), the blockchain software or the SQL database plug-in loads the file database into a volatile memory to create a memory database (S120).

7 is a flowchart illustrating the operation of the block chain system shown in FIG. 1.

1 to 7, it is assumed that the first node 110-1 receives an operation generated by a smart contract (or dapp) executed in the computer 200 and the second node 110-2 It is assumed that the node is in the turn to create the block to be included in the blockchain.

The first node 110-1 receives an operation generated by a smart contract (or dapp) running on the computer 200 (S210), and transmits the received operation to the nodes 110 through the blockchain network 101. -2~110-8) (S220).

Among the nodes 110-2 to 110-8, a node corresponding to the turn of generating a block to be included in the block chain (e.g., the second node 110-2 writes the received operation to the block (S230), The block including the operation is transmitted to the nodes 110-1 and 110-3 to 110-8 through the blockchain network 101 (S240). At this time, the second node 110-2 The steps S250 to S290 described below are performed.

Each node (110-1 to 110-8) is the operation included in the current block (e.g., including the block transmitted from the second node (110-2) and the block generated by the second node (110-2)) It is determined whether this is an SQL query operation (SS250). SQL query operation refers to an operation involving an SQL query.

When the operation is the SQL query operation (YES in S250), each node 110-1 to 110-8 performs an operation corresponding to the SQL query operation in a memory database stored in a volatile memory (S270).

After the current block is agreed upon by more than half of the nodes 110-1 to 110-8 (S280), each node 110-1 to 110-8 performs an operation corresponding to the SQL query operation. The file database stored in the nonvolatile memory is executed (S290). As described above, each node 110-1 to 110-8 creates the memory database from the file database.

When the operation is not the SQL query operation (NO in S250), that is, when the operation is a block chain operation, each node 110-1 to 110-8 is the current block (or The data included in the current block) is processed.

When the block chain operation is an operation for account creation, transaction creation, transaction verification, block configuration and generation, mining and compensation, block verification, block chain creation, or difficulty adjustment, each node (110-1 to 110-8) Is the creation of the electronic wallet related to the account creation, the transmission of the electronic money related to the transaction generation, the transaction transmission in the P2P network related to the transaction verification, the block configuration and generation of the transaction in the block, the mining and compensation Mining to secure the validity of the related block, propagating the P2P network related to the block verification, verifying the block of each node, or changing the block generation period related to the difficulty adjustment.

The method of providing blockchain services and SQL services using the computer 200 running the smart contract that creates the operation and the nodes 110-1 to 110-8 included in the blockchain system 100 is node Each of the nodes 110-1 to 110-8 determines whether the operation included in the current block is a block chain operation or an SQL query operation, and when the operation is the block chain operation, nodes 110-1 to 110-8 ) Each performs an operation corresponding to the block chain operation (e.g., a block chain service), and when the operation is the SQL query operation, each of the nodes 110-1 to 110-8 is applied to the SQL query operation. The corresponding operation (eg, SQL service) is performed on the SQL database.

The operation corresponding to the block chain operation may be account creation, transaction creation, transaction verification, block configuration and generation, mining and compensation, block verification, block chain creation, or difficulty adjustment. An operation corresponding to the SQL query operation may be an operation corresponding to an SQL command.

The method of providing the blockchain service and the SQL service can be performed by blockchain software (eg, a computer program) running on each node 110-1 to 110-8. Blockchain software (e.g., a computer program) that provides blockchain services and SQL services is stored in a non-transitory storage medium that each node 110-1 to 110-8 can read. The non-transitory storage medium may mean a nonvolatile memory.

The present invention has been described with reference to the embodiments shown in the drawings, but these are only exemplary, and those of ordinary skill in the art will appreciate that various modifications and other equivalent embodiments are possible therefrom. Therefore, the true technical protection scope of the present invention should be determined by the technical idea of the attached registration claims.

100: Blockchain system
101: Blockchain network
110-1~110-8: nodes
120-1, 120-2: hardware
130-1, 130-2: processor
120: computer

Claims (15)

Blockchain network; And
Including a first node, a second node, and a third node connected to each other through the blockchain network,
The first node,
Receive operations generated by smart contracts running on the computer,
Transmit the operation to the second node and the third node,
Among the second node and the third node, the second node corresponding to the turn of generating a block to be included in the block chain,
Write the operation to the block,
Transmitting the block including the operation to the first node and the third node,
Each of the first node and the third node,
Determine whether the operation included in the block is an SQL query operation,
When the operation is the SQL query operation, an operation corresponding to the SQL query operation is performed on a memory database stored in a volatile memory, and then an operation corresponding to the SQL query operation is performed on a file database stored in a nonvolatile memory,
The memory database is a blockchain system created from the file database. The method of claim 1,
When the operation is a block chain operation, each of the first node and the third node processes the block according to the block chain operation. The method of claim 2,
When the operation is the block chain operation, each of the first node and the third node stores the processing result for the block in a file-based data storage,
The file-based data storage is a blockchain system different from the memory database and the file database. The method of claim 2, wherein each of the first node and the third node,
It is determined whether the file database exists in the nonvolatile memory,
When the file database does not exist in the nonvolatile memory, the file database is created, and the memory database generated from the file database is loaded into the volatile memory,
Blockchain system for loading the memory database generated from the file database existing in the nonvolatile memory into the volatile memory when the file database exists in the nonvolatile memory. The method of claim 1,
When the SQL query operation includes a SELECT query,
The first node searches for data corresponding to the SELECT query from a first memory database stored in a first volatile memory included in the first node, and transmits the searched data to the computer,
The first memory database is a blockchain system created from a first file database stored in a first nonvolatile memory included in the first node. In the operating method of a blockchain system including nodes connected to each other through a blockchain network,
Receiving an operation generated by a smart contract executed by a first node among the nodes;
Transmitting the operation received by the first node to the remaining nodes among the nodes;
Among the nodes, a second node corresponding to the turn of generating a block to be included in the block chain writes the operation to the block, and the block including the operation from among the nodes other than the second node Transferring to;
Determining whether the operation included in the block by each of the nodes includes an SQL query;
When the operation does not include the SQL query, each of the nodes processing the block according to the operation; And
And when the operation includes the SQL query, each of the nodes performing an operation corresponding to the SQL query on a SQL database. The method of claim 6,
The SQL database includes a memory database stored in a volatile memory and a file database stored in a nonvolatile memory,
The step of performing the operation corresponding to the SQL query on the SQL database,
After performing an operation corresponding to the SQL query on the memory database, performing an operation corresponding to the SQL query on the file database,
The memory database is a method of operating a blockchain system created from the file database. The method of claim 7,
When the above SQL query is a SELECT query,
The method of operating a blockchain system further comprising the step of the first node searching for data from the memory database according to the SELECT query and transmitting the searched data to the computer. The method of claim 7,
Each of the nodes,
Determining whether the file database exists in the nonvolatile memory;
When the file database does not exist in the nonvolatile memory, creating the file database and loading the memory database generated from the file database into the volatile memory; And
And when the file database exists in the nonvolatile memory, loading the memory database generated from the file database existing in the nonvolatile memory into the volatile memory. A computer program associated with a first node and stored in a computer-readable storage medium for processing an operation including an SQL query,
The computer program,
Receiving the operation generated by a smart contract executed on a computer;
Transmitting the operation to second nodes;
Receiving a block including the operation transmitted from a node corresponding to a turn to generate a block to be included in the block chain among the second nodes;
Determining whether the operation included in the received block includes an SQL query;
Processing the block according to the operation when the operation included in the block does not include the SQL query; And
A computer program stored in a computer-readable storage medium comprising the step of performing an operation corresponding to the SQL query to an SQL database when the operation included in the block includes the SQL query. The method of claim 9, wherein performing the operation corresponding to the SQL query on the SQL database,
Performing an operation corresponding to the SQL query on a memory database stored in a volatile memory disposed in the first node; And
And performing an operation corresponding to the SQL query on a file database stored in a nonvolatile memory disposed in the first node,
The SQL database includes the memory database and the file database,
The memory database is a computer program stored in a computer-readable storage medium generated from the file database. In the method of providing blockchain services and SQL services using a computer running a smart contract that creates an operation and nodes included in the blockchain system,
Determining whether an operation included in the block by each of the nodes is a block chain operation or an SQL query operation; And
When the operation is the block chain operation, each of the nodes performs an operation corresponding to the block chain operation, and when the operation is the SQL query operation, each of the nodes performs an operation corresponding to the SQL query operation. A method of providing blockchain services and SQL services, including steps to perform on databases. The method of claim 12,
The operation corresponding to the block chain operation is an operation of processing electronic money,
The operation corresponding to the SQL query operation is a method of providing a blockchain service and an SQL service, which are operations corresponding to SQL commands. The method of claim 12,
The operation corresponding to the block chain operation is an operation of processing electronic money,
When a first node among the nodes receives the operation output from the computer, and the operation includes a SELECT query,
The method of providing the above service,
Retrieving, by the first node, data corresponding to the SELECT query from a memory database of the SQL database; And
The method of providing a block chain service and SQL service further comprising the step of transmitting the data retrieved by the first node to the computer. The method of claim 12,
The operation corresponding to the block chain operation is an operation of processing electronic money,
When the SQL database included in each of the nodes includes a memory database stored in a volatile memory and a file database stored in a nonvolatile memory,
The operation corresponding to the above SQL query operation,
An operation corresponding to the SQL query operation is performed on the memory database,
After the block is agreed upon by more than half of the nodes among the nodes, an operation corresponding to the SQL query operation is performed on the file database.

Images