Abstract
Data mart is the subset of an organizational data warehouse which is designed to focus on a single subject such as Sales, Finance or Marketing. Data marts draw data only from few sources based on the single subject focus. Data marts are smaller and less complex when compared to Data warehouse. Hence, it is easier to build and maintain a data mart. The advantage of using data mart is that the users gain faster access to common data by having little or no knowledge about data mart and obtains data as required. It improves performance and end users response time. The main objective of this project is to develop a data mart prototype for the CSUS Hornet bookstore. The purpose of creating this prototype is to help the Hornet bookstore to retrieve the data in an efficient manner based on inventory and sales of the bookstore. The top two priority searches are: • To find the warranty of computers purchased by the customers in order to find out whether the computers can be repaired at no cost or at partial expense. • To find sales rate of different brand laptops for each semester and then decide on ordering more number of particular brand laptops for next semester based on the laptops which was sold out in more number in the previous semester. In this project, only the top two search priorities are considered. Currently the bookstore keeps track of all the items in an excel sheet where in a user has to manually search for the correct data by scrolling through different excel sheet and find the needed data. Therefore, this data mart will help the Hornet bookstore computer department to retrieve the required data in a simpler manner by providing the data based on the query they are running to obtain information about specific items and as well as sales on certain dates. This project not only helps the hornet bookstore but in turn helps the students who get enrolled in CSC177 coursework because it provides a practical example while learning data warehousing and data mart concepts. To achieve this objective we will be creating a star schema data mart design, data preprocessing and use MY SQL database in creating a data mart