Cassandra database-based distributed transaction management method

• Main Authors: LUO CHUN, CHEN DONG, LI CHUN, ZANG BINGLING, WEI XINGHUA, SHANG SHIYOU, LI JIANHUI, ZHANG WENJIAN, WU YAN
• Format: Patent
• Language: Chinese; English
• Published: 10.12.2021
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention relates to the technical field of database systems, and discloses a cassandra database-based distributed transaction management method, which comprises the following steps of: a data model is established, and a first relation table is established in one or more relation databases to correspond to a second relation table of the cassandra database with the same quantity as the first relation table; in the first relation table and the second relation table, hidden columns are added, and an index is created in the relation database; the transaction operation is recorded, and the new version is synchronized to cassandra; and after the cassandra is written in, all other relational databases are notified to read and apply new transactions, and the data are queried through the index, so that the data in all the relational databases are kept consistent with the data in the cassandra. According to the scheme, a traditional relational database and cassandra can be easily and organically integrated, the sys