Relational database reverse engineering using the Rigi system

Simple item page
dc.contributor.authorDu, Mingen_US
dc.date.accessioned2024-08-13T20:18:50Z
dc.date.available2024-08-13T20:18:50Z
dc.date.copyright2002en_US
dc.date.issued2002
dc.degree.departmentDepartment of Computer Science
dc.degree.levelMaster of Science M.Sc.en
dc.description.abstractData Base Reverse Engineering (DBRE) is a process of recovering or reconstructing the functional and technical specifications of databases. More precisely, it is a process to recover the schemas that are the results of a database design process. It mainly starts from the source code, such as SQL, of the database application program. Recovering these specifications generally helps to re-document, convert, restructure, maintain, migrate, or extend the legacy databases. The problem is extremely complex for old and ill-designed databases, because there is usually no documentation that can be relied upon and the lack of systematic methodologies for designing and maintaining the databases has led to tricky and obscure code. Therefore, DBRE has long been recognized as a complex, tedious and prone-to-failure activity. Various computer-aided DBRE tools have been developed to reduce the complexity of this task. However, a major limitation of current approaches is that they cannot represent database schemas and database structure simultaneously. In this thesis, we propose an approach that can visualize database structure and schema concurrently. The approach is built on the current version of the Rigi system, a popular reverse engineering tool. The contribution of this thesis is that Rigi is extended to a useful DBRE tool. It can be used to extract and represent database design information.
dc.format.extent103 pages
dc.identifier.urihttps://hdl.handle.net/1828/17654
dc.rightsAvailable to the World Wide Weben_US
dc.titleRelational database reverse engineering using the Rigi systemen_US
dc.typeThesisen_US

Files

Original bundle
Now showing 1 - 1 of 1
Thumbnail Image
Name:
DU_Ming_MSC_2002_1214273.pdf
Size:
28.84 MB
Format:
Adobe Portable Document Format
Download

Collections

Electronic Theses and Dissertations (ETD)
 
University of Victoria Libraries

We acknowledge and respect the Lək̓ʷəŋən (Songhees and Esquimalt) Peoples on whose territory the university stands, and the Lək̓ʷəŋən and W̱SÁNEĆ Peoples whose historical relationships with the land continue to this day.