WO2008042980A3 - Methods and systems for providing fault recovery to side effects occurring during data processing - Google Patents

Methods and systems for providing fault recovery to side effects occurring during data processing Download PDF

Info

Publication number
WO2008042980A3
WO2008042980A3 PCT/US2007/080341 US2007080341W WO2008042980A3 WO 2008042980 A3 WO2008042980 A3 WO 2008042980A3 US 2007080341 W US2007080341 W US 2007080341W WO 2008042980 A3 WO2008042980 A3 WO 2008042980A3
Authority
WO
WIPO (PCT)
Prior art keywords
rows
side effects
systems
methods
data processing
Prior art date
Application number
PCT/US2007/080341
Other languages
French (fr)
Other versions
WO2008042980A2 (en
Inventor
Craig Weissman
Steven Tamm
Simon Fell
Simon Wong
Steve Fisher
Original Assignee
Salesforce Com Inc
Craig Weissman
Steven Tamm
Simon Fell
Simon Wong
Steve Fisher
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
Priority claimed from US11/616,657 external-priority patent/US8271641B2/en
Priority claimed from US11/678,477 external-priority patent/US8682863B2/en
Priority claimed from US11/678,500 external-priority patent/US8161010B2/en
Application filed by Salesforce Com Inc, Craig Weissman, Steven Tamm, Simon Fell, Simon Wong, Steve Fisher filed Critical Salesforce Com Inc
Publication of WO2008042980A2 publication Critical patent/WO2008042980A2/en
Publication of WO2008042980A3 publication Critical patent/WO2008042980A3/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1474Saving, restoring, recovering or retrying in transactions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • G06F16/24553Query execution of query operations
    • G06F16/24561Intermediate data storage techniques for performance improvement
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases

Abstract

Embodiments may recover from faults by forming a new set of rows by removing rows associated with faulting save operations and repeating the saving and forming operations using the new set of rows until a set of rows that can be saved from the known start state without fault is determined. When the subset of successful rows is found, embodiments are able to provide assurance that no side effects (i.e., code or operations triggered by saving of a data to a particular location) have been executed on behalf of any of the failed rows (side effects from custom PL/SOQL code included) by deferring execution of triggers until an entire set of rows can be saved and committed.
PCT/US2007/080341 2006-10-04 2007-10-03 Methods and systems for providing fault recovery to side effects occurring during data processing WO2008042980A2 (en)

Applications Claiming Priority (10)

Application Number Priority Date Filing Date Title
US84969306P 2006-10-04 2006-10-04
US60/849,693 2006-10-04
US85086306P 2006-10-10 2006-10-10
US60/850,863 2006-10-10
US11/616,657 2006-12-27
US11/616,657 US8271641B2 (en) 2006-10-04 2006-12-27 Method and system for governing resource consumption in a multi-tenant system
US11/678,500 2007-02-23
US11/678,477 2007-02-23
US11/678,477 US8682863B2 (en) 2006-10-04 2007-02-23 Methods and systems for bulk row save logic in an object relational mapping layer and application framework
US11/678,500 US8161010B2 (en) 2006-10-04 2007-02-23 Methods and systems for providing fault recovery to side effects occurring during data processing

Publications (2)

Publication Number Publication Date
WO2008042980A2 WO2008042980A2 (en) 2008-04-10
WO2008042980A3 true WO2008042980A3 (en) 2008-08-14

Family

ID=39269196

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2007/080341 WO2008042980A2 (en) 2006-10-04 2007-10-03 Methods and systems for providing fault recovery to side effects occurring during data processing

Country Status (1)

Country Link
WO (1) WO2008042980A2 (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8161010B2 (en) 2006-10-04 2012-04-17 Salesforce.Com, Inc. Methods and systems for providing fault recovery to side effects occurring during data processing
US8676864B2 (en) 2011-08-19 2014-03-18 Salesforce.Com, Inc. Methods and systems for providing schema layout in an on-demand services environment
CN109324803A (en) * 2017-07-27 2019-02-12 广州极飞科技有限公司 The upgrade method and device of electron speed regulator, unmanned plane

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6185577B1 (en) * 1998-06-23 2001-02-06 Oracle Corporation Method and apparatus for incremental undo
US6233585B1 (en) * 1998-03-12 2001-05-15 Crossworlds Software, Inc. Isolation levels and compensating transactions in an information system
US20030154197A1 (en) * 2002-02-13 2003-08-14 Permutta Technologies Flexible relational data storage method and apparatus
US20050097149A1 (en) * 2003-11-05 2005-05-05 Lumigent Technologies, Inc. Data audit system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6233585B1 (en) * 1998-03-12 2001-05-15 Crossworlds Software, Inc. Isolation levels and compensating transactions in an information system
US6185577B1 (en) * 1998-06-23 2001-02-06 Oracle Corporation Method and apparatus for incremental undo
US20030154197A1 (en) * 2002-02-13 2003-08-14 Permutta Technologies Flexible relational data storage method and apparatus
US20050097149A1 (en) * 2003-11-05 2005-05-05 Lumigent Technologies, Inc. Data audit system

Also Published As

Publication number Publication date
WO2008042980A2 (en) 2008-04-10

Similar Documents

Publication Publication Date Title
WO2008092162A3 (en) Systems, methods, and media for recovering an application from a fault or attack
WO2012039988A3 (en) System and method for managing integrity in a distributed database
ATE523223T1 (en) SYSTEM FOR RECOVERING TRANSIENT FAULTS IN AN IMPLANTABLE MEDICAL DEVICE
TW200704946A (en) System and method for monitoring a power supply level
WO2009026028A3 (en) Staged, lightweight backup system
GB2463577B (en) Technique for correcting character-recognition errors
WO2011056880A3 (en) Rollback feature
WO2009018249A3 (en) Creating backups in storage systems
TW200632719A (en) Multivariate control of semiconductor processes
WO2008019259A3 (en) Architecture for back up and/or recovery of electronic data
WO2006029290A3 (en) Application of abnormal event detection technology to olefins recovery trains
TW200625101A (en) Backup/restore system and method thereof
WO2008027183A3 (en) Recovering from an interrupted print job
WO2006089263A3 (en) Method and mechanism of handling reporting transactions in database systems
WO2010041852A3 (en) Method and system for perpetual computing using non-volatile random access memory (nvram)
WO2008099786A1 (en) Memory failure recovery method, information processing device, and program
CN102163167A (en) Method and device for rescuing system
TW200708927A (en) Method of resetting an unresponsive system and system capable of recovering from an unresponsive condition
WO2007022392A3 (en) Information protection method and system
CN103514013A (en) Gateway product FLASH configuration loss processing method
WO2008042980A3 (en) Methods and systems for providing fault recovery to side effects occurring during data processing
WO2004081920A3 (en) Policy-based response to system errors occuring during os runtime
WO2007050767A3 (en) System and method for neutralizing pestware that is loaded by a desirable process
WO2008111124A1 (en) Multi-cpu abnormality detection restoration system, method and program
US7966527B2 (en) Watchdog mechanism with fault recovery

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 07843769

Country of ref document: EP

Kind code of ref document: A2

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 07843769

Country of ref document: EP

Kind code of ref document: A2