CA3130648A1 - Data processing query method and device based on olap pre-calculation model - Google Patents
Data processing query method and device based on olap pre-calculation model Download PDFInfo
- Publication number
- CA3130648A1 CA3130648A1 CA3130648A CA3130648A CA3130648A1 CA 3130648 A1 CA3130648 A1 CA 3130648A1 CA 3130648 A CA3130648 A CA 3130648A CA 3130648 A CA3130648 A CA 3130648A CA 3130648 A1 CA3130648 A1 CA 3130648A1
- Authority
- CA
- Canada
- Prior art keywords
- query
- dimension
- entries
- metadata
- olap
- 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 47
- 238000012545 processing Methods 0.000 title claims abstract description 37
- 238000004364 calculation method Methods 0.000 title description 2
- 238000013479 data entry Methods 0.000 claims abstract description 23
- 238000003860 storage Methods 0.000 claims abstract description 14
- 238000004140 cleaning Methods 0.000 claims abstract description 10
- 238000004590 computer program Methods 0.000 claims description 6
- 238000002407 reforming Methods 0.000 claims description 3
- 230000009286 beneficial effect Effects 0.000 description 5
- 238000006243 chemical reaction Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000013499 data model Methods 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 230000003203 everyday effect Effects 0.000 description 2
- 238000011144 upstream manufacturing Methods 0.000 description 2
- 238000012351 Integrated analysis Methods 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000002699 waste material Substances 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/242—Query formulation
- G06F16/2433—Query languages
-
- 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/2453—Query optimisation
-
- 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
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Quality & Reliability (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010950451.7A CN112148719B (zh) | 2020-09-11 | 2020-09-11 | 基于olap预计算模型的数据加工查询方法及装置 |
| CN202010950451.7 | 2020-09-11 |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CA3130648A1 true CA3130648A1 (en) | 2022-03-11 |
Family
ID=73890031
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA3130648A Pending CA3130648A1 (en) | 2020-09-11 | 2021-09-13 | Data processing query method and device based on olap pre-calculation model |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN112148719B (zh) |
| CA (1) | CA3130648A1 (zh) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112685421A (zh) * | 2020-12-31 | 2021-04-20 | 浪潮云信息技术股份公司 | 一种基于大数据和预计算的热线分析方法及模型 |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7716167B2 (en) * | 2002-12-18 | 2010-05-11 | International Business Machines Corporation | System and method for automatically building an OLAP model in a relational database |
| CN107133342A (zh) * | 2017-05-16 | 2017-09-05 | 广州舜飞信息科技有限公司 | 一种IndexR实时数据分析库 |
| CN109684352B (zh) * | 2018-12-29 | 2020-12-01 | 江苏满运软件科技有限公司 | 数据分析系统、方法、存储介质及电子设备 |
-
2020
- 2020-09-11 CN CN202010950451.7A patent/CN112148719B/zh active Active
-
2021
- 2021-09-13 CA CA3130648A patent/CA3130648A1/en active Pending
Also Published As
| Publication number | Publication date |
|---|---|
| CN112148719B (zh) | 2022-11-18 |
| CN112148719A (zh) | 2020-12-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7343568B2 (ja) | 機械学習のためのハイパーパラメータの識別および適用 | |
| CN106997386B (zh) | 一种olap预计算模型、自动建模方法及自动建模系统 | |
| Saleem et al. | Feasible: A feature-based sparql benchmark generation framework | |
| Zhang et al. | On complexity and optimization of expensive queries in complex event processing | |
| Dourish | No SQL: The shifting materialities of database technology | |
| Angles et al. | Benchmarking database systems for social network applications | |
| CN106557558B (zh) | 一种数据分析方法及装置 | |
| Fan et al. | Making queries tractable on big data with preprocessing: through the eyes of complexity theory | |
| US11514498B2 (en) | System and method for intelligent guided shopping | |
| CN110046298A (zh) | 一种查询词推荐方法、装置、终端设备及计算机可读介质 | |
| CN110716950A (zh) | 一种口径系统建立方法、装置、设备及计算机存储介质 | |
| Chambi et al. | Optimizing druid with roaring bitmaps | |
| CA3130648A1 (en) | Data processing query method and device based on olap pre-calculation model | |
| US20190266163A1 (en) | System and method for behavior-on-read query processing | |
| Luo et al. | AutoSmart: An efficient and automatic machine learning framework for temporal relational data | |
| Chen | Multi-perspective evaluation of relational and graph databases | |
| Xylogiannopoulos et al. | Clickstream analytics: an experimental analysis of the amazon users' simulated monthly traffic | |
| CN110765100B (zh) | 标签的生成方法、装置、计算机可读存储介质及服务器 | |
| Phinney et al. | Cartesian operations on distributed datasets using virtual partitioning | |
| Dayal et al. | Optimization of analytic data flows for next generation business intelligence applications | |
| Winberg et al. | A comparison of relational and graph databases for crm systems | |
| CN112667663A (zh) | 一种数据查询方法及系统 | |
| CN110837508A (zh) | 一种口径系统建立方法、装置、设备及计算机存储介质 | |
| KR20190136292A (ko) | 지능형 자료구조 기반의 데이터 처리 방법 및 그를 위한 장치 | |
| Aligon et al. | Summarizing and querying logs of OLAP 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 |