Design of Library Data Warehouse Using SnowFlake Scheme Method: Case Study: Library Database of Campus XYZ

The existence of the library as a technical service unit in a campus is very important to provide services to the academic community. With increasing number of library collections, database that is built has to be able to improve the services oriented on providing data warehouse. Especially at managerial level requires complete information, quickly and accurately to support the process and planning, evaluation, and right decision-making. The design of data warehouse is determined by description of proper information requirement, selection of valid data source, design of data warehouse and ETL process to integrate, extract, cleanse, transform and populate it into data warehouse. The snowflake scheme design method has been applied to accommodate dimension tables of database and other dimension sub-table, so it can generate more information that would be used as material to make a decision.