WO2021238341A1

WO2021238341A1 - Method and device for updating data in database, and electronic device

Info

Publication number: WO2021238341A1
Application number: PCT/CN2021/080734
Authority: WO
Inventors: 张健
Original assignee: 北京金山云网络技术有限公司
Priority date: 2020-05-28
Filing date: 2021-03-15
Publication date: 2021-12-02
Also published as: CN111639087B; CN111639087A

Abstract

A method and device for updating data in a database, and an electronic device, related to the technical field of cloud computing, comprising: acquiring a data read/write instruction generated when executing a read/write operation with respect to a target data page in a database (S202); when the data read/write instruction is acquired, determining whether the target data page satisfies a data updating criterion (S204), where the data updating criterion is a criterion for updating the data content in the target data page; and if the target data page satisfies the data updating criterion, then updating the data content in the target data page (S206). Solved is the technical problem of slow efficiency of an existing technical solution when modifying data in a database.

Description

Method, device and electronic equipment for updating data in database

This disclosure claims the priority of a Chinese patent application filed with the Chinese Patent Office on May 28, 2020, the application number is 202010471948.0, and the invention title is "Data Update Method, Apparatus and Electronic Equipment in Database", the entire content of which is incorporated by reference In this disclosure.

Technical field

The present disclosure relates to the technical field of databases, and in particular to a method, device and electronic equipment for updating data in a database.

Background technique

In the new database architecture that supports the separation of computing and storage, the physical replication mode is generally adopted between the master and the slave, that is: the data synchronized between the database master database and the database slave database is modified data, that is, the modification operation on the master database involves The data page is transferred to the slave library for data overwriting.

The physical replication synchronization method for database column operations involves changes in database table metadata and changes in existing data in the database table. For example, if you add a column to a database table, you need to add a column of records to the data recorded in each row of the table. At the same time, you also need to modify the schema information of the table. The amount of data involved is very large. After the master library is modified, all modified data pages need to be synchronously transmitted to the slave library for mapping writing.

That is to say, in related technical solutions, when the amount of data in the database table is particularly large, the main database operation time is long, the data update efficiency is low, the modified data page records of the physical copy transmission are huge, and the waiting time of the application client is very long. Timeouts can easily occur.

Summary of the invention

In view of this, the purpose of the embodiments of the present disclosure is to provide a method, device, and electronic device for updating data in a database, so as to improve the efficiency of changing data in the database.

In a first aspect, an embodiment of the present disclosure provides a method for updating data in a database, including: obtaining data read and write instructions generated when a read and write operation is performed on a target data page in the database; after obtaining the data read and write instructions , Determine whether the target data page meets the data update condition, wherein the data update condition is a condition for updating the data content in the target data page; if the target data page meets the data update condition, then The data content in the target data page is updated.

In one embodiment, determining whether the target data page satisfies the data update condition includes: obtaining the maximum log sequence number of the target data page in the target data page; determining that the target data page corresponds to the target data page in the target system table The target log sequence number of the target log, wherein the target system table contains the latest metadata information of each data table in the database, and the log sequence number of the operation log corresponding to the latest metadata information; if the maximum log sequence If the number and the target log sequence number are not the same, it is determined that the target data page satisfies the data update condition, and the data content in the target data page is updated.

In one embodiment, updating the data content in the target data page includes: updating the data in the target data page according to the latest metadata information of the target data table in the target system table.

In one embodiment, determining the target log sequence number corresponding to the target data page in the target system table includes: determining the table space ID information of the target data page; searching the target system table for the table space ID The log sequence number corresponding to the information, and the found log sequence number is used as the log sequence number.

In one embodiment, the method further includes: when a metadata modification operation on the target data table is detected, generating an operation log corresponding to the metadata modification operation to obtain a target operation log; The operation log updates the target system table.

