Title:
DATA PARTITIONING METHOD FOR DISTRIBUTED PARALLEL DATABASE SYSTEM
Document Type and Number:
WIPO Patent Application WO/2012/012968
Kind Code:
A1
Abstract:
A data partitioning method for distributed parallel database system includes the following steps: a fact table and a dimension table are established according to the built distributed parallel database system; the records of the dimension table and the fact table are inserted into different nodes according to the partitioning rule; the record of the dimension table is copied into the node of the fact table; and the data deletion and renewing processes are implemented. When partitioning inputting or inserting data set or data flow into the distributed database system, the present invention can satisfy, in each node, the relation between the tables which is defined in the database project, especially the Primary-Foreign Key restriction condition, and provide the data of each node with local maturity. For the query of the connection between tables utilizing the Primary-Foreign Key restriction condition, because the data of each node is provided with local maturity for the type of query so that no dynamic data re-partitioning is need between the nodes, the time consumption for data network transition is avoided, the query response time is reduced, and the query efficiency is increased.
Inventors:
ZHANG, Weiping (No.D Wangjing Building, No.9 Wangjing Zhonghuan NanluChaoyang, Beijing 2, 100102, CN)
张卫平 (中国北京市朝阳区望京中环南路9号望京大厦D座, Beijing 2, 100102, CN)
ZHANG, Songbo (No.D Wangjing Building, No.9 Wangjing Zhonghuan NanluChaoyang, Beijing 2, 100102, CN)
张卫平 (中国北京市朝阳区望京中环南路9号望京大厦D座, Beijing 2, 100102, CN)
ZHANG, Songbo (No.D Wangjing Building, No.9 Wangjing Zhonghuan NanluChaoyang, Beijing 2, 100102, CN)
Application Number:
CN2010/077565
Publication Date:
February 02, 2012
Filing Date:
October 01, 2010
Export Citation:
Assignee:
BEIJING BORQS SOFTWARE TECHNOLOGY CO., LTD. (No.D Wangjing Building, No.9 Wangjing Zhonghuan NanluChaoyang, Beijing 2, 100102, CN)
北京播思软件技术有限公司 (中国北京市朝阳区望京中环南路9号望京大厦D座, Beijing 2, 100102, CN)
ZHANG, Weiping (No.D Wangjing Building, No.9 Wangjing Zhonghuan NanluChaoyang, Beijing 2, 100102, CN)
张卫平 (中国北京市朝阳区望京中环南路9号望京大厦D座, Beijing 2, 100102, CN)
北京播思软件技术有限公司 (中国北京市朝阳区望京中环南路9号望京大厦D座, Beijing 2, 100102, CN)
ZHANG, Weiping (No.D Wangjing Building, No.9 Wangjing Zhonghuan NanluChaoyang, Beijing 2, 100102, CN)
张卫平 (中国北京市朝阳区望京中环南路9号望京大厦D座, Beijing 2, 100102, CN)
International Classes:
G06F17/30
Attorney, Agent or Firm:
NANJING JINGWEI PATENT & TRADEMARK AGENCY CO., LTD (12th Fl.-B, No. 179 Zhongshan Road Gulo, Nanjing Jiangsu 5, 210005, CN)
Download PDF:
Claims: