Reverse engineering of data

IBM Systems Journal

Volumn 37, Issue 2, 1998, Pages 246-269

  Aiken, P H ^a,b,c,d,e  

^a VIRGINIA COMMONWEALTH UNIVERSITY   (United States)

^b GEORGE MASON UNIVERSITY   (United States)

^c GMU Faculty   (United States)

^d GMU Faculty ^*  (United States)

^e Department of Defense   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATA STRUCTURES; DISTRIBUTED COMPUTER SYSTEMS;

DATA REVERSE ENGINEERING (DRE);

COMPUTER AIDED SOFTWARE ENGINEERING;

EID: 0031651325     PISSN: 00188670     EISSN: None     Source Type: Journal    
DOI: 10.1147/sj.372.0246     Document Type: Article

References (35)

1. E. Chikofsky and J. Cross, "Reverse Engineering and Design Recovery: A Taxonomy," IEEE Software 7, No. 1, 13-17 (January 1990).
2. R. N. Karr, Data Management Issues Associated with Stovepipe Systems, General Services Administration/Information Resources Management Service/Policy Analysis Division, Report KMP-94-1-I (October 1993).
3. W. Durell, Data Administration: A Practical Guide to Data Management, McGraw-Hill, Inc., New York (1985).
4. D. Stoddard and C. J. Meadows. "Capital Holding Corporation - Reengineering the Direct Holding Group," in J. Cash, R. Eccles, N. Nohria, and R. Nolan, Building the Information-Age Organization: Structure, Control, and Information Technologies, Richard D. Irwin, Boston, MA (1994), pp. 433-452.
5. J. R. Caron, S. L. Jarvenpaa, and D. B. Stoddard, "Business Reengineering at CIGNA Corporation: Experiences and Lessons Learned from the First Five Years," Management Information Systems Quarterly 18, No. 3, 233-247 (September 1994).
6. Beyond the Basics of Reengineering: Survival Tactics for the '90s, Quality Resources, The Kraus Organization Industrial Engineering and Management Press, Institute of Industrial Engineers, Norcross, GA (1994).
7. L. Wilson, "Cautious Change for Retailers," Information Week, 177-180 (October 10, 1994).
8. S. Haeckel and R. Nolan, "Managing by Wire," Harvard Business Review 71, No. 5, 122-132 (September/October 1993).
9. E. J. Chikofsky, "The Database as a Business Road Map," Database Programming and Design 3, No. 5, 62-67 (May 1990).
10. Proceedings of the First Working Conference on Reverse Engineering, May 21-23, 1993, Baltimore, MD, IEEE Computer Society Press (1993). Proceedings of the Second Working Conference on Reverse Engineering, July 14-16, 1995, Toronto, Canada, IEEE Computer Society Press (1995). Proceedings of the Third Working Conference on Reverse Engineering, November 8-10, 1996, Monterey, CA, IEEE Computer Society Press (1996). Proceedings of the Fourth Working Conference on Reverse Engineering, October 6-8, 1997, Amsterdam, the Netherlands, IEEE Computer Society Press (1997).
11. Proceedings of the First Working Conference on Reverse Engineering, May 21-23, 1993, Baltimore, MD, IEEE Computer Society Press (1993). Proceedings of the Second Working Conference on Reverse Engineering, July 14-16, 1995, Toronto, Canada, IEEE Computer Society Press (1995). Proceedings of the Third Working Conference on Reverse Engineering, November 8-10, 1996, Monterey, CA, IEEE Computer Society Press (1996). Proceedings of the Fourth Working Conference on Reverse Engineering, October 6-8, 1997, Amsterdam, the Netherlands, IEEE Computer Society Press (1997).
12. Proceedings of the First Working Conference on Reverse Engineering, May 21-23, 1993, Baltimore, MD, IEEE Computer Society Press (1993). Proceedings of the Second Working Conference on Reverse Engineering, July 14-16, 1995, Toronto, Canada, IEEE Computer Society Press (1995). Proceedings of the Third Working Conference on Reverse Engineering, November 8-10, 1996, Monterey, CA, IEEE Computer Society Press (1996). Proceedings of the Fourth Working Conference on Reverse Engineering, October 6-8, 1997, Amsterdam, the Netherlands, IEEE Computer Society Press (1997).
13. Proceedings of the First Working Conference on Reverse Engineering, May 21-23, 1993, Baltimore, MD, IEEE Computer Society Press (1993). Proceedings of the Second Working Conference on Reverse Engineering, July 14-16, 1995, Toronto, Canada, IEEE Computer Society Press (1995). Proceedings of the Third Working Conference on Reverse Engineering, November 8-10, 1996, Monterey, CA, IEEE Computer Society Press (1996). Proceedings of the Fourth Working Conference on Reverse Engineering, October 6-8, 1997, Amsterdam, the Netherlands, IEEE Computer Society Press (1997).
14. P. Aiken, Data Reverse Engineering: Slaying the Legacy Dragon, McGraw-Hill, Inc., New York (1996).
15. D. Hay, Data Model Patterns: Conventions of Thought, Dorset House Publishing, New York (1995).
16. W. Premerlani and M. Blaha, "An Approach to Reverse Engineering of Relational Databases," Communications of the ACM 37, No. 5, 42-49, 134 (May 1994).
17. M. Blaha, "Observed Idiosyncracies of Relational Database Designs," Proceedings of the Second Working Conference on Reverse Engineering, July 14-16, 1995, Toronto, Canada, IEEE Computer Society Press (1995), pp. 116-125.
18. M. Blaha, "Dimensions of Relational Database Reverse Engineering," Proceedings of the Fourth Working Conference on Reverse Engineering, October 6-8, 1997, Amsterdam, the Netherlands, IEEE Computer Society Press (1997), pp. 176-183.
19. E. F. Codd, "Relational Database: A Practical Foundation for Productivity," Communications of the ACM 25, No. 2, 109-117 (February 1982).
20. P. Aiken, A. Muntz, and R. Richards, "DoD Legacy Systems: Reverse Engineering Data Requirements," Communications of the ACM 37, No. 5, 26-41 (May 1994).
21. Y. Yoon, P. Aiken, and T. Guimaraes, "Defining Data Quality Metadata: Toward a Life Cycle Approach to Data Quality Engineering," under review by the Information Resources Management Journal.
22. P. Aiken and P. Piper, "Estimating Data Reverse Engineering Projects," Proceedings of the 5th Annual Systems Reengineering Workshop, February 7-9, 1995, Monterey, CA (1995), pp. 133-145. Also available as Report RSI-95-001 from Applied Physics Laboratory Research Center, Johns Hopkins University, Baltimore, MD.
23. L. Hodgson and P. Aiken, "Synergistic Dependence Between Analysis Techniques," Proceedings of the 9th Software Technology Conference, April 27-May 2, 1997, Salt Lake City, UT; published on CD-ROM by the Air Force Software Technology Support Center, http://www.stsc.hill.af.mil.
24. W. Selkow, "Strategic Information Planning: A New Framework," Enterprise Systems Journal (1990).
25. D. Appleton, "Business Rules: The Missing Link," Datamation 30, No. 16, 145-150 (October 1984).
26. B. Inmon, Data Architecture: The Information Paradigm, QED Technical Publishing Group, Boston, MA (1993).
27. P. Aiken and B. Girling, "Data Reengineering Fits the Bill," InformationWeek, 8A-12A (May 26, 1997).
28. P. Aiken, "Integrating the Reverse and Forward Engineering of Data Using Metadata Models," Proceedings of the 10th Annual DAMA-NCR Symposium, September 11-12, 1997, Washington, DC (1997), pp. 103-160; available from National Capital Region, DAMA, McLean, VA.
29. See the IHRIS Project Website at http://www.isy.vcu.edu/ ∼paiken/dre/ihris.htm.
30. E. Chikofsky, "The Necessity of Data Reverse Engineering," Data Reverse Engineering: Slaying the Legacy Dragon, P. Aiken, Editor, McGraw-Hill, Inc., New York (1996), pp. 8-11.
31. F. Neiderman, J. Brancheau, and J. Wetherbe, "Information Systems Management Issues of the '90s," MIS Quarterly 15, No. 4, 475-499 (December 1991).
32. B. Caldwell, "Missteps, Miscues: Business Reengineering Failures Have Cost Corporations Billions, and Spending Is Still on the Rise," InformationWeek, 50-60 (June 20, 1994).
33. P. Aiken and O. Negwenyana, "Reverse Engineering New Systems: An Implementation Support Perspective," under review by IEEE Software.
34. See http://www.microsoft.com/repository/start.htm for details.
35. C. Finkelstein and P. Aiken, Data Warehouse Engineering with Data Quality Reengineering, McGraw-Hill, Inc., New York (scheduled for October 1998 publication).