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.

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

Roy S.;Sen S.;Cortesi A.
2021-01-01

Abstract

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.
File in questo prodotto:
File Dimensione Formato  
ISSE DRAFT.pdf

non disponibili

Tipologia: Documento in Pre-print
Licenza: Accesso chiuso-personale
Dimensione 361.79 kB
Formato Adobe PDF
361.79 kB Adobe PDF   Visualizza/Apri

I documenti in ARCA sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/10278/3754139
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 3
  • ???jsp.display-item.citation.isi??? 2
social impact