Abstract: Methods and systems are described for managing a shared database. One or more processing nodes may access a shared database. A common log node may manage the shared database. The common log node may validate database operations requested by the one or more processing nodes. During validation, the common log node may detect conflicts that occur between database operations requested by the one or more processing nodes.

Abstract: This application provides a data processing method and apparatus. The method includes: receiving, by a master storage node, information that is about a first transaction and that is sent by a read-write node, where the information about the first transaction is used to request to perform a write operation on first data stored on the master storage node; determining, by the master storage node, the first data based on the information about the first transaction, and executing the first transaction; generating, by the master storage node, first transaction status metadata when the first transaction ends, where the first transaction status metadata includes identification information of expired data and identification information of the first transaction; and sending, by the master storage node, the first transaction status metadata to at least one read-only node. According to the data processing method and apparatus, a read delay of a read-only node can be eliminated.

Abstract: This application provides a data processing method and apparatus. The method includes: receiving, by a master storage node, information that is about a first transaction and that is sent by a read-write node, where the information about the first transaction is used to request to perform a write operation on first data stored on the master storage node; determining, by the master storage node, the first data based on the information about the first transaction, and executing the first transaction; generating, by the master storage node, first transaction status metadata when the first transaction ends, where the first transaction status metadata includes identification information of expired data and identification information of the first transaction; and sending, by the master storage node, the first transaction status metadata to at least one read-only node. According to the data processing method and apparatus, a read delay of a read-only node can be eliminated.

Abstract: A database system comprises a plurality of servers with data storage. The system holds first and second database tables. Records of the first database table are distributed among the servers according to values of a first distribution column. The servers can receive access requests and log workload data representative of the requests. Based on the workload data, the servers can determine a performance impact associated with columns of the tables and, upon determining that a performance impact associated with one of the columns is greater than a performance impact associated with the first distribution column, the servers can re-distribute the records among the plurality of servers according to values of the second column.

Abstract: Methods and systems are described for managing a shared database. One or more processing nodes may access a shared database. A common log node may manage the shared database. The common log node may validate database operations requested by the one or more processing nodes. During validation, the common log node may detect conflicts that occur between database operations requested by the one or more processing nodes.

Abstract: A database system comprises a plurality of servers with data storage. The system holds first and second database tables. Records of the first database table are distributed among the servers according to values of a first distribution column. The servers can receive access requests and log workload data representative of the requests. Based on the workload data, the servers can determine a performance impact associated with columns of the tables and, upon determining that a performance impact associated with one of the columns is greater than a performance impact associated with the first distribution column, the servers can re-distribute the records among the plurality of servers according to values of the second column.

Abstract: A database system comprises: a data store containing a database comprising records ordered according to a first key field, and a search index of the first key field. The database system also comprises a replica data store, containing a replica copy of the database, with the records ordered according a second key field, different from the first key field, and a search index of the second key field. A server is configured to receive a request to access the records, and to access the records using the replica copy if the request includes a criterion based on values of the second key field.