Application Program Conversion due to Data Base Changes.

@inproceedings{DBLP:conf/vldb/Su76,
  author    = {Stanley Y. W. Su},
  editor    = {Peter C. Lockemann and
               Erich J. Neuhold},
  title     = {Application Program Conversion due to Data Base Changes},
  booktitle = {Systems for Large Data Bases, September 8-10, 1976, Brussels,
               Belgium},
  publisher = {North Holland {\&} IFIP},
  year      = {1976},
  isbn      = {0-7204-0546-7},
  pages     = {143-157},
  ee        = {db/conf/vldb/Su76.html},
  crossref  = {DBLP:conf/vldb/76},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Advancement in hardware and software technologies and changes in the use environment of data base management systems often require that the data bases and their associated application programs be translated and converted in order to take advantage of newer technologies and new application needs. Research must be conducted to find efficient techniques for automatic or semi-automatic application program conversion, so that the expense and time involved in manual rewriting of application programs can be avoided.

This paper (1) describes the relation between data base translation and application program conversion, (2) identifies the program conversion tasks and their possible automation, (3) explores the techniques for solving the conversion problem through computer aided analysis of application programs, and (4) discusses and illustrates the data mappinq operators useful for data base translation and their effects on program conversion. A semi-automatic approach to the conversion problem is proposed. It divides the conversion into two stages of analysis: data sublanguage statement analysis and conversion, and host language program analysis and conversion. Some conversion tasks and their analysis techniques are identified and described.

Copyright © 1976 by International Federation for Information Processing (IFIP).

ACM SIGMOD Anthology

• 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/vldb7588 or /cdrom

• 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

References

[1]

Donald D. Chamberlin, Raymond F. Boyce: SEQUEL: A Structured English Query Language. SIGMOD Workshop, Vol. 1 1974: 249-264 BibTeX

[2]

...

[3]

...

[4]

E. F. Codd: Further Normalization of the Data Base Relational Model. IBM Research Report, San Jose, California RJ909: (1971) BibTeX

[5]

E. F. Codd: Seven Steps to Rendezvous with the Casual User. IFIP Working Conference Data Base Management 1974: 179-200 BibTeX

[6]

...

[7]

...

[8]

...

[9]

James P. Fry, Randall L. Frank, Ernest A. Hershey III: A Development Model for Data Translation. SIGFIDET Workshop 1972: 77-105 BibTeX

[10]

...

[11]

Barron C. Housel, Vincent Y. Lum, Nan C. Shu: Architecture to An Interactive Migration System (AIMS). SIGMOD Workshop, Vol. 1 1974: 157-169 BibTeX

[12]

Barron C. Housel, Diane C. P. Smith, Nan C. Shu, Vincent Y. Lum: DEFINE: A Non-Procedural Data Description Language for Defining Information Easily. ACM Pacific 1975: 62-70 BibTeX

[13]

Herman Lam, Stanley Y. W. Su: A Semi-Automatic Data Base Translation System. ACM Pacific 1975: 71-79 BibTeX

[14]

...

[15]

William C. McGee: Informal Definitions for the Development of a Storage Structure Definition Language. SIGFIDET Workshop 1970: 338-353 BibTeX

[16]

Alan G. Merten, James P. Fry: A Data Description Language Approach to File Translation. SIGMOD Workshop, Vol. 1 1974: 191-205 BibTeX

[17]

Udo W. Pooch: Translation of Decision Tables. ACM Comput. Surv. 6(2): 125-151(1974) BibTeX

[18]

J. A. Ramirez, N. Adam Rin, Noah S. Prywes: Automatic Generation of Data Conversion Programs Using A Data Description Language. SIGMOD Workshop, Vol. 1 1974: 207-225 BibTeX

[19]

...

[20]

...

[21]

Nan C. Shu, Barron C. Housel, Vincent Y. Lum: CONVERT: A High Level Translation Definition Language for Data Conversion. Commun. ACM 18(10): 557-567(1975) BibTeX

[22]

...

[23]

Edgar H. Sibley, Robert W. Taylor: A Data Definition and Mapping Language. Commun. ACM 16(12): 750-759(1973) BibTeX

[24]

...

[25]

...

[26]

Diane C. P. Smith: A Method for Data Translation Using the Stored Data Definition and Translation Task Group Languages. SIGFIDET Workshop 1972: 107-124 BibTeX

[27]

Stanley Y. W. Su, Herman Lam: A Semi-automatic Data Base Translation System for Achieving Data Sharing in a Network Environment. SIGMOD Workshop, Vol. 1 1974: 227-247 BibTeX

[28]

...

[29]

...

Referenced by

1. Ben Shneiderman, Glenn Thomas: An Architecture for Automatic Relational Database System Conversion. ACM Trans. Database Syst. 7(2): 235-257(1982)
2. Randy H. Katz, Eugene Wong: Decompiling CODASYL DML into Relational Queries. ACM Trans. Database Syst. 7(1): 1-23(1982)
3. Stanley Y. W. Su, Herman Lam, Der Her Lo: Transformation of Data Traversals and Operations in Application Programs to Account for Semantic Changes of Databases. ACM Trans. Database Syst. 6(2): 255-294(1981)
4. Lynn A. Hollabaugh, Lewis T. Reinwald: GPI: A Statistical Package/Data Base Interface. SSDBM 1981: 78-87
5. Robert W. Taylor, James P. Fry, Ben Shneiderman, Diane C. P. Smith, Stanley Y. W. Su: Database Program Conversion: A Framework for Research. VLDB 1979: 299-312
6. Stanley Y. W. Su, Der Her Lo: A Semantic Association Model for Conceptual Design. ER 1979: 169-192
7. J. Nations, Stanley Y. W. Su: Some DML Instruction Sequences for Application Program Analysis and Conversion. SIGMOD Conference 1978: 120-131
8. Barron C. Housel: A Unified Approach to Program and Data Conversion. VLDB 1977: 327-336
9. Stanley Y. W. Su, B. J. Liu: A Methodology of Application Program Analysis and Conversion Based on Database Semantics. SIGMOD Conference 1977: 75-87