In one embodiment, updating the target system table based on the target operation log includes: determining a log sequence number of the target operation log and metadata information corresponding to the target operation log; and storing the target log sequence The number is updated to the log sequence number of the target operation log; the latest metadata information of the target system table is updated to the metadata information corresponding to the target operation log.

In one embodiment, the metadata modification operation includes: a deletion operation on a data column in the target data table, and/or a new operation on a data column in the target data table.

In one embodiment, the method further includes: if the database is the master database, updating the data in the data page corresponding to the at least one database slave database; and the corresponding data in the at least one database slave database After the update of the data in the corresponding data page is completed, the end of the update information is returned to the user.

In a second aspect, an embodiment of the present disclosure provides an apparatus for updating data in a database, including: an acquiring unit, configured to acquire data read and write instructions generated when a read and write operation is performed on a target data page in the database; and a judging unit, configured to After obtaining the data read and write instruction, it is determined whether the target data page satisfies the data update condition, wherein the data update condition is a condition for updating the data content in the target data page; an update unit, setting To update the data content in the target data page if the target data page meets the data update condition.

In a third aspect, an embodiment of the present disclosure provides an electronic device, including a memory, a processor, and a computer program stored on the memory and capable of running on the processor. When the processor executes the computer program, The method described in any one of the above-mentioned first aspects is implemented.

In a fourth aspect, embodiments of the present disclosure provide a computer-readable medium having non-volatile program code executable by a processor, and the program code causes the processor to execute any one of the above-mentioned aspects of the first aspect. method.

In the embodiment of the present disclosure, firstly, the data read and write instructions generated when the target data page in the database is read and written are acquired. After the data read and write instructions are acquired, it is determined whether the target data page satisfies the data update condition, if When the data update condition is met, the data content in the target data page is updated. It can be seen from the above description that in the embodiments of the present disclosure, by updating the target data page that meets the update condition when the data read and write instruction is detected, the data change efficiency in the database can be improved, and the data in the database can be changed. The technical solution is the technical problem of slow efficiency when changing the data in the database.

Other features and advantages of the embodiments of the present disclosure will be described in the following description, and partly become obvious from the description, or understood by implementing the embodiments of the present disclosure. The purpose and other advantages of the embodiments of the present disclosure are realized and obtained by the structures specifically pointed out in the specification, claims and drawings.

In order to make the above-mentioned objectives, features and advantages of the embodiments of the present disclosure more obvious and understandable, preferred embodiments are described in detail below in conjunction with accompanying drawings.

Description of the drawings

In order to more clearly illustrate the technical solutions in the specific embodiments of the present disclosure or related technologies, the following will briefly introduce the drawings that need to be used in the specific embodiments or related technical descriptions. Obviously, the drawings in the following description are For some of the embodiments of the present disclosure, for those of ordinary skill in the art, other drawings may be obtained based on these drawings without creative work.

Figure 1 is a flowchart of a physical database replication method of related technologies;

Fig. 2 is a flowchart of a method for updating data in a database according to an embodiment of the present disclosure;

Fig. 3 is a flowchart of another method for updating data in a database according to an embodiment of the present disclosure;

Fig. 4 is a schematic diagram of a data update device in a database according to an embodiment of the present disclosure;

Fig. 5 is a schematic diagram of an electronic device according to an embodiment of the present disclosure.

Detailed ways

In order to make the objectives, technical solutions, and advantages of the embodiments of the present disclosure clearer, the technical solutions of the embodiments of the present disclosure will be described clearly and completely in conjunction with the accompanying drawings. Obviously, the described embodiments are a part of the embodiments of the present disclosure. Not all examples. Based on the embodiments in the present disclosure, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the protection scope of the present disclosure.

When updating column data in the database, as shown in Figure 1, the related technical solutions are described as follows:

(1) The application client initiates the operation of adding/deleting database table columns to the main database of the database;

(2) The main database of the database completes the operation of the database table columns and modifies the schema metadata of the table;

