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
The D3 DBMS embodies the best and most desired features for developers and users. It is simple in its structure but allows for complex definitions of data structures and program logic. The built-in development environment allows applications to be rapidly prototyped, developed, and modified on the spot. Custom applications and on-site enhancements are common in the D3 community. Everything required for development is already in D3, making D3 much more than a typical database environment. Site administration requires a fraction of the staff of other environments of the same size - a large proportion of sites running D3 do not have an IT staff.
D3 is developed and supported over the many environments indicated on these pages. All code and data easily migrates between environments without modification, so both developers and users can work on their platforms of choice.
Other products from TigerLogic include connectivity tools like FlashCONNECT for web, the D3 Class Libraries, the Open Systems File Interface for Oracle and other environments, and XML technologies to exchange data with other XML-compliant programs or environments.
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.
mv*Base for Windows is the database environment that offers the easiest high-performance path for MultiValue database developers and users to move their applications into a Windows Client/Server environment.
mv*Base is a multivalue-compliant Windows database environment which makes the migration of multivalue applications to a Windows client/server environment fast and easy. mv*Base offers a high-performance multi-dimensional database engine including such features as multi-valued field and unlimited item size providing maximum flexibility for data organization. B-tree indexing provides enhanced performance for sorting and selecting data from BASIC applications.
mvEnterprise offers the ease of use and hierarchical power of the multivalue database model, with the performance and flexibility of UNIX. The Open Data Architecture and UNIX interoperability tools provide a seamless interface between mvEnterprise and UNIX. mvEnterprise features many enhancements for high-performance, effective administration and compatibility with other multivalue environments, providing a near-seamless migration from R83, OA, Ultimate, PRIME, REALITY and others.
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.
Secure and Available 24 X 7
Tuned for business
The current economic climate demands more from your technology than ever before. While easy-to-use, high-performance solutions have always offered a faster return on investment, they may be a matter of survival today. And for businesses prepared to take advantage of changing times to position themselves for the future, they offer a competitive advantage.
UniData(r) comes into its own at times like these, delivering the capabilities you need to develop, enhance and deploy comprehensive business applications rapidly and with minimal cost.
UniData is an extended relational database ideal for embedding in vertical solutions. It allows multiple nested tables within a table, while maintaining support for ANSI SQL access. Data modeling is more intuitive and fewer tables are created compared with a traditional relational database.
Using UniData, developers can create solutions quickly and easily for a wide variety of markets. The product's real-world approach to application development and deployment minimizes time to market, which in turn saves you money and helps you compete more effectively.
Highlights
- Delivers low TCO and exceptional scalability to meet the challenges of on demand business in the SMB and large enterprise market
- Provides intuitive design and high-performance queries using extended relational data model
- Enables use of standard protocols including ODBC, OLEDB, ADO.NET, JDBC, XML and SOAP
- Supports security and robustness via encryption, authentication and high availability features
- Features native, high performance interfaces for .NET, Java(tm) and more
- Leverages application investment with flexible data storage
Reliable and Flexible Foundation for Business Solutions
Successful businesses continually push themselves to find ways to maximize their effectiveness and reduce costs. UniVerse maximizes return on investment and is built to keep costs low, delivering uncompromising reliability and power with the features that successful businesses need.
UniVerse offers a unique combination of an intuitive development environment and a powerful, reliable data engine. It is easy to embed in an application and delivers high-performance and high scalability in a small footprint. On top of that, it's very easy to use and administer.
Based on technology newer than the relational model, UniVerse uses XML-like data structures resulting in fewer tables, fewer joins and better performance.
Highlights
- Provides intuitive database design and high performance data access
- Secures data through encryption and authentication
- Ensures high availability through data replication
- Enables access via a variety of APIs, protocols, frameworks and architectures
- Provides flexible data storage choices for maximum interoperability
- Accelerates time to market and lowers TCO for business solutions
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.