Attributes sanitization in object-oriented design to improve database structure

Saringat, Mohd Zainuri (2014) Attributes sanitization in object-oriented design to improve database structure. Doctoral thesis, Universiti Tun Hussein Onn Malaysia.

Preview	Text 24p MOHD ZAINURI SARINGAT.pdf Download (448kB) | Preview
	Text (Copyright Declaration) MOHD ZAINURI SARINGAT COPYRIGHT DECLARATION.pdf Restricted to Repository staff only Download (207kB) | Request a copy
	Text (Full Text) MOHD ZAINURI SARINGAT WATERMARK.pdf Restricted to Registered users only Download (3MB) | Request a copy

Abstract

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

Item Type:	Thesis (Doctoral)
Subjects:	Q Science > QA Mathematics > QA76 Computer software
Divisions:	Faculty of Computer Science and Information Technology > Department of Software Engineering
Depositing User:	Mrs. Sabarina Che Mat
Date Deposited:	30 Sep 2021 06:29
Last Modified:	30 Sep 2021 06:29
URI:	http://eprints.uthm.edu.my/id/eprint/1215

Actions (login required)

View Item