Abstract
Everyday millions of consumers use cosmetic products to enhance their beauty without having knowledge on hazardous and potentially hazardous ingredients used to produce those cosmetic products. This lack of knowledge is due to information not being reached to consumers in an efficient way. As information and knowledge plays a pivotal role in determining the quality of an individual’s life, Data warehousing techniques could be used in taking raw data from different sources and integrate them to extract useful information which can be efficient and accurate. This project involves the design and implementation of a data mart for the ‘Chemicals in Cosmetics’ dataset provided by the California Safe Cosmetics Program (CSCP) in the California Department of Public Health. The purpose of this application is to provide appropriate information to the consumers of cosmetic products anywhere anytime with ease using of mobile. ‘Chemicals in Cosmetics’ dataset contains all cosmetic products sold in California that has potentially hazardous ingredients and information on incidents reported. I integrated this data set with harmful effects of hazardous ingredients data to provide actual consequences that may cause using them. The application has mobile user interface for Android platform devices with which users can get information of hazardous ingredients, if used any, to make the products they use daily and their side effects. The application development includes data collection, data cleaning and pre-processing, designing the data mart, identifying use cases, designing and implementing Android mobile interface and creating server. The data mart is created using MySQL database, server using Node.js and the android mobile client using Android Studio.