公开(公告)号：US11567799B2

公开(公告)日：2023-01-31

申请号：US16919863

申请日：2020-07-02

Applicant: salesforce.com, inc.

Inventor： Kranthi Baddepuri ,  Siang Hao Darren Poh

IPC: G06F9/50 ,  G06F9/54

Abstract: Described herein is a system and method for determining the status of instances and update applications to reflect the updated statuses of instances, in real-time. In an embodiment, each instance may enable a service to determine the status of an instance. A core application server may load server pool configurations including a status of an instance. The status indicates the instance is live. Core application server may read a gate definition of the instance using the service enabled on the instance. Core application server may determine that a current status of the instance is virtual, based on the gate definition of the instance. The core application may a local cache of core application server to reflect that the current status of the instance is virtual and propagate to applications executed on other instances and core application server.

公开(公告)号：US11537574B2

公开(公告)日：2022-12-27

申请号：US16933753

申请日：2020-07-20

Applicant: salesforce.com, inc.

Inventor： Suresh Nagayanallur Subramanian ,  Manzoor Ahamed Sulthan ,  Yoram Tal ,  Kranthi Baddepuri ,  Subramanian Sathasivam ,  Dinesh reddy Parvata reddy ,  Praveen Kumar Rotam

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.

公开(公告)号：US20220019565A1

公开(公告)日：2022-01-20

申请号：US16933753

申请日：2020-07-20

Applicant: salesforce.com, inc.

Inventor： Suresh Nagayanallur Subramanian ,  Manzoor Ahamed Sulthan ,  Yoram Tal ,  Kranthi Baddepuri ,  Subramanian Sathasivam ,  Dinesh reddy Parvata reddy ,  Praveen Kumar Rotam

IPC: G06F16/215 ,  G06F16/22 ,  G06F16/25 ,  G06F16/23 ,  G06F11/07 ,  G06F11/10 ,  G06F11/34

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.