DATATRIEVE is a database query and report writer tool originally from Digital Equipment Corporation. It runs on the OpenVMS operating system, as well as several PDP-11 operating systems. DATATRIEVE's command structure is nearly plain English, and it is an early example of a Fourth Generation Language (4GL).
DATATRIEVE works against flat files, indexed files, and databases. Such data files are delimited using record definitions stored in the Common Data Dictionary (CDD), or in RMS files. DATATRIEVE is used at many OpenVMS installations.
Historyedit
DATATRIEVE was developed in the late 1970s[1] and early 1980s by a team of software engineers at DEC's Central Commercial Engineering facilities in Merrimack and Nashua, New Hampshire, under database architect Jim Starkey.[2] Many of the project's engineers went on to highly visible careers in database management and other software disciplines.
Version 1 for the PDP-11 was released in 1977; VAX DATATRIEVE was released in 1981 as part of the VAX Information Architecture.
DATATRIEVE adopted the wombat as its notional mascot; the program's help file responded to “HELP WOMBAT” with factual information about real world wombats.
Examples of DATATRIEVE usageedit
DATATRIEVE queries and commands approach plain English sentence structure, though would not be considered natural language, since a precise sentence structure must be used:[3]
DTR> FOR FAMILIES WITH NUMBER_KIDS = 2
CON> PRINT KID_NAME, AGE OF KIDS WITH AGE GT 20
DATATRIEVE can also be used to modify data:
DTR> FOR FAMILIES MODIFY EACH_KID OF FIRST 1 KIDS
Enter KID_NAME:
DATATRIEVE can also cross multiple datasets, creating joined data views:[4]
DTR> PRINT NAME, TYPE, PRICE OF
CON> YACHTS CROSS OWNERS OVER TYPE
Referencesedit
^"Digital introduces Datatrieve". Computerworld. March 27, 1978. p. 53.
^"IEEE Computer Society and GBC/ACM". IEEE.org. Retrieved December 7, 2012.
^(PDF). Archived from the original (PDF) on 2020-12-04. Retrieved 2019-04-30.
^"DEC's 'Datatrieve' Upgrade Enables Cross-File Views". Computerworld. July 21, 1980. p. 44.
External linksedit
"DATATRIEVE". VSI. March 2017. Retrieved 2021-01-16.
Joe H. Gallagher. "The DATATRIEVE Programmer". Retrieved 2013-09-02.
Martin P.J. Zinser. "Datatrieve and Wombats". IBPhoenix. Retrieved 2013-09-02.
April 09, 2024
datatrieve, database, query, report, writer, tool, originally, from, digital, equipment, corporation, runs, openvms, operating, system, well, several, operating, systems, command, structure, nearly, plain, english, early, example, fourth, generation, language,. DATATRIEVE is a database query and report writer tool originally from Digital Equipment Corporation It runs on the OpenVMS operating system as well as several PDP 11 operating systems DATATRIEVE s command structure is nearly plain English and it is an early example of a Fourth Generation Language 4GL Developer s VMS Software Inc originally Digital Equipment Corporation Stable release7 4 1 March 2017Operating systemOpenVMS PDP 11 operating systemsAvailable inEnglish Contents 1 Overview 2 History 3 Examples of DATATRIEVE usage 4 References 5 External linksOverview editDATATRIEVE works against flat files indexed files and databases Such data files are delimited using record definitions stored in the Common Data Dictionary CDD or in RMS files DATATRIEVE is used at many OpenVMS installations History editDATATRIEVE was developed in the late 1970s 1 and early 1980s by a team of software engineers at DEC s Central Commercial Engineering facilities in Merrimack and Nashua New Hampshire under database architect Jim Starkey 2 Many of the project s engineers went on to highly visible careers in database management and other software disciplines Version 1 for the PDP 11 was released in 1977 VAX DATATRIEVE was released in 1981 as part of the VAX Information Architecture DATATRIEVE adopted the wombat as its notional mascot the program s help file responded to HELP WOMBAT with factual information about real world wombats Examples of DATATRIEVE usage editDATATRIEVE queries and commands approach plain English sentence structure though would not be considered natural language since a precise sentence structure must be used 3 DTR gt FOR FAMILIES WITH NUMBER KIDS 2 CON gt PRINT KID NAME AGE OF KIDS WITH AGE GT 20 DATATRIEVE can also be used to modify data DTR gt FOR FAMILIES MODIFY EACH KID OF FIRST 1 KIDS Enter KID NAME DATATRIEVE can also cross multiple datasets creating joined data views 4 DTR gt PRINT NAME TYPE PRICE OF CON gt YACHTS CROSS OWNERS OVER TYPEReferences edit Digital introduces Datatrieve Computerworld March 27 1978 p 53 IEEE Computer Society and GBC ACM IEEE org Retrieved December 7 2012 DATATRIEVE Users Guide PDF Archived from the original PDF on 2020 12 04 Retrieved 2019 04 30 DEC s Datatrieve Upgrade Enables Cross File Views Computerworld July 21 1980 p 44 External links edit DATATRIEVE VSI March 2017 Retrieved 2021 01 16 Joe H Gallagher The DATATRIEVE Programmer Retrieved 2013 09 02 Martin P J Zinser Datatrieve and Wombats IBPhoenix Retrieved 2013 09 02 Retrieved from https en wikipedia org w index php title DATATRIEVE amp oldid 1210295293, wikipedia, wiki, book, books, library,
