Patent attributes
The present disclosure relates to the field of data processing, disclosing a method and apparatus of inter-databases data updating. A method of inter-databases data updating of the present disclosure includes the steps of generating a third row of data based on data of a first database, where data of at least one column of the third row of data is a no-operation operator, the no-operation operator indicating no data change; and updating a fourth row of data of a second database based on the third row of data, where no-operation operator columns of data of the third row of data are not utilized to update data of corresponding columns of the fourth row of data, non no-operation operator columns of data of the third row of data are utilized to update data of corresponding columns of the fourth row of data. When there is only data change at some columns of a row of data, only data of the columns where data has changed will be updated, decreasing the amount of data to be updated, increasing the updating efficiency of databases, and reducing the waste of resources and time.
