| 主权项 |
1. A computer-implemented method for updating and inserting data items into a database, wherein a processor executes the method comprising:
fetching data items, each of the data items comprising a key and information, wherein each key comprises a primary key for the respective data item; obtaining each key of the keys of the data items; determining whether each key of the keys is in a delay queue or is in processing, wherein each key in the delay queue is not available for updating in the database and is not available for committing in the database; determining, based on a determination that at least one key of the keys is not in the delay queue and is not in processing, if a process queue exists and, based on a negative determination that the process queue exists, creating the process queue; determining, based on a determination that at least one key of the keys is in the delay queue or is in processing, if the delay queue exists and, based on a negative determination that the delay queue exists, creating the delay queue; for each key of the keys, storing the key of the keys in the process queue when the key of the keys is available for updating in the database or is available for committing in the database, otherwise storing the key of the keys in the delay queue; scheduling an insert/update operation for the database including data items associated with keys in the process queue; executing a batch commit to information of the data items associated with the keys in the process queue to the database; and removing the keys from the process queue associated with the information committed to the database. |
