The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Dec. 27, 2022
Filed:
Jul. 20, 2020
Salesforce.com, Inc., San Francisco, CA (US);
Suresh Nagayanallur Subramanian, Singapore, SG;
Manzoor Ahamed Sulthan, Singapore, SG;
Yoram Tal, San Francisco, CA (US);
Kranthi Baddepuri, Hyderabad, IN;
Subramanian Sathasivam, Singapore, SG;
Dinesh reddy Parvata reddy, Hyderabad, IN;
Praveen Kumar Rotam, Singapore, SG;
salesforce.com, inc., San Francisco, CA (US);
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.