Pick operating system#Prime INFORMATION
{{Short description|Business data processing operating system released in 1965}}
{{Infobox OS
| name = Pick operating system
| logo =
| screenshot =
| caption =
| developer = Don Nelson
Dick Pick
TRW
| source_model =
| kernel_type = Monolithic (or none for operating environment implementations)
| supported_platforms = Solaris, Linux, AIX, Windows Server (2000 and up)
| ui = Text-based
| family =
| released = 1965 (GIRLS), 1973 (Reality Operating System)
| latest_release_version =
| latest_release_date =
| latest_test_version =
| latest_test_date =
| marketing_target = Business data processing
| programmed_in = Assembly language
| prog_language = Data/BASIC (BASIC-like), PROC procedure language, ENGLISH
| language = English
| updatemodel =
| package_manager =
| working_state =
| license = Proprietary
| website =
}}
The Pick Operating System, also known as the Pick System or simply Pick,{{cite journal |title=The pick operating system – a Practical Guide |journal=Proceedings of the IEEE |volume=77 |issue=2 |pages=363 |last1=Ramming |first1=D |last2=Bourdon |first2=Roger J. |date=1989|doi=10.1109/JPROC.1989.1203777 |s2cid=9328922 }} is a demand-paged, multi-user, virtual memory, time-sharing computer operating system based around a MultiValue database. Pick is used primarily for business data processing. It is named after one of its developers, Dick Pick.{{Cite web |last=Woodyard |first=Chris |date=1994-10-19 |title=Software Developer Dick Pick Dies at 56 |url=https://www.latimes.com/archives/la-xpm-1994-10-19-me-52018-story.html |access-date=2023-06-17 |website=Los Angeles Times |language=en-US |archive-date=2023-03-15 |archive-url=https://web.archive.org/web/20230315113106/https://www.latimes.com/archives/la-xpm-1994-10-19-me-52018-story.html |url-status=live }}
The term "Pick system" has also come to be used as the general name of all operating environments which employ this multivalued database and have some implementation of Pick/BASIC and ENGLISH/Access queries. Although Pick started on a variety of minicomputers, the system and its various implementations eventually spread to a large assortment of microcomputers, personal computers,{{cite magazine|date=July 27, 1987|title=PICK Operating System – brings Mainframe Power to your PC|url=https://books.google.com/books?id=6DsEAAAAMBAJ|magazine=InfoWorld|page=80}} and mainframe computers.
Overview
The Pick Operating System is an integrated computing platform with a database, query and procedural operation languages, peripheral and multi-user management, and BASIC programming capabilities. Its database utilizes a hash-file system, enabling efficient data storage and retrieval by organizing data into dynamic associative arrays managed by associative files.
Data within the Pick system is organized into a hierarchical structure of accounts, dictionaries, files, and sub-files based on a hash-table model with linear probing. This structure comprises variable-length records, fields, and sub-fields, with unique naming conventions that reflect its multivalued database characteristics. Records are identified by unique keys that facilitate direct access to their storage locations.
Initially constrained by the era's technological limitations, the Pick system's capacity has expanded over time, removing earlier record-size limits and introducing dynamic file allocation and B-tree indexing to enhance data management capabilities.
The Pick database operates without explicit data types, treating all data as character strings, which places the onus of data integrity on the applications developed for the system. This flexibility allows Pick to store data in non-first-normal-form, avoiding the need for join operations by containing all related data within single records. This approach can optimize storage and retrieval efficiency for specific kinds of datasets.
History
Pick was originally implemented as the Generalized Information Retrieval Language System (GIRLS) on an IBM System/360 in 1965 by Don Nelson and Dick Pick at TRW, whose government contract for the Cheyenne Helicopter project required developing a database.{{cite web |url=http://www.jes.com/cdp/cdp_faqx.html |title=General Overview of Classic Pick – a short history |date=1995 |access-date=2017-09-27 |archive-date=2018-08-08 |archive-url=https://web.archive.org/web/20180808233754/http://www.jes.com/cdp/cdp_faqx.html |url-status=live }} It was supposed to be used by the U.S. Army to control the inventory of Cheyenne helicopter parts.{{cite web |author1=Nelson |first=Donald B. |date=March 19, 1965 |title=Generalized Information Retrieval Language and System (GIRLS) User Requirements Specification |url=http://www.tincat-group.com/mv/Nelson-GIRLS-1965.html |access-date=February 6, 2015 |archive-date=March 5, 2016 |archive-url=https://web.archive.org/web/20160305003745/http://www.tincat-group.com/mv/Nelson-GIRLS-1965.html |url-status=live }}
Pick was subsequently commercially released in 1973 by Microdata Corporation (and its British distributor CMC) as the Reality Operating System now supplied by Northgate Information Solutions.{{cite book|author=Elleray |first=Dick |date=July 16, 1986 |title=Project Management Bulletin 1986/09 – "The Reality Operating System Revealed |version=1986/09 |publisher=Project Management Group, McDonnell Douglas Informations Systems Group}} McDonnell Douglas bought Microdata in 1981.
The first Microdata implementation, called the Reality, came only with a procedural language (PROC), and a query language (ENGLISH). In 1975, Ken Simms of Pick Systems created an implementation of Dartmouth BASIC for the Reality, with numerous syntax extensions for smart terminal interface and database operations, and it was called Data/BASIC. At or near the same time, SMI of Chicago, created an extended procedural language and called it RPL.
PROC, the procedure language was provided for executing scripts. A SQL-style language called ENGLISH allowed database retrieval and reporting, but not updates (although later, the ENGLISH command "REFORMAT" allowed updates on a batch basis). ENGLISH did not fully allow manipulating the 3-dimensional multivalued structure of data records. Nor did it directly provide common relational capabilities such as joins. This was because powerful data dictionary redefinitions for a field allowed joins via the execution of a calculated lookup in another file. The system included a spooler. A simple text editor for file-system records was provided, but the editor was only suitable{{Cite web|url=https://jonsisk.com/downloads_1|title=Jonathan E. Sisk's Pick/BASIC: A Programmer's Guide|website=jonsisk.com|access-date=2023-03-04|archive-date=2023-03-04|archive-url=https://web.archive.org/web/20230304155804/https://jonsisk.com/downloads_1|url-status=live}} for system maintenance, and could not lock records, so most applications were written with the other tools such as Batch, RPL, or the BASIC language so as to ensure data validation and allow record locking.
By the early 1980s observers saw the Pick Operating System as a strong competitor to Unix.{{cite news |author=Fiedler, Ryan |date=October 1983 |title=The Unix Tutorial / Part 3: Unix in the Microcomputer Marketplace |pages=132 |work=BYTE |url=https://archive.org/stream/byte-magazine-1983-10/1983_10_BYTE_08-10_UNIX#page/n133/mode/2up |access-date=January 30, 2015}} BYTE in 1984 stated that "Pick is simple and powerful, and it seems to be efficient and reliable, too ... because it works well as a multiuser system, it's probably the most cost-effective way to use an XT".{{cite news |author=Rochkind, Marc J. |date=Fall 1985 |title=Pick, Coherent, and THEOS |pages=231 |work=BYTE |url=https://archive.org/stream/byte-magazine-1985-11/1985_11_BYTE_10-11_Inside_the_IBM_PCs#page/n233/mode/2up |access-date=March 19, 2016}} Dick Pick founded Pick & Associates, later renamed Pick Systems, then Raining Data, then ({{as of | 2011 | lc = on}}) TigerLogic, and finally Rocket Software. He licensed "Pick" to a large variety of manufacturers and vendors who have produced different "flavors" of Pick. The database flavors sold by TigerLogic were D3, mvBase, and mv Enterprise. Those previously sold by IBM under the "U2" umbrella are known as UniData and UniVerse. Rocket Software purchased IBM's U2 family of products in 2010 and Tiger Logic's D3 and mvBase family of products in 2014. In 2021, Rocket acquired OpenQM and jBASE as well.
Dick Pick died at age 56 due to stroke complications in October 1994.{{Cite web |last=Johnson |first=Will |title=Richard A "Dick" Pick (d. 19 Oct 1994) |url=http://www.countyhistorian.com/knol/4hmquk6fx4gu-596-richard-a-dick-pick-d-19-oct-1994.html |website=www.countyhistorian.com |access-date=27 September 2017 |archive-date=27 September 2017 |archive-url=https://web.archive.org/web/20170927202550/http://www.countyhistorian.com/knol/4hmquk6fx4gu-596-richard-a-dick-pick-d-19-oct-1994.html |url-status=live }}{{cite news |author=Woodyard |first=Chris |date=October 19, 1994 |title=Software Developer Dick Pick Died at 56 |newspaper=The Los Angeles Times |url=https://www.latimes.com/archives/la-xpm-1994-10-19-me-52018-story.html |access-date=November 13, 2022 |archive-date=October 12, 2018 |archive-url=https://web.archive.org/web/20181012065731/http://articles.latimes.com/1994-10-19/local/me-52018_1_database-management-system |url-status=live }}
Pick Systems often became tangled in licensing litigation, and devoted relatively little effort to marketing{{cite news |author=Lazzareschi |first=Carla |date=November 3, 1985 |title=Computer Wiz Tries Harder to Get Users to Pick His System |newspaper=The Los Angeles Times |url=https://www.latimes.com/archives/la-xpm-1985-11-03-fi-4222-story.html |access-date=November 13, 2022 |archive-date=September 28, 2017 |archive-url=https://web.archive.org/web/20170928005606/http://articles.latimes.com/1985-11-03/business/fi-4222_1_computer |url-status=live }}"Pick's lack of marketing" and improving its software. Subsequent ports of Pick to other platforms generally offered the same tools and capabilities for many years, usually with relatively minor improvements and simply renamed (for example, Data/BASIC became Pick/BASIC and ENGLISH became ACCESS). Licensees often developed proprietary variations and enhancements; for example, Microdata created an input processor called ScreenPro.
See also
References
{{reflist}}
Bibliography
- The REALITY Pocket Guide; Jonathan E. Sisk; Irvine, CA; JES & Associates, Inc.; 1981 {{OCLC|216178915}}
- [https://www.dropbox.com/s/qtb2m5io54no31g/The%20PICK%20Pocket%20Guide%20by%20Jonathan%20E.%20Sisk%205th%20ed%201989.pdf?dl=0 The PICK Pocket Guide, 5th edition]; Jonathan E. Sisk; Irvine, CA; Pick Systems; 1982
- [https://www.dropbox.com/s/f3eopjbsfolxlmi/Exploring%20the%20PICK%20Operating%20System%202nd%20Edition%20by%20Jonathan%20E%20Sisk%20and%20Steve%20VanArsdale.pdf?dl=0 Exploring The Pick Operating System, 2nd Edition]; Jonathan E. Sisk; Steve VanArsdale; Hasbrouck Heights, N.J.; Hayden Book Co. 1985. {{OCLC|12967951}}
- {{cite book |last=Taylor |first=Martin |date=1985 |title=Pick For Users |publisher=Blackwell Scientific Publications |isbn=0-632-01492-X }}
- [https://www.dropbox.com/s/qtb2m5io54no31g/The%20PICK%20Pocket%20Guide%20by%20Jonathan%20E.%20Sisk%205th%20ed%201989.pdf?dl=0 The Pick Pocket Guide, 5th Edition]; Jonathan E. Sisk; Desk reference ed; Hasbrouck Heights, N.J.; Hayden Book Co. 1985. {{OCLC|18872552}}
- [https://www.dropbox.com/s/8p9ad0baauvvtll/The%20PICK%20Perspective%20by%20Ian%20Sandler.pdf?dl=0 The Pick Perspective]; Ian Jeffrey Sandler; Blue Ridge Summit, PA; TAB Professional and Reference Books; 1989. {{OCLC|18521562}} Part of The Pick Library Series, Edited by Jonathan E. Sisk
- [https://www.dropbox.com/s/fioktf7k5hfigvl/PICK%20for%20Professionals%20Advanced%20Methods%20and%20Techniques%20by%20Harvey%20E%20Rodstein.pdf?dl=0 Pick for Professionals : Advanced Methods and Techniques]; Harvey Rodstein; Blue Ridge Summit, PA; TAB Professional and Reference Books; 1990. {{OCLC|20452708}} Part of The Pick Library Series, Edited by Jonathan E. Sisk
- [https://www.dropbox.com/s/kmpm1eq82ehj6ze/Encyclopedia%20Pick%201st%20edition%20Oct%201992.pdf?dl=0 Encyclopedia PICK (EPICK)]; Jonathan E. Sisk; Irvine, CA; Pick Systems; 1992 {{OCLC|28725247}}
- Le Système d'exploitation PICK; Malcolm Bull; Paris: Masson, 1989. {{OCLC|21247561}}
- The Pick operating system; Joseph St John Bate; Mike Wyatt; New York : Van Nostrand Reinhold, 1986. {{OCLC|14904780}}
- The Pick operating system; Malcolm Bull; London; New York : Chapman and Hall, 1987. {{OCLC|13666782}}
- Systeme pick; Patrick Roussel, Pierre Redoin, Michel Martin; Paris: CEdi Test, 1988. {{OCLC|19546897}}
- [https://www.dropbox.com/s/gvo36yj3ra7w36u/Advanced%20PICK%20%26%20UNIX%20-%20Bruno%20Beninca.pdf?dl=0 Advanced PICK et UNIX : la nouvelle norme informatique]; Bruno Beninca; Aulnay-sous-Bois, Seine-Saint-Denis; Relais Informatique International, 1990. {{OCLC|23242884}}
- Le systeme PICK : mode d'emploi d'un nouveau standard informatique; Michel Lallement, Jeanne-Françoise Beltzer; Aulnay-sous-Bois, Seine-Saint-Denis; Relais Informatique International, 1987. {{OCLC|20877971}}
- The Pick operating system : a practical guide; Roger J Bourdon; Wokingham, England; Reading, Mass. : Addison-Wesley, 1987. {{OCLC| 13945808}}
- Le Système d'éxploitation : réalités et perspectives; Bernard de Coux; Paris : Afnor, 1988. {{OCLC|20078135}}
- [https://www.dropbox.com/s/nbxn55yu7yt44g1/PICK%20BASIC%20A%20Programmers%20Guide%20by%20Jonathan%20E%20Sisk%201st%20ed%201987.pdf?dl=0 Pick BASIC : A Programmer's Guide]; Jonathan E Sisk;Blue Ridge Summit, PA : TAB Professional and Reference Books, 1987. {{OCLC|16355134}} Part of The Pick Library Series, Edited by Jonathan E. Sisk
- Pick BASIC : a reference guide; Linda Mui; Sebastopol, CA : O'Reilly & Associates, 1990. {{OCLC|22147353}}
- [https://www.dropbox.com/s/20sc0oapbubyymt/Programming%20with%20IBM%20PC%20BASIC%20and%20the%20PICK%20Database%20System%20by%20David%20L%20Clark.pdf?dl=0 Programming with IBM PC Basic and the Pick database system]; Blue Ridge Summit, PA : TAB Books, 1990. {{OCLC|19723037}} Part of The Pick Library Series, Edited by Jonathan E. Sisk
- An overview of PICK system;Shailesh Kamat; 1993. {{OCLC|29287280}}
- {{cite book |last1=Taylor |first1=Martin |last2=Rees |first2=Stuart |date=1995 |title=Unix and Unidata |publisher=Datamatters |isbn=1-900176-00-9 }}
- Pick: A Multilingual Operating System; Charles M. Somerville; Computer Language Magazine, May 1987, p. 34.
- [https://www.dropbox.com/s/jsvkonswwxvcon4/EPICK%20Encyclopedia%20Pick%20%28c%29%201993%20by%20PICK%20Systems.pdf?dl=0 Encyclopedia Pick (EPICK)]; Jonathan E. Sisk; Pick Systems, 1993
External links
- [http://jes.com/gfx/people/csn_1983_11_28_antigrav_dick_001.jpg Photo of Dick Pick in his anti-gravity boots on the cover of Computer Systems News, 1983.]
- [http://www.mannyneira.com/universe Life the Universe and Everything]: introduction to and online training course in Universe developed by Pick software engineer Manny Neira.
- [https://www.youtube.com/watch?v=6ms0yvJAUAk Video]: "History of the PICK System" made in 1990
- [https://www.multivalue-world.com/documents Pick Publications Database]
- [https://www.youtube.com/watch?v=9Sz3MDl1XRw 1987 Interview with Dick Pick in the Pick Pavilion at COMDEX]
- [https://www.youtube.com/watch?v=VGNRReaQ0Og 1990 Interview with Dick Pick in the Pick Pavilion at COMDEX]
- [https://www.youtube.com/watch?v=mHlRJCrxI-g 1990 Interview with Jonathan Sisk in the Pick Pavilion at COMDEX]
- [https://www.youtube.com/watch?v=CFpK8440HZA&t=83s 1991 Pick Rap Show at COMDEX, co-written by Jonathan Sisk and John Treankler]
- [https://www.youtube.com/watch?v=iSB6ozApdX4 1992 Video of Dick and Zion Pick, who appeared in the Ross Perot campaign rally - includes entire unedited Perot speech]
- [https://seeinggreen.typepad.com/my_weblog/2020/10/the-poet-the-physicist-and-the-immigrant.html An insightful early history of the Pick System, by Chandru Murthi, who was there at the time]
- [https://books.google.com/books?id=9eJxx_ZGKngC&pg=PA321 1984 PC Magazine article "Choosing the Pick of the Litter", by Jonathan E. Sisk and Steve VanArsdale]
- [https://books.google.com/books?id=PfrdbIUydyoC&dq=pick/basic&pg=PA59 Database Management Approach to Operating Systems Development, by Richard A. Pick Chapter 5 of New Directions for Database Systems, Gad Ariav, James Clifford editors]
- [https://www.computerhistory.org/revolution/minicomputers/11/367 Doing More With Less Hardware, Computer History Museum piece on Pick]
{{Time-sharing operating systems}}
{{DEFAULTSORT:Pick Operating System}}
Category:Proprietary database management systems
Category:Proprietary operating systems
Category:Assembly language software
Category:Time-sharing operating systems