SG11201811808VA - Database data modification request processing method and apparatus - Google Patents

Database data modification request processing method and apparatus

Info

Publication number
SG11201811808VA
SG11201811808VA SG11201811808VA SG11201811808VA SG11201811808VA SG 11201811808V A SG11201811808V A SG 11201811808VA SG 11201811808V A SG11201811808V A SG 11201811808VA SG 11201811808V A SG11201811808V A SG 11201811808VA SG 11201811808V A SG11201811808V A SG 11201811808VA
Authority
SG
Singapore
Prior art keywords
data
modification request
log
data modification
request processing
Prior art date
Application number
SG11201811808VA
Inventor
Zhenkun Yang
Fusheng Han
Original Assignee
Alibaba Group Holding Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Alibaba Group Holding Ltd filed Critical Alibaba Group Holding Ltd
Publication of SG11201811808VA publication Critical patent/SG11201811808VA/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14—Error detection or correction of the data by redundancy in operation
    • G06F11/1402—Saving, restoring, recovering or retrying
    • G06F11/1471—Saving, restoring, recovering or retrying involving logging of persistent data for recovery
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/16—Error detection or correction of the data by redundancy in hardware
    • G06F11/20—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements
    • G06F11/2053—Error detection or correction of the data by redundancy in hardware using active fault-masking, e.g. by switching out faulty elements or by switching in spare elements where persistent mass storage functionality or persistent mass storage control functionality is redundant
    • G06F11/2094—Redundant storage or storage space
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2358—Change logging, detection, and notification
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23—Updating
    • G06F16/2379—Updates performed during online database operations; commit processing

Abstract

