Invention Grant
- Patent Title: Optimizing space management of tablespaces in database systems
-
Application No.: US14666409Application Date: 2015-03-24
-
Publication No.: US09886466B2Publication Date: 2018-02-06
- Inventor: Viren D. Parikh , Ramesh C. Pathak , Suryanarayana K. Rao
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Alexander G. Jochym
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A database is identified, wherein the database has two or more tablespaces. A local partition and a global partition for each tablespace of the two or more tablespaces is created, wherein the created two or more global partitions are included in a global storage pool. A request to move an object to a first local partition of a first tablespace of the two or more tablespaces is received. That an amount of used space of the first local partition is above a first threshold is determined. Responsive to determining that the amount of used space of the first local partition is above the first threshold, at least a portion of the object is stored in the global storage pool.
Public/Granted literature
- US20160283503A1 OPTIMIZING SPACE MANAGEMENT OF TABLESPACES IN DATABASE SYSTEMS Public/Granted day:2016-09-29
Information query