CA3131330A1 - Database aggregation query method, device and system - Google Patents
Database aggregation query method, device and system Download PDFInfo
- Publication number
- CA3131330A1 CA3131330A1 CA3131330A CA3131330A CA3131330A1 CA 3131330 A1 CA3131330 A1 CA 3131330A1 CA 3131330 A CA3131330 A CA 3131330A CA 3131330 A CA3131330 A CA 3131330A CA 3131330 A1 CA3131330 A1 CA 3131330A1
- Authority
- CA
- Canada
- Prior art keywords
- hat
- trie
- grouped
- aggregate
- fields
- 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.)
- Pending
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)
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)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN115952185A (zh) * | 2023-03-10 | 2023-04-11 | 布比(北京)网络技术有限公司 | 一种数据处理方法及装置、设备及存储介质 |
Families Citing this family (2)
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)
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)
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) | Database aggregation query method, device and system | |
US10866971B2 (en) | Hash collision tables for relational operations | |
US9251213B2 (en) | Estimating error propagation for database optimizers | |
US11663213B2 (en) | Distinct value estimation for query planning | |
US7146365B2 (en) | Method, system, and program for optimizing database query execution | |
US11514028B2 (en) | Hybrid data storage and load system with ROWID lookup | |
US20200089678A1 (en) | Autonomic caching for in memory data grid query processing | |
CA3057038C (en) | Data filtering method, apparatus, electronic apparatus and storage medium | |
CN114443691B (zh) | 数据库查询调优方法、***及计算机设备 | |
US11500873B2 (en) | Methods and systems for searching directory access groups | |
US12026160B2 (en) | Query plan cache in database systems | |
US11790008B2 (en) | Persisted queries and batch streaming | |
US20100191730A1 (en) | Efficiency in processing queries directed to static data sets | |
CN108932258B (zh) | 数据索引处理方法及装置 | |
US20230146136A1 (en) | Method and apparatus for scoring precomputation model, device, and storage medium | |
CN116860798A (zh) | 数据查询方法、电子设备及计算机可读存储介质 | |
CN110781205A (zh) | 一种基于jdbc的数据库直查方法、装置及*** | |
US10803065B1 (en) | Microcubes | |
CN114064729A (zh) | 一种数据检索方法、装置、设备及存储介质 | |
Ujibashi et al. | Design of a Shared Memory mechanism for efficient paralell processing in PostgreSQL | |
KR20210095083A (ko) | 그래프 계산의 처리 방법, 장치, 전자기기 및 저장매체 | |
WO2021143199A1 (zh) | 日志查询方法、装置、计算机设备和存储介质 | |
US11803597B2 (en) | Data updating method, apparatus, search server, terminal and storage medium | |
US20240152513A1 (en) | Processing correlated calculated fields in correlated subqueries | |
US20240126816A1 (en) | Self-discovery and construction of type-sensitive columnar formats on type-agnostic storage servers to accelerate offloaded queries |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
EEER | Examination request |
Effective date: 20220916 |
|
EEER | Examination request |
Effective date: 20220916 |
|
EEER | Examination request |
Effective date: 20220916 |
|
EEER | Examination request |
Effective date: 20220916 |
|
EEER | Examination request |
Effective date: 20220916 |