(3) The database master database synchronizes the modification records involved in the operation to the database slave database through physical replication;

(4) The database replays the modified page data synchronized from the main database from the database;

(5) The database returns the ACK confirmation character of the physical copy result of the main database from the database;

(6) The main database of the database returns the ACK confirmation character of the application APP result.

For related technologies, when the data volume of the database table is particularly large, the main database operation time is long, the modified data page records of the physical copy transmission are huge, the waiting time of the application APP will be very long, and it is prone to timeout.

Based on this, in the embodiment of the present disclosure, a method for updating data in a database is proposed. This method can improve the database by updating the target data page that meets the update condition when the data read and write instruction is detected. The change efficiency of data in the database, and then solve the technical problem of slow efficiency when changing the data in the database through related technical solutions. The method will be described below in conjunction with an embodiment.

Example one:

According to an embodiment of the present disclosure, an embodiment of a method for updating data in a database is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and Although the logical sequence is shown in the flowchart, in some cases, the steps shown or described can be performed in a different order than here.

Fig. 2 is a flowchart of a method for updating data in a database according to an embodiment of the present disclosure. As shown in Fig. 2, the method includes the following steps:

Step S202: Obtain data read and write instructions generated when a read and write operation is performed on the target data page in the database.

The database architecture includes a database master database and a database slave database. In step S202, the database may be a database master database or a database slave database, which is not specifically limited in the embodiment of the present disclosure. In the embodiment of the present disclosure, the data read and write instruction may be an instruction sent by the user to the database through the client to read and write the data page of the data table in the database. Among them, the database (database master library and database slave library) contains multiple data tables, and the data in each data table exists in multiple data pages.

Step S204, after obtaining the data read and write instruction, determine whether the target data page meets the data update condition, where the data update condition is a condition for updating the data content in the target data page.

It can be known from the above description that in the related technology, after the application initiates the operation of adding/deleting database table columns to the database main database, the database main database modifies the column data in the data table to obtain the updated database main database. When an application accesses the main database of the database, you can perform the corresponding read and write operations in the main database after the update. However, when the amount of data in the database table is particularly large, the main database operation time is long, and the physical replication and transmission The modified data page has huge records, and the application APP waits for a long time, and it is prone to timeout.

Based on this, in the embodiments of the present disclosure, passive access to the database can be set to trigger data changes, that is, after the data read and write instructions are obtained, it is determined whether the target data page in the database meets the data update condition. Wherein, the data update condition is determined based on the log serial number of the target data page and is set as a condition for judging whether to update the data content in the target data page. Through the above processing method, the database does not need to modify the data in the database in real time after executing the DDL (Data Destination Language) operation, and the data can be distributed and updated through passive access to reduce the transient pressure of the database DDL operation and shorten the response of the database time.

In step S206, if the target data page meets the data update condition, the data content in the target data page is updated.

In one embodiment, step S206, judging whether the target data page meets the data update condition, includes the following steps:

Step S2061: Obtain the maximum log sequence number of the target data page in the target data page;

Step S2062: Determine the target log sequence number corresponding to the target data page in the target system table, where the target system table contains the latest metadata information of each data table in the database, and the log sequence number of the operation log corresponding to the latest metadata information ；

In step S2063, if the maximum log sequence number and the target log sequence number are not the same, it is determined that the target data page meets the data update condition, and the data content in the target data page is updated.

In the embodiment of the present disclosure, a system table Schema_version_table (abbreviated as SVT), namely the target system table (abbreviated as SVT table) is added in advance. Set the new schema information of the record table and its corresponding redo log in the SVT table to form a triplet {N, LSN_N, new schema description}, where N is the table space ID and LSN_N is the log sequence number corresponding to the MLOG_TRX_DDL log LSN.

