IMS DB: DEDB Vs DL/I database Top Differences

Here are the differences between DEDB and DL/I databases.

DL/I Databases

Often it is called as full function database. It is like general database access manager. All the general purpose projects uses these kinds of databases.

DEDB Databases

Often it is called data entry database. These kind of of databases will be used in Banking, credit and Debit card processing projects. The implementation of DEDB is different from DL/I.

DEDB Applications

  • Large databases containing millions of records, extending well beyond the original 4GB database limits of DL/1 databases
  • Access to each database record that can be achieved by access via a key field
  • Lower processing costs per database record and per update than are required for DL/1 databases
  • The capability to support higher transaction workloads than DL/1 can sustain, while maintaining the per-transaction cost advantages mentioned above
  • Improved availability, with reduced requirements for database outage, especially for database maintenance activities such as database reorganizations
  • Lower processing costs for particular types of processing, where data are inserted online and retrieved in batches for further processing, and eventually deleted in batches
  • The possibility of eliminating transaction-related I/O from database processing.

Keep Reading

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.