Method and apparatus for operating database

An apparatus for operating a database, applied to a database server in a distributed database system, comprising:

• at least one processor;
• and
• a memory storing instructions, wherein the instructions when executed by the at least one processor, cause the at least one processor to perform operations, the operations comprising:
• in response to receiving a database operation request sent by a user using a terminal device, the database operation request comprising a database operation statement, a user identifier and a user private key, determining whether a user indicated by the user identifier has a permission to operate data targeted by the database operation statement;
• performing, in response to determining the user having the permission, a digital signature on the database operation statement using the user private key to obtain signature information, generating transaction information according to the database operation statement, the signature information and the user identifier, and storing the generated transaction information into a local transaction information buffer pool;
• and
• selecting, in response to competing for a transaction information block recording permission using a preset consensus algorithm, transaction information in the local transaction information buffer pool to generate a block, parsing and executing a database operation statement in each piece of selected transaction information, concatenating the generated block to a local blockchain, and broadcasting the generated block to other database servers other than the database server in the distributed database system.

A database server, comprising:

• one or more processors;
• and
• a storage device, configured to store one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform operations, the operations comprising:
• in response to receiving a database operation request sent by a user using a terminal device, the database operation request comprising a database operation statement, a user identifier and a user private key, determining whether a user indicated by the user identifier has a permission to operate data targeted by the database operation statement;
• performing, in response to determining the user having the permission, a digital signature on the database operation statement using the user private key to obtain signature information, generating transaction information according to the database operation statement, the signature information and the user identifier, and storing the generated transaction information into a local transaction information buffer pool;
• and
• selecting, in response to competing for a transaction information block recording permission using a preset consensus algorithm, transaction information in the local transaction information buffer pool to generate a block, parsing and executing a database operation statement in each piece of selected transaction information, concatenating the generated block to a local blockchain, and broadcasting the generated block to other database servers other than the database server in a distributed database system.

A non-transitory computer readable medium, storing a computer program, wherein the program, when executed by a processor, implements operations comprising:

• in response to receiving a database operation request sent by a user using a terminal device, the database operation request comprising a database operation statement, a user identifier and a user private key, determining whether a user indicated by the user identifier has a permission to operate data targeted by the database operation statement;
• performing, in response to determining the user having the permission, a digital signature on the database operation statement using the user private key to obtain signature information, generating transaction information according to the database operation statement, the signature information and the user identifier, and storing the generated transaction information into a local transaction information buffer pool;
• and
• selecting, in response to competing for a transaction information block recording permission using a preset consensus algorithm, transaction information in the local transaction information buffer pool to generate a block, parsing and executing a database operation statement in each piece of selected transaction information, concatenating the generated block to a local blockchain, and broadcasting the generated block to other database servers other than the database server in the distributed database system.

A distributed database system, comprising at least one database server, the database server comprising:

• one or more processors;
• and
• a storage device, configured to store one or more programs, wherein the one or more programs, when executed by the one or more processors, cause the one or more processors to perform operations, the operations comprising:
• in response to receiving a database operation request sent by a user using a terminal device, the database operation request comprising a database operation statement, a user identifier and a user private key, determining whether a user indicated by the user identifier has a permission to operate data targeted by the database operation statement;
• performing, in response to determining the user having the permission, a digital signature on the database operation statement using the user private key to obtain signature information, generating transaction information according to the database operation statement, the signature information and the user identifier, and storing the generated transaction information into a local transaction information buffer pool;
• and
• selecting, in response to competing for a transaction information block recording permission using a preset consensus algorithm, transaction information in the local transaction information buffer pool to generate a block, parsing and executing a database operation statement in each piece of selected transaction information, concatenating the generated block to a local blockchain, and broadcasting the generated block to other database servers other than the database server in the distributed database system.