For example, when a DDL operation is performed on a data table in the database, a redo log MLOG_TRX_DDL will be generated. In the embodiment of the present disclosure, the log sequence number of the redo log and the new schema description corresponding to the DDL operation (ie , The latest metadata information), and the table space ID is recorded as a triple in the SVT table, where the table space ID is the table space ID information of each data table in the database. It should be noted that, in the embodiment of the present disclosure, the DDL operation is an operation of deleting or adding a column of a data table in the database.

That is to say, in the embodiment of the present disclosure, the SVT table records the new schema description (the latest metadata information) of each data table in the database after the most recent DDL operation is performed, and the operation log corresponding to the new schema description (For example, redo log) log sequence number LSN.

Based on this, in the embodiment of the present disclosure, since the log sequence number of the data page is recorded in the data page, the maximum log sequence number of the target data page can be obtained in the target data page first, and the maximum log sequence number Indicates the log sequence number of the redo log corresponding to the latest DDL operation on the target data page.

After that, in the SVT table, determine the target log sequence number corresponding to the target data page. In one embodiment, the target log sequence number can be determined by the table space ID. In an embodiment, the table space ID information of the target data page may be determined. For example, the determined table space ID information of the target data page is N. Next, look up the log sequence number corresponding to the table space ID information in the target system table, and use the found log sequence number as the log sequence number. It can be seen from the above description that there are multiple triples in the SVT table, and each triple includes: the log sequence number of the redo log, and the new schema description (ie, the latest metadata information) corresponding to the DDL operation, and Table space ID. Based on this, in the implementation of the present disclosure, the target log sequence number corresponding to the table space ID information of the target data table can be searched in the SVT table, for example, N. After the target log sequence number is found, the maximum log sequence number can be compared with the target log sequence number. If the maximum log sequence number and the target log sequence number are inconsistent, it is determined that the target data page meets the data update condition.

It should be noted that what is recorded in the SVT table is the new schema description of the latest DDL operation and its corresponding log sequence number. Therefore, if the maximum log sequence number is inconsistent with the target log sequence number, it indicates that the target data page is being executed After the latest DDL operation, the corresponding data content in the target data page has not been updated. Therefore, the target data page satisfies the data update condition.

After it is determined that the target data page meets the data update condition, the data in the target data page can be updated according to the latest metadata information of the target data table in the target system table. In one embodiment, the corresponding triplet can be determined in the SVT table according to the table space ID information N, and then the latest metadata information is determined in the triplet, and the target data page is updated according to the latest metadata information. The data in is updated.

It can be seen from the above description that in the embodiments of the present disclosure, the above-mentioned processing method enables the database to perform DDL operations without real-time modification of the data in the database. The data can be distributed and updated through passive access to reduce the instantaneous pressure of database DDL operations and shorten The response time of the database.

In the embodiment of the present disclosure, if the database is the database master database, the data in the corresponding data page in the at least one database slave database is updated.

It should be noted that in the embodiment of the present disclosure, the database master database and the database slave database each correspond to a target system table SVT table, and the target system table contains the triplet data corresponding to each data table in the database: {N ,LSN_N,new schema description}, where N is the tablespace ID, and LSN_N is the MLOG_TRX_DDL log corresponding to the log sequence number LSN. That is, in the embodiment of the present disclosure, after the data content in the target data page in the database master library is updated, the data in the corresponding data page can also be updated according to the target system table of the database slave library. And after the update of the data in the corresponding data page in the at least one database from the database is completed, the end of the update information is returned to the user.

In one embodiment, the method further includes the following process:

Step S1, when the metadata modification operation on the target data table is detected, an operation log corresponding to the metadata modification operation is generated to obtain the target operation log; wherein, in the embodiment of the present disclosure, the metadata modification operation includes: The deletion operation of the data column in the data table, and/or the new operation of the data column in the target data table.

Step S2, update the target system table based on the target operation log.

It should be noted that in the embodiment of the present disclosure, step S1 and step S2 can be performed before step S202 to step S206, and can also be performed after step S202 to step S206, which is not specifically limited in the embodiment of the present disclosure.

