Semi-automated approach for converting ERD to semi-star schema

Small and medium enterprises cannot afford the cost of creating a data warehouse and if they do so, they fail to maintain it due to high updation cost. To solve this problem, semi-star schema has already been proposed. Semi-star schema modeling is a new technique, so data warehouse designers may face problems in creating it. Some method based on source-driven approach is required to generate it because source driven approaches are stable, as far as the data is stable in a database. To avoid complexities of semi-star generation, a semi-automated approach to convert entity relation diagram to semi-star schema is presented in this paper. This approach uses some automation steps of entity relationship diagram to star schema conversion that calculates connection topology value and apply threshold on it and the rest of the steps are its own. Thus the complex process of data warehouse generation is simplified using approach presented here.