CA3131330A1 - Database aggregation query method, device and system - Google Patents

Database aggregation query method, device and system Download PDF

Info

Publication number: CA3131330A1
Authority: CA; Canada
Prior art keywords: hat; trie; grouped; aggregate; fields
Prior art date: 2020-09-18
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.): Pending

Application number

CA3131330A

Other languages

English (en)

French (fr)

Inventor

Qiang Zhang

Jinzhong Wang

Qian Sun

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.)

10353744 Canada Ltd

Original Assignee

10353744 Canada 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.)

2020-09-18

Filing date

2021-09-20

Publication date

2022-03-18

2021-09-20 Application filed by 10353744 Canada Ltd filed Critical 10353744 Canada Ltd

2022-03-18 Publication of CA3131330A1 publication Critical patent/CA3131330A1/en

Status Pending legal-status Critical Current

Links

238000000034 method Methods 0.000 title claims abstract description 35
230000002776 aggregation Effects 0.000 title description 2
238000004220 aggregation Methods 0.000 title description 2
238000004364 calculation method Methods 0.000 claims abstract description 21
230000006870 function Effects 0.000 claims description 44
230000004931 aggregating effect Effects 0.000 claims description 8
238000012545 processing Methods 0.000 description 8
238000004891 communication Methods 0.000 description 5
238000011240 pooled analysis Methods 0.000 description 5
230000008569 process Effects 0.000 description 4
230000002035 prolonged effect Effects 0.000 description 3
238000010586 diagram Methods 0.000 description 2
238000013468 resource allocation Methods 0.000 description 2
240000008100 Brassica rapa Species 0.000 description 1
241001023492 Rubicundus Species 0.000 description 1
102100030852 Run domain Beclin-1-interacting and cysteine-rich domain-containing protein Human genes 0.000 description 1
101710179516 Run domain Beclin-1-interacting and cysteine-rich domain-containing protein Proteins 0.000 description 1
238000013459 approach Methods 0.000 description 1
230000009286 beneficial effect Effects 0.000 description 1
230000005540 biological transmission Effects 0.000 description 1
238000013500 data storage Methods 0.000 description 1
230000003247 decreasing effect Effects 0.000 description 1
230000000694 effects Effects 0.000 description 1
238000005516 engineering process Methods 0.000 description 1
230000006872 improvement Effects 0.000 description 1
238000007726 management method Methods 0.000 description 1
238000012986 modification Methods 0.000 description 1
230000004048 modification Effects 0.000 description 1
230000003287 optical effect Effects 0.000 description 1
230000000750 progressive effect Effects 0.000 description 1
230000003068 static 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/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
- 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/248—Presentation of query results

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)

CA3131330A 2020-09-18 2021-09-20 Database aggregation query method, device and system Pending CA3131330A1 (en)

Applications Claiming Priority (2)

Application Number	Priority Date	Filing Date	Title
CN202010988662.XA CN112307062B (zh)	2020-09-18	2020-09-18	数据库聚合查询方法、装置及***
CN202010988662.X		2020-09-18

Publications (1)

Publication Number	Publication Date
CA3131330A1 true CA3131330A1 (en)	2022-03-18

Family

ID=74483523

Family Applications (1)

Application Number	Title	Priority Date	Filing Date
CA3131330A Pending CA3131330A1 (en)	2020-09-18	2021-09-20	Database aggregation query method, device and system

Country Status (2)

