Welcome Guest | My Membership | Login

MultiValue Databases

MultiValue Databases are a type of multidimensional database, typically considered synonymous with PICK, a database originally developed as the Pick operating system.

MultiValue databases differ from traditional relational database in that they have features that support and encourage the use of attributes having a list of values, rather than all attributes having a single value. They are often categorized with MUMPS within the category of post-relational databases, although the data model actually pre-dates the relational model.

Who Uses MultiValue Business Software?

Over 10 million people in companies around the world sign on to a MultiValue system every day when they arrive at work. MultiValue business software solutions are available for over 300 major industries and institutions. From the smallest company to companies with thousands of users.

Collectively, the sellers or MultiValue business solutions represent a $2 billion plus annual market in software alone and have a staggering three million strong user base worldwide which has accumulated over the past 25 years.

In the late 1990s, International Spectrum conducted a survey of over 500 active companies in the MV market. These companies were categorized as either a VAR, Software House, or Independent Consulting Firm.

The survey revealed that the average MultiValue VAR generates $4.71 million revenue in the market annually. The average MultiValue Software House reported $2.04 million annual revenue and the average MultiValue consultant generates $187K annually. Those doing the best are those who know both the web and legacy MultiValue applications.

International Spectrum currently is aware of over 400 active MultiValue VARs, 182 active MultiValue Software Houses and approximately 2,000 independent consultants. Based on the above survey, a simple linear extrapolation estimates the annual MultiValue market at $2.95 billion.

Find out more about MultiValiue Technologies and the MultiValue Symbol by clicking on the MultiValue Symbol.

InterSystems has enhanced the Caché database with MultiValue data access. Caché natively supports MultiValue data files and dictionaries, a MultiValue query language, MultiValue Basic, PROCs, and more.

Not only do MultiValue applications run on Caché, but the skills that built those applications can be used throughout the InterSystems technology stack. MultiValue developers can take advantage of:

  • Object syntax in MultiValue Basic
  • Seamless SQL and object projections of data
  • Web services
  • InterSystems Zen technology for building rich, interactive Web interfaces
  • Advanced security features
  • Browser-based system management
  • InterSystems DeepSee for embedded real-time business intelligence
  • InterSystems Ensemble for integration and work flow

Rocket D3 Database Management System is a powerful multidimensional database management systems that are the choice of thousands of application developers worldwide.

Powerful development environment designed for today's business critical transactional and analytical database applications, providing:

  • Scalability
  • Flexibility
  • Seamless interoperability
  • Connectivity
  • Low system management cost

A multidimensional database, a development environment including a development language, and a middleware component allowing other mainstream and standards-based products to communicate with the jBASE products. The unique jEDI middleware enables access to other databases such as Oracle, DB2 and SQL Server. Microsoft Windows, all major Unix platforms including Linux, and IBM's e-Servers are supported.


Rocket mvBase Database Management System is a powerful multidimensional database management systems that are the choice of thousands of application developers worldwide.

High-performance, multidimensional database engine with MuliValued fields, unlimited items sizes and maximum flexibility for data organization.


Rocket mvEnterprise is a powerful multidimensional database management systems that are the choice of thousands of application developers worldwide.

Combination of the easy-to-use and powerful hierarchical Rocket D3 Database Management System model with the performance and flexibility of UNIX.


ONware is software that opens the door to a wide variety of technology types, such as MultiValue, Object and Relational. ONware offers an API (Application Program Interface) that emulates U2, D3 and other MultiValue and Pick type environments. ONware includes a MultiValue environment that separates the application from dependency on a specific type of database system. The application is the application; the data is only data. ONware protects the integrity of the MultiValue application objects, allowing data to be stored in the database that best fits each organizations needs.


OpenInsight is a repository-based applications development environment that enables development teams to work collaboratively to design, develop, deploy and scale high-performance business solutions on leading messaging and client/server platforms. OpenInsight is a Windows-based application development environment that can reside on either Windows or Linux servers when used in conjuction with our network product Universal Driver 4.5. Arev32, Character to OpenInsight (CTO), the U2 Connector, WebOI and the Bravo Dashboard are all included in OpenInsight 9.0 Server Edition and above.


OpenQM is a high performance multivalue database environment with a low price tag and close compatibility with other products. Available for Windows, Linux, Mac, AIX and PDA, a commercial QM licence includes the AccuTerm terminal emulator at no extra cost. The QMClient API allows development of VB, C and web front ends.

