Using ORACLE tools to generate Multidimensional Model in Warehouse

被引：0
|
作者：
Wiak, Slawomir [1 ]
Drzymala, Pawel [1 ]
Welfle, Henryk [1 ]
机构：
[1] Tech Univ Lodz, Inst Mechatron & Informat Syst, PL-90924 Lodz, Poland
来源：
PRZEGLAD ELEKTROTECHNICZNY | 2012年 / 88卷 / 1A期
关键词：
Database in Management; Business Intelligence; Data Warehouse; OLAP;
D O I：
暂无
中图分类号：
TM [电工技术]; TN [电子技术、通信技术];
学科分类号：
0808 ; 0809 ;
摘要：
The paper presents modern techniques of data modelling and processing, collected by the company. It presents the process of multidimensional data modelling (include the transformation of logical structure to relational structure and next transformation to Multidimensional Model of warehouse in star or snowflake schema). It also shows the ETL process and methods of creating OLAP cubes by use of ORACLE tools to support decision making by business analysts. An approach based on data mining techniques allows analysts to capture certain features in customers, to offer dedicated products for the customer groups. Based on customer behaviour can be concluded about his tendencies to their certain behaviours and preferences.
引用
收藏
页码：257 / 262
页数：6
相关论文
共 50 条
  • [21] Empirical analysis of metrics for object oriented multidimensional model of data warehouse using unsupervised machine learning techniques
    Sabharwal S.
    Nagpal S.
    Aggarwal G.
    [J]. International Journal of System Assurance Engineering and Management, 2017, 8 (Suppl 2) : 703 - 715
  • [22] Theoretical Validation of Object-Oriented Metrics for Data Warehouse Multidimensional Model
    Gosain, Anjana
    Gupta, Rakhi
    [J]. PROCEEDINGS OF THE 5TH INTERNATIONAL CONFERENCE ON FRONTIERS IN INTELLIGENT COMPUTING: THEORY AND APPLICATIONS, FICTA 2016, VOL 1, 2017, 515 : 681 - 691
  • [23] A Model Driven Architecture Approach to Generate Multidimensional Schemas of Data Warehouses
    Azzaoui, Amine
    Rabhi, Ouzayr
    Mani, Ayyoub
    [J]. INTERNATIONAL JOURNAL OF ONLINE AND BIOMEDICAL ENGINEERING, 2019, 15 (12) : 18 - 31
  • [24] Modern Data Warehouse Tools
    Yadav, Rakhee
    Sharma, Yogesh Kumar
    Patil, Rajendra
    [J]. BIOSCIENCE BIOTECHNOLOGY RESEARCH COMMUNICATIONS, 2020, 13 (10): : 102 - 105
  • [25] Tools for data warehouse quality
    Gebhardt, M
    Jarke, M
    Jeusfeld, MA
    Quix, C
    Sklorz, S
    [J]. TENTH INTERNATIONAL CONFERENCE ON SCIENTIFIC AND STATISTICAL DATABASE MANAGEMENT - PROCEEDINGS, 1998, : 229 - 232
  • [26] Automatic Warehouse for Workshop Tools
    Ferreira, Marco
    Rodrigues, Miguel
    Monteiro, Caetano
    [J]. INNOVATIONS IN MECHATRONICS ENGINEERING, 2022, : 154 - 163
  • [27] Multiversion Document Warehouse: An Approach to Multidimensional Analysis
    Khrouf, Kais
    Feki, Jamel
    Soule-Dupuy, Chantal
    [J]. JOURNAL OF INTELLIGENCE STUDIES IN BUSINESS, 2012, 2 (01): : 32 - 40
  • [28] A Relational Data Warehouse for Multidimensional Process Mining
    Vogelgesang, Thomas
    Appelrath, H. -Juergen
    [J]. DATA-DRIVEN PROCESS DISCOVERY AND ANALYSIS, SIMPDA 2015, 2017, 244 : 155 - 184
  • [29] A Study of Multidimensional Modeling Approaches for Data Warehouse
    Yusof, Sharmila Mat
    Sidi, Fatimah
    Ibrahim, Hamidah
    Affendey, Lilly Suriani
    [J]. PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON APPLIED SCIENCE AND TECHNOLOGY 2016 (ICAST '16), 2016, 1761
  • [30] Multidimensional normal forms for data warehouse design
    Lechtenbörger, J
    Vossen, G
    [J]. INFORMATION SYSTEMS, 2003, 28 (05) : 415 - 434
12345