Database deployment objects and deterministic locking models
Methods and systems for deploying a database are described. In an example, a processor can generate an object that specifies a set of data from the database, a set of dependencies associated with the set of data, and a set of changes applicable to the set of data. The processor can determine a schedule to lock the set of data based on the set of dependencies. The processor can lock the set of data in accordance with the schedule. The processor can apply the set of changes to the set of data. The processor can release the set of data with the applied changes to update the database.
1. A system comprising:
a memory configured to store a database;
a processor comprising hardware, the processor being configured to be in communication with the memory, and the processor being configured to:
generate an object that specifies:
a set of data from the database,
a set of dependencies associated with the set of data, and
a set of changes applicable to the set of data;
determine a schedule based on the set of dependencies, wherein the schedule indicates a sequential order to individually:
lock a data among the set of data;
apply a change among the set of changes to the locked data; and
release the locked data with the applied changes to update the database.
2. The system of claim 1 , wherein the set of dependencies indicate at least one of:
dependencies among data of the set of data;
dependencies associated with running sessions of at least one application using the set of data; and
dependencies associated with workloads of the set of data.
3. The system of claim 2 , wherein the processor is configured to identify the set of dependencies based on at least historical data of the dependencies associated with running sessions and the dependencies associated with the workloads.
4. The system of claim 1 , wherein the processor is configured to generate a snapshot of the set of data and apply the set of changes to the snapshot.
5. The system of claim 1 , wherein the dependencies indicate a dependency order of the data among the set of data, and the sequential order is a reverse dependency order to lock the data among the set of data.
6. The system of claim 1 , wherein at least a portion of the database remain accessible in response to the lock of the set of data.
7. A computer-implemented method comprising:
generating, by a processor, an object that specifies:
a set of data from the database,
a set of dependencies associated with the set of data, and
a set of changes applicable to the set of data;
determining, by the processor, a schedule based on the set of dependencies, wherein the schedule indicates a sequential order to individually perform:
locking, by the processor, a data among the set of data;
applying, by the processor, a change among the set of changes to the locked data; and
releasing, by the processor, the locked data with the applied changes to update the database.
8. The computer-implemented method of claim 7 , wherein the set of dependencies indicate at least one of:
dependencies among data of the set of data;
dependencies associated with running sessions of at least one application using the set of data; and
dependencies associated with workloads of the set of data.
9. The computer-implemented method of claim 8 , further comprising identifying, by the processor, the set of dependencies based on at least historical data of the dependencies associated with running sessions and the dependencies associated with the workloads.
10. The computer-implemented method of claim 7 , further comprising:
generating, by the processor, a snapshot of the set of data; and
applying, by the processor, the set of changes to the snapshot.
11. The computer-implemented method of claim 7 , wherein the dependencies indicate a dependency order of the data among the set of data, and the sequential order is a reverse dependency order to lock the data among the set of data.
12. The computer-implemented method of claim 7 , wherein at least a portion of the database remain accessible in response to the lock of the set of data.
13. A computer program product for deploying a database, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor of a device to cause the device to:
generate an object that specifies:
a set of data from the database,
a set of dependencies associated with the set of data, and
a set of changes applicable to the set of data;
determine a schedule based on the set of dependencies, wherein the schedule indicates a sequential order to individually:
lock a data among the set of data;
apply a change among the set of changes to the locked dataset of data; and
release the locked data with the applied changes to update the database.
14. The computer program product of claim 13 , wherein the set of dependencies indicate at least one of:
dependencies among data of the set of data;
dependencies associated with running sessions of at least one application using the set of data; and
dependencies associated with workloads of the set of data.
15. The computer program product of claim 13 , wherein the program instructions are further executable by the processor of the device to cause the device to identify the set of dependencies based on at least historical data of the dependencies associated with running sessions and the dependencies associated with the workloads.
16. The computer program product of claim 13 , wherein the program instructions are further executable by the processor of the device to cause the device to:
generate a snapshot of the set of data; and
apply the set of changes to the snapshot.
17. The computer program product of claim 13 , wherein the dependencies indicate a dependency order of the data among the set of data, and the sequential order is a reverse dependency order to lock the data among the set of data.
18. The computer program product of claim 13 , wherein at least a portion of the database remain accessible in response to the lock of the set of data.