Evaluation of Some Properties of Distributed Databases using Oracle
In this study, query processing efficiency of the distributed database in the relational database Oracle9i was examined and compared. Our test data is based on a (Customer Type Definition), which is designed to represent customer information of bank. We generated 8 different sizes of test customers:...
| Published in: | AL-Rafidain Journal of Computer Sciences and Mathematics |
|---|---|
| Main Author: | |
| Format: | Article in Journal/Newspaper |
| Language: | Arabic English |
| Published: |
Mosul University
2013
|
| Subjects: | |
| Online Access: | https://doi.org/10.33899/csmj.2013.163540 https://doaj.org/article/5d0cdff5ea7a4ee39422b00679d3eca4 |
| Summary: | In this study, query processing efficiency of the distributed database in the relational database Oracle9i was examined and compared. Our test data is based on a (Customer Type Definition), which is designed to represent customer information of bank. We generated 8 different sizes of test customers: 300, 600, 900, 2100,4500, 45000, 1360 Records. DML language (SQL) as tools for any comparison can be achieved by the statistical performance parameter (Elapsed time, CPU time, Logical read , Physical read, Logical write, Physical write, Elapsed time, UGA ) .statistical analysis using ANOVA TABLE is used to judge between comparisons. All the queries were run on two computers for different sizes of vertical and horizontal fragments. Changes in performance metrics for each query were written in table after experiments. Finally, we presented the results, and discussed where enhancements are required. Statistical analysis using ANOVA TABLE were used to distinguish between this comparison, it had been found that SELECT, UPDATE and DELETE have the most influence on the performance parameter respectively. |
|---|