vs

IDMS vs UDS/SQL

IDMS: CODASYL network-model mainframe database, now Broadcom's, still running decades-old COBOL systems. UDS/SQL: Fujitsu BS2000 mainframe DBMS combining a CODASYL network model with SQL on the same data.

key differences

  • IDMS is built for larger datasets (≤ 1 PB) than UDS/SQL (≤ 10 TB).
  • Horizontal scaling is addon in IDMS and none in UDS/SQL.
  • Only IDMS has compression.

choose idms for

  • +Government and utility billing systems on z/OS
  • +Manufacturing and distribution systems built in the 1980s
  • +Exposing legacy IDMS data via SQL and web services during migration

best at · OLTP

choose uds-sql for

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

best at · OLTP

overview
Primary model
Network / Navigational
Network / Navigational
Also supports
Relational
Relational
Type
Database engine
Database engine
Status
Active
Active
Developer
Broadcom (originally Cullinane, Computer Associates)
Fujitsu (originally Siemens)
First release
1973
1976
Latest version
–
V2.9C (2026)
License
ProprietaryProprietary commercial license
ProprietaryCommercial (Fujitsu BS2000 software)
Free tier
—
—
popularity
WhichDB Score
6.2
0.0
Rank
#366
#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
Client server, Shared storage
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
DML (navigational), SQL (IDMS SQL option), ADS/Online
COBOL DML, CALL DML, SQL
Client languages
COBOL, PL/I, Assembly, Java
COBOL
Best for
OLTP
OLTP

IDMS vs UDS/SQL: FAQ

What is the difference between IDMS and UDS/SQL?

IDMS: CODASYL network-model mainframe database, now Broadcom's, still running decades-old COBOL systems. UDS/SQL: Fujitsu BS2000 mainframe DBMS combining a CODASYL network model with SQL on the same data. IDMS is built for larger datasets (≤ 1 PB) than UDS/SQL (≤ 10 TB). Horizontal scaling is addon in IDMS and none in UDS/SQL. Only IDMS has compression.

When should I choose IDMS over UDS/SQL?

Choose IDMS for government and utility billing systems on z/OS; manufacturing and distribution systems built in the 1980s; and exposing legacy IDMS data via SQL and web services during migration. Choose UDS/SQL for core banking, insurance and public-sector systems on BS2000; and maintaining CODASYL-era COBOL applications.

Is IDMS or UDS/SQL more popular?

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

Are IDMS and UDS/SQL open source?

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