Attributes sanitization in object-oriented design to improve database structure

Modelling using the Entity Relationship Model was introduced more than thirty years ago. Until late 1990’s, object-oriented introduced class diagram. However, designing a good database is still a serious issue. Some of the issues are very difficult to handle such as consistency checking betwee...

Full description

Saved in:

Bibliographic Details
Main Author:	Saringat, Mohd Zainuri
Format:	Thesis
Language:	English English English
Published:	2014
Subjects:	QA76 Computer software
Online Access:	http://eprints.uthm.edu.my/1215/1/24p%20MOHD%20ZAINURI%20SARINGAT.pdf http://eprints.uthm.edu.my/1215/2/MOHD%20ZAINURI%20SARINGAT%20COPYRIGHT%20DECLARATION.pdf http://eprints.uthm.edu.my/1215/3/MOHD%20ZAINURI%20SARINGAT%20WATERMARK.pdf
Tags:	Add Tag No Tags, Be the first to tag this record!

id	my-uthm-ep.1215
record_format	uketd_dc
spelling	my-uthm-ep.12152021-09-30T06:29:54Z Attributes sanitization in object-oriented design to improve database structure 2014-06 Saringat, Mohd Zainuri QA76 Computer software Modelling using the Entity Relationship Model was introduced more than thirty years ago. Until late 1990’s, object-oriented introduced class diagram. However, designing a good database is still a serious issue. Some of the issues are very difficult to handle such as consistency checking between system design and database design, redundancy of data, mismatch of the data structure with the user’s needs in the database and unused data in the database. In this thesis, a new technique called UInData is introduced as an alternative method for designing database based on attribute sanitization. The proposed technique will extract class behaviour from class diagram to produce schema table which will then be compared with the user interface to normalize the structure. Attributes sanitization is introduced to remove the unused attributes and to provide final schema table. An experiment using three case studies has shown that some improvements of designing optimal database have been achieved in term of data sanitization and data accessibility. Attribute sanitization was applied in LAS, SPKS and MPBP database. Data sanitizations have removed 2.2%, 14.1% and 24.5% from defined attributes which are not used by user interface. Meanwhile the results shown in data accessibility for these three cases have shown that LAS was reduced by 50%, SPKS have not reducing of data accessibility and MPBP was reduced by 20% when UInData is used as compared to using ordinary object-oriented. Therefore, the UInData is a good alternative technique to improve database structure 2014-06 Thesis http://eprints.uthm.edu.my/1215/ http://eprints.uthm.edu.my/1215/1/24p%20MOHD%20ZAINURI%20SARINGAT.pdf text en public http://eprints.uthm.edu.my/1215/2/MOHD%20ZAINURI%20SARINGAT%20COPYRIGHT%20DECLARATION.pdf text en staffonly http://eprints.uthm.edu.my/1215/3/MOHD%20ZAINURI%20SARINGAT%20WATERMARK.pdf text en validuser phd doctoral Universiti Tun Hussein Onn Malaysia Fakulti Sains Komputer dan Teknologi Maklumat
institution	Universiti Tun Hussein Onn Malaysia
collection	UTHM Institutional Repository
language	English English English
topic	QA76 Computer software
spellingShingle	QA76 Computer software Saringat, Mohd Zainuri Attributes sanitization in object-oriented design to improve database structure
description	Modelling using the Entity Relationship Model was introduced more than thirty years ago. Until late 1990’s, object-oriented introduced class diagram. However, designing a good database is still a serious issue. Some of the issues are very difficult to handle such as consistency checking between system design and database design, redundancy of data, mismatch of the data structure with the user’s needs in the database and unused data in the database. In this thesis, a new technique called UInData is introduced as an alternative method for designing database based on attribute sanitization. The proposed technique will extract class behaviour from class diagram to produce schema table which will then be compared with the user interface to normalize the structure. Attributes sanitization is introduced to remove the unused attributes and to provide final schema table. An experiment using three case studies has shown that some improvements of designing optimal database have been achieved in term of data sanitization and data accessibility. Attribute sanitization was applied in LAS, SPKS and MPBP database. Data sanitizations have removed 2.2%, 14.1% and 24.5% from defined attributes which are not used by user interface. Meanwhile the results shown in data accessibility for these three cases have shown that LAS was reduced by 50%, SPKS have not reducing of data accessibility and MPBP was reduced by 20% when UInData is used as compared to using ordinary object-oriented. Therefore, the UInData is a good alternative technique to improve database structure
format	Thesis
qualification_name	Doctor of Philosophy (PhD.)
qualification_level	Doctorate
author	Saringat, Mohd Zainuri
author_facet	Saringat, Mohd Zainuri
author_sort	Saringat, Mohd Zainuri
title	Attributes sanitization in object-oriented design to improve database structure
title_short	Attributes sanitization in object-oriented design to improve database structure
title_full	Attributes sanitization in object-oriented design to improve database structure
title_fullStr	Attributes sanitization in object-oriented design to improve database structure
title_full_unstemmed	Attributes sanitization in object-oriented design to improve database structure
title_sort	attributes sanitization in object-oriented design to improve database structure
granting_institution	Universiti Tun Hussein Onn Malaysia
granting_department	Fakulti Sains Komputer dan Teknologi Maklumat
publishDate	2014
url	http://eprints.uthm.edu.my/1215/1/24p%20MOHD%20ZAINURI%20SARINGAT.pdf http://eprints.uthm.edu.my/1215/2/MOHD%20ZAINURI%20SARINGAT%20COPYRIGHT%20DECLARATION.pdf http://eprints.uthm.edu.my/1215/3/MOHD%20ZAINURI%20SARINGAT%20WATERMARK.pdf
_version_	1747830754259238912

Attributes sanitization in object-oriented design to improve database structure

Similar Items