- All Journals
- Al-Qadisiyah University
- Basrah University
- Kirkuk University
- Mosul University
- The Iraqi Borad for Medical Specialization
- University of Anbar
- University of Technology
- Al Mustafa University
- Al-Zahraa University for Women
- Alnoor University
- Kunooz University
- Misan University
- Ninevah University
- Tikrit University
- University of Al-Hamdaniya
- University of Kerbala
Guidelines For Better Queries Performance In Database Systems | ||
| Baghdad College of Economic sciences University | ||
| Article 1, Volume 0, Issue 14, 2018, Pages 377-394 | ||
| Author | ||
| Dr. Lamyaa A.S. Al-Sammaraie | ||
| Abstract | ||
| Query optimization is more than transformation and query equivalence. Database designers must develop a robust cost metric, and consider cost and search space. Building extensible enumeration architecture is important, understanding the existing framework makes effective query optimizations. This paper presents effective guidelines to Database designers to guide them for a better understanding to effective query optimization factors . It identifies and presents , effective guidelines for Query evaluation to the mostly used databases (Relational, Deductive, Object Oriented, Multiple , Distributed & Parallel ) types approaches that affect optimizing relational query minimizes the most relevant performance measures (like CPU, Memory, resource usage,… etc). | ||
| Keywords | ||
| query optimization; database systems; object oriented databases | ||
|
Statistics Article View: 127 PDF Download: 80 |
||