Mosul University
  • Register
  • Login
  • العربیة

AL-Rafidain Journal of Computer Sciences and Mathematics

Notice

As part of Open Journals’ initiatives, we create website for scholarly open access journals. If you are responsible for this journal and would like to know more about how to use the editorial system, please visit our website at https://ejournalplus.com or
send us an email to info@ejournalplus.com

We will contact you soon

  1. Home
  2. Volume 5, Issue 2
  3. Authors

Current Issue

By Issue

By Subject

Keyword Index

Author Index

Indexing Databases XML

About Journal

Aims and Scope

Editorial Board

Editorial Staff

Publication Ethics

Indexing and Abstracting

Related Links

Peer Review Process

News

Measuring of Oracle Optimizer Performance for Object-Relational Database Entities

    Esam Mahmoud Mohammed Alaa F.S. AL_Mukhtar

AL-Rafidain Journal of Computer Sciences and Mathematics, 2008, Volume 5, Issue 2, Pages 125-140
10.33899/csmj.2008.163977

  • Show Article
  • Download
  • Cite
  • Statistics
  • Share

Abstract

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.
 
Keywords:
    Oracle Database
  • PDF (438 K)
  • XML
(2008). Measuring of Oracle Optimizer Performance for Object-Relational Database Entities. AL-Rafidain Journal of Computer Sciences and Mathematics, 5(2), 125-140. doi: 10.33899/csmj.2008.163977
Esam Mahmoud Mohammed; Alaa F.S. AL_Mukhtar. "Measuring of Oracle Optimizer Performance for Object-Relational Database Entities". AL-Rafidain Journal of Computer Sciences and Mathematics, 5, 2, 2008, 125-140. doi: 10.33899/csmj.2008.163977
(2008). 'Measuring of Oracle Optimizer Performance for Object-Relational Database Entities', AL-Rafidain Journal of Computer Sciences and Mathematics, 5(2), pp. 125-140. doi: 10.33899/csmj.2008.163977
Measuring of Oracle Optimizer Performance for Object-Relational Database Entities. AL-Rafidain Journal of Computer Sciences and Mathematics, 2008; 5(2): 125-140. doi: 10.33899/csmj.2008.163977
  • RIS
  • EndNote
  • BibTeX
  • APA
  • MLA
  • Harvard
  • Vancouver
  • Article View: 51
  • PDF Download: 38
  • LinkedIn
  • Twitter
  • Facebook
  • Google
  • Telegram
  • Home
  • Glossary
  • News
  • Aims and Scope
  • Privacy Policy
  • Sitemap
This journal is licensed under a Creative Commons Attribution 4.0 International (CC-BY 4.0)

Powered by eJournalPlus