Lessons Learned Using a Relational Database for System Conversion
Richard W. Stahlhut, David P. McCallie · PubMed Central · 1989
Before a new system is brought on-line, data from an old system frequently needs to be massaged prior to loading into the new system. To determine if 4-GL tools could be used in these projects, a relational database management system, Oracle, was used to convert our old ADT system's data into the format required by the new system. In doing so, we learned several important performance lessons regarding proper structuring of SQL statements and database tuning. Although the ADT system data were successfully manipulated using this 4-GL product, one should understand database tuning and consider the options carefully before embarking on a large-scale conversion.