Reverse Engineering in a Client-Server Environment
Case Studies on Relational Database Design
Cite this chapter
- Brian Siu 2 &
- Joseph Fong 3
71 Accesses
1 Citations
Relational database management systems (RDBMS) share a high percentage of the database market. Coupled with client application development tools like PowerBuilder, * and data modeling and design tools like ERwin/ERX, rapid application development is made possible. However, due to the ease of use of these client-server tools, there is a tendency for application developers to quick start their application development process without going through a formal process of database design. Through the use of reverse engineering tools, physical database schemas can be converted into their entity-relationship (ER) model. By looking at the ER model we can evaluate whether the relational database design has been completee or not.
This paper first gives an overview of client-server computing, reengineering and reverse engineering, followed by an introduction of a database modeling and design tool which provides forward and reverse engineering capabilities in a client-server database environment. Using this tool, two case studies were carried out. In the first case, an incomplete database design was revealed. In the second case, the ER model showed that database design has been completed. An integrated approach is proposed for database modeling, design and database generation.
Article Footnote
PowerBuilder, Erwin/ERX, and other brand names are product names of their respective owners.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Subscribe and save.
- Get 10 units per month
- Download Article/Chapter or eBook
- 1 Unit = 1 Article or 1 Chapter
- Cancel anytime
- Available as PDF
- Read on any device
- Instant download
- Own it forever
- Compact, lightweight edition
- Dispatched in 3 to 5 business days
- Free shipping worldwide - see info
Tax calculation will be finalised at checkout
Purchases are for personal use only
Institutional subscriptions
Unable to display preview. Download preview PDF.
Similar content being viewed by others
Formalization of Database Reverse Engineering
Database reverse engineering based on meta-models
Evaluation of XIS-Reverse, a Model-Driven Reverse Engineering Approach for Legacy Information Systems
Cheung, To-yat (1993). “Temporal Databases - their present and future”, 5th International Hong Kong Computer Society Database Workshop, Next Generation Database Systems, Hong Kong Computer Society, Hong Kong, pp.29–46.
Google Scholar
Date, C.J. (1990). An Introduction to Database Systems, 5/e, Addison-Wesley.
Dewire, D.T. (1993). Client/Server Computing. McGraw Hill.
Khoshafian, S. (1993). Object-oriented Databases, Wiley.
Logic Works (1994). ERwin/ERX for PowerBuilder, Database Design Tool, Release 1.5c,User’s Guide. Princeton, Logic Works Inc. 1989–1994, NJ 08540.
Oracle Seminar (1994). Oracle CDE2 Tools, Maximizing Developer Productivity Seminar.Oracle Systems Hong Kong Limited, December 8, 1994.
PowerBuilder Watcom SQL, Version 3.0, PowerSoft Corporation, 1994.
Sybase (1993). Sybase OnmiSQL Gateway: A New Generation Gateway for the Distributed Enterprise. Sybase Corporation, April 1993.
Download references
Author information
Authors and affiliations.
Division of Technology, City University of Hong Kong, Tat Chee Avenue, Kowloon Tong, Hong Kong, China
Department of Computer Science, City University of Hong Kong, Tat Chee Avenue, Kowloon Tong, Hong Kong, China
Joseph Fong
You can also search for this author in PubMed Google Scholar
Editor information
Editors and affiliations.
City University of Hong Kong, Kowloon, Hong Kong, China
To-yat Cheung , Joseph Fong & Brian Siu , &
Rights and permissions
Reprints and permissions
Copyright information
© 1996 Springer Science+Business Media New York
About this chapter
Siu, B., Fong, J. (1996). Reverse Engineering in a Client-Server Environment. In: Cheung, Ty., Fong, J., Siu, B. (eds) Database Reengineering and Interoperability. Springer, Boston, MA. https://doi.org/10.1007/978-1-4615-1803-7_7
Download citation
DOI : https://doi.org/10.1007/978-1-4615-1803-7_7
Publisher Name : Springer, Boston, MA
Print ISBN : 978-1-4613-5728-5
Online ISBN : 978-1-4615-1803-7
eBook Packages : Springer Book Archive
Share this chapter
Anyone you share the following link with will be able to read this content:
Sorry, a shareable link is not currently available for this article.
Provided by the Springer Nature SharedIt content-sharing initiative
- Publish with us
Policies and ethics
- Find a journal
- Track your research
IMAGES