Country	Link
CN (1)	CN112307062B (zh)
CA (1)	CA3131330A1 (zh)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number	Priority date	Publication date	Assignee	Title
CN115952185A (zh) *	2023-03-10	2023-04-11	布比（北京）网络技术有限公司	一种数据处理方法及装置、设备及存储介质

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number	Priority date	Publication date	Assignee	Title
CN113204602B (zh) *	2021-05-07	2023-08-01	星环信息科技(上海)股份有限公司	数据处理方法、装置、设备及存储介质
CN115174496B (zh) *	2022-05-23	2024-02-13	北京大学	一种用于网内聚合传输的处理终端和交换机

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number	Priority date	Publication date	Assignee	Title
CN104199541A (zh) *	2014-08-08	2014-12-10	乐视网信息技术（北京）股份有限公司	基于笔画输入进行搜索的方法及装置
US10740328B2 (en) *	2016-06-24	2020-08-11	Microsoft Technology Licensing, Llc	Aggregate-query database system and processing
CN106250519A (zh) *	2016-08-04	2016-12-21	曙光信息产业(北京)有限公司	用于并行数据库的数据查询方法和装置
CN109471863B (zh) *	2018-11-12	2021-07-20	北京懿医云科技有限公司	基于分布式数据库的信息查询方法及装置、电子设备
CN110175184B (zh) *	2019-04-30	2023-01-20	创新先进技术有限公司	一种数据维度的下钻方法、***及电子设备

2020
- 2020-09-18 CN CN202010988662.XA patent/CN112307062B/zh active Active
2021
- 2021-09-20 CA CA3131330A patent/CA3131330A1/en active Pending

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number	Priority date	Publication date	Assignee	Title
CN115952185A (zh) *	2023-03-10	2023-04-11	布比（北京）网络技术有限公司	一种数据处理方法及装置、设备及存储介质

Also Published As

Publication number	Publication date
CN112307062B (zh)	2022-11-22
CN112307062A (zh)	2021-02-02

Similar Documents

Publication	Publication Date	Title
CA3131330A1 (en)	2022-03-18	Database aggregation query method, device and system
US10866971B2 (en)	2020-12-15	Hash collision tables for relational operations
US9251213B2 (en)	2016-02-02	Estimating error propagation for database optimizers
US11663213B2 (en)	2023-05-30	Distinct value estimation for query planning
US7146365B2 (en)	2006-12-05	Method, system, and program for optimizing database query execution
US11514028B2 (en)	2022-11-29	Hybrid data storage and load system with ROWID lookup
US20200089678A1 (en)	2020-03-19	Autonomic caching for in memory data grid query processing
CA3057038C (en)	2023-06-27	Data filtering method, apparatus, electronic apparatus and storage medium
CN114443691B (zh)	2024-01-23	数据库查询调优方法、***及计算机设备
US11500873B2 (en)	2022-11-15	Methods and systems for searching directory access groups
US12026160B2 (en)	2024-07-02	Query plan cache in database systems
US11790008B2 (en)	2023-10-17	Persisted queries and batch streaming
US20100191730A1 (en)	2010-07-29	Efficiency in processing queries directed to static data sets
CN108932258B (zh)	2022-05-24	数据索引处理方法及装置
US20230146136A1 (en)	2023-05-11	Method and apparatus for scoring precomputation model, device, and storage medium
CN116860798A (zh)	2023-10-10	数据查询方法、电子设备及计算机可读存储介质
CN110781205A (zh)	2020-02-11	一种基于jdbc的数据库直查方法、装置及***
US10803065B1 (en)	2020-10-13	Microcubes
CN114064729A (zh)	2022-02-18	一种数据检索方法、装置、设备及存储介质
Ujibashi et al.	2015	Design of a Shared Memory mechanism for efficient paralell processing in PostgreSQL
KR20210095083A (ko)	2021-07-30	그래프 계산의 처리 방법, 장치, 전자기기 및 저장매체
WO2021143199A1 (zh)	2021-07-22	日志查询方法、装置、计算机设备和存储介质
US11803597B2 (en)	2023-10-31	Data updating method, apparatus, search server, terminal and storage medium
US20240152513A1 (en)	2024-05-09	Processing correlated calculated fields in correlated subqueries
US20240126816A1 (en)	2024-04-18	Self-discovery and construction of type-sensitive columnar formats on type-agnostic storage servers to accelerate offloaded queries

Legal Events

Date	Code	Title	Description
2023-02-08	EEER	Examination request	Effective date: 20220916
2023-05-11	EEER	Examination request	Effective date: 20220916
2023-06-15	EEER	Examination request	Effective date: 20220916
2023-08-10	EEER	Examination request	Effective date: 20220916
2023-12-15	EEER	Examination request	Effective date: 20220916