CN110674228B - 数据仓库模型构建和数据查询方法、装置及设备 - Google Patents
数据仓库模型构建和数据查询方法、装置及设备 Download PDFInfo
- Publication number
- CN110674228B CN110674228B CN201910896842.2A CN201910896842A CN110674228B CN 110674228 B CN110674228 B CN 110674228B CN 201910896842 A CN201910896842 A CN 201910896842A CN 110674228 B CN110674228 B CN 110674228B
- Authority
- CN
- China
- Prior art keywords
- data
- column
- index
- theme
- logic
- 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 97
- 238000010276 construction Methods 0.000 title claims abstract description 31
- 238000013507 mapping Methods 0.000 claims description 18
- 238000004364 calculation method Methods 0.000 claims description 16
- 238000013075 data extraction Methods 0.000 claims description 8
- 238000010586 diagram Methods 0.000 description 22
- 230000008569 process Effects 0.000 description 22
- 238000004458 analytical method Methods 0.000 description 16
- 238000012423 maintenance Methods 0.000 description 12
- 238000003860 storage Methods 0.000 description 11
- 230000006870 function Effects 0.000 description 9
- 230000006872 improvement Effects 0.000 description 8
- 238000007726 management method Methods 0.000 description 8
- 238000004590 computer program Methods 0.000 description 7
- 238000012545 processing Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 5
- 230000009286 beneficial effect Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 4
- 230000000694 effects Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000013461 design Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000000750 progressive effect Effects 0.000 description 2
- 241000533950 Leucojum Species 0.000 description 1
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 229940005022 metadate Drugs 0.000 description 1
- JUMYIBMBTDDLNG-UHFFFAOYSA-N methylphenidate hydrochloride Chemical compound [Cl-].C=1C=CC=CC=1C(C(=O)OC)C1CCCC[NH2+]1 JUMYIBMBTDDLNG-UHFFFAOYSA-N 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 229920001296 polysiloxane Polymers 0.000 description 1
- 239000010979 ruby Substances 0.000 description 1
- 229910001750 ruby Inorganic materials 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- 230000001131 transforming effect Effects 0.000 description 1
- 238000013519 translation 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/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
-
- 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/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
-
- 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
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)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (15)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910896842.2A CN110674228B (zh) | 2019-09-23 | 2019-09-23 | 数据仓库模型构建和数据查询方法、装置及设备 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910896842.2A CN110674228B (zh) | 2019-09-23 | 2019-09-23 | 数据仓库模型构建和数据查询方法、装置及设备 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110674228A CN110674228A (zh) | 2020-01-10 |
CN110674228B true CN110674228B (zh) | 2024-03-26 |
Family
ID=69077144
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910896842.2A Active CN110674228B (zh) | 2019-09-23 | 2019-09-23 | 数据仓库模型构建和数据查询方法、装置及设备 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110674228B (zh) |
Families Citing this family (20)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111311329B (zh) * | 2020-02-20 | 2023-07-25 | 口碑(上海)信息技术有限公司 | 标签数据获取方法、装置、设备及可读存储介质 |
CN111552679A (zh) * | 2020-04-09 | 2020-08-18 | 苏宁金融科技(南京)有限公司 | 基于简单需求的快速建模方法及装置 |
CN111930820A (zh) * | 2020-08-19 | 2020-11-13 | 武汉众邦银行股份有限公司 | 一种基于web端操作的自助数据提取方法 |
CN111966761A (zh) * | 2020-08-20 | 2020-11-20 | 合肥智圣新创信息技术有限公司 | 基于DataV的多维度模型数据可视化定制平台及方法 |
CN112131203A (zh) * | 2020-08-28 | 2020-12-25 | 北京思特奇信息技术股份有限公司 | 一种数据仓库搭建的方法和系统 |
CN112199393B (zh) * | 2020-09-18 | 2024-05-10 | 深圳希施玛数据科技有限公司 | 基于跨表查询的数据表生成方法、装置、设备及存储介质 |
CN112256804A (zh) * | 2020-10-27 | 2021-01-22 | 武汉市钱鲸科技有限公司 | 一种零售用服务人群统计分类方法 |
CN112256745A (zh) * | 2020-10-27 | 2021-01-22 | 武汉市钱鲸科技有限公司 | 一种零售数据分析方法 |
CN112364004B (zh) * | 2020-11-10 | 2023-09-26 | 中国平安人寿保险股份有限公司 | 基于数据仓库的保单数据处理方法、装置及存储介质 |
CN112508346B (zh) * | 2020-11-17 | 2022-06-24 | 四川新网银行股份有限公司 | 一种实现指标化业务数据勾稽的方法 |
CN112598508B (zh) * | 2020-12-28 | 2024-01-19 | 中国农业银行股份有限公司 | 征信数据使用方法及系统 |
CN112860696B (zh) * | 2021-02-07 | 2024-04-12 | 中国邮政储蓄银行股份有限公司 | 数据的查询方法及装置、数据查询模型 |
CN112966004B (zh) * | 2021-03-04 | 2023-07-28 | 北京百度网讯科技有限公司 | 数据查询方法、装置、电子设备以及计算机可读介质 |
CN113590660A (zh) * | 2021-07-23 | 2021-11-02 | 山东派盟网络科技有限公司 | 一种数据自助查询方法、装置以及电子设备 |
CN113590593A (zh) * | 2021-08-04 | 2021-11-02 | 浙江大华技术股份有限公司 | 数据表信息的生成方法和装置、存储介质及电子装置 |
CN113742313A (zh) * | 2021-08-05 | 2021-12-03 | 紫金诚征信有限公司 | 数据仓库构建方法、装置、计算机设备和存储介质 |
CN115510289B (zh) * | 2022-09-22 | 2023-04-25 | 中电金信软件有限公司 | 一种数据立方体配置方法、装置、电子设备及存储介质 |
CN115712691A (zh) * | 2022-11-17 | 2023-02-24 | 创新奇智(重庆)科技有限公司 | 一种数据关系处理方法及系统 |
CN116578547A (zh) * | 2023-05-16 | 2023-08-11 | 佛山众陶联供应链服务有限公司 | 一种针对陶瓷生产线的数仓建模方法和系统 |
CN117763059A (zh) * | 2023-12-27 | 2024-03-26 | 江苏金融租赁股份有限公司 | 一种数据仓库和数据集市的模型构建方法及系统 |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103577590A (zh) * | 2013-11-12 | 2014-02-12 | 北京润乾信息系统技术有限公司 | 一种数据查询方法和系统 |
US20160078064A1 (en) * | 2014-09-11 | 2016-03-17 | Oracle International Corporation | Automatic generation of logical database schemas from physical database tables and metadata |
CN110019551A (zh) * | 2017-12-19 | 2019-07-16 | 阿里巴巴集团控股有限公司 | 一种数据仓库构建方法及装置 |
-
2019
- 2019-09-23 CN CN201910896842.2A patent/CN110674228B/zh active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103577590A (zh) * | 2013-11-12 | 2014-02-12 | 北京润乾信息系统技术有限公司 | 一种数据查询方法和系统 |
US20160078064A1 (en) * | 2014-09-11 | 2016-03-17 | Oracle International Corporation | Automatic generation of logical database schemas from physical database tables and metadata |
CN110019551A (zh) * | 2017-12-19 | 2019-07-16 | 阿里巴巴集团控股有限公司 | 一种数据仓库构建方法及装置 |
Non-Patent Citations (1)
Title |
---|
苏力萍.《商业智能理论与应用实践》.中国科学技术出版社,2012,正文第46-75页. * |
Also Published As
Publication number | Publication date |
---|---|
CN110674228A (zh) | 2020-01-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110674228B (zh) | 数据仓库模型构建和数据查询方法、装置及设备 | |
Poorthuis et al. | Making big data small: strategies to expand urban and geographical research using social media | |
JP5819376B2 (ja) | 列ベースのデータベースに対する列スマートな機構 | |
CN107451225B (zh) | 用于半结构化数据的可缩放分析平台 | |
CN107016001B (zh) | 一种数据查询方法及装置 | |
CN111971666A (zh) | 优化sql查询计划的维度上下文传播技术 | |
US20160328432A1 (en) | System and method for management of time series data sets | |
EP2784700A2 (en) | Integration of transactional and analytical capabilities of a database management system | |
JP6434154B2 (ja) | トランザクションアクセスパターンに基づいた結合関係の識別 | |
US9201700B2 (en) | Provisioning computer resources on a network | |
Murthy et al. | Big Data solutions on a small scale: Evaluating accessible high-performance computing for social research | |
US10558665B2 (en) | Network common data form data management | |
US10909160B2 (en) | Digital duplicate | |
CN110399359B (zh) | 一种数据回溯方法、装置及设备 | |
US11615076B2 (en) | Monolith database to distributed database transformation | |
US10002179B2 (en) | Detection and creation of appropriate row concept during automated model generation | |
CN110414259A (zh) | 一种构建数据类目、实现数据共享的方法及设备 | |
US11436656B2 (en) | System and method for a real-time egocentric collaborative filter on large datasets | |
US11704345B2 (en) | Inferring location attributes from data entries | |
US20160162496A1 (en) | Computer implemented system and method for investigative data analytics | |
US10095738B1 (en) | Dynamic assignment of logical partitions according to query predicate evaluations | |
CN112435022A (zh) | 基于用户实时数据的动态检索系统、及方法 | |
Suri et al. | A comparative study between the performance of relational & object oriented database in Data Warehousing | |
CN111008198A (zh) | 业务数据获取方法、装置、存储介质、电子设备 | |
Reniers et al. | Schema design support for semi-structured data: Finding the sweet spot between NF and De-NF |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20201012 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20201012 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20240229 Address after: 128 Meizhi Road, Guohao Times City # 20-01, Singapore 189773 Applicant after: Advanced Nova Technology (Singapore) Holdings Ltd. Country or region after: Singapore Address before: 27 Hospital Road, George Town, Grand Cayman ky1-9008 Applicant before: Innovative advanced technology Co.,Ltd. Country or region before: Cayman Islands |
|
GR01 | Patent grant | ||
GR01 | Patent grant |