The present application discloses a database data modification request processing method and apparatus, to resolve a problem in the existing technology that a database data modification request processing mode takes a relatively long time. The method includes following: data request 5 modifying second data in the database to first data and generating a first log and a second log based on the data modification request, where the first log includes the first data, and the second log includes the second data; and returning a modification result that corresponds to the data modification request after performing persistence processing on the first log. 10
SG11201811808VA 2016-07-04 2017-06-27 Database data modification request processing method and apparatus SG11201811808VA (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201610518735.2A CN106897338A (en) 2016-07-04 2016-07-04 A kind of data modification request processing method and processing device for database
PCT/CN2017/090269 WO2018006723A1 (en) 2016-07-04 2017-06-27 Database data modification request processing method and apparatus

Publications (1)

Publication Number Publication Date
SG11201811808VA true SG11201811808VA (en) 2019-02-27

Family

ID=59191565

Family Applications (1)

Application Number Title Priority Date Filing Date
SG11201811808VA SG11201811808VA (en) 2016-07-04 2017-06-27 Database data modification request processing method and apparatus

Country Status (9)

Country Link
US (3) US11106695B2 (en)
EP (1) EP3480705B1 (en)
JP (1) JP6987340B2 (en)
KR (1) KR102248386B1 (en)
CN (1) CN106897338A (en)
MY (1) MY189491A (en)
SG (1) SG11201811808VA (en)
TW (1) TWI701567B (en)
WO (1) WO2018006723A1 (en)

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106897338A (en) 2016-07-04 2017-06-27 阿里巴巴集团控股有限公司 A kind of data modification request processing method and processing device for database
CN110209642A (en) * 2018-02-05 2019-09-06 北京智明星通科技股份有限公司 Method, apparatus, server and the computer-readable medium of information processing
CN110851486A (en) * 2018-07-26 2020-02-28 珠海格力电器股份有限公司 Data storage method and device
CN110134653B (en) * 2019-05-17 2021-09-07 杭州安恒信息技术股份有限公司 Method and system for assisting database auditing by using logs
CN112416924A (en) * 2019-08-22 2021-02-26 富泰华工业（深圳）有限公司 Data synchronous query method and device, computer device and storage medium
CN110543386B (en) * 2019-09-16 2022-06-10 上海达梦数据库有限公司 Data storage method, device, equipment and storage medium

Family Cites Families (34)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5430869A (en) * 1991-05-29 1995-07-04 Hewlett-Packard Company System and method for restructuring a B-Tree
US5701480A (en) 1991-10-17 1997-12-23 Digital Equipment Corporation Distributed multi-version commitment ordering protocols for guaranteeing serializability during transaction processing
WO1996027157A1 (en) * 1995-02-28 1996-09-06 Ntt Data Communications Systems Corporation Cooperative distributed system, and journal and recovery processings therein
US6510421B1 (en) * 1998-12-29 2003-01-21 Oracle Corporation Performing 2-phase commit with presumed prepare
US6981004B2 (en) * 2002-09-16 2005-12-27 Oracle International Corporation Method and mechanism for implementing in-memory transaction logging records
JP4186602B2 (en) * 2002-12-04 2008-11-26 株式会社日立製作所 Update data writing method using journal log
US7168001B2 (en) 2004-02-06 2007-01-23 Hewlett-Packard Development Company, L.P. Transaction processing apparatus and method
JP4582297B2 (en) * 2004-06-25 2010-11-17 日本電気株式会社 Replication system, apparatus, method, and program
JP4248510B2 (en) * 2005-03-24 2009-04-02 株式会社東芝 Computer system, disk device, and data update control method
US8185551B2 (en) * 2007-06-08 2012-05-22 Massachusetts Institute Of Technology Disk-resident streaming dictionary
CN101681313A (en) * 2008-02-29 2010-03-24 株式会社东芝 Memory system
JP2009211215A (en) * 2008-03-01 2009-09-17 Toshiba Corp Memory system
JP4870190B2 (en) * 2009-04-27 2012-02-08 株式会社日立製作所 Data processing method, computer, and data processing program
US10430298B2 (en) * 2010-10-28 2019-10-01 Microsoft Technology Licensing, Llc Versatile in-memory database recovery using logical log records
CN102024021A (en) * 2010-11-04 2011-04-20 曙光信息产业(北京)有限公司 Method for logging metadata in logical file system
CN102270225B (en) * 2011-06-28 2015-10-21 用友网络科技股份有限公司 Data change daily record method for supervising and data change daily record supervising device
CN103166785A (en) * 2011-12-15 2013-06-19 同程网络科技股份有限公司 Distributed type log analysis system based on Hadoop
JP2013178685A (en) * 2012-02-29 2013-09-09 Nec Corp Data processing system with asynchronous backup function, front system, backup method and program therefor
JP2014071487A (en) * 2012-09-27 2014-04-21 Sony Corp File recorder, file system management method and change drive
US9396220B2 (en) * 2014-03-10 2016-07-19 Oracle International Corporation Instantaneous unplug of pluggable database from one container database and plug into another container database
US10706009B2 (en) * 2013-03-14 2020-07-07 Oracle International Corporation Techniques to parallelize CPU and IO work of log writes
US9514007B2 (en) * 2013-03-15 2016-12-06 Amazon Technologies, Inc. Database system with database engine and separate distributed storage service
US9098453B2 (en) * 2013-07-11 2015-08-04 International Business Machines Corporation Speculative recovery using storage snapshot in a clustered database
CN104462127B (en) * 2013-09-22 2018-07-20 阿里巴巴集团控股有限公司 A kind of record data-updating method and device
US10230796B2 (en) * 2014-05-30 2019-03-12 Apple Inc. Intelligent disk space manager
US10545987B2 (en) * 2014-12-19 2020-01-28 Pure Storage, Inc. Replication to the cloud
CN104537037B (en) * 2014-12-23 2018-01-23 杭州华为数字技术有限公司 A kind of method and device of processing data storehouse daily record
US9811493B2 (en) * 2015-05-29 2017-11-07 Toshiba Memory Corporation Semiconductor device
CN107924362B (en) * 2015-09-08 2022-02-15 株式会社东芝 Database system, server device, computer-readable recording medium, and information processing method
US10296661B2 (en) 2015-09-11 2019-05-21 Salesforce.Com, Inc. Processing log files using a database system
US10747739B1 (en) * 2015-09-18 2020-08-18 Amazon Technologies, Inc. Implicit checkpoint for generating a secondary index of a table
CN108431804B (en) * 2015-10-23 2022-01-14 甲骨文国际公司 Ability to group multiple container databases into a single container database cluster
CN107046552B (en) * 2016-02-05 2020-10-23 华为技术有限公司 Data synchronization device and method based on heartbeat and distributed storage system
CN106897338A (en) 2016-07-04 2017-06-27 阿里巴巴集团控股有限公司 A kind of data modification request processing method and processing device for database

Also Published As

Publication number Publication date
EP3480705A1 (en) 2019-05-08
CN106897338A (en) 2017-06-27
EP3480705B1 (en) 2021-08-04
WO2018006723A1 (en) 2018-01-11
JP6987340B2 (en) 2021-12-22
JP2019527883A (en) 2019-10-03
US11132379B2 (en) 2021-09-28
US20190155817A1 (en) 2019-05-23
US20200125581A1 (en) 2020-04-23
US11106695B2 (en) 2021-08-31
KR102248386B1 (en) 2021-05-07
TW201804346A (en) 2018-02-01
KR20190026846A (en) 2019-03-13
EP3480705A4 (en) 2019-05-08
US20210390114A1 (en) 2021-12-16
MY189491A (en) 2022-02-16
TWI701567B (en) 2020-08-11

Similar Documents

Publication Publication Date Title
SG11201811808VA (en) Database data modification request processing method and apparatus
PH12019500771A1 (en) Business processing method and apparatus
MY190598A (en) Blockchain data processing method and apparatus
MX2016014234A (en) System and method for the creation and use of visually-diverse high-quality dynamic layouts.
GB2566420A (en) Providing debug information on production containers using debug containers
SG11201804033RA (en) Information recommendation method and apparatus
WO2016094182A3 (en) Network device predictive modeling
SG10201810036QA (en) Processing queries containing a union-type operation
PH12019500453A1 (en) Search information processing method and apparatus
MX2017015844A (en) System and method for the generation of an adaptive user interface in a website building system.
EP4242892A3 (en) Code pointer authentication for hardware flow control
WO2016164680A3 (en) Automated model development process
SG11201806674TA (en) Electronic payment service processing method and device, and electronic payment method and device
WO2014153010A3 (en) Systems and methods for concurrent online and offline document processing
AU2015364405A8 (en) Methods for simultaneous source separation
SG11201805759PA (en) Service fallback method and apparatus
GB2571841A (en) Automated mutual improvement of oilfield models
GB2565701A (en) Repair diagnostic system and method
EP2779037A3 (en) Information processing system and information processing method for comparing devices
SG11201909119YA (en) Search method and apparatus and non-temporary computer-readable storage medium
WO2014194321A3 (en) Method and apparatus for browsing information
WO2016083892A3 (en) Estimating a time variant signal representing a seismic source
MX2015003764A (en) Method and device for terminal verification.
GB2583636A8 (en) Facilitation of domain and client-specific application program interface recommendations
MX2021005993A (en) Logic circuitry.