Invention Grant
- Patent Title: Resumable and online schema transformations
-
Application No.: US15588323Application Date: 2017-05-05
-
Publication No.: US10769134B2Publication Date: 2020-09-08
- Inventor: Panagiotis Antonopoulos , Alexander Thien Tran
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: Microsoft Technology Licensing, LLC
- Current Assignee: Microsoft Technology Licensing, LLC
- Current Assignee Address: US WA Redmond
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/23 ; G06F16/21 ; G06F16/2453 ; G06F16/22

Abstract:
A database command is received from a user for modifying an existing data structure or creating a new data structure. The database command is used to construct a query that is provided to a query optimizer component where the query is transformed into a first query execution plan including operations that persist operation state. Some data specified in the query is received, and some of the new data structure is constructed by executing some of the first query plan. While receiving some of data specified in the query and constructing some of the new data structure, operation state of execution is persisted. When an interruption of execution of the first query plan occurs, an updated query plan is generated using persisted operation state. External updates occur, before or after the interruption, but before executing the updated query plan. The external updates are transactionally validated.
Public/Granted literature
- US20180121494A1 Resumable and Online Schema Transformations Public/Granted day:2018-05-03
Information query