From the above description, it can be known that in the embodiment of the present disclosure, a new system table, namely, the target system table (SVT table for short) is added in advance. Set the new schema information of the record table and its corresponding redo log in the SVT table to form a triplet {N, LSN_N, new schema description}, where N is the table space ID, and LSN_N is the log sequence number corresponding to the MLOG_TRX_DDL log LSN.

In the embodiment of the present disclosure, when the database detects a metadata modification operation on the target data table (that is, a DDL operation), it generates a redo log (that is, a target operation log) corresponding to the metadata modification operation, and then, The target system table can be updated based on the target operation log.

In an embodiment, the above update process can be described as:

First, determine the log sequence number of the target operation log and the metadata information corresponding to the target operation log;

Second, update the target log sequence number to the log sequence number of the target operation log;

Finally, the latest metadata information of the target system table is updated to the metadata information corresponding to the target operation log.

In one embodiment, after detecting the user's latest metadata modification operation on the target data table, the operation log corresponding to the latest metadata modification operation, that is, the target operation log, may be generated. Then, update the target log sequence number in the target system table (that is, the log sequence number of the operation log corresponding to the last metadata modification operation) to the log sequence number of the target operation log (that is, the log sequence number of the latest metadata modification operation). The log sequence number of the operation log). At the same time, the latest metadata information in the target system table (that is, the metadata information corresponding to the last metadata modification operation) can be updated to the metadata information corresponding to the target operation log (that is, the latest metadata modification operation corresponds to Metadata information).

It should be noted that, in the embodiments of the present disclosure, the databases described in the above embodiments can be a database master database and a database slave database. Both the database master database and the database slave database correspond to a target system table SVT table. The table contains the triplet data corresponding to each data table in the database: {N, LSN_N, new schema description}, where N is the table space ID, and LSN_N is the log sequence number LSN corresponding to the MLOG_TRX_DDL log.

That is to say, in the embodiment of the present disclosure, the update process of the target system table of the database master library is the same as the update process of the target system table of the database slave library, and will not be described here.

In one embodiment, after the database master database updates the target system table according to the above-described process, it sends an update completion message to the database slave database. After that, the database slave database performs the update on the target system table according to the process described above. renew. After both the database master library and the database slave database have performed the update operation, the update complete message is returned to the client.

It can be seen from the above description that, in the embodiment of the present disclosure, when performing DDL operations (ie, metadata modification operations) on the database, the database master database or the database slave database only needs to modify the metadata information of the target system table, without synchronization All changed page data greatly reduces the amount of data synchronized between the master and slave libraries.

Embodiment two:

Fig. 3 is a flowchart of another method for updating data in a database according to an embodiment of the present disclosure. As can be seen from Fig. 3, the processing procedure of the method is described as follows:

(1) Record the LSN mark when the data page is modified in the data page, assuming it is LSN x;

(2) When the data table in the database performs a DDL operation (that is, a metadata modification operation), a redo log MLOG_TRX_DDL is generated;

(3) The new schema information (that is, the latest metadata information) of the SVT (Schema_version_table) recording table and its corresponding redo log form a triple {N, LSN_N, new schema information}. Among them, N is the table space ID, LSN_N is the MLOG_TRX_DDL log corresponding to the LSN; SVT table is a new target system table (abbreviated as SVT table) in the database;

(4) Obtain the data read and write instructions generated when performing read and write operations on data pages in the database;

(5) Compare the LSN x of the data page with the LSN number corresponding to the schema of the table recorded in the SVT; if the LSN x of the data page and the LSN number LSN_N corresponding to the schema of the table recorded in the SVT are not equal (for example, LSN_N>LSN x ), the data in the data page is modified according to the new schema information to generate a new data page;

Among them, in the embodiment of the present disclosure, when the database replays the MLOG_TRX_DDL log from the library, the corresponding SVT table will also be updated. Both the main database and the slave database correspond to a target system table SVT table.

