IBM SQL/DS

From Wikipedia, the free encyclopedia
  (Redirected from SQL/DS)
Jump to navigation Jump to search

SQL/DS (Structured Query Language/Data System), released in 1981, was IBM's first commercial relational-database management system.[1] It implemented the SQL database-query language.

SQL/DS ran on the DOS/VSE and VM/CMS operating systems. A little later, IBM also introduced DB2, another SQL-based DBMS, this one for the MVS operating system. The two products have coexisted since then; however, SQL/DS was rebranded as "DB2 for VM and VSE" in the late 1990s.

References[edit]

  1. ^ S. Sumathi, S. Esakkirajan (13 Feb 2007). Fundamentals of Relational Database Management Systems. Springer. ISBN 3540483977. The product was called SQL/DS (Structured Query Language/Data Store) and ran under the DOS/VSE operating system environment

I am Emil T. Cipolla; I was the lead planner at IBM Endicott NY in 1978 thru 1985, and prepared the marketing material for the first several releases of SQL / DS. From memory I can provide much of the history, and have most of the original IBM publicly available Announcement letters . How do I do proceed? Does any one care about the history?

Briefly, Ed (Ted) Codd at IBM San Jose Calif developed the relational model - System R, (as a prototype). One of the original test sites was Pratt & Whitney Aircraft. The language was Structured Query Language (aka SEQUEL) ; key developers included Chris Date and Don Chamberlain (and others -) who can provide more of the background of System R and SEQUEL.

At the time, the dominate data base was IBM's IMS DB, developed and by IBM Santa Theresa; it is a hierarchical data model,and the program had to know the detailed structure and relationship among the various records and sub records and fields - one 'navigated' thru the data base structure by providing specific detailed search parameters, and testing when sub -record segments were crossed. The significant 'beauty' of the relational model is that one simply could retrieve the desired data fields among various records (two dimensional tables) simply by asking for them, and specifying the relationship among them. The Relational Database program knew where these segments were stored, and provided them to the application. Programming under the relational model was an order of magnitude simpler than the hierarchical model

This article will not attempt to describe the Relational model (see other articles for Codd's rules and the relational model).

IBM Santa Theresa had little incentive to introduce a competitive data model to the high end main frame IMS DB/DC MVS market segment. IBM Endicott, under the Lab Development managers Jack Cook, Jerry Becker, Larry Whitney and the outstanding programming development team, was anxious to provide a simpler and easier to use data model for the mid-range customer set. They 'ownership' of the System R prototype code was transferred to Endicott in late 1978, which modified it to execute on the IBM mid-range operating systems and hardware.

The initial vision of SQL / DS was to be an on-line ad hoc data management query tool for simple small data sets - performance was not the primary design goal. However, the customer reaction was so positive, that capabilities were added to make SQL / DS a robust data base model.

My previous assignment in IBM was as a system engineer whose customer set was mid range operating systems. My role was to use my customer experience to develop a business case, forecast, price point, and the marketing program material for target customer set (the mid range DOS/VS and VM/CMS operating systems.

Shall I continue with this ?? Is the history of interest ?