Title:
無共有型並列データベースシステム及びデータベース管理方法
Document Type and Number:
Japanese Patent JP2007531087
Kind Code:
A
Abstract:
An ultra-shared-nothing parallel database system includes at least one master node and multiple slave nodes. A database consisting of at least one fact table and multiple dimension tables is partitioned and distributed across the slave nodes of the database system so that queries are processed in parallel without requiring the transfer of data between the slave nodes. The fact table and a first dimension table of the database are partitioned across the slave nodes. The other dimension tables of the database are duplicated on each of the slave nodes and at least one of these other dimension tables is partitioned across the slave nodes.
Inventors:
Frost, stuart
Application Number:
JP2007503912A
Publication Date:
November 01, 2007
Filing Date:
February 17, 2005
Export Citation:
Assignee:
DATALLEGRO,INC.
International Classes:
G06F17/30; G06F17/00
Domestic Patent References:
| JPH11110262A | 1999-04-23 | |||
| JPH1153232A | 1999-02-26 |
Other References:
JPN6010056062, ＳＵＮ Ｊ． ｅｔ ａｌ．, "Ｄｙｎａｍｉｃ Ｍａｉｎｔｅｎａｎｃｅ ｏｆ Ｍｕｌｔｉｄｉｍｅｎｓｉｏｎａｌ Ｒａｎｇｅ Ｄａｔａ Ｐａｒｔｉｔｉｏｎｉｎｇ", Ｐｒｏｃｅｅｄｉｎｇｓ ｏｆ ｔｈｅ １ｓｔ ＡＣＭ ｉｎｔｅｒｎａｔｉｏｎａｌ ｗｏｒｋｓｈｏｐ ｏｎ Ｄａｔａ ｗａｒｅｈｏｕｓｉｎｇ ａｎｄ ＯＬＡＰ, 1998, ｐｐ．７２ − ７９, US, ｔｈｅ Ａｓｓｏｃｉａｔｉｏｎ ｆｏｒ Ｃｏｍｐｕｔｉｎｇ Ｍａｃｈｉｎｅｒｙ
JPN6010056063, ＳＴＯＥＨＲ Ｔ， ｅｔ ａｌ．, "Ｍｕｌｔｉ−ｄｉｍｅｎｓｉｏｎａｌ ｄａｔａｂａｓｅ ａｌｌｏｃａｔｉｏｎ ｆｏｒ ｐａｒａｌｌｅｌ ｄａｔａ ｗａｒｅｈｏｕｓｅｓ", Ｐｒｏｃｅｅｄｉｎｇｓ ｏｆ ｔｈｅ ２６ｔｈ Ｉｎｔｅｒｎａｔｉｏｎａｌ Ｃｏｎｆｅｒｅｎｃｅ ｏｎ Ｖｅｒｙ Ｌａｒｇｅ Ｄａｔａ Ｂａｓｅｓ, 2000, ｐｐ． ２７３ − ２８４, US, Ｍｏｒｇａｎ Ｋａｕｆｍａｎｎ Ｐｕｂｌｉｓｈｅｒｓ Ｉｎｃ．
JPN6010056063, ＳＴＯＥＨＲ Ｔ， ｅｔ ａｌ．, "Ｍｕｌｔｉ−ｄｉｍｅｎｓｉｏｎａｌ ｄａｔａｂａｓｅ ａｌｌｏｃａｔｉｏｎ ｆｏｒ ｐａｒａｌｌｅｌ ｄａｔａ ｗａｒｅｈｏｕｓｅｓ", Ｐｒｏｃｅｅｄｉｎｇｓ ｏｆ ｔｈｅ ２６ｔｈ Ｉｎｔｅｒｎａｔｉｏｎａｌ Ｃｏｎｆｅｒｅｎｃｅ ｏｎ Ｖｅｒｙ Ｌａｒｇｅ Ｄａｔａ Ｂａｓｅｓ, 2000, ｐｐ． ２７３ − ２８４, US, Ｍｏｒｇａｎ Ｋａｕｆｍａｎｎ Ｐｕｂｌｉｓｈｅｒｓ Ｉｎｃ．
Attorney, Agent or Firm:
Moriaki Ogawa