Back to results
US 2019/0087447 A1Published application
Database system
AssigneeIntersec
InventorsFlorent BRUNEAU, Jean-Marc COIC
Life of this patent
Estimating the term…
Abstract
A database system (2) stores a database in the random-access memory of a plurality of computer devices (4) by organizing an efficient and robust distribution.
Claims12
A database system, comprising a plurality of computing devices (4) and an allocator (6) which is designed to distribute the data of the database over the computing devices (4), wherein the computing devices (4) are each designated by a host index and each comprise a random-access memory,
- wherein the allocator (6) is configured:
- to organize a plurality of spaces indexed over each random-access memory, and to organize a part at least of the data of the database into tranches having a tranche index,
- to define a plurality of mutually distinct sequences each comprising a plurality of pairs whose number is equal to the number of computing devices (4), each pair associating a unique rank value and a host index,
- to maintain a list of the functional computing devices (4) over time,
- to associate each tranche with a sequence of the plurality of sequences, on the basis of the list of functional computing devices (4), so that, for two tranches having respectively a first tranche index and a second tranche index such that the difference between the first tranche index and the second tranche index is equal to the number of sequences of the plurality of sequences, a given sequence of the plurality of sequences is associated with a single tranche whose tranche index lies between the first tranche index and the second tranche index,
- to define, for a tranche of given tranche index, from among the list of functional computing devices (4), a master space on the computing device (4) whose host index is associated with the lowest rank in the sequence associated with the given tranche, the master space being chosen on the computing device (4) as the space whose index corresponds to the given tranche index,
- to define, for a tranche of given tranche index, from among the list of functional computing devices (4), a plurality of slave spaces, chosen on computing devices (4) in such a way that the sum of ranks which are associated with the host indices of these computing devices (4) in the sequence associated with the given tranche is a minimum, each slave space being chosen on the respective computing device (4) as the space whose index corresponds to the given tranche index, and the computing devices (4) are configured such that one of the computing devices (4) which receives a master space replicates the data of the associated tranche on the corresponding slave spaces.
4 more elements
A database management method, comprising distributing data of the database over a plurality of computing devices (4), the method comprising the following operations:
- (a) associating a host index with each computing device (4),
- (b) organizing a plurality of spaces indexed on the random-access memory of each computing device (4),
- (c) organizing a part at least of the data of the database into tranches having a tranche index,
- (d) defining a plurality of mutually distinct sequences each comprising a plurality of pairs whose number is equal to the number of computing devices (4), each pair associating a unique rank value and a host index,
- (e) associating each tranche with a sequence of the plurality of sequences, on the basis of the list of functional computing devices (4), so that, for two tranches having respectively a first tranche index and a second tranche index such that the difference between the first tranche index and the second tranche index is equal to the number of sequences of the plurality of sequences, a given sequence of the plurality of sequences is associated with a single tranche whose tranche index lies between the first tranche index and the second tranche index, by
- (e1) defining, for a tranche of given tranche index, from among the list of functional computing devices (4), a master space on the computing device (4) whose host index is associated with the lowest rank in the sequence associated with the given tranche, the master space being chosen on the computing device (4) as the space whose index corresponds to the given tranche index,
- (e2) defining, for a tranche of given tranche index, from among the list of functional computing devices (4), a plurality of slave spaces, chosen on computing devices (4) in such a way that the sum of ranks which are associated with the host indices of these computing devices (4) in the sequence associated with the given tranche is a minimum, each slave space being chosen on the respective computing device (4) as the space whose index corresponds to the given tranche index,
- (f) storing the data of each given tranche on the master space which is associated therewith,
- (g) replicating the data stored on the master spaces on the corresponding slave spaces.
6 more elements
Dependencies are inferred from the claim text.