-
公开(公告)号:US10353723B2
公开(公告)日:2019-07-16
申请号:US15883803
申请日:2018-01-30
Applicant: salesforce.com, inc.
Inventor: Raghavendran Hanumantharau , Yoram Tal
IPC: G06F9/455 , G06F16/242
Abstract: In some database systems, a user device may query for data records using a procedural language extension to structured query language (PL/SQL) call. However, some databases may not be configured to process PL/SQL code. In these cases, a virtual machine may intercept the PL/SQL call, and may transform the call to a format usable by the database. For example, the virtual machine may deconstruct the PL/SQL call to determine the procedural and query functions that comprise the PL/SQL call. The virtual machine may then search a database for non-PL/SQL code snippets that correspond to these determined functions, and may generate non-PL/SQL code (e.g., Java code) that may perform the same functions as the PL/SQL call. The virtual machine, the database, or a combination of the two may execute the non-PL/SQL code to retrieve the data records from the database, and may return the records to the user device.
-
公开(公告)号:US20190042288A1
公开(公告)日:2019-02-07
申请号:US15883803
申请日:2018-01-30
Applicant: salesforce.com, inc.
Inventor: Raghavendran Hanumantharau , Yoram Tal
CPC classification number: G06F9/4552 , G06F9/45558 , G06F16/2448 , G06F16/2452 , G06F2009/45562 , G06F2009/45595
Abstract: In some database systems, a user device may query for data records using a procedural language extension to structured query language (PL/SQL) call. However, some databases may not be configured to process PL/SQL code. In these cases, a virtual machine may intercept the PL/SQL call, and may transform the call to a format usable by the database. For example, the virtual machine may deconstruct the PL/SQL call to determine the procedural and query functions that comprise the PL/SQL call. The virtual machine may then search a database for non-PL/SQL code snippets that correspond to these determined functions, and may generate non-PL/SQL code (e.g., Java code) that may perform the same functions as the PL/SQL call. The virtual machine, the database, or a combination of the two may execute the non-PL/SQL code to retrieve the data records from the database, and may return the records to the user device.
-
公开(公告)号:US10523425B2
公开(公告)日:2019-12-31
申请号:US15630642
申请日:2017-06-22
Applicant: salesforce.com, inc.
Inventor: Raghavendran Hanumantharau , Yoram Tal , Amit Das , Edward F. Gulakowski, Jr.
Abstract: Systems and methods for changing database passwords are described. A first server computing system receives an indication to perform a password change process for an administrative account of an associated database. The server generates a vault configured to store a password change status and a password secret associated with the account. The server sets the password change status to a first value to indicate that the server is performing the password change process and then performs the password change process for the account. The server then sets the password change status to a second value to enable a second server computing system to perform a second password change process for a second administrative account of a database associated with the second server system. The database associated with the second server computing system is a standby database of the database associated with the first server system.
-
公开(公告)号: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
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
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.
-
-
-
-