Deletes - Object Oriented Databases vs Relational Databases

Object Oriented Database vs Relational Database

Deletes

The third phase of the program was the delete phase. Every third part in the tree that was a leaf node is deleted. This phase was executed 4 times in each run. With each successive run, fewer parts get deleted since the tree is smaller. The total time for all delete runs was then recorded. The results are shown here (again, times are in ms). Again the RDBMS outperforms Objectivity when the number of records being deleted is very small. Objectivity overtakes the RDBMS in the second test with 268 records, and dramatically outperforms the RDBMS when a large number of records are deleted. In the last test Objec tivity was over 5 times faster than the RDBMS in deleting records.