Invention Grant
- Patent Title: Making parallel execution of structured query language statements fault-tolerant
- Patent Title (中): 使并行执行结构化查询语言语句容错
-
Application No.: US13569377Application Date: 2012-08-08
-
Publication No.: US08572051B1Publication Date: 2013-10-29
- Inventor: Mengmeng Chen , Yali Zhu , Thierry Cruanes , Alan Wood
- Applicant: Mengmeng Chen , Yali Zhu , Thierry Cruanes , Alan Wood
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Palermo Truong Becker Bingham Wong LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Parallel execution of SQL statements is made fault-tolerant. Specifically, during parallel query processing, a new row source is created that allows checkpoints to be stored at certain points in the query processing. If a failure occurs, then the query can be restarted from the most recent checkpoint (rather than from the very beginning of the query). The checkpoints are implemented at operation boundaries where rows need to be redistributed among processes. These are natural checkpoint locations because (1) each subsequent operation can proceed from the output of the previous operation, which is stored as a checkpoint, and (2) these operation completions tend to be points in the computation where the query state is minimized, thus minimizing checkpoint storage requirements.
Information query