whichdb
vs

IBM IMS vs UDS/SQL

IBM IMS: IBM's 1960s hierarchical database and transaction manager, still running bank and airline cores on z/OS. UDS/SQL: Fujitsu BS2000 mainframe DBMS combining a CODASYL network model with SQL on the same data.

key differences

  • IBM IMS is primarily a hierarchical database; UDS/SQL is network / navigational.
  • IBM IMS is built for larger datasets (≤ 1 PB) than UDS/SQL (≤ 10 TB).
  • Horizontal scaling is addon in IBM IMS and none in UDS/SQL.
  • Only IBM IMS has compression, encryption at rest, online schema changes.
  • Only UDS/SQL has joins.

choose ibm-ims for

  • +Core banking ledgers and payment processing
  • +Insurance policy administration
  • +Airline and travel reservation back ends
  • +Exposing legacy IMS transactions as APIs

best at · OLTP

choose uds-sql for

  • +Core banking, insurance and public-sector systems on BS2000
  • +Maintaining CODASYL-era COBOL applications

best at · OLTP

IBM IMSIBM's 1960s hierarchical database and transaction manager, still running bank and airline cores on z/OS.
UDS/SQLFujitsu BS2000 mainframe DBMS combining a CODASYL network model with SQL on the same data.
overview
Primary model
Hierarchical
Network / Navigational
Also supports
–
Relational
Type
Database engine
Database engine
Status
Active
Active
Developer
IBM
Fujitsu (originally Siemens)
First release
1968
1976
Latest version
15.6 (Jun 13, 2025)
V2.9C (2026)
License
ProprietaryProprietary commercial license
ProprietaryCommercial (Fujitsu BS2000 software)
Free tier
—
—
popularity
WhichDB Score
7.7
0.0
Rank
#338
#834
GitHub stars
–
–
Stack Overflow questions
–
–
scale & guarantees
Comfortable data size
Large (≤ 1 PB)
Medium (≤ 10 TB)
Horizontal scaling
Addon
None
Multi-region
Read replicas
None
ACID
Full
Full
Consistency
Strong
Strong
Schema
Strict
Strict
Architecture
Shared storage, Client server
Client server, Distributed
deployment
Self-hosted
✓
✓
Vendor-managed cloud
—
—
Serverless
—
—
Embedded
—
—
Edge
—
—
Clouds
–
–
capabilities
Transactions
✓
✓
Joins
—
✓
Secondary indexes
✓
✓
Full-text search
—
—
Vector search
—
—
Geospatial
—
—
JSON
—
—
Change data capture
—
—
Triggers
—
—
Stored procedures
—
—
Materialized views
—
—
TTL / expiry
—
—
Pub/Sub
—
—
Columnar storage
—
—
In-memory
—
—
Durable persistence
✓
✓
Compression
✓
—
Encryption at rest
✓
—
Role-based access
✓
✓
Time travel
—
—
Branching
—
—
Online schema changes
✓
—
Streaming ingest
—
—
Offline sync
—
—
Runs in WebAssembly
—
—
interfaces
Query languages
DL/I, SQL (IMS Open Database)
COBOL DML, CALL DML, SQL
Client languages
COBOL, PL/I, Java, C, Assembly
COBOL
Best for
OLTP
OLTP
Add more to this comparisonNot sure either fits? Try smart match

IBM IMS vs UDS/SQL: FAQ

What is the difference between IBM IMS and UDS/SQL?

IBM IMS: IBM's 1960s hierarchical database and transaction manager, still running bank and airline cores on z/OS. UDS/SQL: Fujitsu BS2000 mainframe DBMS combining a CODASYL network model with SQL on the same data. IBM IMS is primarily a hierarchical database; UDS/SQL is network / navigational. IBM IMS is built for larger datasets (≤ 1 PB) than UDS/SQL (≤ 10 TB). Horizontal scaling is addon in IBM IMS and none in UDS/SQL.

When should I choose IBM IMS over UDS/SQL?

Choose IBM IMS for core banking ledgers and payment processing; insurance policy administration; and airline and travel reservation back ends. Choose UDS/SQL for core banking, insurance and public-sector systems on BS2000; and maintaining CODASYL-era COBOL applications.

Is IBM IMS or UDS/SQL more popular?

IBM IMS ranks #338 on the WhichDB Score (7.7/100) and UDS/SQL ranks #834 (0.0/100). Popularity is not fit: check the requirements that matter for your project.

Are IBM IMS and UDS/SQL open source?

No. IBM IMS is proprietary, closed-source software. No. UDS/SQL is proprietary, closed-source software. License: Commercial (Fujitsu BS2000 software).