Materialized View Construction Based on Clustering Technique

Abstract : 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.
Document type :
Conference papers
Khalid Saeed; Václav Snášel. 13th IFIP International Conference on Computer Information Systems and Industrial Management (CISIM), Nov 2014, Ho Chi Minh City, Vietnam. Springer, Lecture Notes in Computer Science, LNCS-8838, pp.254-265, 2014, Computer Information Systems and Industrial Management. 〈10.1007/978-3-662-45237-0_25〉
Liste complète des métadonnées

Cited literature [14 references]  Display  Hide  Download

https://hal.inria.fr/hal-01405594
Contributor : Hal Ifip <>
Submitted on : Wednesday, November 30, 2016 - 11:01:44 AM
Last modification on : Thursday, December 1, 2016 - 1:04:16 AM
Document(s) archivé(s) le : Monday, March 27, 2017 - 7:57:53 AM

File

978-3-662-45237-0_25_Chapter.p...
Files produced by the author(s)

Licence


Distributed under a Creative Commons Attribution 4.0 International License

Identifiers

Citation

Santanu Roy, Ranak Ghosh, Soumya Sen. Materialized View Construction Based on Clustering Technique. Khalid Saeed; Václav Snášel. 13th IFIP International Conference on Computer Information Systems and Industrial Management (CISIM), Nov 2014, Ho Chi Minh City, Vietnam. Springer, Lecture Notes in Computer Science, LNCS-8838, pp.254-265, 2014, Computer Information Systems and Industrial Management. 〈10.1007/978-3-662-45237-0_25〉. 〈hal-01405594〉

Share

Metrics

Record views

38

Files downloads

45