CN104871153B8 - 用于分布式大规模并行处理数据库的方法和系统 - Google Patents

用于分布式大规模并行处理数据库的方法和系统 Download PDF

Info

Publication number
CN104871153B8
CN104871153B8 CN201380051321.8A CN201380051321A CN104871153B8 CN 104871153 B8 CN104871153 B8 CN 104871153B8 CN 201380051321 A CN201380051321 A CN 201380051321A CN 104871153 B8 CN104871153 B8 CN 104871153B8
Authority
CN
China
Prior art keywords
tables
data
distributed
database
partition group
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201380051321.8A
Other languages
English (en)
Other versions
CN104871153B (zh
CN104871153A (zh
Inventor
卡米尼·杰格缇雅尼
杰森·扬·孙
沈秀棠
甘嘎瓦拉·普拉萨德·瓦拉库汝
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Huawei Technologies Co Ltd
Original Assignee
Huawei Technologies Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority claimed from US13/663,327 external-priority patent/US9920415B2/en
Application filed by Huawei Technologies Co Ltd filed Critical Huawei Technologies Co Ltd
Priority to CN201811146623.4A priority Critical patent/CN109388638B/zh
Priority claimed from PCT/CN2013/086139 external-priority patent/WO2014067449A1/en
Publication of CN104871153A publication Critical patent/CN104871153A/zh
Publication of CN104871153B publication Critical patent/CN104871153B/zh
Application granted granted Critical
Publication of CN104871153B8 publication Critical patent/CN104871153B8/zh
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

一种大规模并行处理的实施例方法，包括：将主键分配给数据库中的第一数据表、将外键分配给所述数据库中的第二数据表，所述第二数据表的外键与所述第一数据表的主键完全相同；确定所述数据库需要的分区组数；基于分配的所述主键和需要的分区组数将所述第一数据表划分成多个第一分区，基于分配的所述外键和需要的分区组数将所述第二数据表划分成多个第二分区；根据分区情况将所述第一分区和第二分区分发到所述分区组。本发明还公开了一种实现所述实施例方法的实施例系统。
CN201380051321.8A 2012-10-29 2013-10-29 用于分布式大规模并行处理数据库的方法和系统 Active CN104871153B8 (zh)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811146623.4A CN109388638B (zh) 2012-10-29 2013-10-29 用于分布式大规模并行处理数据库的方法及系统

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
US13/663,327 US9920415B2 (en) 2010-10-19 2012-10-29 Mitigation and elimination of tin whiskers
US13/663,327 2012-10-29
US13/663,237 2012-10-29
PCT/CN2013/086139 WO2014067449A1 (en) 2012-10-29 2013-10-29 System and method for flexible distributed massively parallel processing (mpp) database

Related Child Applications (1)

Application Number Title Priority Date Filing Date
CN201811146623.4A Division CN109388638B (zh) 2012-10-29 2013-10-29 用于分布式大规模并行处理数据库的方法及系统

Publications (3)

Publication Number Publication Date
CN104871153A CN104871153A (zh) 2015-08-26
CN104871153B CN104871153B (zh) 2018-10-30
CN104871153B8 true CN104871153B8 (zh) 2019-02-01

Family

ID=53975894

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201380051321.8A Active CN104871153B8 (zh) 2012-10-29 2013-10-29 用于分布式大规模并行处理数据库的方法和系统

Country Status (1)

Country Link
CN (1) CN104871153B8 (zh)

Families Citing this family (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105550309A (zh) * 2015-12-12 2016-05-04 天津南大通用数据技术股份有限公司 Mpp架构数据库集群序列系统及序列管理方法
US10756961B2 (en) 2016-01-27 2020-08-25 Oracle International Corporation System and method of assigning admin partition membership based on switch connectivity in a high-performance computing environment
CN107451154B (zh) * 2016-05-31 2021-03-30 华为技术有限公司 一种数据表的处理方法、装置及系统
CN106202441A (zh) * 2016-07-13 2016-12-07 腾讯科技（深圳）有限公司 基于关系型数据库的数据处理方法、装置和系统
CN107784030B (zh) * 2016-08-31 2020-04-28 华为技术有限公司 一种处理连接查询的方法及装置
CN106682215B (zh) * 2016-12-30 2020-04-28 华为技术有限公司 一种数据处理方法和管理节点
CN108874950B (zh) * 2018-06-05 2022-04-12 亚信科技（中国）有限公司 一种基于er关系的数据分布存储方法及装置
CN108959510B (zh) * 2018-06-27 2022-04-19 北京奥星贝斯科技有限公司 一种分布式数据库的分区级连接方法和装置
CN116756150B (zh) * 2023-08-16 2023-10-31 浩鲸云计算科技股份有限公司 一种Mpp数据库大表关联加速方法

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050038784A1 (en) * 2001-02-27 2005-02-17 Oracle International Corporation Method and mechanism for database partitioning
US20050187977A1 (en) * 2004-02-21 2005-08-25 Datallegro, Inc. Ultra-shared-nothing parallel database
US7203686B1 (en) * 2003-12-30 2007-04-10 Ncr Corp. Partition join in a partitioned database system
CN101916261A (zh) * 2010-07-28 2010-12-15 北京播思软件技术有限公司 一种分布式并行数据库系统的数据分区方法

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050038784A1 (en) * 2001-02-27 2005-02-17 Oracle International Corporation Method and mechanism for database partitioning
US7203686B1 (en) * 2003-12-30 2007-04-10 Ncr Corp. Partition join in a partitioned database system
US20050187977A1 (en) * 2004-02-21 2005-08-25 Datallegro, Inc. Ultra-shared-nothing parallel database
CN101916261A (zh) * 2010-07-28 2010-12-15 北京播思软件技术有限公司 一种分布式并行数据库系统的数据分区方法

Also Published As

Publication number Publication date
CN104871153B (zh) 2018-10-30
CN104871153A (zh) 2015-08-26

Similar Documents

Publication Publication Date Title
CN104871153B8 (zh) 用于分布式大规模并行处理数据库的方法和系统
EP3535729A4 (en) DATA AGGREGATION SYSTEMS AND METHODS ASSOCIATED WITH MEDICAL CARE FROM MULTIPLE DATA CENTERS AND APPLICATIONS THEREOF
EP3026549A3 (en) Systems and methods of data extraction in a vector processor
EP2608074A3 (en) Systems and methods for merging source records in accordance with survivorship rules
WO2012129149A3 (en) Aggregating search results based on associating data instances with knowledge base entities
EP2595068A3 (en) System and method of performing snapshot isolation in distributed databases
GB2514275A (en) Identifying and ranking solutions from multiple data sources
MX2016004369A (es) Sistemas y metodos para la asignacion y enrutamiento basandose en agrupacion.
GB201310169D0 (en) A method for attesting a plurality of data processing systems
WO2014107519A3 (en) Compression and deduplication layered driver
EP3887966A4 (en) SCHEDULING TASKS IN DATABASE SYSTEMS
WO2015020921A3 (en) Clustering short answers to questions
WO2013188843A3 (en) Vehicle fleet routing system
GB2507208A (en) Modular array of fixed-coupling quantum systems for quantum information processing
GB2531198A (en) Identifying matching properties between a group of bodies representing a geological structure and a table of properties
CA2883079C (en) Associating computer-executable objects with three-dimensional spaces within an architectural design environment
GB2541616A (en) Data processing system and method for financial or non-financial data
PH12017500234B1 (en) Information-processing system
MX2016016009A (es) Sistema y metodos para una credencial inlcuyendo multiples privilegios de acceso.
EP3040865A4 (en) Database management system and computer system
MX2018006523A (es) Tecnicas para asignacion de asuntos.
WO2014004545A3 (en) Pushing business objects
WO2014165208A3 (en) Meter reading data validation
WO2012003249A3 (en) System and method of analyzing business process events
EP2626795A3 (en) User-guided multi-schema integration

Legal Events

Date Code Title Description
PB01 Publication
EXSB Decision made by sipo to initiate substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
CI03 Correction of invention patent
CI03 Correction of invention patent

Correction item: Priority first application number

Correct: 13/663,237

False: 13/663,327

Number: 44-01

Volume: 34

Correction item: Priority first application number

Correct: 13/663,237

False: 13/663,327

Number: 44-01

Page: The title page

Volume: 34