Invention Grant
- Patent Title: Autonomous database defragmentation
-
Application No.: US16933753Application Date: 2020-07-20
-
Publication No.: US11537574B2Publication Date: 2022-12-27
- Inventor: Suresh Nagayanallur Subramanian , Manzoor Ahamed Sulthan , Yoram Tal , Kranthi Baddepuri , Subramanian Sathasivam , Dinesh reddy Parvata reddy , Praveen Kumar Rotam
- Applicant: salesforce.com, inc.
- Applicant Address: US CA San Francisco
- Assignee: salesforce.com, inc.
- Current Assignee: salesforce.com, inc.
- Current Assignee Address: US CA San Francisco
- Agency: Kowert, Hood, Munyon, Rankin & Goetzel, P.C.
- Agent Mark D. Seegers; Dean M. Munyon
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/215 ; G06F16/25 ; G06F11/07 ; G06F11/10 ; G06F11/34 ; G06F16/23

Abstract:
Techniques are disclosed relating to performing database defragmentation operations by autonomously rebuilding index objects stored in one or more tablespaces of a database. In various embodiments, the disclosed techniques include autonomously performing defragmentation operations for one or more tablespaces in a database in an online manner such that a server system may continue to service data access requests while performing the defragmentation operations. In one non-limiting embodiment, for example, the disclosed techniques include selecting a first tablespace to defragment based on its level of fragmentation (e.g., relative to the other tablespaces). The server system may then rebuild index objects, from the first tablespace, to a new tablespace such that the index objects are stored in the new tablespace without fragmentation. The server system may then reclaim at least a portion of the storage space used to store the first tablespace and repeat, as desired, to autonomously defragment multiple tablespaces.
Public/Granted literature
- US20220019565A1 AUTONOMOUS DATABASE DEFRAGMENTATION Public/Granted day:2022-01-20
Information query