Materialized View Construction Based on Clustering Technique - Inria - Institut national de recherche en sciences et technologies du numérique Access content directly
Conference Papers Year : 2014

Materialized View Construction Based on Clustering Technique

Ranak Ghosh
  • Function : Author
  • PersonId : 994895
Soumya Sen
  • Function : Author
  • PersonId : 994896


Materialized view is important to any data intensive system where answering queries at runtime is subject of interest. Users are not aware about the presence of materialized views in the system but the presence of these results in fast access to data and therefore optimized execution of queries. Many techniques have evolved over the period to construct materialized views. However the survey work reveals a few attempts to construct materialized views based on attribute similarity measure by statistical similarity function and thereafter applying the clustering techniques. In this paper we have proposed materialized view construction methodology at first by analyzing the attribute similarity based on Jaccard Index then clustering methodology is applied using similarity based weighted connected graph. Further the clusters are validated to check the correctness of the materialized views.
Fichier principal
Vignette du fichier
978-3-662-45237-0_25_Chapter.pdf (168.12 Ko) Télécharger le fichier
Origin : Files produced by the author(s)

Dates and versions

hal-01405594 , version 1 (30-11-2016)





Santanu Roy, Ranak Ghosh, Soumya Sen. Materialized View Construction Based on Clustering Technique. 13th IFIP International Conference on Computer Information Systems and Industrial Management (CISIM), Nov 2014, Ho Chi Minh City, Vietnam. pp.254-265, ⟨10.1007/978-3-662-45237-0_25⟩. ⟨hal-01405594⟩
62 View
108 Download



Gmail Facebook X LinkedIn More