Rocket UniData / UniVerse
activeby Rocket Software · since 1985 · also known as Rocket U2, UniVerse, UniData, U2, IBM U2
Rocket's Pick-style MultiValue databases, powering thousands of vertical business applications.
Overview
UniVerse and UniData are the two MultiValue (Pick-family) databases sold together as Rocket U2. Records are dynamic arrays whose fields can hold multiple values and sub-values, described by optional dictionaries, so one record can hold an order with all its lines; applications are written in a BASIC dialect with English-like query languages (RetrieVe/UniQuery) and an SQL layer. Rocket bought U2 from IBM in 2009 and keeps both lines current: UniVerse 14.2.1 shipped in November 2025 with an optional recoverable file system, and UniData 8.3.2 in 2024. Expect to find them inside long-lived ERP, healthcare, banking and distribution packages rather than in new builds.
Strengths & trade-offs
Strengths
- +Nested multi-value records model orders, invoices and patient charts without join tables
- +Embedded Python and REST services help modernise BASIC applications
- +Very fast keyed access on hashed files
- +Active vendor releases from Rocket for both UniVerse and UniData
Trade-offs
- −Niche skills; Pick BASIC developers are increasingly rare
- −SQL layer is an afterthought compared with the native query languages
- −No horizontal scaling; HA relies on replication add-ons
Great for
- +Running vertical ERP, distribution and healthcare packages built on U2
- +Higher-education student information systems
- +Modernising Pick applications behind REST and .NET
Think twice for
- −Greenfield applications
- −Analytics without exporting to SQL systems
- −Teams without MultiValue experience
Capabilities
Native or official first-party support · 6 of 25 tracked
Scale & consistency
- Comfortable data size
- Medium · ≤ 10 TB
- Horizontal scaling
- None
- Multi-region
- Read replicas
- Transactions
- Limited ACID
- Consistency
- Strong
- Schema
- Flexible
- Architecture
- Client server, Primary replica
- Query languages
- UniVerse BASIC / UniBasic, RetrieVe / UniQuery, SQL
Single-server engines; U2 Data Replication provides hot standby and DR.
Deployment
Ecosystem
Alternatives to Rocket UniData / UniVerse
MultiValue database that compiles Pick BASIC to native code, now part of Rocket's MV portfolio.
rocket-unidata-universe vs jbase →Compact MultiValue (Pick) database from Ladybridge, once GPL-licensed, now Rocket's entry-level MV product.
rocket-unidata-universe vs openqm →Multi-model data platform (SQL, objects, globals, vectors) with built-in interoperability, big in healthcare.
rocket-unidata-universe vs intersystems-iris →Inverted-list, multi-value mainframe database paired with Natural, run as a standalone Software AG business.
rocket-unidata-universe vs adabas →Microsoft's flagship RDBMS: T-SQL, columnstore, Always On, and now native vectors and JSON.
rocket-unidata-universe vs sql-server →Rocket Software's mainframe inverted-list DBMS, in production since 1972 and still getting releases.
rocket-unidata-universe vs model-204 →Rocket UniData / UniVerse FAQ
What is Rocket UniData / UniVerse?
Rocket UniData / UniVerse is a multivalue (Pick) database by Rocket Software, first released in 1985. UniVerse and UniData are the two MultiValue (Pick-family) databases sold together as Rocket U2. Records are dynamic arrays whose fields can hold multiple values and sub-values, described by optional dictionaries, so one record can hold an order with all its lines; applications are written in a BASIC dialect with English-like query languages (RetrieVe/UniQuery) and an SQL layer. Rocket bought U2 from IBM in 2009 and keeps both lines current: UniVerse 14.2.1 shipped in November 2025 with an optional recoverable file system, and UniData 8.3.2 in 2024. Expect to find them inside long-lived ERP, healthcare, banking and distribution packages rather than in new builds.
Is Rocket UniData / UniVerse open source?
No. Rocket UniData / UniVerse is proprietary, closed-source software.
Does Rocket UniData / UniVerse support ACID transactions?
Partly. Rocket UniData / UniVerse offers limited ACID guarantees (for example, single-record or single-partition transactions), with strong consistency.
Does Rocket UniData / UniVerse scale horizontally?
Rocket UniData / UniVerse does not scale horizontally; it runs on a single node, so you scale it up rather than out. It is comfortable at medium scale (≤ 10 TB). It supports cross-region read replicas.
How can I run Rocket UniData / UniVerse?
You can self-host it.
What is Rocket UniData / UniVerse best for?
Rocket UniData / UniVerse is a strong fit for running vertical ERP, distribution and healthcare packages built on U2; higher-education student information systems; and modernising Pick applications behind REST and .NET. Think twice for greenfield applications.
What are the best alternatives to Rocket UniData / UniVerse?
Common alternatives to Rocket UniData / UniVerse include jBASE, OpenQM, InterSystems IRIS, Software AG Adabas and Microsoft SQL Server. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.
How popular is Rocket UniData / UniVerse?
Rocket UniData / UniVerse ranks #289 of 844 databases on the WhichDB Score (11.0/100), and #1 among multivalue (Pick) databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.