Invention Grant
- Patent Title: Online schema change of range-partitioned index in a distributed storage system
-
Application No.: US16617443Application Date: 2017-06-30
-
Publication No.: US11249961B2Publication Date: 2022-02-15
- Inventor: Krishnan Varadarajan , Jianwu Gao , Jegan Devaraju , Shane Mainali , Zichen Sun , Quan Zhang , Venkates Paramasivam Balakrishnan , Shaoyu Zhang , Kaifeng Zhu , Ju Wang , Manish Chablani , Hao Feng
- 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
- Agency: Mannava & Kang, P.C.
- International Application: PCT/CN2017/091087 WO 20170630
- International Announcement: WO2019/000386 WO 20190103
- Main IPC: G06F16/21
- IPC: G06F16/21 ; G06F16/22 ; G06F16/23 ; G06F16/27

Abstract:
A distributed storage system includes table controllers collectively storing partitions of a logical table having multiple rows. For each of the partitions, a corresponding table controller stores a subset of the rows of the logical table across individual pages. A management controller updates a schema of the logical table from a first to a second schema definition by, for each of the partitions, sending an update command indicating the second schema definition to the corresponding table controller. The first table controller corresponds to a first partition that includes a first subset of the rows. The first table controller, prior to receiving the update command, includes an identifier of the first schema definition within each page of data for the first subset. Subsequent to receiving the update command, the first table controller, when writing each new page of data for the first subset, includes an identifier of the second schema definition.
Information query