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 PDF

Info

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
Application number
CA3130648A
Other languages
English (en)
French (fr)
Inventor
Xiaolong Guo
Qian Sun
Qiang SANG
Yaofeng Zheng
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.)
Filing date
Publication date
Application filed by 10353744 Canada Ltd filed Critical 10353744 Canada Ltd
Publication of CA3130648A1 publication Critical patent/CA3130648A1/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/215Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2453Query optimisation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/283Multi-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)
CA3130648A 2020-09-11 2021-09-13 Data processing query method and device based on olap pre-calculation model Pending CA3130648A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN202010950451.7 2020-09-11
CN202010950451.7A CN112148719B (zh) 2020-09-11 2020-09-11 基于olap预计算模型的数据加工查询方法及装置

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)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112685421A (zh) * 2020-12-31 2021-04-20 浪潮云信息技术股份公司 一种基于大数据和预计算的热线分析方法及模型

Family Cites Families (3)

* Cited by examiner, † Cited by third party
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 江苏满运软件科技有限公司 数据分析系统、方法、存储介质及电子设备

Also Published As

Publication number Publication date
CN112148719A (zh) 2020-12-29
CN112148719B (zh) 2022-11-18

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
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
CN114647704A (zh) 业务数据处理方法以及相关设备
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) 지능형 자료구조 기반의 데이터 처리 방법 및 그를 위한 장치
CN117290355B (zh) 一种元数据地图构建系统

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