An Efficient I-MINE Algorithm for Materialized Views in a data Warehouse Environment
The ability to afford decision makers with both accurate and timely consolidated information as well as rapid query response times is the fundamental requirement for the success of a Data Warehouse. Selecting views to materialize for the purpose of supporting the decision making efficiently is one of the most significant decisions in designing Data Warehouse. Selecting a set of derived views to materialize which minimizes the sum of total query response time maintenance of the selected views is defined as view selection problem. Therefore, to select an appropriate set of a view is the major target that diminishes the entire query response time and also maintains the selected views. Selecting a suitable set of views that minimizes the total cost associated with the materialized views is the key objective of data warehousing. However, these views have maintenance cost, so materialization of all views is not possible. In this paper we are taking into consideration of query frequency, query processing cost and space requirement. In order to find the frequent queries, we make use of I-mine mining techniques from which the frequently user accessible queries will be generated. Then, an appropriate set of views can be selected to materialize by minimizing the total query response time and/or the storage space along with maximizing the query frequency. These can be utilized by the users to obtain the quicker results once a set of views is materialized for the data warehouse.
Keywords: materialization view, data warehousing, selection cost, I-mine item set index, FP growth
Download Full-Text
ABOUT THE AUTHORS
T.Nalini
Mrs. T.Nalini received M.Sc from the Karanataka university, M.Tech from Bharath University in 2000,2007 respectively. Now, she is pursuing Ph.D. in Bharath university. She was a Lecturer between 2000 and 2006. Currently she is an Assistant Professor in the Department of CSE. She has published more than 4 research papers in international journals. She has attended a number of short-term courses and conferences to enrich his knowledge. She also presented the paper 15 national conferences and 2 international conferences. And she has attended many workshop and seminars in various organization with various subject she has organized a National level conferences and workshop. She is a life member of many professional bodies like ISTE, CSI, IEEE.
Dr. A. Kumaravel
Dr. A.Kumaravel received PG in Computer Science in Applied Sciences from the MIT Chennai , Ph.D in theoretical computer science from Anna university in 1988,1992 respectively. He was worked as a professor in CS for more than 20 years in Singapore. He has published more than 10 papers, and he also presented 20 papers in national and international conferences. He has organized workshops, national and international conferences, seminars in various organizations. Now, he is working as Dean of Computing Studies. He is member of Board of studies in Bharath University. He had received senior fellowship in UGC. He is a life member of many professional bodies like ISTE, CSI, IEEE.
Dr.K.Rangarajan
Dr.K.Rangarajan is a Professor and Dean of Science & Humanities, Bharath University, TN, India. He has about 60 research publications and guiding many research scholars. His research areas include Automata Theory, Formal Languages, Petri Nets and Graph theory.
T.Nalini
Mrs. T.Nalini received M.Sc from the Karanataka university, M.Tech from Bharath University in 2000,2007 respectively. Now, she is pursuing Ph.D. in Bharath university. She was a Lecturer between 2000 and 2006. Currently she is an Assistant Professor in the Department of CSE. She has published more than 4 research papers in international journals. She has attended a number of short-term courses and conferences to enrich his knowledge. She also presented the paper 15 national conferences and 2 international conferences. And she has attended many workshop and seminars in various organization with various subject she has organized a National level conferences and workshop. She is a life member of many professional bodies like ISTE, CSI, IEEE.
Dr. A. Kumaravel
Dr. A.Kumaravel received PG in Computer Science in Applied Sciences from the MIT Chennai , Ph.D in theoretical computer science from Anna university in 1988,1992 respectively. He was worked as a professor in CS for more than 20 years in Singapore. He has published more than 10 papers, and he also presented 20 papers in national and international conferences. He has organized workshops, national and international conferences, seminars in various organizations. Now, he is working as Dean of Computing Studies. He is member of Board of studies in Bharath University. He had received senior fellowship in UGC. He is a life member of many professional bodies like ISTE, CSI, IEEE.
Dr.K.Rangarajan
Dr.K.Rangarajan is a Professor and Dean of Science & Humanities, Bharath University, TN, India. He has about 60 research publications and guiding many research scholars. His research areas include Automata Theory, Formal Languages, Petri Nets and Graph theory.
