论文信息 - ERDraw: An XML-based ER-diagram Drawing and Translation Tool

ERDraw: An XML-based ER-diagram Drawing and Translation Tool

The Entity-Relationship (ER) model is one of the most popular methodologies for designing relational databases. Several commercial products have been developed to support drawing ER-diagrams in a graphical fashion. Their architectures and implementation details, however, are not available in public. Inspired by these products and recent developments in XML technology and semantic drawing framework Drawlet, we have developed an educational prototype ERDraw that supports drawing ERdiagrams visually and translating them to relational database schemas automatically. In this paper, we describe the architecture of ERDraw and its implementation details to illustrate how such a tool can be developed.

[1] C. M. Sperberg-McQueen,et al. Extensible Markup Language (XML) , 1997, World Wide Web J..

[2] Peter P. Chen. ER Model, XML and the Web , 1999, ER.

[3] Alfons Kemper,et al. Databases and transaction processing: an application-oriented approach , 2002, SGMD.

[4] Peter P. Chen. The Entity-Relationship Model: Towards a unified view of Data , 1976 .

[5] Peter P. Chen. The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[6] Ramez Elmasri,et al. The Category Concept: An Extension to the Entity-Relationship Model , 1985, Data Knowl. Eng..

[7] Raghu Ramakrishnan,et al. Database Management Systems , 1976 .

[8] T. J. Teorey,et al. A logical design methodology for relational databases using the extended entity-relationship model , 1986, CSUR.