Embodiment three:

The embodiment of the present disclosure also provides a device for updating data in a database. The device for updating data in the database is mainly configured to execute the method for updating data in the database provided by the above-mentioned content of the embodiment of the present disclosure. The update device will be introduced in detail.

Fig. 4 is a schematic diagram of a data update device in a database according to an embodiment of the present disclosure. As shown in Fig. 4, the data update device in the database mainly includes an acquisition unit 10, a judgment unit 20 and an update unit 30, wherein:

The acquiring unit 10 is configured to acquire data read and write instructions generated when a read and write operation is performed on a target data page in the database;

The judging unit 20 is configured to judge whether the target data page meets the data update condition after obtaining the data read and write instruction, where the data update condition is a condition for updating the data content in the target data page;

The update unit 30 is configured to update the data content in the target data page if the target data page meets the data update condition.

In the embodiment of the present disclosure, firstly, the data read and write instructions generated when the target data page in the database is read and written are acquired. After the data read and write instructions are acquired, it is determined whether the target data page satisfies the data update condition, if When the data update condition is met, the data content in the target data page is updated. It can be seen from the above description that in the embodiments of the present disclosure, by updating the target data page that meets the update condition when the data read and write instruction is detected, the data change efficiency in the database can be improved, and the data in the database can be changed. The technical solution is a slow technical problem when changing the data in the database.

In one embodiment, the judging unit is configured to: obtain the maximum log sequence number of the target data page in the target data page; determine the target log sequence number corresponding to the target data page in the target system table, wherein the target system table contains the database The latest metadata information of each data table in each data table, and the log sequence number of the operation log corresponding to the latest metadata information; if the maximum log sequence number and the target log sequence number are not the same, it is determined that the target data page meets the data update conditions, and the target The data content in the data page is updated.

In one embodiment, the judging unit is further configured to update the data in the target data page according to the latest metadata information of the target data table in the target system table.

In an embodiment, the judging unit is further configured to: determine the table space ID information of the target data page; search for the log sequence number corresponding to the table space ID information in the target system table, and use the found log sequence number as the log sequence No.

In one embodiment, the device is further configured to: when a metadata modification operation on the target data table is detected, generate an operation log corresponding to the metadata modification operation to obtain the target operation log; and compare the target system table based on the target operation log Update.

In one embodiment, the device is further configured to: determine the log sequence number of the target operation log and the metadata information corresponding to the target operation log; update the target log sequence number to the log sequence number of the target operation log; The latest metadata information is updated to the metadata information corresponding to the target operation log.

In one embodiment, the device is further configured to: if the database is the database master, update the data in the data page corresponding to the at least one database slave library; the data page corresponding to the at least one database slave library After the update of the data in the data is completed, the end of the update information is returned to the user.

The implementation principles and technical effects of the device provided in the embodiments of the present disclosure are the same as those of the foregoing method embodiments. For a brief description, for the parts not mentioned in the device embodiments, please refer to the corresponding content in the foregoing method embodiments.

Embodiment four:

5, an embodiment of the present disclosure also provides an electronic device 100, including: a processor 50, a memory 51, a bus 52 and a communication interface 53, the processor 50, the communication interface 53, and the memory 51 are connected by the bus 52; the processor 50 It is configured to execute an executable module stored in the memory 51, such as a computer program.

The memory 51 may include a high-speed random access memory (RAM, Random Access Memory), and may also include a non-volatile memory (non-volatile memory), such as at least one disk memory. The communication connection between the system network element and at least one other network element is realized through at least one communication interface 53 (which may be wired or wireless), and the Internet, a wide area network, a local network, a metropolitan area network, etc. may be used.

The bus 52 may be an ISA bus, a PCI bus, an EISA bus, or the like. The bus can be divided into address bus, data bus, control bus and so on. For ease of presentation, only one bidirectional arrow is used to indicate in FIG. 5, but it does not mean that there is only one bus or one type of bus.

