DATATRIEVE

DATATRIEVE is a database query and report writer tool originally from Digital Equipment Corporation.

Uses your system voice; voice and rate in settings.

≈ 3 min read

Cite, export and learn8 citation formats · 8 exports · lesson and quiz

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

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).

Overview

edit edit source

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.

History

edit edit source

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 usage

edit edit source

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

References

edit edit source
  1. ^ "Digital introduces Datatrieve". Computerworld. March 27, 1978. p. 53. Wikipedia revision 1301094606, retrieved 2026-11-22
  2. ^ "IEEE Computer Society and GBC/ACM". IEEE.org. Retrieved December 7, 2012. Wikipedia revision 1301094606, retrieved 2026-11-22
  3. ^ "DATATRIEVE Users Guide" (PDF). Archived from the original (PDF) on 2020-12-04. Retrieved 2019-04-30. Wikipedia revision 1301094606, retrieved 2026-11-22
  4. ^ "DEC's 'Datatrieve' Upgrade Enables Cross-File Views". Computerworld. July 21, 1980. p. 44. Wikipedia revision 1301094606, retrieved 2026-11-22
edit edit source

Text derived from https://en.wikipedia.org/w/index.php?oldid=1301094606 under CC BY-SA 4.0; modifications have been made.

Words in each sectionHistoryHistoryHistory: 105 words105Examples of DATATRIEVE …Examples of DATATRIEVE usageExamples of DATATRIEVE usage: 99 words99OverviewOverviewOverview: 38 words38
Words in each section. Measured from the stored article body; sections below the minimum are not plotted.

References

  1. ↩Wikipedia “DATATRIEVE” revision 1301094606 · retrieved 2026-10-20 release date (×1) · confidence 0.95 revision URL

Provenance

snapshot enwiki-001301094606 · captured 2025-07-18 · ledger · version history

Cite this page as: encyclopegia.org, “DATATRIEVE”, snapshot enwiki-001301094606. https://encyclopegia.org/a/datatrieve