Software:System 2000

From HandWiki
Short description: Hierarchical database management software

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

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

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

  1. "SOFTWARE & SERVICES: SAS". Computerworld: p. 22. February 24, 1986. "Acquiring the System 2000 program gave SAS more “depth as a software company"" 
  2. 2.0 2.1 2.2 Mary Brandel (May 24, 2007). "The top 10 dead (or dying) computer skills". Computerworld. https://www.computerworld.com/article/2541481/the-top-10-dead--or-dying--computer-skills.html. 
  3. "System 2000 Essentials: Database Files". https://www.sfu.ca/sasdoc/sashtml/a2000/z1004785.htm. 
  4. 4.0 4.1 "SYSTEM 2000 Database Management Software". https://support.sas.com/resources/s2k/overview.html. 
  5. "Creating and Loading SYSTEM 2000 Databases". http://www.math.wpi.edu/saspdf/a2000/c06.pdf. 
  6. "SYSTEM 2000 Database Management Software". https://support.sas.com/resources/s2k/overview.html. 
  7. "What other oddball languages have you coded in?". October 3, 2008. https://ibmmainframes.com/about34850.html. "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?". https://www.ibm.com/docs/zosbasics/com.ibm.zos.zappldev/zappldev_111.htm. 
  12. "MRI Announces Autumn SYSTEM 2000 Class Schedule". Computerworld: p. 58. October 30, 1978. 
  13. "MRI Systems Corporation". https://www.researchgate.net/publication/220494296. 
  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. https://dl.acm.org/doi/abs/10.1109/MAHC.2009.105. 
  15. "Robert L. Brueck: Books, Biography". https://www.amazon.com/Robert-L.-Brueck/e/B01APSG24E%3Fref=dbs_a_mng_rwt_scns_share. "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.