Implementation of Data Warehousing Tool with Data Mapping for Environmental Research
The interpretation of immense data generated from numerous environmental researches enables the generation of knowledge apart from those for which the data were originally gathered for. Hence, a data management system with capability for data integration, pre-processing, production of specific datasets for external data analysis, data mining and/or support for decision making tasks is essential. This paper implements a data warehouse design that serves as management platform for the scientific data generated in a nuclear research and development facility in the Philippines and the meteorological, radioactivity, and other relevant data obtained from environmental monitoring systems around the world. The datasets are loaded into the system through a parser module with metadata information attached to each dataset. Data transformation is achieved using a pre-processing module to generate customized datasets through a retrieval module that is compatible with data analysis software such as WEKA.
Keywords: Data Management, Data Warehousing, Metadata, ETL, Parser
Download Full-Text
ABOUT THE AUTHORS
Ana Elena L. Conjares
Mrs Conjares finished her BS in Mathematics in 1982, Cum Laude, from the University of Nueva Caceres in Naga City, Philippines. She obtained her Master of Science in Computer Science degree from the Ateneo de Manila University, Loyola Heights in Quezon City in 2000 as a government scholar of the Department of Science and Technology (DOST) Human Resource Development Program. She is now currently pursuing her degree in Doctor of Information Technology at the Technological Institute of the Philippines, Quezon City campus. Ms Conjares works at the Philippine Nuclear Research Institute for the past three decades and currently heads the Technology Diffusion Division of the Institute. She is also designated as Chief Information Officer and Information Systems Strategic Planner. She had twice for one year each worked at the Comprehensive Nuclear Test-Ban Treaty Organization based in Vienna, Austria as project management team for their Science and Technology 2009 and 2011 events, respectively. She is also recognized as an expert of the International Atomic Energy Agency’s (IAEA) Regulatory Authority Information System which is deployed to Member States, having performed expert missions in Laos PDR, Myanmar and Brunei Darussalam as well as hosted and supervised on-the-job trainee from Member State in the Philippines.
Bobby D. Gerardo
Dr Gerardo finished his BS in Electrical Engineering in 1994, with High Distinction from Western Institute of Technology at Iloilo, Philippines. He took his Master of Arts in Education Major in Mathematics from University of the Philippines in Diliman Quezon City in 2000 being the grantee of DOST-SEI scholarship for Math and Science Faculty. He pursued his Ph.D. in Information and Telecommunications with major in distributed systems at Kunsan National University, Korea in 2007 being the grantee of Korean Scholarship for Brain Korea (BK-21) project. He is currently the Vice President for Administration and Finance of West Visayas State University, Iloilo City, Philippines. His dissertation: Discovering Driving Patterns using Rule-based intelligent Data Mining Agent (RiDAMA) in Distributed Insurance Telematic Systems. He has published 54 research papers in national and international journals and conferences. He is a referee to international conferences and journal publications such as in IEEE Transactions on Pattern Analysis and Machine Intelligence and IEEE Transactions on Knowledge and Data Engineering. He is interested in the following research fields: distributed systems, telematics systems, CORBA, data mining, web services, ubiquitos computing and mobile communications. Dr. Gerardo is a recipient of CHED Republica Award in Natural Science Category (ICT field) in 2010. His paper entitled SMS-based Automatic Billing System of Household Power Consumption based on Active Experts Messaging was awarded Best Paper on December 2011in Jeju, Korea. Another Best Paper award for his paper Intelligent Decision Support using Rule-based Agent for Distributed Telematics Systems” Asia Pacific International Conference on Information Science and Technology on December 18, 2008. An Excellent Paper award was given for his paper “Principal Component Analysis Mechanism for Association Rule Mining”, Korean Society of Internet Information’s (KSII) 2004 Autumn Conference on November 5, 2004. He was given a University Researcher Award by West Visayas State University in 2005.
Ruji P. Medina
Dr Medina is Dean of the Graduate Programs and concurrent Chair of the Environmental and Sanitary Engineering Program of the Technological Institute of the Philippines in Quezon City. He holds a Ph.D. in Environmental Engineering from the University of the Philippines with sandwich program at the University of Houston, Texas where he worked on the synthesis of nanocomposite materials. He finished his MS in Environmental Engineering from the Mapúa Institute of Technology, graduating Summa Cum Laude. He obtained his Bachelor’s degree in Chemical Engineering from the University of the Philippines in Diliman, Quezon City. His research interests include urban mining, electronic wastes, and nanomaterials, He counts among his expertise environmental modeling and mathematical modeling using multivariate analysis.
Ana Elena L. Conjares
Mrs Conjares finished her BS in Mathematics in 1982, Cum Laude, from the University of Nueva Caceres in Naga City, Philippines. She obtained her Master of Science in Computer Science degree from the Ateneo de Manila University, Loyola Heights in Quezon City in 2000 as a government scholar of the Department of Science and Technology (DOST) Human Resource Development Program. She is now currently pursuing her degree in Doctor of Information Technology at the Technological Institute of the Philippines, Quezon City campus. Ms Conjares works at the Philippine Nuclear Research Institute for the past three decades and currently heads the Technology Diffusion Division of the Institute. She is also designated as Chief Information Officer and Information Systems Strategic Planner. She had twice for one year each worked at the Comprehensive Nuclear Test-Ban Treaty Organization based in Vienna, Austria as project management team for their Science and Technology 2009 and 2011 events, respectively. She is also recognized as an expert of the International Atomic Energy Agency’s (IAEA) Regulatory Authority Information System which is deployed to Member States, having performed expert missions in Laos PDR, Myanmar and Brunei Darussalam as well as hosted and supervised on-the-job trainee from Member State in the Philippines.
Bobby D. Gerardo
Dr Gerardo finished his BS in Electrical Engineering in 1994, with High Distinction from Western Institute of Technology at Iloilo, Philippines. He took his Master of Arts in Education Major in Mathematics from University of the Philippines in Diliman Quezon City in 2000 being the grantee of DOST-SEI scholarship for Math and Science Faculty. He pursued his Ph.D. in Information and Telecommunications with major in distributed systems at Kunsan National University, Korea in 2007 being the grantee of Korean Scholarship for Brain Korea (BK-21) project. He is currently the Vice President for Administration and Finance of West Visayas State University, Iloilo City, Philippines. His dissertation: Discovering Driving Patterns using Rule-based intelligent Data Mining Agent (RiDAMA) in Distributed Insurance Telematic Systems. He has published 54 research papers in national and international journals and conferences. He is a referee to international conferences and journal publications such as in IEEE Transactions on Pattern Analysis and Machine Intelligence and IEEE Transactions on Knowledge and Data Engineering. He is interested in the following research fields: distributed systems, telematics systems, CORBA, data mining, web services, ubiquitos computing and mobile communications. Dr. Gerardo is a recipient of CHED Republica Award in Natural Science Category (ICT field) in 2010. His paper entitled SMS-based Automatic Billing System of Household Power Consumption based on Active Experts Messaging was awarded Best Paper on December 2011in Jeju, Korea. Another Best Paper award for his paper Intelligent Decision Support using Rule-based Agent for Distributed Telematics Systems” Asia Pacific International Conference on Information Science and Technology on December 18, 2008. An Excellent Paper award was given for his paper “Principal Component Analysis Mechanism for Association Rule Mining”, Korean Society of Internet Information’s (KSII) 2004 Autumn Conference on November 5, 2004. He was given a University Researcher Award by West Visayas State University in 2005.
Ruji P. Medina
Dr Medina is Dean of the Graduate Programs and concurrent Chair of the Environmental and Sanitary Engineering Program of the Technological Institute of the Philippines in Quezon City. He holds a Ph.D. in Environmental Engineering from the University of the Philippines with sandwich program at the University of Houston, Texas where he worked on the synthesis of nanocomposite materials. He finished his MS in Environmental Engineering from the Mapúa Institute of Technology, graduating Summa Cum Laude. He obtained his Bachelor’s degree in Chemical Engineering from the University of the Philippines in Diliman, Quezon City. His research interests include urban mining, electronic wastes, and nanomaterials, He counts among his expertise environmental modeling and mathematical modeling using multivariate analysis.
