A Requirement-Based Approach to Data Modeling and Re-Engineering.

Alice H. Muntz, Christian T. Ramiller: A Requirement-Based Approach to Data Modeling and Re-Engineering. VLDB 1994: 643-654

@inproceedings{DBLP:conf/vldb/MuntzR94,
  author    = {Alice H. Muntz and
               Christian T. Ramiller},
  editor    = {Jorge B. Bocca and
               Matthias Jarke and
               Carlo Zaniolo},
  title     = {A Requirement-Based Approach to Data Modeling and Re-Engineering},
  booktitle = {VLDB'94, Proceedings of 20th International Conference on Very
               Large Data Bases, September 12-15, 1994, Santiago de Chile, Chile},
  publisher = {Morgan Kaufmann},
  year      = {1994},
  isbn      = {1-55860-153-8},
  pages     = {643-654},
  ee        = {db/conf/vldb/vldb94-643.html},
  crossref  = {DBLP:conf/vldb/94},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

This paper reports on the managerial experience, technical approach, and lessons learned from re-engineering eight departmental large-scale information systems. The driving strategic objective of each project was to migrate these systems into a set of enterprise-wide systems, which incorporate current and future requirements, drastically reduce operational and maintenance cost, and facilitate common understandings among stakeholders (i.e., policy maker, high-level management, IS developer/maintainer/end-users). A logical data model, which contains requirements, rules, physical data representation as well as logical data object, clearly documents the baseline data requirements implemented by the legacy system and is crucial to achieve this strategic goal. Re-engineering products are captured in the dictionaries of a CASE tool (i.e., in the form of a business process decomposition hierarchy, as-is data model, normalized logical data model, and linkages among data objects) and are supplemented with traceability matrices in spreadsheets. The re-engineered data products are used as follows: (1) migration of the legacy databases to relational database management systems, (2) automatically generation of databases and applications for migration from mainframes to client-server, (3) enterprise data standardization, (4) integration of disparate information systems, (5) re-documentation, (6) data quality assessment and assurance, and (7) baseline specifications for future systems.

Copyright © 1994 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Online Paper

Download PDF file (www.vldb.org, Darmstadt, Germany)
Download PDF file (www.acm.org, New York, USA)

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the CD and click on the path of your mount point:
/Anthology/vldb8997 or /cdrom

DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...

Windows: Click the letter of your CD drive
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Mac: Click here
UNIX/LINUX: mount the DVD and click on the path of your mount point:
/Anthology/aDVD1 or /dvd

Printed Edition

Jorge B. Bocca, Matthias Jarke, Carlo Zaniolo (Eds.): VLDB'94, Proceedings of 20th International Conference on Very Large Data Bases, September 12-15, 1994, Santiago de Chile, Chile. Morgan Kaufmann 1994, ISBN 1-55860-153-8
Contents

References

[DoD94]: ...
[MH94]: ...
[AHR94]: Peter H. Aiken, Alice H. Muntz, Russ Richards: DoD Legacy Systems: Reverse Engineering Data Requirements. Commun. ACM 37(5): 26-41(1994)
[AHR93]: ...
[HI93a]: ...
[HI93b]: ...
[BLN86]: Carlo Batini, Maurizio Lenzerini, Shamkant B. Navathe: A Comparative Analysis of Methodologies for Database Schema Integration. ACM Comput. Surv. 18(4): 323-364(1986)
[P&B94]: William J. Premerlani, Michael R. Blaha: An Approach for Reverse Engineering of Relational Databases. Commun. ACM 37(5): 42-49, 134(1994)
[HDA87]: Kathi Hogshead Davis, Adarsh K. Arora: Converting A Relational Database Model into an Entity-Relationship Model. ER 1987: 271-285
[M&M90]: Victor M. Markowitz, Johann A. Makowsky: Identifying Extended Entity-Relationship Object Structures in Relational Schemas. IEEE Trans. Software Eng. 16(8): 777-790(1990)
[M&S89]: Victor M. Markowitz, Arie Shoshani: On the Correctness of Representing Extended Entity-Relationship Structures in the Relational Model. SIGMOD Conference 1989: 430-439
[NEK94]: Jim Q. Ning, Andre Engberts, Wojtek Kozaczynski: Automated Support for Legacy Code Understanding. Commun. ACM 37(5): 50-57(1994)
[MNBBK94]: Lawrence Markosian, Philip Newcomb, Russell Brand, Scott Burson, Ted Kitzmiller: Using an Enabling Technology to Reengineer Legacy Systems. Commun. ACM 37(5): 58-70(1994)
[HCTJ93]: ...