Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking

A database must always in stable state, consistent and reliable. An integrity constraint checking is an important issue that must be addressed in order to maintain the database consistency. Due to various constraints inherited from limitations of wireless communication and mobile devices, it is a ch...

Full description

Bibliographic Details
Main Authors:	Zarina, Dzolkhifli, Wan Nurul Safawati, Wan Manan, Mohd Hafiz, Mohd Hassin, Hamidah, Ibrahim
Format:	Conference or Workshop Item
Language:	English
Published:	2015
Subjects:	QA76 Computer software
Online Access:	http://umpir.ump.edu.my/id/eprint/10589/ http://umpir.ump.edu.my/id/eprint/10589/1/Pre-Fetch%20Data%20Caching%20Strategy%20in%20Mobile%20Database%20System%20for%20Integrity%20Constraints%20Checking.pdf

id	ump-10589
recordtype	eprints
spelling	ump-105892018-03-28T05:59:59Z http://umpir.ump.edu.my/id/eprint/10589/ Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking Zarina, Dzolkhifli Wan Nurul Safawati, Wan Manan Mohd Hafiz, Mohd Hassin Hamidah, Ibrahim QA76 Computer software A database must always in stable state, consistent and reliable. An integrity constraint checking is an important issue that must be addressed in order to maintain the database consistency. Due to various constraints inherited from limitations of wireless communication and mobile devices, it is a challenge on maintaining data consistency in databases. One of limitation of mobile devices that is looked into is limited storage capabilities, a mobile host is not capable of storing all data items in the network, thus it must share some data item with a database in the fixed network. Data caching technique is used to cache frequently accessed data from the base station into mobile host. By caching only the needed data items during integrity constraints checking, it allows mobile host to continue processing without worrying about disconnection. The main aim of this research is to propose a data caching strategies for the purpose of checking integrity constraints in a mobile environment. Two pre-fetch data caching strategies, namely: Blind Strategy (BS) and Relax Strategy (RS) which are embedded in the proposed framework were proposed for the purposed of checking integrity constraints in a mobile environment. The BS strategy blindly pre-fetch data caches into mobile host while RS strategy pre-fetch data cache by analyzing the relationships between integrity tests. These two strategies adopted the simplified form of integrity tests that are sufficient and complete tests. As a result, RS strategy reduced the amount of data items to be cached for the process of integrity constraints checking. 2015 Conference or Workshop Item PeerReviewed application/pdf en http://umpir.ump.edu.my/id/eprint/10589/1/Pre-Fetch%20Data%20Caching%20Strategy%20in%20Mobile%20Database%20System%20for%20Integrity%20Constraints%20Checking.pdf Zarina, Dzolkhifli and Wan Nurul Safawati, Wan Manan and Mohd Hafiz, Mohd Hassin and Hamidah, Ibrahim (2015) Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking. In: International Conference on Software Engineering & Computer Systems (ICSECS 2015), 19-20 Aug 2015 , Kuantan, Pahang. . (Unpublished)
repository_type	Digital Repository
institution_category	Local University
institution	Universiti Malaysia Pahang
building	UMP Institutional Repository
collection	Online Access
language	English
topic	QA76 Computer software
spellingShingle	QA76 Computer software Zarina, Dzolkhifli Wan Nurul Safawati, Wan Manan Mohd Hafiz, Mohd Hassin Hamidah, Ibrahim Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking
description	A database must always in stable state, consistent and reliable. An integrity constraint checking is an important issue that must be addressed in order to maintain the database consistency. Due to various constraints inherited from limitations of wireless communication and mobile devices, it is a challenge on maintaining data consistency in databases. One of limitation of mobile devices that is looked into is limited storage capabilities, a mobile host is not capable of storing all data items in the network, thus it must share some data item with a database in the fixed network. Data caching technique is used to cache frequently accessed data from the base station into mobile host. By caching only the needed data items during integrity constraints checking, it allows mobile host to continue processing without worrying about disconnection. The main aim of this research is to propose a data caching strategies for the purpose of checking integrity constraints in a mobile environment. Two pre-fetch data caching strategies, namely: Blind Strategy (BS) and Relax Strategy (RS) which are embedded in the proposed framework were proposed for the purposed of checking integrity constraints in a mobile environment. The BS strategy blindly pre-fetch data caches into mobile host while RS strategy pre-fetch data cache by analyzing the relationships between integrity tests. These two strategies adopted the simplified form of integrity tests that are sufficient and complete tests. As a result, RS strategy reduced the amount of data items to be cached for the process of integrity constraints checking.
format	Conference or Workshop Item
author	Zarina, Dzolkhifli Wan Nurul Safawati, Wan Manan Mohd Hafiz, Mohd Hassin Hamidah, Ibrahim
author_facet	Zarina, Dzolkhifli Wan Nurul Safawati, Wan Manan Mohd Hafiz, Mohd Hassin Hamidah, Ibrahim
author_sort	Zarina, Dzolkhifli
title	Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking
title_short	Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking
title_full	Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking
title_fullStr	Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking
title_full_unstemmed	Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking
title_sort	pre-fetch data caching strategy in mobile database system for integrity constraints checking
publishDate	2015
url	http://umpir.ump.edu.my/id/eprint/10589/ http://umpir.ump.edu.my/id/eprint/10589/1/Pre-Fetch%20Data%20Caching%20Strategy%20in%20Mobile%20Database%20System%20for%20Integrity%20Constraints%20Checking.pdf
first_indexed	2023-09-18T22:10:21Z
last_indexed	2023-09-18T22:10:21Z
_version_	1777414986147037184

Pre-Fetch Data Caching Strategy in Mobile Database System for Integrity Constraints Checking

Similar Items