Home   |   Solutions   |   Refine for dbms conversion

Refine for dbms conversion

DB2, IDMS DB, IDMS, DATACOM, IDS2, ADABAS

Converting pre-relational databases to SQL standards, or consolidating heterogeneous and multiple data formats, delivers a high ROI by exiting obsolescence and high license and maintenance fees.

Objectives

  • Reduction of DBMS license and maintenance fees.
  • Replacement by SQL standard.
  • Maintain or increase performance.

Challenges

Any project for the elimination of a pre-relational database must meet the following requirements:

  • Keep response times to a minimum
  • Minimize system resource usage relative to the pre-relational database
  • Maintain the behavior and features of existing applications.
  • Code maintainability after conversion, for future upgrades.

Solution overview

Refine supports many proprietary data formats, including:

Files (sequential, relative, indexed) ESDS, KSDS...ENSCRIBE, ISAM, UFAS, QSAM, SAM, SFS, VSAM ...GDG, PDS
Pre-relational databasesADABAS, DATACOM, IMS/DB (DL/1), CA-IDMS

Refine can generate data format conversions for the majority of the market's RDBMSs, including DB2, ORACLE or SQL Server.

Conversion platform architecture

Benefits

  • Migration process automation covers all steps, i.e. data discovery, qualification, reloading and static testing.
  • Complete automation enables the project to focus on schema, path and constraint optimization, through several iterations.
  • The solution proposes many data rationalization and improvement options corresponding to the majority of technical situations.
© Copyright 2009 MetaWare - All rights reserved