Data Warehouse Enhancement Manipulating Materialized View Hierarchy

被引：0
|
作者：
Khan, Sajid Ullah [1 ]
Shah, Waqas Mahmood [1 ]
Haris, Muhammad [1 ]
Naseem, Rashid [1 ]
机构：
[1] City Univ Sci & Informat Technol Peshawar, Peshawar, Pakistan
来源：
2013 EIGHTH INTERNATIONAL CONFERENCE ON DIGITAL INFORMATION MANAGEMENT (ICDIM) | 2013年
关键词：
Materialized View; Data warehouse; Complex Calculations;
D O I：
暂无
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
Materialized Views usually used in distributed databases for replication and can also be used for well-organized delivery of data to a querying process. The process of data delivery to queries can further be accelerated if materialized views hierarchy is introduced to the existing materialized view. The newly generated sub views of the existing materialized views forms a materialized views hierarchy consists of parents and newly generated sub materialized views. The newly generated sub materialized views are dependent over the existing materialized views. Besides, these newly generated views are automatically created upon the creation of the parent materialized with some restrictions. This reduces the user dependency due to creation of materialized views based on some parameters. These parameters include the number of newly generated materialized views and the type of the data a view contain. In this paper, a stable approach is suggested to create newly generated materialized views to answer user queries without consulting the parent materialized view that requires no complex calculations and joining of multiple tables.
引用
收藏
页码：369 / 372
页数：4
相关论文
共 50 条
  • [1] Materialized View Selection in the Data Warehouse
    Zhou Lijuan
    Geng Haijun
    Xu Mingsheng
    APPLIED MECHANICS AND MECHANICAL ENGINEERING, PTS 1-3, 2010, 29-32 : 1133 - 1138
  • [2] Materialized view selection in a data warehouse
    Feng, Y
    Du, XY
    Wang, S
    WEB-AGE INFORMATION MANAGEMENT, PROCEEDINGS, 2000, 1846 : 323 - 328
  • [3] Maintenance technology of materialized view in data warehouse
    Gu, Yan
    Wuhan Ligong Daxue Xuebao/Journal of Wuhan University of Technology, 2007, 29 (06): : 118 - 121
  • [4] Research on Materialized View Selection in the Data Warehouse
    Zhou Li-juan
    Geng Hai-jun
    Xu Ming-sheng
    RECENT TRENDS IN MATERIALS AND MECHANICAL ENGINEERING MATERIALS, MECHATRONICS AND AUTOMATION, PTS 1-3, 2011, 55-57 : 361 - 366
  • [5] Materialized view evolution support in data warehouse environment
    Zhang, C
    Yang, J
    6TH INTERNATIONAL CONFERENCE ON DATABASE SYSTEMS FOR ADVANCED APPLICATIONS, PROCEEDINGS, 1999, : 247 - 254
  • [6] Research on Materialized View Selection Algorithm in Data Warehouse
    Zhou Lijuan
    Ge Xuebin
    Wang Linshuang
    Shi Qian
    2009 INTERNATIONAL FORUM ON COMPUTER SCIENCE-TECHNOLOGY AND APPLICATIONS, VOL 2, PROCEEDINGS, 2009, : 326 - 329
  • [7] ASVMRT: Materialized View Selection Algorithm in Data Warehouse
    Yang, Jin-Hyuk
    Chung, In-Jeong
    JOURNAL OF INFORMATION PROCESSING SYSTEMS, 2006, 2 (02): : 67 - 75
  • [8] Analysis and Comparison on Selection Algorithms of Materialized View in Data Warehouse
    Lin, Qiao
    2011 INTERNATIONAL CONFERENCE ON FUTURE COMPUTERS IN EDUCATION (ICFCE 2011), VOL II, 2011, : 132 - 136
  • [9] Materialized view selection based on query cost in data warehouse
    Zhou, LJ
    Liu, C
    Liu, D
    DATA MINING AND KNOWLEDGE DISCOVERY: THEORY, TOOLS, AND TECHNOLOGY VI, 2004, 5433 : 246 - 252
  • [10] Applying evolutionary algorithms to materialized view selection in a data warehouse
    Horng, JT
    Chang, YJ
    Liu, BJ
    SOFT COMPUTING, 2003, 7 (08) : 574 - 581
12345