CN110175202A - 用于数据库的表的外连接的方法和系统 - Google Patents
用于数据库的表的外连接的方法和系统 Download PDFInfo
- Publication number
- CN110175202A CN110175202A CN201910345389.6A CN201910345389A CN110175202A CN 110175202 A CN110175202 A CN 110175202A CN 201910345389 A CN201910345389 A CN 201910345389A CN 110175202 A CN110175202 A CN 110175202A
- Authority
- CN
- China
- Prior art keywords
- nodes
- executed
- node
- attended operation
- broadcast
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 35
- 230000002776 aggregation Effects 0.000 claims description 11
- 238000004220 aggregation Methods 0.000 claims description 11
- 238000009826 distribution Methods 0.000 description 9
- 230000008901 benefit Effects 0.000 description 6
- 238000010586 diagram Methods 0.000 description 6
- 230000005540 biological transmission Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
年龄 | 补贴 |
22 | 1000 |
23 | 1500 |
24 | 2000 |
年龄 | 补贴 |
22 | 张三 |
22 | 李四 |
年龄 | 补贴 |
23 | 王五 |
年龄 | 补贴 |
25 | 赵六 |
年龄 | 补贴 |
27 | 孙七 |
27 | 钱八 |
Claims (15)
Priority Applications (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910345389.6A CN110175202B (zh) | 2019-04-26 | 2019-04-26 | 用于数据库的表的外连接的方法和系统 |
PCT/CN2020/071400 WO2020215830A1 (zh) | 2019-04-26 | 2020-01-10 | 用于数据库的表的外连接的方法和系统 |
US16/877,394 US10885035B2 (en) | 2019-04-26 | 2020-05-18 | Method and system for outer join of database tables |
US17/100,574 US11086872B2 (en) | 2019-04-26 | 2020-11-20 | Method and system for outer join of database tables |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910345389.6A CN110175202B (zh) | 2019-04-26 | 2019-04-26 | 用于数据库的表的外连接的方法和系统 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110175202A true CN110175202A (zh) | 2019-08-27 |
CN110175202B CN110175202B (zh) | 2021-09-10 |
Family
ID=67690144
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910345389.6A Active CN110175202B (zh) | 2019-04-26 | 2019-04-26 | 用于数据库的表的外连接的方法和系统 |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN110175202B (zh) |
WO (1) | WO2020215830A1 (zh) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111209305A (zh) * | 2019-11-19 | 2020-05-29 | 华为技术有限公司 | 查询数据的方法、数据节点、分布式数据库、计算设备 |
WO2020215830A1 (zh) * | 2019-04-26 | 2020-10-29 | 创新先进技术有限公司 | 用于数据库的表的外连接的方法和系统 |
US10885035B2 (en) | 2019-04-26 | 2021-01-05 | Advanced New Technologies Co., Ltd. | Method and system for outer join of database tables |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110302151A1 (en) * | 2010-06-04 | 2011-12-08 | Yale University | Query Execution Systems and Methods |
CN102844754A (zh) * | 2010-03-30 | 2012-12-26 | 惠普发展公司,有限责任合伙企业 | 用于对并行数据库管理系统的外连接的系统和方法 |
US20170147644A1 (en) * | 2015-11-20 | 2017-05-25 | Sap Se | Query optimization using join cardinality |
CN109344169A (zh) * | 2018-09-20 | 2019-02-15 | 新华三大数据技术有限公司 | 数据处理方法及装置 |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8306959B2 (en) * | 2010-08-06 | 2012-11-06 | Ianywhere Solutions, Inc. | Incremental maintenance of immediate materialized views with outerjoins |
CN106933927B (zh) * | 2015-12-31 | 2019-12-10 | 北京国双科技有限公司 | 数据表的连接方法和装置 |
CN109241101B (zh) * | 2018-08-31 | 2020-06-30 | 阿里巴巴集团控股有限公司 | 一种数据库查询优化方法、装置、及计算机设备 |
CN110175202B (zh) * | 2019-04-26 | 2021-09-10 | 蚂蚁金服(杭州)网络技术有限公司 | 用于数据库的表的外连接的方法和系统 |
-
2019
- 2019-04-26 CN CN201910345389.6A patent/CN110175202B/zh active Active
-
2020
- 2020-01-10 WO PCT/CN2020/071400 patent/WO2020215830A1/zh active Application Filing
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102844754A (zh) * | 2010-03-30 | 2012-12-26 | 惠普发展公司,有限责任合伙企业 | 用于对并行数据库管理系统的外连接的系统和方法 |
US20110302151A1 (en) * | 2010-06-04 | 2011-12-08 | Yale University | Query Execution Systems and Methods |
US20170147644A1 (en) * | 2015-11-20 | 2017-05-25 | Sap Se | Query optimization using join cardinality |
CN109344169A (zh) * | 2018-09-20 | 2019-02-15 | 新华三大数据技术有限公司 | 数据处理方法及装置 |
Non-Patent Citations (2)
Title |
---|
于洋 等: "基于布谷鸟过滤器的外连接算法", 《华东师范大学学报(自然科学版)》 * |
樊秋实: "面向OceanBase的分布式大表连接与优化", 《中国优秀硕士学位论文全文数据库 信息科技辑(月刊 )》 * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2020215830A1 (zh) * | 2019-04-26 | 2020-10-29 | 创新先进技术有限公司 | 用于数据库的表的外连接的方法和系统 |
US10885035B2 (en) | 2019-04-26 | 2021-01-05 | Advanced New Technologies Co., Ltd. | Method and system for outer join of database tables |
US11086872B2 (en) | 2019-04-26 | 2021-08-10 | Ant Financial (Hang Zhou) Network Technology Co., Ltd. | Method and system for outer join of database tables |
CN111209305A (zh) * | 2019-11-19 | 2020-05-29 | 华为技术有限公司 | 查询数据的方法、数据节点、分布式数据库、计算设备 |
Also Published As
Publication number | Publication date |
---|---|
WO2020215830A1 (zh) | 2020-10-29 |
CN110175202B (zh) | 2021-09-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7779008B2 (en) | Parallel partition-wise aggregation | |
Afrati et al. | Optimizing joins in a map-reduce environment | |
US9195701B2 (en) | System and method for flexible distributed massively parallel processing (MPP) database | |
CN110837585B (zh) | 多源异构的数据关联查询方法及系统 | |
US20120036146A1 (en) | Apparatus for elastic database processing with heterogeneous data | |
CN110175202A (zh) | 用于数据库的表的外连接的方法和系统 | |
CN104408159B (zh) | 一种数据关联、加载、查询方法及装置 | |
US11036709B2 (en) | Single-level, multi-dimension, hash-based table partitioning | |
US11086872B2 (en) | Method and system for outer join of database tables | |
CN110110108B (zh) | 一种图数据库的数据导入方法及装置 | |
CN104871153A (zh) | 用于灵活的分布式大规模并行处理(mpp)数据库的系统和方法 | |
CN107798017A (zh) | 分布式数据库中的执行计划信息生成方法和系统 | |
CN109716321A (zh) | N路散列连接 | |
CN111475511A (zh) | 基于树状结构的数据存储方法、访问方法、装置及设备 | |
WO2021004266A1 (zh) | 数据插入方法、装置、设备和储存介质 | |
CN110389953B (zh) | 基于压缩图的数据存储方法、存储介质、存储装置和服务器 | |
CN114490724B (zh) | 处理数据库查询语句的方法和装置 | |
CN113468169B (zh) | 硬件数据库查询方法、数据库系统查询方法及装置 | |
CN108345699A (zh) | 获取多媒体数据的方法、装置及存储介质 | |
CN111259062B (zh) | 一种能够保证分布式数据库全表查询语句结果集顺序的方法和装置 | |
CN108536758B (zh) | 一种数据库模式的数据表重构方法、装置及系统 | |
CN109388638B (zh) | 用于分布式大规模并行处理数据库的方法及系统 | |
US7933867B1 (en) | Maintaining views of cube-based operations in a database system | |
CN113722332B (zh) | 基于数据结构提升匹配算法效率和鲁棒性的方法及系统 | |
CN117744792A (zh) | 一种子图匹配的处理方法和装置 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 40013137 Country of ref document: HK |
|
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
TA01 | Transfer of patent application right |
Effective date of registration: 20210129 Address after: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Applicant after: Ant financial (Hangzhou) Network Technology Co.,Ltd. Address before: Ky1-9008 business centre, 27 Hospital Road, Georgetown, grand caiman, UK Applicant before: Innovative advanced technology Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20210907 Address after: 100020 unit 02, 901, floor 9, unit 1, building 1, No.1, East Third Ring Middle Road, Chaoyang District, Beijing Applicant after: Beijing Aoxing Beisi Technology Co.,Ltd. Address before: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province 310000 Applicant before: Ant financial (Hangzhou) Network Technology Co.,Ltd. |