A General Methodology for Data Conversion and Restructuring
IBM Journal of Research and DevelopmentPublished 1 September 1976
Vincent Y. Lum, N. C. Shu, Barron C. Housel
Citations20
Generate an AI Snapshot to get a quick, structured summary of this paper.
Study Snapshot
ObjectiveStudy objective
MethodsResearch methodology
PopulationPopulation studied
Sample sizeSample sizes
OutcomesStudy outcomes here
ResultsStudy results comes here
LimitationsResearch study limitations comes here
A concise AI-generated summary of the paper will appear here once you click Generate AI Snapshot.
TL;DR
This paper describes these two languages, DEFINE and CONVERT, and gives numerous examples to show the capabilities of these languages and how they can be used in data conversion and restructuring.
Abstract
This paper presents a methodology and a model for data conversion or translation. The model assumes that both source and target systems are available and that conversion interfaces may be required to interact between these systems and the conversion system. To achieve data conversion or translation using this approach, two languages are needed: 1) a language to describe the data structures, and 2) a language to specify the mapping between source and target data. This paper describes these two languages, DEFINE and CONVERT and gives numerous examples to show the capabilities of these languages and how they can be used in data conversion and restructuring. Both languages are high level and nonprocedural and have the power to deal with most situations encountered in data conversion processes. In addition, the paper also describes some of the facilities in the languages specifically designed for data checking in a data conversion process.
Keywords
Computer Science
Communications of the ACMA relational model of data for large shared data banks
4,834 Citations1983E. F. Codd
SEQUEL
576 Citations1976Donald D. Chamberlin, Raymond F. Boyce
The data manipulation facility for a structured English query language (SEQUEL) which can be used for accessing data in an integrated relational data base.
A data base sublanguage founded on the relational calculus
372 Citations1971E. F. Codd
Three principal types of language for data base manipulation are identified: the low-level, procedure-oriented, intermediate level, algebraic, and the high level, relational calculus-based data sublanguage, an example of which is described in this paper.
Communications of the ACMCONVERT
111 Citations1975Nan C. Shu, Barron C. Housel +1 more
A high level and nonprocedural translation definition language, CONVERT, which provides very powerful and highly flexible data restructuring capabilities and is based on the simple underlying concept of a form which enables the users to visualize the translation processes, and thus makes data translation a much simpler task.
Communications of the ACMA data definition and mapping language
61 Citations1973Edgar H. Sibley, Robert W. Taylor
The paper reviews past work in the data definition language for describing both logical and physical aspects of data and applications of these generalized data definition languages are discussed.
An approach to Stored Data Definition and Translation
40 Citations1972James P. Fry, Diane P. Smith +1 more
Major components of each language for data translation are discussed and sample statements in terms of an example data translation from a COBOL file to a NIPS/360 file are provided.
ScholarlyCommons (University of Pennsylvania)An approach to data description and conversion
37 Citations1971Diane C. P. Smith
The aim is to understand data structures by developing a model which not only characterizes current data organizational techniques, but also provides a framework within which new data structures can be defined.
“Automatic generation of data conversion programs using a data description language”
35 Citations1976Jesús Alberto Ramírez Torres, N. Adam Rin +1 more
The paper describes the application of automatic program generation methodology in generating file conversion programs in PL/1 capable of converting the source file and producing the target file.
A method for data translation using the Stored-Data Definition and Translation Task Group languages
33 Citations1972Diane C. P. Smith
The research done for this paper was part of the author's task as a member of the Stored-Data Definition end Translation Task Group, and members of this group contributed many ideas and helpful criticisms.
A relational data base management system
31 Citations1972Giampio Bracchi, A. Fedeli +1 more
The design criteria and the overall organization of MORIS, a new general purpose data management system, are illustrated, which is designed to provide independence of application programs from growths in data types and changes in data representation, convertibility of data among different storage structures, and ability to provide solutions to a wide variety of unanticipated user's problems in fast and uniform retrieval times.
A high-level data manipulation language for hierarchical data structures
27 Citations1976Barron C. Housel, Nan C. Shu
It is asserted that the hierarchical view of data will continue to be popular for a broad class of applications and users and a nonprocedural language, CONVERT, is proposed as a high-level DBMS interface to provide users with a tool for performing complex data manipulation and query of hierarchical data abstractions.
Deep Blue (University of Michigan)Generalized Data Base Management System Data Structures And Their Mappingto Physical Storage.
24 Citations1971Robert W. Taylor
Architecture to an interactive migration system (AIMS)
21 Citations1976Barron C. Housel, Vincent Y. Lum +1 more
The architecture of a system to aid conversion should have the ability to extract pertinent information from high level source application programs and source systems environment and ability to carry out the translation process automatically after directions are given from a high level language.
A record oriented, grammar driven data translation model
10 Citations1976Shaun Liu, Jack Heller
This paper examines the problem of translating data from one computer stored form into another and proposes an unifying approach —a top down grammar driven method—to the generalized data translation problem.
Preliminary discussion of a general data-to-storage structure mapping language
8 Citations1970Edgar H. Sibley, Robert W. Taylor
ScholarlyCommons (University of Pennsylvania)Automatic Generation of Data Conversions - Programs Using a Data Description Language (DDL) Volume 1 and 2
2 Citations1973Jesús Alberto Ramírez Torres
This repor t 8 describes the Data Description and Data Manipulation Languages (DDL/DML), the operation of the Processor, and includes a user guide and f u l l documentation of t h e processing system.