OpenQM is the only multivalue database available both as a fully supported commercial product and in open source form under the General Public Licence.


A MultiValue and relational(SQL)-enabled database, it allows users to maximise the use of existing technologies while ensuring their customers needs are met, now and in the future. While maintaining its virtual machine concept, Reality now has open interfaces - using integrated ODBC/JDBC SQL, Web Services, HTML, TCP/IP Sockets and simple extensions to DataBasic - an extended Dartmouth BASIC language with exceptional database and string handling abilities. Remote calls can also be made in order to provide integration with open Java applications and Microsoft Visual Basic/C/C++/C# and .net.


Power and Performance without the Maintenance.

Deliver Even Better Availability, Interoperability and Security for Your Data.

UniData is an extended relational data server ideal for embedding in a variety of industry-focused solutions. Its extended relational model, with NoSQL access to data, is perfect for rapid cost-effective applications serving the needs of businesses from SMB to the enterprise where outstanding performance, reliability, scalability and manageability are needed.

Product Highlights:

  • Delivers low TCO and exceptional scalability to meet the challenges of on demand business in the SMB and large enterprise markets
  • Provides intuitive design and high-performance queries using an extended relational data model
  • Supports security and robustness via encryption, authentication and high availability features
  • Features native high-performance interfaces for .NET, Java and more
  • Includes U2 Dynamic Objects for easier exchange of data with web services

Emerging Technologies:

  • Data Type Enforcement provides an optional check on data written to a file in order to assure only valid data is stored.
  • Replication with External Database Access (EDA) can be used to replicate your data to a SQL database on the same server.
  • U2 MetaData Manager (U2 MDM), a user-friendly tool, quickly and easily builds and maintains mappingsfor your SQL tools accessing UniData.

Fast and Flexiblefor the Enterprise.

Modern data. Managed.

UniVerse is an extended relational data server optimized for embedding in vertical applications. UniVerse offers a nested relational (MultiValue) data model , with NoSQL access to data, means intuitive data modeling and fewer resulting tables.

Product Highlights:

  • Delivers high performance to business solutions through super-efficient database structures
  • Speeds your time to market while providing a lower total cost of ownership
  • Advanced management with audit logging and account-based licensing
  • Protects your data and provides around-the-clock availability to your enterprise application
  • Integrates easily with third party software and external data sources

Emerging Technology:

U2 MetaData Manager (U2MDM), a user-friendly tool, quickly and easily builds and maintains mappings for your SQL tools accessing UniVerse.


UniVision is an industry-leading DBMS integrating powerful, high-performance MultiValue database management and Client/Server technologies in a single product.

UniVision, a significantly enhanced Pick R83, AP and D3 compatible multi-user DBMS integrates powerful, high-performance MultiValue database management and Client/Server technologies in a single product.

It offers exceptional database engine flexibility combining unparalleled multi-user connectivity with superior price/performance, and ease of use in an open systems world with integrated SQL technology.


Hierarchical and multidimensional data management systems based on the Pick Universal Data Model (Pick UDM) built for critical business transactional and analytical applications. The choice of more than a thousand application developers worldwide, Pick databases offer flexibility, enterprise scalability, high-performance and cost efficient solutions.


Advanced Revelation is an award winning DOS development environment that is distinguished by unrivaled flexibility in application development and robust, multi-user data access. Advanced Revelation combines a powerful and flexible database management system with a suite of professional development tools including: forms designer, report writers, and a Basic compatible programming language.

Advanced Revelation is a complete relational database management system for PCs, LANs and client/server applications. Advanced Revelation provides the critical building blocks that ensure unrivaled flexibility in application development and robust multi-user data access. Advanced Revelation is fully programmable and scalable to handle even your most demanding application development needs. Advanced Revelation is the best database management system for your needs now and for years to come.


Mentor PRO is a portable, 32-bit protected mode database and native operating environment for Intel-compatible processors which supports up to 256 users. The integrated database environment makes it an ideal business application environment with many ease of use features. Mentor PROs BASIC compiler and run-time are optimized for the database application environment and offer the best performance available in a database environment of its kind. PicLan, included with Mentor PRO, expands the application environment to the network providing network connectivity as well as network file transfer and printer sharing.




Hierarchical and multidimensional data management systems based on the Pick Universal Data Model (Pick UDM) built for critical business transactional and analytical applications. The choice of more than a thousand application developers worldwide, Pick databases offer flexibility, enterprise scalability, high-performance and cost efficient solutions.



Return to top