Measuring of Oracle Optimizer Performance for Object-Relational Database Entities
SQL Optimization is the process of choosing the most efficient way to execute SQL such as Data manipulation language (Select, Insert, Update, Delete). Relational model represents the object through the use of relations; on the other hand the main aim of ORDBMS model is to represent the special cha...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Mosul University
2008-12-01
|
| Series: | Al-Rafidain Journal of Computer Sciences and Mathematics |
| Subjects: | |
| Online Access: | https://csmj.mosuljournals.com/article_163977_dbdacb1328e00d97b01de4a8324e5ea7.pdf |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1850275115556667392 |
|---|---|
| author | Esam Mohammed Alaa AL_Mukhtar |
| author_facet | Esam Mohammed Alaa AL_Mukhtar |
| author_sort | Esam Mohammed |
| collection | DOAJ |
| description | SQL Optimization is the process of choosing the most efficient way to execute SQL such as Data manipulation language (Select, Insert, Update, Delete). Relational model represents the object through the use of relations; on the other hand the main aim of ORDBMS model is to represent the special characteristics of OOP. The first model deals with the Relation & Correlated sub queries, while the second one uses collection types (Object type, Varrays, Nested table). Explain plane is used to examine exactly how oracle execute SQL statements “ oracle SQL analyze” provides a facility for easily generate any explain plan . DML language (SQL) as tools for any comparison can be achieved by the statistical performance parameter (Elapsed time, CPU time, Logical block read, Physical block read …). Statistical analysis using ANOVA TABLE is used to judge between comparisons. We found that nested table was the most effective type of data, the object type was the least effective (consume lowest time of execution). We also found that increasing data size will increase any of performance data parameter until we reach size of 40% the time begins to decrease. It is found that SELECT, UPDATE and DELETE have the most influence on the performance parameter, respectively. |
| format | Article |
| id | doaj-art-80d28e0fb5624a2bb8bf50bf2155f607 |
| institution | OA Journals |
| issn | 1815-4816 2311-7990 |
| language | English |
| publishDate | 2008-12-01 |
| publisher | Mosul University |
| record_format | Article |
| series | Al-Rafidain Journal of Computer Sciences and Mathematics |
| spelling | doaj-art-80d28e0fb5624a2bb8bf50bf2155f6072025-08-20T01:50:56ZengMosul UniversityAl-Rafidain Journal of Computer Sciences and Mathematics1815-48162311-79902008-12-015212514010.33899/csmj.2008.163977163977Measuring of Oracle Optimizer Performance for Object-Relational Database EntitiesEsam Mohammed0Alaa AL_Mukhtar1Foundation of Technical Education Mosul Technical Institute, IraqMinistry of Electricity Northern Electricity, IraqSQL Optimization is the process of choosing the most efficient way to execute SQL such as Data manipulation language (Select, Insert, Update, Delete). Relational model represents the object through the use of relations; on the other hand the main aim of ORDBMS model is to represent the special characteristics of OOP. The first model deals with the Relation & Correlated sub queries, while the second one uses collection types (Object type, Varrays, Nested table). Explain plane is used to examine exactly how oracle execute SQL statements “ oracle SQL analyze” provides a facility for easily generate any explain plan . DML language (SQL) as tools for any comparison can be achieved by the statistical performance parameter (Elapsed time, CPU time, Logical block read, Physical block read …). Statistical analysis using ANOVA TABLE is used to judge between comparisons. We found that nested table was the most effective type of data, the object type was the least effective (consume lowest time of execution). We also found that increasing data size will increase any of performance data parameter until we reach size of 40% the time begins to decrease. It is found that SELECT, UPDATE and DELETE have the most influence on the performance parameter, respectively.https://csmj.mosuljournals.com/article_163977_dbdacb1328e00d97b01de4a8324e5ea7.pdforacledatabase |
| spellingShingle | Esam Mohammed Alaa AL_Mukhtar Measuring of Oracle Optimizer Performance for Object-Relational Database Entities Al-Rafidain Journal of Computer Sciences and Mathematics oracle database |
| title | Measuring of Oracle Optimizer Performance for Object-Relational Database Entities |
| title_full | Measuring of Oracle Optimizer Performance for Object-Relational Database Entities |
| title_fullStr | Measuring of Oracle Optimizer Performance for Object-Relational Database Entities |
| title_full_unstemmed | Measuring of Oracle Optimizer Performance for Object-Relational Database Entities |
| title_short | Measuring of Oracle Optimizer Performance for Object-Relational Database Entities |
| title_sort | measuring of oracle optimizer performance for object relational database entities |
| topic | oracle database |
| url | https://csmj.mosuljournals.com/article_163977_dbdacb1328e00d97b01de4a8324e5ea7.pdf |
| work_keys_str_mv | AT esammohammed measuringoforacleoptimizerperformanceforobjectrelationaldatabaseentities AT alaaalmukhtar measuringoforacleoptimizerperformanceforobjectrelationaldatabaseentities |