Performance Study and Migration of Freeware RDBMS Products

Abstract

The selection of freeware DBMS is not an easy matter, that adopting one of available versions is better to be done depending on specific criteria helps in such selection. This research intended to achieve a number of aims those are: comparing free DBMS products through two of the most common and strongest, Oracle and Postgres. The study also intends to highlight the process of migration among DBMS products. Also to give an idea about the benchmarking. In order to achieve these objectives, the descriptive methodology followed to give introductory definition about Oracle and Postgres, then theoretically compare them. Also sample database created to make applications on it, migrate it to Postgres concerning the tools, types and the steps to accomplish the migration process. After that, it has been showed how the performance information extracted using the existed facilities in Oracle, also it had been showed how to perform Oracle benchmark test using professional program for this purpose, which is swingbench. Then, both Oracle and Postgres monitored using professional program ManageEngine, and performance information extracted. Then compare the extracted performance information, and the illustrated comparisons are done using the graphical charts. This research explained the possibilities to migrate from one DBMS to another, ensuring migrated all objects and data with least errors. In term of performance, both products provide considerable solutions, where Postgres is more efficient. The results of this research are summarized in that, OracleXE is suitable for the small databases, also in the cases of the supported additional features (materialized view). Whereas Postgres is suitable with the large databases contain huge amount of data. The research recommends a group of topics to be studied and researched such as studying the migration errors deeply, and to developed benchmark tools for Postgres.