Abstract: An index table update method, and a device are presented. The method includes adjusting an index density of a second index table in a memory when determining that storage space occupied by the second index table reaches an upper limit or a lower limit of a preset range, where the index density of the second index table is a ratio of a quantity of index records included in the second index table to a quantity of index records included in a first index table in an external storage; and selecting an index record from the first index table according to the adjusted index density, and updating the second index table using the selected index record. In this way, the second index table is dynamically adjusted according to a storage space occupation status of the memory, and system performance and retrieval efficiency are further ensured.

Abstract: In a transaction processing method performed by a database server, the server receives a transaction request to perform an operation on multiple data partitions of the database. The server obtains data snapshots of the multiple data partitions, and confirms that the data snapshots meet a consistency requirement. The Server performs the operation of the first transaction on the data snapshots, and then write the data of the data snapshots after the operation to the multiple data partitions.

Abstract: An index table update method, and a device are presented. The method includes adjusting an index density of a second index table in a memory when determining that storage space occupied by the second index table reaches an upper limit or a lower limit of a preset range, where the index density of the second index table is a ratio of a quantity of index records included in the second index table to a quantity of index records included in a first index table in an external storage; and selecting an index record from the first index table according to the adjusted index density, and updating the second index table using the selected index record. In this way, the second index table is dynamically adjusted according to a storage space occupation status of the memory, and system performance and retrieval efficiency are further ensured.