会员体验
专利管家(专利管理)
工作空间(专利管理)
风险监控(情报监控)
数据分析(专利分析)
侵权分析(诉讼无效)
联系我们
交流群
官方交流:
QQ群: 891211   
微信请扫码    >>>
现在联系顾问~
热词
    • 3. 发明授权
    • Method for assuring atomicity of multi-row update operations in a
database system
    • 确保数据库系统中多行更新操作的原子性的方法
    • US4498145A
    • 1985-02-05
    • US393967
    • 1982-06-30
    • Jerry W. BakerRichard A. CrusDonald J. Haderle
    • Jerry W. BakerRichard A. CrusDonald J. Haderle
    • G06F12/00G06F7/22G06F9/44G06F9/46G06F11/14G06F7/00G06F11/00
    • G06F17/30595G06F11/1474G06F9/463G06F2201/80Y10S707/99953
    • A method for assuring atomicity of user requested multi-row update operations to tables such as in a relational database, guarantees that for any update operation that succeeds all stated effects will have occurred and that for any update operation that fails the system state as perceived by the user remains unchanged. This is accomplished by establishing, in response to a multi-row update operation request, an execution module of a program containing sets of machine language code instructions implementing the update operation request with a savepoint request at the beginning of the execution module of the program. For each set of machine language code instructions in or called by the execution module which modified the user perceived system state, information is logged to a soft log. Upon completing the execution module of the program, the savepoint is dropped, causing all soft log information recorded since the savepoint to be deleted and releasing all resources held to guarantee restoration of the user perceived system state at the time of the savepoint request. Responsive to the detection of an error during execution of the execution module of the program, the soft logged information is used to restore the user perceived state to that existing at the time of the savepoint request.
    • 确保用户请求的多行更新操作对诸如关系数据库之类的表的原子性的方法保证对于所有已经发生的所有效果的任何更新操作都会发生,并且对于任何由于 用户保持不变。 这是通过响应于多行更新操作请求,在程序的执行模块的开始处建立包含实现具有保存点请求的更新操作请求的机器语言代码指令的程序的程序的执行模块来实现的。 对于修改用户感知系统状态的执行模块中的每个机器语言代码指令集或调用,信息被记录到软日志。 完成程序的执行模块后,保存点被删除,导致从保存点记录的所有软日志信息被删除,并释放保存的所有资源,以保证在保存点请求时恢复用户感知的系统状态。 响应于在执行程序的执行模块期间检测到错误,软记录信息用于将用户感知状态恢复到保存点请求时存在的状态。