SQL queries optimization for UiTM student academic system using Oracle hints / Mohd Junaidi Johari
Query optimization is the most critical phase in query processing. Query processing is the scientific art of obtaining the desired information from a database system in a predictable and reliable fashion. Database systems must be able to respond to requests for information from the user. In large da...
Saved in:
| 主要作者: | |
|---|---|
| 格式: | Thesis |
| 语言: | English |
| 出版: |
2014
|
| 主题: | |
| 在线阅读: | https://ir.uitm.edu.my/id/eprint/64549/1/64549.pdf |
| 标签: |
添加标签
没有标签, 成为第一个标记此记录!
|
| id |
my-uitm-ir.64549 |
|---|---|
| record_format |
uketd_dc |
| spelling |
my-uitm-ir.645492023-05-09T07:36:06Z SQL queries optimization for UiTM student academic system using Oracle hints / Mohd Junaidi Johari 2014 Johari, Mohd Junaidi Programming languages (Electronic computers) Query optimization is the most critical phase in query processing. Query processing is the scientific art of obtaining the desired information from a database system in a predictable and reliable fashion. Database systems must be able to respond to requests for information from the user. In large database systems, which may be running on unpredictable and volatile environments, it is difficult to produce efficient database query plans based on information available solely at compile time. Getting the database results in a timely manner deals with the technique of query optimization. Efficient processing of queries is an important requirement in many interactive environments that involve massive amounts of data. Efficient query processing in domains such as the web, multimedia search, and distributed systems has shown a great impact on performance. This research will introduce the SQL queries optimization for UiTM Student Academic System using Oracle Hints. The objective in this research is to identify high load queries and to experiment with the chosen types of hints and finally to propose optimize query plan for the selected queries. The categories and types of hints are also described in this research. For the finding, several types of hints implemented in the queries such as index hints, use hash hints, leading hints and use join operation hints with index. Hopefully, with this research can help the UiTM Student Academic System to improve the performance time in producing the output. 2014 Thesis https://ir.uitm.edu.my/id/eprint/64549/ https://ir.uitm.edu.my/id/eprint/64549/1/64549.pdf text en public masters Universiti Teknologi MARA (UiTM) Faculty of Computer and Mathematical Sciences Abdul Manaf, Norehan |
| institution |
Universiti Teknologi MARA |
| collection |
UiTM Institutional Repository |
| language |
English |
| advisor |
Abdul Manaf, Norehan |
| topic |
Programming languages (Electronic computers) |
| spellingShingle |
Programming languages (Electronic computers) Johari, Mohd Junaidi SQL queries optimization for UiTM student academic system using Oracle hints / Mohd Junaidi Johari |
| description |
Query optimization is the most critical phase in query processing. Query processing is the scientific art of obtaining the desired information from a database system in a predictable and reliable fashion. Database systems must be able to respond to requests for information from the user. In large database systems, which may be running on unpredictable and volatile environments, it is difficult to produce efficient database query plans based on information available solely at compile time. Getting the database results in a timely manner deals with the technique of query optimization. Efficient processing of queries is an important requirement in many interactive environments that involve massive amounts of data. Efficient query processing in domains such as the web, multimedia search, and distributed systems has shown a great impact on performance. This research will introduce the SQL queries optimization for UiTM Student Academic System using Oracle Hints. The objective in this research is to identify high load queries and to experiment with the chosen types of hints and finally to propose optimize query plan for the selected queries. The categories and types of hints are also described in this research. For the finding, several types of hints implemented in the queries such as index hints, use hash hints, leading hints and use join operation hints with index. Hopefully, with this research can help the UiTM Student Academic System to improve the performance time in producing the output. |
| format |
Thesis |
| qualification_level |
Master's degree |
| author |
Johari, Mohd Junaidi |
| author_facet |
Johari, Mohd Junaidi |
| author_sort |
Johari, Mohd Junaidi |
| title |
SQL queries optimization for UiTM student academic system using Oracle hints / Mohd Junaidi Johari |
| title_short |
SQL queries optimization for UiTM student academic system using Oracle hints / Mohd Junaidi Johari |
| title_full |
SQL queries optimization for UiTM student academic system using Oracle hints / Mohd Junaidi Johari |
| title_fullStr |
SQL queries optimization for UiTM student academic system using Oracle hints / Mohd Junaidi Johari |
| title_full_unstemmed |
SQL queries optimization for UiTM student academic system using Oracle hints / Mohd Junaidi Johari |
| title_sort |
sql queries optimization for uitm student academic system using oracle hints / mohd junaidi johari |
| granting_institution |
Universiti Teknologi MARA (UiTM) |
| granting_department |
Faculty of Computer and Mathematical Sciences |
| publishDate |
2014 |
| url |
https://ir.uitm.edu.my/id/eprint/64549/1/64549.pdf |
| _version_ |
1783735483887517696 |