ER modelling – a zoom in and zoom out approach

Xiong Wang

International Journal of Data Mining, Modelling and Management, 2009, vol. 1, issue 4, 357-374

Abstract: Entity-relationship modelling is an effective design method for relational databases. It is covered in almost every textbook on database systems. Yet, there is not a single book that gives a systematic process on building an entity-relationship model step-by-step from the requirement specifications. In this paper, a zoom in and zoom out approach for such a process is introduced. A toolkit called ERZoom has been developed to assist the designer in the zoom in and zoom out design process. ERZoom provides a unique feature that enables the designer to view a selected subset of the entities and their attributes, while hiding the rest of the entity-relationship model. This is especially useful in distributed database design where vertical fragmentation is a major issue. ERZoom is developed as an open source package using Java. The zoom in and zoom out approach has been taught to beginners for several years and was well-received by the audience.

Keywords: entity-relationship modelling; conceptual modelling; relational database design; data modelling; distributed database design. (search for similar items in EconPapers)
Date: 2009
References: Add references at CitEc
Citations:

Downloads: (external link)
http://www.inderscience.com/link.php?id=29031 (text/html)
Access to full text is restricted to subscribers.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ids:ijdmmm:v:1:y:2009:i:4:p:357-374

Access Statistics for this article

More articles in International Journal of Data Mining, Modelling and Management from Inderscience Enterprises Ltd
Bibliographic data for series maintained by Sarah Parker ().