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:...
Saved in:
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Mosul University
2013-09-01
|
| Series: | Al-Rafidain Journal of Computer Sciences and Mathematics |
| Subjects: | |
| Online Access: | https://csmj.mosuljournals.com/article_163540_f3a852a7343b660ec1f4a0e7bd30e261.pdf |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1849727030888759296 |
|---|---|
| author | Alaa Saeed Al-Mukhtar |
| author_facet | Alaa Saeed Al-Mukhtar |
| author_sort | Alaa Saeed Al-Mukhtar |
| collection | DOAJ |
| description | 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. |
| format | Article |
| id | doaj-art-5d0cdff5ea7a4ee39422b00679d3eca4 |
| institution | DOAJ |
| issn | 1815-4816 2311-7990 |
| language | English |
| publishDate | 2013-09-01 |
| publisher | Mosul University |
| record_format | Article |
| series | Al-Rafidain Journal of Computer Sciences and Mathematics |
| spelling | doaj-art-5d0cdff5ea7a4ee39422b00679d3eca42025-08-20T03:09:58ZengMosul UniversityAl-Rafidain Journal of Computer Sciences and Mathematics1815-48162311-79902013-09-0110313114210.33899/csmj.2013.163540163540Evaluation of Some Properties of Distributed Databases using OracleAlaa Saeed Al-Mukhtar0Computer and Informatics Department General Directorate of North Electricity Distribution Ministry of ElectricityIn 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.https://csmj.mosuljournals.com/article_163540_f3a852a7343b660ec1f4a0e7bd30e261.pdfdistributed databasedistributed management systemdata fragmentation cpu timelogical readphysical readphysical writeelapsed timeuga |
| spellingShingle | Alaa Saeed Al-Mukhtar Evaluation of Some Properties of Distributed Databases using Oracle Al-Rafidain Journal of Computer Sciences and Mathematics distributed database distributed management system data fragmentation cpu time logical read physical read physical write elapsed time uga |
| title | Evaluation of Some Properties of Distributed Databases using Oracle |
| title_full | Evaluation of Some Properties of Distributed Databases using Oracle |
| title_fullStr | Evaluation of Some Properties of Distributed Databases using Oracle |
| title_full_unstemmed | Evaluation of Some Properties of Distributed Databases using Oracle |
| title_short | Evaluation of Some Properties of Distributed Databases using Oracle |
| title_sort | evaluation of some properties of distributed databases using oracle |
| topic | distributed database distributed management system data fragmentation cpu time logical read physical read physical write elapsed time uga |
| url | https://csmj.mosuljournals.com/article_163540_f3a852a7343b660ec1f4a0e7bd30e261.pdf |
| work_keys_str_mv | AT alaasaeedalmukhtar evaluationofsomepropertiesofdistributeddatabasesusingoracle |