HomePage | RecentChanges | Preferences

The Pick Multi-Value database has been around since the late 60's. The History of Multi-Value is interesting, diverse and also full of Colorful Characters. Pick and other Multi-Value databases have numerous monikers; Multi-Value, MV and Multi-dimensional are just a couple of them.

Wikipedia has a good overview article for those new to MV: [WikiPedia]

The following characteristics are common to most MV systems:

MV DBMS products traditionally run as a Virtual Machine over an operating system. In addition to other connectivity methods, many users can connect to these environments using Terminal Emulators like Accuterm, Winnix or Wintegrate. These terminal emulators can host graphical interfaces and provide other capabilities that integrate server and client.

For those who are interested in some of the more technical details of Pick and the Pick Data Structure should review some of the links found at the bottom of this page. There is a general Philosophy of Pick for those who just want some more general info.

A concerted effort is now taking place to create a formal definition of MV, led primarily by members of U2UG and the Oliver mailing lists.

A partial list of commercially available MV systems:

A partial list of Open Source and/or freebie MV systems

A very partial list of extinct (or nearly so) MV systems:

Other Notes

For a comparison of MV Databases, there is a fine paper by MIS Modular Information Systems @ http://www.utwo.co.za/MultiValueReviewWhitePaper.pdf
[former link to CDBMA] no longer valid.

A very good basic manual of PICK/BASIC can be found at: Jonathan E. Sisk's "Pick/BASIC: A Programmer's Guide": January, 2000 WWW Edition http://www.jes.com/pb/index.html

For an introduction to using the Pick Query Language, see "Getting Started in OpenQM" from http://www.rushflat.co.nz/downloads.shtml

IBM's white paper on comparing MV Architecture vs: "Normalized" DB structures can be found @: ftp://ftp.software.ibm.com/software/data/u2/pubs/whitepapers/nested_rdbms.pdf
[former link to CDBMA] no longer valid.

Search on Key words "[Nested Relational Databases]" pulls up a significant number of sites with good information for those interested in the subject.

A basic intro to the MV DBMS Model for someone more familiar with relational: http://www.nebula-rnd.com/products/mvdbms.htm

Notes / Discussion

HomePage | RecentChanges | Preferences
This page is read-only | View other revisions
Last edited August 20, 2009 8:20 am by Jacques Franken (diff)