CN110597808A - 分布式数据库表连接方法、装置、***、服务器及介质 - Google Patents
分布式数据库表连接方法、装置、***、服务器及介质 Download PDFInfo
- Publication number
- CN110597808A CN110597808A CN201910769332.9A CN201910769332A CN110597808A CN 110597808 A CN110597808 A CN 110597808A CN 201910769332 A CN201910769332 A CN 201910769332A CN 110597808 A CN110597808 A CN 110597808A
- Authority
- CN
- China
- Prior art keywords
- data
- node
- appearance
- inner table
- thread
- 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
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
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)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (15)
Priority Applications (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910769332.9A CN110597808B (zh) | 2019-08-20 | 2019-08-20 | 分布式数据库表连接方法、装置、***、服务器及介质 |
CN202110641444.3A CN113434500A (zh) | 2019-08-20 | 2019-08-20 | 表连接方法、装置、分布式数据库***、服务器及介质 |
PCT/CN2020/072120 WO2021031527A1 (zh) | 2019-08-20 | 2020-01-15 | 分布式数据库表连接方法、装置、***、服务器及介质 |
US16/882,880 US11036733B2 (en) | 2019-08-20 | 2020-05-26 | Method, apparatus, system, server, and storage medium for connecting tables stored at distributed database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910769332.9A CN110597808B (zh) | 2019-08-20 | 2019-08-20 | 分布式数据库表连接方法、装置、***、服务器及介质 |
Related Child Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110641444.3A Division CN113434500A (zh) | 2019-08-20 | 2019-08-20 | 表连接方法、装置、分布式数据库***、服务器及介质 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110597808A true CN110597808A (zh) | 2019-12-20 |
CN110597808B CN110597808B (zh) | 2021-05-18 |
Family
ID=68854769
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910769332.9A Active CN110597808B (zh) | 2019-08-20 | 2019-08-20 | 分布式数据库表连接方法、装置、***、服务器及介质 |
CN202110641444.3A Pending CN113434500A (zh) | 2019-08-20 | 2019-08-20 | 表连接方法、装置、分布式数据库***、服务器及介质 |
Family Applications After (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110641444.3A Pending CN113434500A (zh) | 2019-08-20 | 2019-08-20 | 表连接方法、装置、分布式数据库***、服务器及介质 |
Country Status (2)
Country | Link |
---|---|
CN (2) | CN110597808B (zh) |
WO (1) | WO2021031527A1 (zh) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021031527A1 (zh) * | 2019-08-20 | 2021-02-25 | 蚂蚁金服(杭州)网络技术有限公司 | 分布式数据库表连接方法、装置、***、服务器及介质 |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN114115735B (zh) * | 2021-11-18 | 2024-02-09 | 北京奥星贝斯科技有限公司 | 写入数据的方法及装置 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104391957A (zh) * | 2014-12-01 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | 一种针对混合型大数据处理***的数据交互分析方法 |
US20160267135A1 (en) * | 2015-03-10 | 2016-09-15 | Oracle International Corporation | Adaptive handling of skew for distributed joins in a cluster |
CN107870954A (zh) * | 2016-09-28 | 2018-04-03 | ***通信集团广东有限公司 | 一种分布式数据库的扩展方法及装置 |
CN109299340A (zh) * | 2018-12-03 | 2019-02-01 | 江苏警官学院 | 一种基于图数据库的微博用户转发关系导入及可视化方法 |
Family Cites Families (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP2499576A2 (en) * | 2009-11-13 | 2012-09-19 | Richard S. Anderson | Distributed symmetric multiprocessing computing architecture |
US8935232B2 (en) * | 2010-06-04 | 2015-01-13 | Yale University | Query execution systems and methods |
US9298772B2 (en) * | 2013-03-15 | 2016-03-29 | Oracle International Corporation | Small table replication for parallelized join operations |
US9372892B1 (en) * | 2015-12-28 | 2016-06-21 | International Business Machines Corporation | Bloom filter construction method for use in a table join operation portion of processing a query to a distributed database |
CN107305581B (zh) * | 2016-04-25 | 2020-06-16 | 华为技术有限公司 | 分布式数据库***中的表连接方法及分布式数据库*** |
CN110019360A (zh) * | 2017-10-27 | 2019-07-16 | 阿里巴巴集团控股有限公司 | 一种数据处理方法及装置 |
CN110019341B (zh) * | 2017-12-08 | 2021-07-23 | 杭州海康威视数字技术股份有限公司 | 一种数据查询方法及装置 |
US10698920B2 (en) * | 2017-12-22 | 2020-06-30 | Dropbox, Inc. | Techniques for a linearizable primary-secondary database system that replicates database data with eventual consistency |
CN108829798B (zh) * | 2018-06-05 | 2024-02-02 | 平安科技(深圳)有限公司 | 基于分布式数据库的数据存储方法及*** |
CN109165258A (zh) * | 2018-08-14 | 2019-01-08 | 郑州云海信息技术有限公司 | 一种数据同步方法与装置 |
CN109508326B (zh) * | 2018-11-22 | 2020-03-17 | 北京百度网讯科技有限公司 | 用于处理数据的方法、装置和*** |
CN110597808B (zh) * | 2019-08-20 | 2021-05-18 | 蚂蚁金服(杭州)网络技术有限公司 | 分布式数据库表连接方法、装置、***、服务器及介质 |
-
2019
- 2019-08-20 CN CN201910769332.9A patent/CN110597808B/zh active Active
- 2019-08-20 CN CN202110641444.3A patent/CN113434500A/zh active Pending
-
2020
- 2020-01-15 WO PCT/CN2020/072120 patent/WO2021031527A1/zh active Application Filing
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104391957A (zh) * | 2014-12-01 | 2015-03-04 | 浪潮电子信息产业股份有限公司 | 一种针对混合型大数据处理***的数据交互分析方法 |
US20160267135A1 (en) * | 2015-03-10 | 2016-09-15 | Oracle International Corporation | Adaptive handling of skew for distributed joins in a cluster |
CN107870954A (zh) * | 2016-09-28 | 2018-04-03 | ***通信集团广东有限公司 | 一种分布式数据库的扩展方法及装置 |
CN109299340A (zh) * | 2018-12-03 | 2019-02-01 | 江苏警官学院 | 一种基于图数据库的微博用户转发关系导入及可视化方法 |
Non-Patent Citations (2)
Title |
---|
KALEIDOSCOPIC: "《阿里巴巴分布式数据库服务DRDS研发历程》", 《HTTP://WWW.CNBLOGS.COM/KALEIDOSCOPE/P/9762988.HTML》 * |
樊秋实: "《面向OceanBase的分布式大表连接与优化》", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021031527A1 (zh) * | 2019-08-20 | 2021-02-25 | 蚂蚁金服(杭州)网络技术有限公司 | 分布式数据库表连接方法、装置、***、服务器及介质 |
Also Published As
Publication number | Publication date |
---|---|
CN110597808B (zh) | 2021-05-18 |
CN113434500A (zh) | 2021-09-24 |
WO2021031527A1 (zh) | 2021-02-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8812535B2 (en) | Propagating a query in a federated database | |
EP2005709B1 (en) | Service registry and relevant system and method | |
US11477084B2 (en) | Method and system for node discovery and self-healing of blockchain networks | |
US9875186B2 (en) | System and method for data caching in processing nodes of a massively parallel processing (MPP) database system | |
US11736371B2 (en) | Heartbeat information sending method and apparatus, and heartbeat sending node | |
CN108737534B (zh) | 一种基于区块链的数据传输方法、装置、区块链*** | |
WO2015062444A1 (en) | System and method for creating a distributed transaction manager supporting repeatable read isolation level in a mpp database | |
US20090077075A1 (en) | Management of logical statements in a distributed database environment | |
CN108984639B (zh) | 服务器集群的数据处理方法和装置 | |
CN110413845B (zh) | 基于物联网操作***的资源存储方法及装置 | |
CN110427386B (zh) | 数据处理方法、装置及计算机存储介质 | |
CN110597808B (zh) | 分布式数据库表连接方法、装置、***、服务器及介质 | |
CN111930770A (zh) | 数据查询方法、装置及电子设备 | |
CN103607424A (zh) | 一种服务器连接方法及服务器*** | |
CN107547605B (zh) | 一种基于节点队列的消息读写方法及节点设备 | |
CN110798492B (zh) | 数据存储方法及装置、数据处理*** | |
US11954069B2 (en) | Find operation for union-mounted systems | |
US11036733B2 (en) | Method, apparatus, system, server, and storage medium for connecting tables stored at distributed database | |
CN107710793A (zh) | 一种定位方法及对应装置 | |
CN115510161A (zh) | 数据同步方法、装置、设备及存储介质 | |
JP2011134005A (ja) | 構成情報管理装置、分散情報管理システム、分散情報管理方法および分散情報管理プログラム | |
CN117312297B (zh) | 数据管理方法及装置 | |
JPH09114722A (ja) | 分散システムにおける共有情報管理方法 | |
CN115827270A (zh) | 数据处理方法、装置、服务器、介质及产品 | |
CN117493277A (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 | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman 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 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 | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20210207 Address after: 801-10, Section B, 8th floor, 556 Xixi Road, Xihu District, Hangzhou City, Zhejiang Province Applicant after: Ant financial (Hangzhou) Network Technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Innovative advanced technology Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right |
Effective date of registration: 20210909 Address after: 100020 unit 02, 901, floor 9, unit 1, building 1, No.1, East Third Ring Middle Road, Chaoyang District, Beijing Patentee 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 Patentee before: Ant financial (Hangzhou) Network Technology Co.,Ltd. |
|
TR01 | Transfer of patent right |