Preventing database package updates to fail customer requests and cause data corruptions

Patent metadata

Field	Value
Publication number	US-11182144-B2
Application number	US-201816236915-A
Country	US
Kind code	B2
Filing date	Dec 31, 2018
Priority date	Dec 31, 2018
Publication date	Nov 23, 2021
Grant date	Nov 23, 2021

Abstract

A method for processing database package connections and updates has been developed. First, an execution request for a database package is received. A connection context is then established which can execute the execution request. The database package is determined whether or not it is valid with proper package updates prior to establishing the connection. If the database package is determined to not be valid, change packages are retrieved for the database package. The valid change packages are then compiled for the database package and the connection request is executed for the updated database package with the connection context.

First claim

What is claimed is:

1. A method for processing database package connections and updates for a database user, comprising:
receiving a first execution request for executing a database control code using a specified connection, where the specified connection is between the database user and a database and is used for executing the database control code which processes the database package;
establishing a connection context which can execute the first execution request for executing the database control code, where the connection context contains code that ties a session to the first execution request from the database user;
determining whether the database package is valid with most recent package updates, where validity of the database package is determined prior to establishing the connection context;
failing the first execution request for executing the database control code because the database package is determined to be invalid due lacking the most recent package updates;
retrieving valid change packages for the database package in response to determining that the database package is not valid;
compiling the valid change packages for the database package that creates an updated database package;
initiating a second execution request for executing the database control code for the updated database package; and
executing the second execution request for executing the database control code for the updated database package with the connection context after compiling the valid change packages for the database package.

2. The method of claim 1 , where the first execution request for the database package is an initial connection request at a multi-tenant database.

3. The method of claim 1 , where the database package is determined to be valid by referring to a timestamp for a latest package update of the database package.

4. The method of claim 3 , where the timestamp contains the version of the latest package update and when the latest package update occurred.

5. The method of claim 4 , where the database package is determined to not be valid if a timestamp for the latest package update is greater than start of the first execution request.

6. The method of claim 1 , where a flag is set for the connection context in response to determining that the database package is not valid.

7. The method of claim 1 , where all valid change packages for the database package are retrieved in response to determining that the database package is not valid.

8. An apparatus for processing database package connections and updates for a database user, comprising:
a processor;
a memory coupled to the processor that includes computer software program instructions capable of:
receiving a first execution request for executing a database control code using a specified connection, where the specified connection is between the database user and a database and is used for executing the database control code for executing the database control code which processes the database package;
request for executing the database control code, where the connection context contains code that ties a session to the first execution request from the database user;
determining whether the database package is valid with most recent package updates, where validity of the database package is determined prior to establishing the connection context;
failing the first execution request for executing the database control code because the database package is determined to be invalid due lacking the most recent package updates;
retrieving valid change packages for the database package in response to determining that the database package is not valid;
compiling the valid change packages for the database package that creates an updated database package;
initiating a second execution request for executing a database control code for the updated database package; and
executing the second execution request for executing a database control code for the updated database package with the connection context after compiling the valid change packages for the database package.

9. The apparatus of claim 8 , where the connection request for the database package is an initial connection request at a multi-tenant database.

10. The apparatus of claim 8 , where the database package is determined to be valid by referring to a timestamp for a latest package update of the database package.

11. The apparatus of claim 10 , where the timestamp contains the version of the latest package update and when the latest package update occurred.

12. The apparatus of claim 11 , where the database package is determined to not be valid if the timestamp for the latest package update is greater than start of the execution request.

13. The apparatus of claim 8 , where a flag is set for the connection context in response to determining that the database package is not valid.

14. The apparatus of claim 8 , where all valid change packages for the database package are retrieved in response to determining that the database package is not valid.

15. A computer readable storage media comprising:
computer software instructions stored in a non-transitory computer readable storage media, where the computer software instructions are configured to implement instructions capable of:
receiving a first execution request for executing a database control code using a specified connection, where the specified connection is between the database user and a database and is used for executing the database control code which processes the database package;
establishing a connection context which can execute the first execution request for executing the database control code, where the connection context contains code that ties a session to the first execution request from the database user;
determining whether the database package is valid with most recent package updates, where validity of the database package is determined prior to establishing the connection context;
failing the first execution request for executing the database control code because the database package is determined to be invalid due lacking the most recent package updates;
retrieving valid change packages for the database package in response to determining that the database package is not valid;
compiling the valid change packages for the database package that creates an updated database package;
initiating a second execution request for executing the database control code for the updated database package; and
executing the second execution request for executing the database control code for the updated database package with the connection context after compiling the valid change packages for the database package.

Assignees

• Salesforce Com Inc

Inventors

• Mathur Rohitashva

Classifications

• G06F8/65 Primary

  Updates (security arrangements therefor G06F21/57) · CPC title

• G06F16/283

  Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP · CPC title

• G06F16/21

  Design, administration or maintenance of databases · CPC title