GENERATING DATABASE SEQUENCES IN A REPLICATED DATABASE ENVIRONMENT
First Claim
1. A method for generating database sequences in a replicated database environment, comprising:
- providing a group of nodes each hosting an instance of a replicated database, with one node in the group elected as a master node responsible for generating and distributing values for auto-generated values in a column or row of the replicated database;
dividing, by the master node, a sequence space of possible auto-generated values for the column or row into sub-ranges and assigning a sub-range to a particular node in the group of nodes; and
distributing, by the master node, values of the assigned sub-range to a particular node of the group of nodes.
1 Assignment
0 Petitions
Accused Products
Abstract
Embodiments relate to generating database sequences in a replicated database environment. An aspect includes providing a group of nodes each hosting an instance of a replicated database, with one node in the group elected as a master node responsible for generating and distributing values for auto-generated values in a column or row of the replicated database. Another aspect includes dividing, by the master node, a sequence space of possible auto-generated values for the column or row into sub-ranges and assigning a sub-range to a particular node in the group of nodes. Another aspect includes distributing, by the master node, values of the assigned sub-range to a particular node of the group of nodes.
20 Citations
18 Claims
-
1. A method for generating database sequences in a replicated database environment, comprising:
-
providing a group of nodes each hosting an instance of a replicated database, with one node in the group elected as a master node responsible for generating and distributing values for auto-generated values in a column or row of the replicated database; dividing, by the master node, a sequence space of possible auto-generated values for the column or row into sub-ranges and assigning a sub-range to a particular node in the group of nodes; and distributing, by the master node, values of the assigned sub-range to a particular node of the group of nodes. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system for generating database sequences in a replicated database environment, comprising:
-
a group of nodes each hosting an instance of a replicated database, with one node in the group elected as a master node responsible for generating and distributing values for auto-generated values in a column or row of the replicated database; the master node comprising a sub-range allocating component that divides a sequence space of possible auto-generated values for the column or row into sub-ranges and assigning a sub-range to a particular node in the group of nodes; and the master node further comprising a demand receiving and value generating component that distributes values of the assigned sub-range to a particular node. - View Dependent Claims (12, 13, 14, 15, 16, 17)
-
-
18. A computer program product for generating database sequences, the computer program product comprising a computer readable storage medium having computer-readable program code embodied therewith, the computer-readable program code configured to:
-
divide, in a replicated database environment having a group of nodes each hosting an instance of a replicated database, with one node in the group elected as a master node responsible for generating and distributing values for auto-generated values in a column or row of the replicated database, a sequence space of possible auto-generated values for the column or row into sub-ranges and assigning a sub-range to a particular node in the group of nodes; and distribute values of the assigned sub-range to a particular node of the group of nodes.
-
Specification