Construction and distribution of materialized views in Non-binary data space

被引:2
|
作者
Roy, Santanu [1 ]
Shit, Bibekananda [1 ]
Sen, Soumya [2 ]
Cortesi, Agostino [3 ]
机构
[1] Future Inst Engn & Management, Kolkata, India
[2] Univ Calcutta, Kolkata, India
[3] Ca Foscari Univ, DAIS, Venice, Italy
关键词
Association rules; Non-binary data space; Dynamic support count; Materialized view; SELECTION;
D O I
10.1007/s11334-021-00404-8
中图分类号
TP31 [计算机软件];
学科分类号
081202 ; 0835 ;
摘要
Materialized views are heavily used to speed up the query response time of any data centric application. In the literature, the construction and dynamic maintenance of materialized views are carried out in a Binary Data Space where all attributes are given the same weight. Considering different weights may be particularly significant when similar queries are fired from multiple sites in a distributed environment, as taking into account the number of accesses to the different attribute values may reflect into the ability of tuning the materialized views accordingly. The methodology to construct weighted materialized view introduced in this paper is based on the association mining techniques, by applying it in a Non-Binary Data Space in distributed environments. The allocation of the views in the operating sites is also considered to a suitable use in distributed databases. Experimental results prove the superiority of proposed methodology on three bench mark datasets in terms of query Hit-Miss ratio and regulation of the view size with varying requirement of practical applications.
引用
收藏
页码:205 / 217
页数:13
相关论文
共 50 条
  • [1] Construction and distribution of materialized views in Non-binary data space
    Santanu Roy
    Bibekananda Shit
    Soumya Sen
    Agostino Cortesi
    Innovations in Systems and Software Engineering, 2021, 17 : 205 - 217
  • [2] Binary Weight Distribution of Non-Binary LDPC Codes
    Andriyanova, Iryna
    Rathi, Vishwambhar
    Tillich, Jean-Pierre
    2009 IEEE INTERNATIONAL SYMPOSIUM ON INFORMATION THEORY, VOLS 1- 4, 2009, : 65 - 69
  • [3] Materialized Views in Data Mining
    Attar, Vahida
    Inamdar, Vandana
    INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND NETWORK SECURITY, 2007, 7 (12): : 90 - 94
  • [4] Materialized Data Mining Views
    Morzy, Tadeusz
    Wojciechowski, Marek
    Zakrzewicz, Maciej
    LECTURE NOTES IN COMPUTER SCIENCE <D>, 2000, 1910 : 65 - 74
  • [5] Materialized views in data mining
    Czejdo, B
    Morzy, M
    Wojciechowski, M
    Zakrzewicz, M
    13TH INTERNATIONAL WORKSHOP ON DATABASE AND EXPERT SYSTEMS APPLICATIONS, PROCEEDINGS, 2002, : 827 - 831
  • [6] Weight Distribution of Non-binary LDPC Codes
    Kasai, Kenta
    Poulliat, Charly
    Declercq, David
    Shibuya, Tomoharu
    Sakaniwa, Kohichi
    2008 INTERNATIONAL SYMPOSIUM ON INFORMATION THEORY AND ITS APPLICATIONS, VOLS 1-3, 2008, : 748 - +
  • [7] Selecting materialized views in a data warehouse
    Zhou, LJ
    Liu, C
    Liu, DX
    STORAGE AND RETRIEVAL FOR MEDIA DATABASES 2003, 2003, 5021 : 456 - 461
  • [8] Non-binary matroids having four non-binary elements
    Lemos, M
    ARS COMBINATORIA, 1997, 46 : 97 - 117
  • [9] Materialized views in data warehousing environments
    Ciferri, CDD
    de Souza, FD
    SCCC 2001: XXI INTERNATIONAL CONFERENCE OF THE CHILEAN COMPUTER SCIENCE SOCIETY, PROCEEDINGS, 2001, : 3 - 12
  • [10] Selecting Materialized Views for RDF Data
    Castillo, Roger
    Leser, Ulf
    CURRENT TRENDS IN WEB ENGINEERING, 2010, 6385s : 126 - 137