Convert Database Structure into Star Schema Structure for Data Warehouse

The database has started in the 1960s to make designing, building, and maintaining easily for information system difficulties. Since this time the database uses as storage for data and information and salves the problem about saving them safely. The dramatically increase in governments and companies transactions meet by increase in their databases, data storage and quires which used to retrieve data from database. They use information processing system which is used for storage of everyday activities about them. However, information processing systems rely on online transaction processing (OLTP) in DB, which is not so easily accessible to the governments and companies' users. Moreover, relational database was not designed to support multi dimensional view. Need for Multi dimensional view, Online Analytical Processing (OLAP) and reducing time consuming for reports generating leads to the concept of a data warehouse. This study convert database into data warehouse based on a star schema structure by using several tools and techniques as software and hardware. We investigate how star schema makes fast respond for quire and for better performance. The star schema structure data can be viewed and analyzed as multi dimensional view and can be used for Online Analytical Processing.