DISTRIBUTED DATABASE MANAGEMENT SYSTEM AND DISTRIBUTED DATABASE MANAGEMENT METHOD

• US 20110307470A1
• Filed: 02/16/2010
• Published: 12/15/2011
• Est. Priority Date: 02/24/2009
• Status: Abandoned Application

• Current Assignee: NEC Corporation
• Original Assignee: NEC Corporation
• Inventors: Kamimura, Junpei, Kashiwagi, Takehiko
• Application Number:
  US13/202,914
• Publication Number:
  US 20110307470A1
• Time in Patent Office: Days
• US Class Current: 707/713
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

Provided is a non-shared type database system capable of efficiently manipulating data in a distributed database. A distributed database management system has a query receiving unit (load balancer) that receives a query; and, plural storage processing units that manipulate data in the distributed database in a cooperative manner on the basis of the received query. Each of the storage processing units includes: a storage device that stores one of partial databases constituting the distributed database; and, a data manipulation unit that manipulates data in the partial databases stored in the storage device on the basis of the received query.

Claims

1. A distributed database management system for manipulating data in a distributed database, comprising:

a query receiving unit that receives a query; and

,

a plurality of storage processing units that manipulates data in the distributed database in a cooperative manner on the basis of the received query, wherein

each of the plurality of the storage processing units includes;

a storage device that stores one of a plurality of partial databases constituting the distributed database; and

,

a data manipulation unit that manipulates data in the partial databases stored in the storage device on the basis of the received query.

2. The distributed database management system according to claim 1, wherein,

in the case where a data set necessary for manipulating the data on the basis of the query is not stored in the partial database of a first storage processing unit of the plurality of the storage processing units, the data manipulation unit in the first storage processing unit issues a data transferring request of the data set to a second storage processing unit or a plurality of second storage processing unit, each of which is different from the first storage processing unit of the plurality of the storage processing units, and,

in response to the data transferring request, the data manipulation unit of the second storage processing unit acquires the data set from the partial database of the second storage processing unit, and transfers the acquired data set to the first storage processing unit.

3. The distributed database management system according to claim 2, further comprising a router that performs routing between the plurality of the storage processing units and the query receiving unit, and controls data transmission between given storage processing units of the plurality of the storage processing units, wherein

the router integrates the data sets transferred from the plurality of the second storage processing units to form a new table, and transfers a data set of the new table to the first storage processing unit.

4. The distributed database management system according to claim 2, wherein

the data manipulation unit in the first storage processing unit generates an internal query as the data transferring request, and

the data manipulation unit in the second storage processing unit manipulates data in the partial database of the second storage processing unit on the basis of the internal query to acquire the data set.

5. The distributed database management system according to claim 1, wherein

the query is described in a database language specifying one or more data manipulations selected from among searching, inserting, updating and deleting of data in the database.

6. The distributed database management system according to claim 5, wherein

the data manipulation unit includes:

a query analyzing unit that analyzes an internal query; and

,

a transaction execution unit that executes a transaction based on the result of the analysis by the query analyzing unit to manipulate the data.

7. The distributed database management system according to claim 6, wherein

the query analyzing unit optimizes the internal query so as to be suitable for a data structure of the partial database stored in the storage device.

8. The distributed database management system according to claim 1, wherein

the query receiving unit includes the query analyzing unit that analyzes and optimizes the received query.

9. The distributed database management system according to claim 1, wherein

the partial database includes:

a plurality of entity data;

an identifier table contains data identifiers with fixed lengths each uniquely representing each of the entity data, in an area specified by at least one tuple defined in a row direction and at least one attributed field defined in a column direction; and

,

a conversion table representing a correspondent relationship between position data each indicating a storage area of each of the entity data and each of the data identifiers.

10. The distributed database management system according to claim 9, wherein

a storage area for the identifier table and a storage area for the entity data are allocated differently from each other.

11. The distributed database management system according to claim 9, wherein

a value of each of the data identifiers is a value outputted from a hash function for outputting a bit stream with a fixed length in response to input of the entity data.

12. The distributed database management system according to claim 9, wherein

a plurality of identifier tables is provided;

the partial database further includes a reference table including a group of reference identifiers each uniquely representing each of the data identifiers in the plurality of the identifier tables; and

,

the data manipulation unit manipulates the data using the reference table and the identifier tables.

13. The distributed database management system according to claim 12, wherein

each of the identifier tables specifies a one-to-one correspondent relationship between the reference identifiers and the data identifiers so as to exclude overlap of the one-to-one correspondent relationship.

14. A distributed database management method in a distributed database management system including a plurality of storage processing units that manipulates data in a distributed database in a cooperative manner on the basis of a query, each of the storage processing units including a storage device that stores one of a plurality of partial databases constituting the distributed database, the distributed database management method including:

in the case where a data set necessary for manipulating the data on the basis of the query is not stored in the partial database, issuing, by a first storage processing unit of the plurality of the storage processing units, a data transferring request of the data set to a second storage processing unit or a plurality of second storage processing units, each of which is different from the first storage processing unit of the plurality of the storage processing units;

in response to the data transferring request, acquiring, by the second storage processing units, the data set from the partial database, and transferring the acquired data set to the first storage processing unit; and

,

manipulating, by the first storage processing unit, the data using the data set transferred from the second storage processing unit.

15. The distributed database management method according to claim 14, wherein

said issuing the data transferring request includes generating an internal query as the data transferring request, and

said acquiring the data set includes manipulating data in the partial database on the basis of the internal query, thereby acquiring the data set.

16. The distributed database management method according to claim 15, further including:

optimizing the internal query so as to be suitable for a data structure of the partial database stored in the storage device.

17. The distributed database management method according to claim 14, further including:

receiving the query; and

,

analyzing and optimizing the received query.

18. The distributed database management method according to claim 14, wherein

the partial database includes:

a plurality of entity data;

an identifier table that contains data identifiers with fixed lengths each uniquely representing the entity data in an area specified by at least one tuple defined in a row direction and at least one attributed field defined in a column direction; and

,

a conversion table that represents a correspondent relationship between position data each indicating a storage area of each of the plurality of the entity data and the data identifiers.

19. The distributed database management method according to claim 18, wherein

a plurality of identifier tables is provided;

the partial database further includes a reference table having a group of reference identifiers each uniquely representing each of the data identifiers in the plurality of the identifier tables; and

,

data are manipulated using the reference table and the identifier tables.

20. The distributed database management method according to claim 19, wherein

each of the identifier tables specifies a one-to-one correspondent relationship between the reference identifiers and the data identifiers so as to exclude overlap of the one-to-one correspondent relationship.