Mining User Demanded Data From Data Mart Using Inductive Rule Mining
A data warehouse is a database used for reporting and analyzing the data stored in the repositories. A data mart acts as the accessing form of the data warehouse situation used to obtain the data out to the users. Accessing of data in the data warehouse is a challenging approach since the user needs better understanding of the data structure stored in the repositories. To handle this issue, data mart is introduced. Data marts built separate functional data repository layers based on the requirements and applications of the corporate data applications. However function requirements of users are not easily understood by the data warehouse model. It needs efficient decision support system to extract the required user demanded data from data warehouse. Existing work only identified the functional activities of the data mart based on attribute relativity in the data mart and it does not extract the user demanded information from the repositories. To improve the decision support system to extract the required user demanded data from data mart, inductive rule mining is used. The decision support is done with inductive rule mining on functional data marts segregates of the layered data repository and extracted the required information for the user. The induced rules are proposed to be the supportive knowledge for identifying the user needed information. An experimental evaluation is conducted with benchmark datasets from UCI repository data sets and compared with existing functional behavior pattern for data mart based on attribute relativity in terms of number of decision rules, extracted data relativity, analysis of functional behavior.
Key words: Decision support system, Inductive rule mining, Inductive rules, Data mart, Data warehouse
Keywords: Decision support system, Inductive rule mining, Inductive rules, Data mart, Data warehouse
Download Full-Text
ABOUT THE AUTHORS
M Paulraj
PAULRAJ M received a Master Degree from Madurai Kamaraj University, India, Post Graduate Diploma in Business Administration from Annamalai University, India and Master of Computer Application (M.C.A) degree from Indira Gandhi National Open University, New Delhi, India, in 2002. He joined the Computer Centre , Department of Statistics, Ministry of Planning, New Delhi, and He joined the National Crime Records Bureau, Ministry of Home Affairs, New Delhi, where he was a Junior Staff Officer(System Analyst). He is currently Senior Systems Manager of Department of Information Technology at Canara Bank, Head Office, Bangalore, India, his job interests include introducing new technology and projects related to financial systems & analysis. He currently preparing a Ph.D in Computer Science, research scholar, thesis titled “Performance Analysis for Data Mart” in a reputed University at Tamil Nadu, India.
Sivaprakasam P
Dr. SIVAPRAKASAM P, M.Sc., M.Phil., Ph.D is associate professor, Department of Computer Science, at Sri Vasavi College, Erode, Tamil Nadu, India. He obtained Ph.D. from Periyar University, Salem, Tamil Nadu, India in Analysis of Web Caching Architecture.
M Paulraj
PAULRAJ M received a Master Degree from Madurai Kamaraj University, India, Post Graduate Diploma in Business Administration from Annamalai University, India and Master of Computer Application (M.C.A) degree from Indira Gandhi National Open University, New Delhi, India, in 2002. He joined the Computer Centre , Department of Statistics, Ministry of Planning, New Delhi, and He joined the National Crime Records Bureau, Ministry of Home Affairs, New Delhi, where he was a Junior Staff Officer(System Analyst). He is currently Senior Systems Manager of Department of Information Technology at Canara Bank, Head Office, Bangalore, India, his job interests include introducing new technology and projects related to financial systems & analysis. He currently preparing a Ph.D in Computer Science, research scholar, thesis titled “Performance Analysis for Data Mart” in a reputed University at Tamil Nadu, India.
Sivaprakasam P
Dr. SIVAPRAKASAM P, M.Sc., M.Phil., Ph.D is associate professor, Department of Computer Science, at Sri Vasavi College, Erode, Tamil Nadu, India. He obtained Ph.D. from Periyar University, Salem, Tamil Nadu, India in Analysis of Web Caching Architecture.
