Obsolescence factors as well as skills shortage and high cost of ownership of pre-relational databases drive the need for their replacement. Converting pre-relational databases to SQL standards, or consolidating heterogeneous and multiple data formats, is the best way to reach the following objectives:
Projects eliminating pre-relational databases must meet the following requirements
(sequential, relative, indexed)
|ESDS, KSDS... ENSCRIBE, ISAM, UFAS, QSAM, SAM, SFS, VSAM, GDG, PDS, …|
|Pre-relational databases||ADABAS, DATACOM, DMSII, CA-IDMS, IDMS-X, IDSII, IMAGE, IMS/DB (DL/1), ...|
|Relational databases||DB2, INFORMIX, nonStop SQL, ORACLE, RDB, SQL Server, SYBASE, …|
Refine can generate database migrations for the majority of today’s RDBMS, including DB2, ORACLE, and SQL Server.
Complete automation allows the project to focus on schema, path and constraints optimization, through several iterations. Metaware’s solution proposes many data rationalization and improvement options for a wide array of technical situations.