Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin

DBMS system is widely used in information technology era. It is used to store and retrieve important data of the computer system in the organization. DBMS performance is the critical factor of the computing system where most of the system I/O happening at the database level. Most of the enterprise D...

Full description

Saved in:

Bibliographic Details
Main Author:	Jemaludin, Mohd Zainal
Format:	Thesis
Language:	English
Published:	2014
Subjects:	Database management
Online Access:	https://ir.uitm.edu.my/id/eprint/64551/1/64551.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-uitm-ir.64551
record_format	uketd_dc
spelling	my-uitm-ir.645512023-05-09T07:36:44Z Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin 2014 Jemaludin, Mohd Zainal Database management DBMS system is widely used in information technology era. It is used to store and retrieve important data of the computer system in the organization. DBMS performance is the critical factor of the computing system where most of the system I/O happening at the database level. Most of the enterprise DBMS system is using enterprise system storage which a system by itself. It is an independent system to provide high disk performance I/O to the DBMS. DBMS has its own I/O behavior while enterprise storage is also has its own I/O configuration. Managing DBMS I/O and enterprise storage I/O is crucial to ensure good performance to the entire system landscape. After all, the only mechanical component used in computer system is the magnetic disk which embedded in the enterprise storage architecture. Thus, mapping the right DBMS disk into enterprise storage configuration is important and such study is yet to be done. There are studies showing that DBMS and enterprise storage system are managed by separate party. Typically DBMS is managed by database administrator and enterprise storage is managed by SAN administrator. This system support arrangement makes the I/O mapping issue become worst as the both role have their opinion and perception toward the disk configuration. The research is minimizing this gap by providing the disk configuration of DBMS and enterprise storage system guideline. The research covers the scope of Oracle database running on Unix platform and using SAN enterprise storage system. Qualitative method is used as an approach to get the data. The experts of oracle DBMS and SAN administrator were interviewed and analysis was performed at the end of the research. The validation of answers was done at the second round of interview. The matching process was also being done at the second interview based on first round of interview. The guideline of DBMS disk configuration is the result from this research. The research limitation and recommendation for future study is included in this research. 2014 Thesis https://ir.uitm.edu.my/id/eprint/64551/ https://ir.uitm.edu.my/id/eprint/64551/1/64551.pdf text en public masters Universiti Teknologi MARA (UiTM) Faculty of Computer and Mathematical Sciences Sahroni, Mohamad Norzamani
institution	Universiti Teknologi MARA
collection	UiTM Institutional Repository
language	English
advisor	Sahroni, Mohamad Norzamani
topic	Database management
spellingShingle	Database management Jemaludin, Mohd Zainal Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin
description	DBMS system is widely used in information technology era. It is used to store and retrieve important data of the computer system in the organization. DBMS performance is the critical factor of the computing system where most of the system I/O happening at the database level. Most of the enterprise DBMS system is using enterprise system storage which a system by itself. It is an independent system to provide high disk performance I/O to the DBMS. DBMS has its own I/O behavior while enterprise storage is also has its own I/O configuration. Managing DBMS I/O and enterprise storage I/O is crucial to ensure good performance to the entire system landscape. After all, the only mechanical component used in computer system is the magnetic disk which embedded in the enterprise storage architecture. Thus, mapping the right DBMS disk into enterprise storage configuration is important and such study is yet to be done. There are studies showing that DBMS and enterprise storage system are managed by separate party. Typically DBMS is managed by database administrator and enterprise storage is managed by SAN administrator. This system support arrangement makes the I/O mapping issue become worst as the both role have their opinion and perception toward the disk configuration. The research is minimizing this gap by providing the disk configuration of DBMS and enterprise storage system guideline. The research covers the scope of Oracle database running on Unix platform and using SAN enterprise storage system. Qualitative method is used as an approach to get the data. The experts of oracle DBMS and SAN administrator were interviewed and analysis was performed at the end of the research. The validation of answers was done at the second round of interview. The matching process was also being done at the second interview based on first round of interview. The guideline of DBMS disk configuration is the result from this research. The research limitation and recommendation for future study is included in this research.
format	Thesis
qualification_level	Master's degree
author	Jemaludin, Mohd Zainal
author_facet	Jemaludin, Mohd Zainal
author_sort	Jemaludin, Mohd Zainal
title	Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin
title_short	Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin
title_full	Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin
title_fullStr	Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin
title_full_unstemmed	Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin
title_sort	modeling the dbms disk configuration performance by mapping dbms and disk i/o performance: a case study in oil & gas industry / mohd zainal jemaludin
granting_institution	Universiti Teknologi MARA (UiTM)
granting_department	Faculty of Computer and Mathematical Sciences
publishDate	2014
url	https://ir.uitm.edu.my/id/eprint/64551/1/64551.pdf
_version_	1783735484386639872

Modeling the DBMS disk configuration performance by mapping DBMS and disk I/O performance: a case study in oil & gas industry / Mohd Zainal Jemaludin

Similar Items