skip to main content
10.1145/1500774.1500849acmotherconferencesArticle/Chapter ViewAbstractPublication PagesafipsConference Proceedingsconference-collections
research-article
Free access

Automatic database system conversion: schema revision, data translation, and source-to-source program transformation

Published: 07 June 1982 Publication History

Abstract

Changing data requirements present database administrators with a difficult problem: the revision of the schema, the translation of the stored database, and the conversion of the numerous application programs. This paper describes an automatic database system conversion facility which provides one approach for coping with this problem. The Pure Definition Language and the Pure Manipulation Language have been designed to facilitate the conversions specified in the Pure Transformation Language. Two conversions and their effect on retrievals are demonstrated.

References

[1]
Shneiderman, B., and G. Thomas. Automatic Database System Conversion I: Data Definition and Manipulation Facilities. Computer Science Technical Report Series TR-82, University of Maryland, College Park, Md., 20742 (1979), 39 pages. (Submitted for publication.)
[2]
Thomas, G., and B. Shneiderman. Automatic Database System Conversion II: A Transformation Language. Computer Science Technical Report Series TR-281, University of Maryland, College Park, Md. 20742 (1979), 46 pages. (Submitted for publication.)
[3]
Shneiderman, B., and G. Thomas. "Path Expressions for Complex Queries and Automatic Database Program Conversion." Proceedings of the 6th Very Large Data Bases Conference. Montreal (1980), pp. 33--44.
[4]
Thomas, G., and B. Shneiderman. "Automatic Database System Conversion: A Transformation Language Approach to Sub-Schema Implementation." Proceedings of the IEEE COMPSAC '80 Conference, Chicago, (1980).
[5]
Shneiderman, B., and G. Thomas, Pure Database System Report: A Transformation Language Approach to Automatic Schema, Stored Data and Program Conversion. Computer Science Technical Report Series TR-880, University of Maryland, College Park, Md. 20742 (1980), 91 pages. (Submitted for publication.)
[6]
Shneiderman, B., and G. Thomas. Pure Definition Language Manual. University of Maryland, College Park, Md. 20742 (1980), 10 pages.
[7]
Shneiderman, B., and G. Thomas. Pure Manipulation Language Manual. University of Maryland, College Park, Md. 20742 (1980), 30 pages.
[8]
Shneiderman, B., and G. Thomas. Pure Transformation Language Manual, University of Maryland, College Park, Md. 20742 (1980) 50 pages.
[9]
Fosler, C. Pure System XPL---DMS/1100 Implementation Documentation. Computer Science Technical Report Series TR-872, University of Maryland, College Park, Md. 20742 (1980), 38 pages.
[10]
Fosler, C. Pure PDL and PML Runstream and Examples. University of Maryland, College Park, Md. 20742 (1980), 32 pages.
[11]
Sevitsky, N. Pure User's Manual. University of Maryland, College Park, Md. 20742 (1980), 52 pages.
[12]
Shneiderman, B., and G. Thomas. "An Architecture for Automatic Relational Database System Conversion." ACM Transactions on Database Systems (June 1982.)
[13]
Dale, A. and N. Dale. "Main Schema---External Schema Interaction in Hierarchically Organized Data Bases." Proc. ACM SIGMOD Conference, 1977 pp. 102--110.
[14]
Dale, A., and N. Dale. "Schema and Occurrence Structure Transformations in Hierarchical Systems." Proc. ACM SIGMOD conference (1978).
[15]
Gerritsen, R. and H. L. Morgan. "Dynamic Restructuring of Databases with Generation Data Structures." ACM National Conference 1976, pp. 281--286.
[16]
Housel, B. "A Unified Approach to Program and Data Conversion." Proc. 3rd Very Large Data Bases Conference, Tokyo (1977).
[17]
Jacobs, B. "Applications of Database Logic to Automatic Program Conversion." Submitted for publication.
[18]
Navathe, S. B. "Schema Analysis for Database Restructuring." ACM Transactions on Database Systems, 5 (1980), pp. 157--184.
[19]
Navathe, S. B., and J. P. Fry. "Restructuring for Large Databases: Three Levels of Abstraction. ACM Transactions on Database Systems 1 (1976), pp. 138--156.
[20]
Sakai, H. "Entity-Relationship Approach to the Conceptual Schema Design." Proceedings of the ACM SIGMOD Conference, 1980, pp. 1--8.
[21]
Shu, N., B. Housel, R. W. Taylor, S. Ghosh, and V. Lum "EXPRESS: A Data Extraction, Processing, and Restructuring System." ACM Transactions on Database Systems 2, (1977) pp. 134--174.
[22]
Shneiderman, B. "A Framework for Automatic Conversion of Network Database Programs Under Schema Transformations." Third Jerusalem Conference on Information Technology (J. Moneta, ed.) Amsterdam: North-Holland, 1978.
[23]
Shu, N. C., B. C. Housel, and V. Y. Lum. "CONVERT: A High Level Translation Definition Language for Data Conversion." Communications of the ACM, 18 (1975), pp. 557--567.
[24]
Su, S. Y. W. "Application Program Conversion Due to Database Changes." Proc. 2nd International Conference Very Large Data Bases, Brussels, Belgium (September 1976). Amsterdam: North-Holland, 1976, pp. 143--158.
[25]
Su, S. Y. W., and H. Lam. "Transformation of Data Traversals and Operation in Application Programs to Account for Semantic Changes in Databases." Department of Computer and Information Sciences, University of Florida, Gainesville, Florida, 1979.
[26]
Su, S. Y. W., and B. J. Liu. "A Methodology of Application Program Analysis and Conversion Based on Database Semantics." Proceedings of the ACM SIGMOD Conference, 1977, pp. 75--87.
[27]
Su., S. Y. W., and M. J. Reynolds, "Conversion of High-Level Sublanguage Queries to Account for Database Changes." AFIPS, Proceedings of the National Computer Conference (Vol. 47), 1978, pp. 857--875.
[28]
Swarthwout, D. E., M. E. Deppe, and J. P. Fry. "Operational Software for Restructuring Network Databases." AFIPS, Proceedings of the National Computer Conference (Vol. 46), 1977, pp. 499--508.
[29]
Taylor, R. W., J. P. Fry, B. Shneiderman, D. C. P., Smith, and S. Y. W. Su, "Database Program Conversion: A Framework for Research." Proceedings of the 5th Very Large Database Conference. Available from ACM New York, 1979.

