A methodology for view integration in manufacturing database design

제조 데이타베이스 설계에서의 뷰 통합 방안

Conceptual database design is an important activity because the performance of a DBMS heavily depends on the proper design of the database, and view integration is one of the most important phases of conceptual database design. During this phase, the individual views designed by separate user groups are integrated into a global view for the entire system. After the view integration, a database schema must be validated before it becomes a stable product of the design. In this paper, a methodology for view integration an validation is suggested. The individual views are modeled by entity-relationship model. The entities are integrated according to their name and domain information. After that, the relationships are merged by their constraints. We also present a methodology for checking redundant relationships which has an algorithmic description.