System 2000 (software)

From Wikipedia, the free encyclopedia

System 2000[1][2][3] (S2K)[4][5] is a hierarchical database management system (DBMS).[2] Although not a relational database, S2K does have SQL support.[6] In 2007 it was noted that, while still 'running on systems cranking away in back rooms across the U.S.' it has a problem: "there's little curriculum coverage anymore at universities teaching computer science."[2]

Overview[edit]

System 2000 originated as software for the IBM mainframe environment. It could operate in batch processing mode or be used via CICS. [4][7] It competed with Cincom's Total, Software AG's ADABAS, Applied Data Research's DATACOM/DB, Computer Corporation of America's Model 204, and IBM Information Management System (IMS) and DL/I.[8] Unisys and CDC versions were subsequently released, as was an interface to SAS.[9]

Programmers could access its Data manipulation language (DML) via a precompiler;[10] these existed for COBOL, FORTRAN, and ASSEMBLY Language. Statements written in S2K's Procedural Language could be intermixed with these languages: the 3 character code "*PL" (in columns 1-3) identified these statements as intended for the precompiler (also referred to as a preprocessor[11]).

History[edit]

System 2000[12] was developed in 1970.[13] SAS Institute acquired S2K from Intel in 1984, which had acquired it from MRI Systems Corporation in 1979.[14]

MRI was founded by Robert L. Brueck.[15][16]

References[edit]

  1. ^ "SOFTWARE & SERVICES: SAS". Computerworld. February 24, 1986. p. 22. Acquiring the System 2000 program gave SAS more "depth as a software company"
  2. ^ a b c Mary Brandel (May 24, 2007). "The top 10 dead (or dying) computer skills". Computerworld.
  3. ^ "System 2000 Essentials: Database Files".
  4. ^ a b "SYSTEM 2000 Database Management Software".
  5. ^ "Creating and Loading SYSTEM 2000 Databases" (PDF).
  6. ^ "SYSTEM 2000 Database Management Software". Retrieved June 22, 2021.
  7. ^ "What other oddball languages have you coded in?". October 3, 2008. using CICS and a System 2000 database
  8. ^ Software Memories»Blog Archive » Prerelational DBMS vendors — a quick overview
  9. ^ SAS/ACCESS 9.1 Interface to System 2000. ISBN 1590471695. SAS/ACCESS software provides an interface between SAS and SYSTEM 2000
  10. ^ Jay-Louise Weldon (1981). Data Base Administration. p. 221. ISBN 978-0-3064-0595-2.
  11. ^ "What is a precompiler?". IBM.
  12. ^ "MRI Announces Autumn SYSTEM 2000 Class Schedule". Computerworld. October 30, 1978. p. 58.
  13. ^ "MRI Systems Corporation". ResearchGate.
  14. ^ R. L. Brueck (2009). "System 2000: The MRI Systems Corporation". IEEE Annals of the History of Computing. 31 (4): 76–86. doi:10.1109/MAHC.2009.105. S2CID 34802924.
  15. ^ "Robert L. Brueck: Books, Biography". Amazon. founded the company that became MRI Systems Corporation and was subsequently acquired by Intel Corporation in 1979.
  16. ^ Robert L. Brueck (2014). In the Rear View Mirror: Memories and Metaphysics. ISBN 978-1-5025-6904-2.