Wherein, the memory 51 is configured to store a program, and the processor 50 executes the program after receiving an execution instruction. The method executed by the flow process definition apparatus disclosed in any of the foregoing embodiments of the present disclosure can be applied to the processor 50, Or implemented by the processor 50.

The processor 50 may be an integrated circuit chip with signal processing capabilities. In the implementation process, the steps of the above method can be completed by hardware integrated logic circuits in the processor 50 or instructions in the form of software. The aforementioned processor 50 may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU for short), a network processor (Network Processor, NP), etc.; it may also be a digital signal processor (Digital Signal Processing, DSP for short), etc. ), Application Specific Integrated Circuit (ASIC for short), Field-Programmable Gate Array (FPGA for short) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components. The methods, steps, and logical block diagrams disclosed in the embodiments of the present disclosure can be implemented or executed. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor or the like. The steps of the method disclosed in the embodiments of the present disclosure may be directly embodied as being executed and completed by a hardware decoding processor, or executed and completed by a combination of hardware and software modules in the decoding processor. The software module can be located in a mature storage medium in the field, such as random access memory, flash memory, read-only memory, programmable read-only memory, or electrically erasable programmable memory, registers. The storage medium is located in the memory 51, and the processor 50 reads the information in the memory 51, and completes the steps of the above method in combination with its hardware.

In addition, in the description of the embodiments of the present disclosure, unless otherwise clearly specified and limited, the terms "installed", "connected", and "connected" should be understood in a broad sense, for example, they may be fixed connections or detachable connections. , Or integrally connected; it can be a mechanical connection or an electrical connection; it can be directly connected or indirectly connected through an intermediate medium, and it can be the internal communication between two components. For those of ordinary skill in the art, the specific meanings of the above-mentioned terms in the embodiments of the present disclosure can be understood in specific situations.

In the description of the embodiments of the present disclosure, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer" The orientation or positional relationship indicated by "" is based on the orientation or positional relationship shown in the drawings, and is only for the convenience of describing the embodiments of the present disclosure and simplifying the description, and does not indicate or imply that the device or element referred to must have a specific orientation, It is constructed and operated in a specific orientation, and therefore cannot be understood as a limitation of the present disclosure. In addition, the terms "first", "second", and "third" are only provided for descriptive purposes, and cannot be understood as indicating or implying relative importance.

The computer program product for performing a method for updating data in a database provided by an embodiment of the present disclosure includes a computer-readable storage medium storing a non-volatile program code executable by a processor, and instructions included in the program code can be set to execute the foregoing method For the specific implementation of the method in the embodiment, please refer to the method embodiment, which will not be repeated here.

Those skilled in the art can clearly understand that, for the convenience and conciseness of description, the specific working process of the above-described system, device, and unit can refer to the corresponding process in the foregoing method embodiment, which will not be repeated here.

In the several embodiments provided in the present disclosure, it should be understood that the disclosed system, device, and method may be implemented in other ways. The device embodiments described above are merely illustrative. For example, the division of units is only a logical function division, and there may be other divisions in actual implementation. For example, multiple units or components can be combined or integrated. To another system, or some features can be ignored, or not implemented. In addition, the displayed or discussed mutual couplings or direct couplings or communication connections may be indirect couplings or communication connections between devices or units through some communication interfaces, and may be in electrical, mechanical or other forms.

The units described as separate components may or may not be physically separate, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the objectives of the solutions of the embodiments.

In addition, the functional units in the various embodiments of the present disclosure may be integrated into one processing unit, or each unit may exist alone physically, or two or more units may be integrated into one unit.

If the function is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a non-volatile computer readable storage medium executable by a processor. Based on this understanding, the technical solution of the present disclosure essentially or the part that contributes to the related technology or the part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including several The instructions are used to make a computer device (which may be a personal computer, a server, or a network device, etc.) execute all or part of the steps of the methods of the various embodiments of the present disclosure. The aforementioned storage media include: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic disks or optical disks and other media that can store program codes. .

