Pickwiki - User contributions [en]

Main Page

2019-01-10T03:54:15Z

Dwolt: /* News */

{{#seo:
|title=PickWiki | Powered by Zumasys
|titlemode=replace
|description=The site is all about Pick/MultiValue databases and applications. PickWiki was created by Ian McGowan and is now managed by Zumasys.
}}

Welcome to the <big>'''PickWiki!'''</big> This site is about [[MultiValuedDatabases| Multivalue Databases]]. Learn more about the evolution of the [[Pick Operating System]].

== News ==

* 2019-01-09 [http://www.zumasys.com/contest The $10,000 MultiValue Idea Contest] is Open until the end of February 2019
* 2015-07-13 [http://www.zumasys.com/admin/zumasys-tincat-group-collaborate-to-update-the-multivalue-family-tree/ Zumasys & Tincat Group Collaborate to Update The MultiValue Family Tree]
* 2015-03-09 Management of pickwiki.com has been transitioned to [http://www.zumasys.com Zumasys] and the original UseMod Wiki platform has been migrated to MediaWiki
* 2015-01-15 [http://www.zumasys.com/admin/zumasys-acquires-jbase-database/ Zumasys acquires jBase!]

== About PickWiki ==
This wiki runs on MediaWiki and is currently managed by Zumasys.
* [[Special:Allpages| Index]] - All pages
* [[Special:RecentChanges| Recent Changes]]
* Information about the [[MoveToMediaWiki]]
* [[Special:ListUsers]] - As a registered user, you can create your own page and your updates will automatically link to it!

== Some useful starting points ==
* [[HistoryOfMV | Pick/MultiValue Turns 50 Years Old]]
* [[InMemoriam| In Memoriam]] - Remembering those who are no longer with us
* [[MultiValuedDatabases#Licensees | Pick Licensees]] - List of Pick Licensees
* [[MultiValuedDatabases| MultiValued Databases]] - Describes the database and its history
* [[Getting_Started|Getting Started]] with MultiValued Databases
* [[HowTos]] - Common issues and solutions, like creating web interfaces
* [[SourceCode| Source Code]] - Programming and technical articles

== Other resources==
* [[Blogs]] related to [[MultiValue]] software
* [[Community]] page includes links to [[employment]], [[UserGroups]] and forums to post questions
* [[Freeware]] - All free, mostly open source
* [[MultiValueConsultants| MultiValue Consultants]] - Need some help? Find the perfect person!
* [[MultiValueCompanies| MultiValue Companies]] - List of companies which use MultiValue databases

== Help ==

* [http://en.wikipedia.org/wiki/Help:Wiki_markup Text Formatting Rules]
* [http://www.mediawiki.org/wiki/Help:FAQ MediaWiki FAQ]

MultiValueCompanies

2016-08-02T17:40:36Z

Dwolt: Changed Datatel to their new name, Ellucian, and indicated that UniData is often middleware, rather than the DBMS

This page is (or will be) a list of companies which use or used [[MultiValue]] databases. If you work for a company which uses one or did, or know of other companies which use it or did, edit this page and add them here.

{| class="wikitable"
|-
! Company / Link
! Product Name
! Purpose
! Database
! Location
! Type
|-
| [http://www.adpdealerservices.com/ ADP, Dealer Services] || DMS, ADPDrive || Dealer Servicing || [[UniData]] || Hoffman Estates, IL || Customer
|-
| [http://www.linkedin.com/companies/ultradata Ultradata] || <nowiki>UltraFIS</nowiki> || Credit Union Core Systems || [[UniData]] / [[UniVerse]] || Pleasanton, CA || Vendor
|-
| [http://www.idsgrp.com International Decision Systems] || Infolease || Leasing System || [[UniData]] || Mineapolis, MN || Vendor
|-
| [http://www.botw.com Bank of the West] || Infolease || Leasing System || [[UniData]] || San Francisco, CA || Customer
|-
| [http://www.mbms.net Medical Billing & Management Services] || Inhouse,MITS || Physician Billing || Universe || Newark, DE || Developer-Customer
|-
| [http://www.onderdelenlijn.nl autonet] || automate, onderdelenlijn || car dismantlers automation || D3 || Dordrecht, NL || Vendor
|-
| [http://www.ellucian.com Ellucian] || Colleague || Higher Education administration || UniData (also as middleware with SQL Server and Oracle) || Fairfax, VA || Vendor
|}

----

Also visit the [http://www.mvcommunitymap.com [[MultiValue]] Community Map] website.

We have taken our database of multivalue users and vendors and have begun
mapping them using Google Maps and eventually Google Earth. Our goal, albeit
a lofty one, is to eventually map 80%-90% of the user community world wide.

We believe that this tool can be a very valuable contribution to the
mvCommunity. End-Users can use it to view resources available (Developers,
Consultants or Vendors) in their area. Vendors can use it to demonstrate
the strength and diversity of the mvCommunity, locally and globally, in
their sales endeavors.

<nowiki>To make this the powerful tool that I know it can be, we need the help of
the community. We are asking for everyone's help in identifying as many of
the multivalue End Users, Vendors and Software products as possible. Send us
the name of your employer, your past employers, MV Vendors, the applications
that you've worked with, the MV Tools that you've used and of course, your
name. We want to map all things multivalue. To contribute, you can use the
contact us page, or email your contributions to info@mvcommunitymap.com.
Contributions should contain at a minimum the Company Name or Developers
Name, City, State or Zip/Postal Code and Country. If a product, Product
Name, Vendor Name and Zip/Postal Code & Country.</nowiki>

All information received will be kept confidential but we will contact
companies and individuals to confirm their current multivalue status.

----

(TG) While it would be nice to create a real Who's Who list of companies here, to reaffirm that this platform is in good use, my guess is that there won't be many companies listed here. Most companies simply don't want to publish the names of their databases, application vendors, or other details of their IT infrastructure. For some it's a security issue. For most there's simply no benefit and it may invite solicitations ... or worse. If this page only has a handful of companies, when we know there are thousands of systems out there, I think it might do more harm than good in the big picture. I think a proper effort would need to be made by the DBMS companies, to get voluntary listings from their customers, and then for the sum of all of that effort to be posted here. But I don't think that will ever happen. That's just my view. Other opinions are welcome.

Blogs

2015-08-01T13:32:16Z

Dwolt: removed the SnupNow blog entry

* Brian's [[MultiValue]] blog, by Brian Leach, at http://mvdeveloper.blogspot.com/
* Neblog, by Tony Gravagno, at http://nebula-rnd.com/blog/
* Tincat Mewsings, 2006 blog starting with Is Codd Dead? entry, by Dawn Wolthuis at http://tincat-group.com/mewsings/2006/01/is-codd-dead.html
* International Spectrum Blog : http://blog.intl-spectrum.com/
* Kevin King at Precision Solutions uses his forum as a blog : http://www.precisonline.com/forum/index.php
* U2 Tech Blog: http://u2tech.wordpress.com/
* Gregor's UV space: http://gdoesu2.wordpress.com/
* Manny Neira's Universe page: http://www.mannyneira.com/universe/
* Tom Packert's Articles: http://www.mindspring.com/~tpackert/Articles.htm

HistoryOfMV

2015-07-27T00:07:13Z

Dwolt: /* Other Resources */ Added tincat-group historical resources related to MultiValue

==Pick / MultiValue Turns 50 Years Old==

50 years ago in 1965, the origins of the PICK Operating System stemmed from a real-life application of computer technology: the design of a data management stores system, initially for the tracking of parts for rocket engines within the huge military contractor TRW Systems Inc., and later adopted and funded by the US Army to track the maintenance and repair of Cheyenne helicopters. The challenge of the project was that the system was to have an English-like retrieval language which could be used on a computer which had not yet been specified.

The system was being developed by Don Nelson and was initially titled Parts Acquisition Data System (PADS). Richard (Dick) Pick, for whom the operating system was named, was hired in 1965 specifically to work with Nelson on the project. In the course of its somewhat complex evolution, the first spec was called Generalized Information Retrieval Language and System (GIRLS). Later yet, the project was re-named General Information Management (GIM). It was then dubbed by the Army, which took over the funding of the project to develop a system to support the Cheyenne helicopter, Integrated Technical Data System or ITDS. The software was delivered to the Army in 1969 and implemented on an IBM mainframe. In that year the Army said in a published report that GIM (or ITDS) was "by far the finest generalized information management system in the country."

No real commercial use was made of GIM which enabled Dick Pick to continue to research his own work, deemed to be public domain because it had been developed under the auspices of the US Department of Defense, once the project was completed. Dick Pick's development continued while he was working for General Analytics Corporation where he was ensconced for a short period beginning in May 1969. The previously named GIM or ITDS became known as Reactive Information System, RIS. It was while Dick Pick was with General Analytics Corporation that RIS was first ported to a minicomputer, the Microdata 800 CPU.
General Analytics filed for bankruptcy in 1970 and Dick Pick continued to independently work on the molding of RIS to the Microdata 800. He now called the system ACCESS.

In June 1972, Dick Pick founded Richard Pick and Associates and continued his efforts, switching from the Microdata 800 to the Microdata 1600 and naming the overall system—comprising ACCESS software, firmware and the Microdata—"DM 512".

It is important to note here, that its origins as a database operating system designed specifically to run application software and designed for computer users, as opposed to computer technicians and programmers, is intrinsic to the nature and future success of PICK. Because it meets a need for simplicity of use, provides good online response and report writing features, users find PICK a truly useful system, particularly in multiuser database applications; because its rapid systems development facilities enable the easy tailoring of online, realtime software packages, manufacturers and software houses find PICK affords them a distinct advantage when pursuing vertical markets.

The first commercial step in the growth of PICK was the implementation on Microdata (now McDonnell Douglas Computer Systems Company; the name change occurred in late 1984 when McDonnell Douglas acquired Microdata) minicomputers. This occurred when Dick Pick entered into an agreement with Microdata to implement his software concepts on its computers and in 1974, when Microdata was given marketing rights, DM 512 was once again re-named, this time by Microdata. The system was called REALITY and the retrieval language, English. From 1970 to 1978 PICK was virtually the exclusive property of Microdata. During this period Microdata marketed its new product by appointing dealers throughout the world, achieving a moderate amount of success.

Contrary to popular opinion—and according to an interview (Datastream magazine, October 1981) with Ken Simms who worked with Dick Pick on pioneering the PICK Operating System—in 1975 Pick became an unsalaried employed of Microdata. Simms said: "Nobody at Pick and Associates was ever a real employee of Microdata. At one time, some of us were employees for $1.00 a year, which was to get certain company benefits. Dick Pick became head of REALITY development and the Microdata programmers who worked on REALITY actually worked at Pick and Associates offices on Skypark Circle."

Then, in the late 70's, following a dispute with management, Dick Pick split with Microdata and intended to market the system to a broader reaching base on his own. A lawsuit over the rights to the system followed and can be cited as one of the reasons the PICK Operating System remained, and has been frequently touted "the best kept secret in the computer world". The lawsuit was finally settled out of court in 1981.

Microdata retained the exclusive rights to REALITY and its development on Microdata hardware and Pick and Associates had the rights to develop PICK and to port it onto other computer systems. Thus, this small company, Pick and Associates, was the only willing source of supply to enable the operating system to be implemented on other manufacturers' machines.

Adding further to the relative inconspicuousness—at the time—of PICK as a powerful operating environment was the tendency of those few vendors who did license PICK to call it by a proprietary name—for example: Zebra from General Automation, Mentor from [[AppliedDigitalDataSystems | Applied Digital Data Systems (ADDS/NCR)]] and Ultimate from The Ultimate Corp.

Pick and Associates' early licensing policy was also a deterrent to rapid and full-scale porting of PICK by manufacturers, a factor which changed in 1984. Prior to this, a license reputedly cost $1 million or more, and each license agreement was structured differently in its terms and fees. The new policy established in 1984 set a consistent one-time fee of $50,000 per licensee and a royalty of $50 per user.

Following Dick Pick's departure from Microdata, Pick and Associates began to import the 8-bit minicomputer, Multi-6, from Intertechnique (now called IN2), the French company which had previously been contracted (in Dick Pick's Microdata days) to manufacture and supply a firmware board which was integral to the REALITY Operating System. The Multi-6 was based upon the Microdata 1600 CPU.

The PICK Operating System was implemented on Intertechnique hardware by Dick Pick and marketed in the US as the Evolution system. In Europe, the system was marketed by Intertechnique until 1984. Microdata, in the meantime, introduced Release 3 of the REALITY Operating System on new firmware, with improved memory capacity and additional firmware coded routines.

During Pick and Associates' period of involvement with Evolution, PICK was ported to Honeywell (now Bull HN Worldwide Information Systems) Level 6 minicomputers for The Ultimate Corp. This was the first port of PICK to a non-Microdata machine—the Intertechnique machine was, at the time, an exact hardware copy of the Microdata machine, running the same firmware and same software. So, the first PICK port is considered to be the Honeywell Ultimate system.

The Honeywell system marked a turning point for PICK—for the first time PICK was running on a well-known computer; it could run more terminals and handle larger applications than previously and thus proved to be a highly successful venture. It was a move which proved instrumental in encouraging other hardware manufacturers to offer PICK on their own systems. The Honeywell Ultimate port was closely followed by the second porting, to the ADDS Mentor machine.

Success of the PICK Operating System, although only moderate, was sufficient to engender PICK look-alikes to emerge around 1977-78. Seattle-based Devcom formed by Rod Burns and John Drumheller with the aim of producing a compatible replacement for the Microdata systems and financed by a number of disillusioned Microdata customers, produced what would eventually become INFORMATION running on the Prime 50 series of computers.

Devcom, lacking the expertise to successfully market its implementation, and recognizing its fallibility in this area, invited Jim Whelan to join the operation as principal of the company. He convinced Prime to buy the product. The marketing rights to INFORMATION were sold to Prime in 1979 and Devcom was completely bought out in 1982.

In 1981 the first implementation on IBM equipment began on the Series 1. Shortly after, Pick and Associates adopted the name by which it is known today—Pick Systems. From here on, implementations began in earnest and 1982 saw the beginning of new ports on equipment from Altos, Systems Management Inc. (SMI) on the IBM 4300, Datamedia, General Automation and the Pertec Computer Corporation.

In the meantime, the next chapter in the story of the PICK Operating System was unfolding. Dick Pick, deciding to concentrate his efforts on the operating system development rather than hardware marketing, sold his holding in Pick and Associates, and with that, the rights to the Evolution computer (he continued however, to retain a majority interest in Pick and Associates; the sale of his holding in the operation related only to the Evolution system). Evolution Computer Corporation was founded in February 1980 to continue marketing the Evolution system.

Dick Pick was quoted in an interview in the now defunct Datastream magazine outlining his reasons for selling Evolution: "I sold Evolution because it doesn't seem to make much sense for us to be directly in the hardware business, since we license so many people on the software for them to sell the hardware. It is incongruous for us to be competing with licensees so we made a decision to get completely out of the hardware and be the developers of the basic system."

In the March 1980 REALITY Users News newsletter, the event was reported thus under the headline "PICK GETS OUT OF MANUFACTURING": "Pick and Associates has entered into an agreement under which it has sold its manufacturing, timesharing and service operations. This will allow founder and developer of the PICK Operating System, Richard Pick, to devote his time to the development of enhancements to his system and to the development of other systems.

===Other Resources===

* [[JesHistory]] - A condensed view according to [[JonSisk]]
* http://en.wikipedia.org/wiki/Pick_operating_system
* http://www.microdata-alumni.org/historical.htm
* [[KenSimms|An Incomplete History of Pick/BASIC]] by Gregory M. Amov and M. Denis Hill
* http://www.tincat-group.com/mv - Includes the MultiValue Family Tree and Nelson-Pick papers

ONware

2015-07-26T23:58:34Z

Dwolt: Started initial page for ONware

ONware includes the MVON MultiValue database that serves as middleware in many solutions that include Data/BASIC along with an RDBMS such as Oracle or SQL Server. Onware is distributed by Ongroup International.

http://www.ongroup.com

ONware products include

* [[MVON]] DBMS
* ONsync
* Blacksmith tools

MVON

2015-07-26T23:55:45Z

Dwolt: Added an initial page for MVON

MVON MultiValue database from [[ONgroup]] includes compatibility for [[Universe]], [[UniData]], [[D3]], PI/Open, and Power95, with TCL, Data/BASIC, the MultiValue query language (queryON), and the usual fare of feature familiar to MultiValue developers.

http://www.ongroup.com

Important features

* While data can be persisted directly in MVON, like [[jBASE]] and [[UniData]] this engine can serve as middleware so that Oracle and SQL Server are the most popular data storage DBMS tools for persisting the data
* [[ONware]] products such as ONsync can be used with UniData and Universe -- there is no need to switch your MultiValue database to make use of some ONware tools
* MVON can be used to move data to an open source database with the introduction of connectivity to PostgreSQL
* additional database adapters will be developed as requested. For example, when there is a case to be made for data storage in MongoDB or other NoSQL DBMS's, these will be written
* Blacksmith tools are part of the ONware catalog

MultiValuedDatabases

2015-07-26T23:41:35Z

Dwolt: Added MVON / ONware from ONgroup and ScarletDME, an open source fork of OpenQM

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

Wikipedia has a good overview article for those new to MV: [http://en.wikipedia.org/wiki/Pick_operating_system Wikipedia - Pick Operating System]

The following characteristics are common to most MV systems:
*A [[HashingFileSystem]] (as a minimum - newer systems have many different types of files)
*Dictionaries that describe the record layout, but do not constrain the data
*Records with fixed primary keys, delimited by [[AttributeMarks]]
*Records can be extended on the fly
*[[MultiValued]] fields within the records, traditionally seperated by [[ValueMarks]]
*A Basic programming language that understands files, dictionaries and records
*A query language, that deals with multivalued data structures

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 [[TerminalEmulators|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 [[PickDataStructure|Pick Data Structure]] should review some of the links found at the bottom of this page. There is a general [[PhilosophyOfPick| Philosophy of Pick]] for those who just want some more general info.

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

== A partial list of commercially available MV systems: ==

*[[Cache|Caché]]
*[[D3]]
*[[jBase | jBASE]]
*[[mvBase]]
*[[MVON]] / [[ONware]]
*[[OpenInsight]]
*[[OpenQM | OpenQM]] / [[QM | QM]]
*[[Reality]]
*[[UniData]]
*[[UniVerse]]
*[[UniVision]]

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

*Bart
*[[MaVerick]]
*[[OpenQM]]
*Winter
*ScarletDME

== Licensees ==

*[[AppliedDigitalDataSystems | ADDS Mentor]]
*Advanced Pick
*Advanced Revelation
*[[Altos]]
*[[Archford | Archford Computers International]]
*[[C-Itoh]]
*CDI ??
*[[Climax]]
*Datamedia
*[[Edgcore | Edgcore Technology]]
*[[ElectroniqueSergeDassault | Electronique Serge Dassault]]
*[[Fujitsu]]
*[[IBCTechnologies | IBC Technologies, Inc.]]
*ICL Clan
*[[IN2]]
*mvEnterprise (nearly so)
*Siemens-Nixdorf
*Pertec
*Power95
*[[PrimeInformation|Prime Information]]
*R83
*[[Rexon | Rexon Business Machines]]
*Sanyo[[/ICON]]
*TAU ??
*[[Ultimate]]
*[[UltPlus]]
*Wicat

== 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 <br>
[http://www.cdbma.org/library/MultiValue_Review_White_Paper.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 <br>
[http://www.cdbma.org/presentations/nested_rdbms.pdf former link to CDBMA] no longer valid.

Search on Key words "[http://www.google.com/search?num=100&q=Nested+Relational+Databases 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 ==
* [TG] Would be nice if someone helped owner of [http://conceptoriented.org/faqs/com-related-faq.html this site] to correct his MV-related links.
* [TG] Can we host the linked PDF files here so that they don't disappear anymore?

Dawn Wolthuis

2009-01-22T23:36:47Z

Dwolt: *

I have an blog containing articles about database theory and practice that starts at http://tincat-group.com/mewsings/2006/01/is-codd-dead.html

And a 2009 blog where I will be documenting my current project as it unfolds, found at http://snupnow.wordpress.com/

I am writing new software using InterSystems Cache', the most recent major implementation of MultiValue. Feel free to email me at dwolt at tincat-group.com to ask any questions about our use of Cache'. I previously worked with UniData.