Invention Grant
- Patent Title: Persistent version storage for relational database management system
-
Application No.: US16112523Application Date: 2018-08-24
-
Publication No.: US11379433B2Publication Date: 2022-07-05
- Inventor: Raghavendra Thallam Kodandaramaih , Peter Byrne , Hanumantha Rao Kodavalla , Wei Chen , Girish Mittur Venkataramanappa , Adrian-Leonard Radu , Panagiotis Antonopoulos , Varun Kunjbihari Tibrewal
- 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: Ray Quinney & Nebeker
- Agent Tiffany Healy
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/21 ; G06F16/28 ; G06F16/22 ; G06F16/23 ; G06F16/11 ; G06F16/27

Abstract:
A relational database system that implements persistent version storage may include an in-row module that is executable by one or more processors to implement an in-row scheme by storing in-row previous version information within a payload of a row within a database page. The relational database system may additionally include an off-row module that is executable by the one or more processors to implement an off-row scheme by storing off-row previous version information in an off-row page that is separate from the database page. The relational database system may additionally include a storage policy that defines when previous version information is stored in accordance with the in-row scheme and when the previous version information is stored in accordance with the off-row scheme. The relational database system may additionally include a cleanup module that cleans up older versions when they are deemed unnecessary by the system.
Information query