Cited By

View all
  • (2016)Synchronization of Queries and Views Upon Schema EvolutionsACM Transactions on Database Systems10.1145/290372641:2(1-41)Online publication date: 11-May-2016
  • (1994)Data conversion rules from network to relational databasesInformation and Software Technology10.1016/0950-5849(94)90053-136:3(141-153)Online publication date: Mar-1994
  • (1993)Why views do not provide logical data independenceProceedings of ICCI'93: 5th International Conference on Computing and Information10.1109/ICCI.1993.315342(393-397)Online publication date: 1993
  1. Automatic database system conversion: schema revision, data translation, and source-to-source program transformation

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Other conferences
    AFIPS '82: Proceedings of the June 7-10, 1982, national computer conference
    June 1982
    857 pages
    ISBN:088283035X
    DOI:10.1145/1500774
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    • AFIPS: American Federation of Information Processing Societies

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 07 June 1982

    Permissions

    Request permissions for this article.

    Check for updates

    Qualifiers

    • Research-article

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)48
    • Downloads (Last 6 weeks)15
    Reflects downloads up to 19 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2016)Synchronization of Queries and Views Upon Schema EvolutionsACM Transactions on Database Systems10.1145/290372641:2(1-41)Online publication date: 11-May-2016
    • (1994)Data conversion rules from network to relational databasesInformation and Software Technology10.1016/0950-5849(94)90053-136:3(141-153)Online publication date: Mar-1994
    • (1993)Why views do not provide logical data independenceProceedings of ICCI'93: 5th International Conference on Computing and Information10.1109/ICCI.1993.315342(393-397)Online publication date: 1993

    View Options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Login options

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media