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 条
  • [1] Enriching Hierarchies in Multidimensional Model of Data Warehouse using WORDNET
    Marini
    Nazri, Mior Nasir Mior
    [J]. 2013 INTERNATIONAL CONFERENCE ON RESEARCH AND INNOVATION IN INFORMATION SYSTEMS (ICRIIS), 2013, : 296 - 301
  • [2] Fuzzy spatial data warehouse: A multidimensional model
    David, Perez
    Somodevilla, Maria J.
    Pineda, No H.
    [J]. ENC 2007: EIGHTH MEXICAN INTERNATIONAL CONFERENCE ON CURRENT TRENDS IN COMPUTER SCIENCE, PROCEEDINGS, 2007, : 3 - 9
  • [3] A distributed multidimensional data model of data warehouse
    Lin, YF
    Huang, HK
    Li, HS
    [J]. ROUGH SETS, FUZZY SETS, DATA MINING, AND GRANULAR COMPUTING, 2003, 2639 : 664 - 667
  • [4] Empirical Validation of Multidimensional Model for Data Warehouse
    Mann, Suman
    Bharti
    Singh, Perminder
    [J]. 2014 3RD INTERNATIONAL CONFERENCE ON RELIABILITY, INFOCOM TECHNOLOGIES AND OPTIMIZATION (ICRITO) (TRENDS AND FUTURE DIRECTIONS), 2014,
  • [5] AN OBJECT ORIENTED MULTIDIMENSIONAL MODEL FOR DATA WAREHOUSE
    Gosain, Anjana
    Mann, Suman
    [J]. FOURTH INTERNATIONAL CONFERENCE ON MACHINE VISION (ICMV 2011): COMPUTER VISION AND IMAGE ANALYSIS: PATTERN RECOGNITION AND BASIC TECHNOLOGIES, 2012, 8350
  • [6] Oracle parallel warehouse server
    Hallmark, G
    [J]. 13TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING - PROCEEDINGS, 1997, : 314 - 320
  • [7] Empirical Investigation of Metrics for Multidimensional Model of Data Warehouse Using Support Vector Machine
    Sabharwal, Sangeeta
    Nagpal, Sushama
    Aggarwal, Gargi
    [J]. 2015 4TH INTERNATIONAL CONFERENCE ON RELIABILITY, INFOCOM TECHNOLOGIES AND OPTIMIZATION (ICRITO) (TRENDS AND FUTURE DIRECTIONS), 2015,
  • [8] Comprehensive complexity metric for data warehouse multidimensional model understandability
    Gosain, Anjana
    Singh, Jaspreeti
    [J]. IET SOFTWARE, 2020, 14 (03) : 275 - 282
  • [9] Multidimensional analysis model for a document warehouse that includes textual measures
    Mendoza, Martha
    Alegria, Erwin
    Maca, Manuel
    Cobos, Carlos
    Leon, Elizabeth
    [J]. DECISION SUPPORT SYSTEMS, 2015, 72 : 44 - 59
  • [10] Multidimensional Modeling for Data Warehouse Using Object Oriented Approach
    Gosain, Anjana
    Khatri, Sunil Kumar
    Manna, Suman
    [J]. 2014 3RD INTERNATIONAL CONFERENCE ON RELIABILITY, INFOCOM TECHNOLOGIES AND OPTIMIZATION (ICRITO) (TRENDS AND FUTURE DIRECTIONS), 2014,
12345