Invention Grant
- Patent Title: Usage-optimized tables
- Patent Title (中): 使用优化表
-
Application No.: US12968124Application Date: 2010-12-14
-
Publication No.: US08868618B2Publication Date: 2014-10-21
- Inventor: Naresh Sundaram , Marcus E. Markiewicz , Brett A. Shirley
- Applicant: Naresh Sundaram , Marcus E. Markiewicz , Brett A. Shirley
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agent Louise Bowman; Jim Ross; Micky Minhas
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F7/00

Abstract:
Systems and methods are disclosed for employing usage-optimized tables with a computer database system. In one embodiment, the database system stores create, update, and delete database operations in the usage-optimized table. The create, update, and delete database operations remain in the usage-optimized table until a flush condition is reached. When the flush condition is reached, the create, update, and delete operations are transferred to their corresponding real tables. In embodiments, the read operation does not flush the contents of the usage-optimized table to the real table. In such embodiments, the database system modifies read operations to account for data resident on the usage-optimized tables.
Public/Granted literature
- US20120150917A1 USAGE-OPTIMIZED TABLES Public/Granted day:2012-06-14
Information query