Finally, it should be noted that the above embodiments are only specific implementations of the present disclosure, which are used to illustrate the technical solutions of the present disclosure, rather than limit it. The protection scope of the present disclosure is not limited thereto, although referring to the foregoing embodiments The present disclosure has been described in detail, and those of ordinary skill in the art should understand that any person skilled in the art can still modify or modify the technical solutions described in the foregoing embodiments within the technical scope disclosed in the present disclosure. It is easy to think of changes, or equivalent replacements of some of the technical features; and these modifications, changes or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present disclosure, and should be covered by the protection of the present disclosure Within range. Therefore, the protection scope of the present disclosure should be subject to the protection scope of the claims.

Industrial applicability

Based on the method, device and electronic device for updating data in the database provided by the embodiments of the present disclosure, by updating the target data page that meets the update condition when the data read and write instruction is detected, the data change in the database can be improved. Efficiency, and then solve the technical problem of slow efficiency when changing data in the database through related technical solutions.

Claims

A method for updating data in a database, including:

Obtain the data read and write instructions generated when the target data page in the database is read and written;

After obtaining the data read and write instruction, determine whether the target data page meets a data update condition, where the data update condition is a condition for updating data content in the target data page;

If the target data page meets the data update condition, the data content in the target data page is updated.
The method according to claim 1, wherein determining whether the target data page satisfies a data update condition comprises:

Acquiring the maximum log sequence number of the target data page in the target data page;

Determine the target log sequence number corresponding to the target data page in the target system table, where the target system table contains the latest metadata information of each data table in the database, and the operation corresponding to the latest metadata information The log sequence number of the log;

If the maximum log sequence number and the target log sequence number are not the same, it is determined that the target data page meets the data update condition, and the data content in the target data page is updated.
The method according to claim 2, wherein updating the data content in the target data page comprises:

The data in the target data page is updated according to the latest metadata information of the target data table in the target system table.
The method according to claim 2, wherein determining the target log sequence number corresponding to the target data page in the target system table comprises:

Determine the table space ID information of the target data page;

Look up the log sequence number corresponding to the table space ID information in the target system table, and use the searched log sequence number as the log sequence number.
The method according to claim 2, wherein the method further comprises:

When a metadata modification operation on the target data table is detected, an operation log corresponding to the metadata modification operation is generated to obtain a target operation log;

The target system table is updated based on the target operation log.
The method according to claim 5, wherein updating the target system table based on the target operation log comprises:

Determining the log sequence number of the target operation log and metadata information corresponding to the target operation log;

Updating the target log sequence number to the log sequence number of the target operation log;

The latest metadata information of the target system table is updated to the metadata information corresponding to the target operation log.
The method according to claim 5, wherein the metadata modification operation comprises:

Delete operations on data columns in the target data table, and/or add new operations on data columns in the target data table.
The method according to claim 2, wherein the method further comprises:

If the database is a database master database, update the data in the corresponding data page of at least one database slave database;

After the update of the data in the corresponding data page of the at least one database from the database is completed, the update completion information is returned to the user.
A device for updating data in a database includes:

The acquiring unit is configured to acquire the data read and write instructions generated when the target data page in the database is read and written;

The judging unit is configured to judge whether the target data page satisfies a data update condition after obtaining the data read and write instruction, wherein the data update condition is a condition for updating data content in the target data page ；

The update unit is configured to update the data content in the target data page if the target data page meets the data update condition.
An electronic device, comprising a memory, a processor, and a computer program stored on the memory and capable of running on the processor, and the processor implements the aforementioned claims 1-8 when the processor executes the computer program Any of the methods described.
A computer readable medium having non-volatile program code executable by a processor, the program code causing the processor to execute the method described in any one of the foregoing claims 1-8.