CN104504154B - 一种数据聚合查询的方法及装置 - Google Patents
一种数据聚合查询的方法及装置 Download PDFInfo
- Publication number
- CN104504154B CN104504154B CN201510018619.XA CN201510018619A CN104504154B CN 104504154 B CN104504154 B CN 104504154B CN 201510018619 A CN201510018619 A CN 201510018619A CN 104504154 B CN104504154 B CN 104504154B
- Authority
- CN
- China
- Prior art keywords
- data
- node
- aggregate
- inquiry
- packet
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000004220 aggregation Methods 0.000 claims description 98
- 230000002776 aggregation Effects 0.000 claims description 98
- 230000006870 function Effects 0.000 claims description 70
- 238000009826 distribution Methods 0.000 claims description 27
- 238000001914 filtration Methods 0.000 claims description 10
- 102100034286 Ankyrin repeat domain-containing protein 27 Human genes 0.000 claims description 9
- 101000780114 Homo sapiens Ankyrin repeat domain-containing protein 27 Proteins 0.000 claims description 9
- 238000006116 polymerization reaction Methods 0.000 claims description 9
- 238000003860 storage Methods 0.000 claims description 7
- 238000000354 decomposition reaction Methods 0.000 claims description 5
- 230000008859 change Effects 0.000 claims description 3
- 238000004891 communication Methods 0.000 abstract description 10
- 238000012545 processing Methods 0.000 description 15
- 238000010586 diagram Methods 0.000 description 12
- 101100328884 Caenorhabditis elegans sqt-3 gene Proteins 0.000 description 9
- 101100328886 Caenorhabditis elegans col-2 gene Proteins 0.000 description 8
- 238000004590 computer program Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 238000007405 data analysis Methods 0.000 description 6
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 101100237842 Xenopus laevis mmp18 gene Proteins 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 230000007423 decrease Effects 0.000 description 2
- 235000013399 edible fruits Nutrition 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 101100323284 Mus musculus Ankrd27 gene Proteins 0.000 description 1
- 230000001154 acute effect Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 229910002056 binary alloy Inorganic materials 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 239000002360 explosive Substances 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012546 transfer Methods 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
- G06F16/24556—Aggregation; Duplicate elimination
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (12)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510018619.XA CN104504154B (zh) | 2015-01-14 | 2015-01-14 | 一种数据聚合查询的方法及装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510018619.XA CN104504154B (zh) | 2015-01-14 | 2015-01-14 | 一种数据聚合查询的方法及装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104504154A CN104504154A (zh) | 2015-04-08 |
CN104504154B true CN104504154B (zh) | 2018-01-16 |
Family
ID=52945551
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510018619.XA Active CN104504154B (zh) | 2015-01-14 | 2015-01-14 | 一种数据聚合查询的方法及装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104504154B (zh) |
Families Citing this family (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105045871B (zh) * | 2015-07-15 | 2018-09-28 | 国家超级计算深圳中心(深圳云计算中心) | 数据聚合查询方法及装置 |
CN106250519A (zh) * | 2016-08-04 | 2016-12-21 | 曙光信息产业(北京)有限公司 | 用于并行数据库的数据查询方法和装置 |
CN106250566A (zh) * | 2016-08-31 | 2016-12-21 | 天津南大通用数据技术股份有限公司 | 一种分布式数据库及其数据运算的管理方法 |
CN106339480A (zh) * | 2016-08-31 | 2017-01-18 | 天津南大通用数据技术股份有限公司 | 数据分组聚合数据分布的选择方法及装置 |
CN106844415B (zh) * | 2016-11-18 | 2021-08-20 | 北京奇虎科技有限公司 | 一种SparkSQL系统中的数据处理方法和装置 |
CN107480260B (zh) * | 2017-08-16 | 2021-02-23 | 北京奇虎科技有限公司 | 大数据实时分析方法、装置、计算设备及计算机存储介质 |
CN107729365B (zh) * | 2017-09-07 | 2020-02-07 | 中国科学院自动化研究所 | 物化视图选择和优化方法及装置 |
CN107918676B (zh) * | 2017-12-15 | 2022-01-18 | 联想(北京)有限公司 | 结构化查询的资源优化方法及数据库查询系统 |
CN108628975B (zh) * | 2018-04-25 | 2020-08-21 | 上海达梦数据库有限公司 | 一种数据库sql语句优化方法及装置 |
CN109710630A (zh) * | 2018-12-25 | 2019-05-03 | 中科曙光国际信息产业有限公司 | 异构数据源的查询方法及装置 |
CN109828968B (zh) * | 2019-02-19 | 2021-12-21 | 广州虎牙信息科技有限公司 | 一种数据去重处理方法、装置、设备、集群及存储介质 |
CN112182028B (zh) * | 2020-09-29 | 2024-07-05 | 北京人大金仓信息技术股份有限公司 | 基于分布式数据库的表的数据行数查询方法和装置 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103136364A (zh) * | 2013-03-14 | 2013-06-05 | 曙光信息产业(北京)有限公司 | 集群数据库系统及其数据查询处理方法 |
CN103310011A (zh) * | 2013-07-02 | 2013-09-18 | 曙光信息产业(北京)有限公司 | 集群数据库系统环境下的数据查询解析方法 |
CN104123374A (zh) * | 2014-07-28 | 2014-10-29 | 北京京东尚科信息技术有限公司 | 分布式数据库中聚合查询的方法及装置 |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US8386508B2 (en) * | 2008-04-28 | 2013-02-26 | Infosys Technologies Limited | System and method for parallel query evaluation |
-
2015
- 2015-01-14 CN CN201510018619.XA patent/CN104504154B/zh active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103136364A (zh) * | 2013-03-14 | 2013-06-05 | 曙光信息产业(北京)有限公司 | 集群数据库系统及其数据查询处理方法 |
CN103310011A (zh) * | 2013-07-02 | 2013-09-18 | 曙光信息产业(北京)有限公司 | 集群数据库系统环境下的数据查询解析方法 |
CN104123374A (zh) * | 2014-07-28 | 2014-10-29 | 北京京东尚科信息技术有限公司 | 分布式数据库中聚合查询的方法及装置 |
Also Published As
Publication number | Publication date |
---|---|
CN104504154A (zh) | 2015-04-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104504154B (zh) | 一种数据聚合查询的方法及装置 | |
US11514045B2 (en) | Structured cluster execution for data streams | |
CN106250519A (zh) | 用于并行数据库的数据查询方法和装置 | |
US9152669B2 (en) | System and method for distributed SQL join processing in shared-nothing relational database clusters using stationary tables | |
US7730055B2 (en) | Efficient hash based full-outer join | |
US9576026B2 (en) | System and method for distributed SQL join processing in shared-nothing relational database clusters using self directed data streams | |
CN103678550B (zh) | 一种基于动态索引结构的海量数据实时查询方法 | |
CN104657446B (zh) | 分表联合统计查询方法、装置和系统 | |
CN103258049A (zh) | 一种基于海量数据的关联规则挖掘方法 | |
Ban et al. | Query optimization of distributed database based on parallel genetic algorithm and max-min ant system | |
CN101739398A (zh) | 分布式数据库多连接查询优化算法 | |
CN105204920B (zh) | 一种基于映射聚合的分布式计算作业的实现方法及装置 | |
CN104809168A (zh) | 超大规模rdf图数据的划分与并行分布处理方法 | |
CN103177035A (zh) | 一种在数据库中查询数据的装置及方法 | |
CN105550332A (zh) | 一种基于双层索引结构的起源图查询方法 | |
CN107545005A (zh) | 一种数据处理方法及装置 | |
CN104834709B (zh) | 一种基于负载均衡的并行余弦模式挖掘方法 | |
US9934304B2 (en) | Systems and methods for memory optimization interest-driven business intelligence systems | |
CN104303176A (zh) | 查询处理 | |
CN108228654A (zh) | 一种大数据分布式存储方法和系统 | |
CN105608077A (zh) | 一种大数据分布式存储方法和系统 | |
US9305065B2 (en) | Calculating count distinct using vertical unions | |
CN116401277A (zh) | 数据处理方法、装置、系统、设备及介质 | |
Anyanwu et al. | Algebraic optimization for processing graph pattern queries in the cloud | |
CN104834532B (zh) | 一种分布式数据向量化处理方法和装置 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
TR01 | Transfer of patent right |
Effective date of registration: 20220801 Address after: 100089 building 36, courtyard 8, Dongbeiwang West Road, Haidian District, Beijing Patentee after: Dawning Information Industry (Beijing) Co.,Ltd. Patentee after: DAWNING INFORMATION INDUSTRY Co.,Ltd. Address before: 100193 No. 36 Building, No. 8 Hospital, Wangxi Road, Haidian District, Beijing Patentee before: Dawning Information Industry (Beijing) Co.,Ltd. |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20240430 Address after: Room 168, 1st Floor, Building 10, No. 1 Courtyard, Longxing Jiayuan, southeast corner of the intersection of Longhu Inner Ring Road and Longzhiyuan East Ninth Street, Zhengdong New District, Zhengzhou City, Henan Province, 450018 Patentee after: Shuguang Information Industry (Henan) Co.,Ltd. Country or region after: China Address before: 100089 building 36, courtyard 8, Dongbeiwang West Road, Haidian District, Beijing Patentee before: Dawning Information Industry (Beijing) Co.,Ltd. Country or region before: China Patentee before: DAWNING INFORMATION INDUSTRY Co.,Ltd. |
|
TR01 | Transfer of patent right |