ACM SIGMOD Anthology VLDB dblp.uni-trier.de

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

ACM SIGMOD Anthology

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

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 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML

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) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[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) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[P&B94]
William J. Premerlani, Michael R. Blaha: An Approach for Reverse Engineering of Relational Databases. Commun. ACM 37(5): 42-49, 134(1994) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[HDA87]
Kathi Hogshead Davis, Adarsh K. Arora: Converting A Relational Database Model into an Entity-Relationship Model. ER 1987: 271-285 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[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) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[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 CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[NEK94]
Jim Q. Ning, Andre Engberts, Wojtek Kozaczynski: Automated Support for Legacy Code Understanding. Commun. ACM 37(5): 50-57(1994) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[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) CiteSeerX Google scholar pubzone.org BibTeX bibliographical record in XML
[HCTJ93]
...

Copyright © Tue Mar 16 02:22:04 2010 by Michael Ley (ley@uni-trier.de)