A database synchronization algorithm for mobile devices

Mi Young Choi, Eun Ae Cho, Dae Ha Park, Chang Joo Moon, Doo Kwon Baik

Research output: Contribution to journalArticle

21 Citations (Scopus)

Abstract

This paper proposes an SAMD (Synchronization Algorithms based on Message Digest) algorithm based on message digest in order to facilitate data synchronization between a server-side database and a mobile database. The SAMD algorithm makes the images at the server-side database and the mobile database uses message digest tables to compare two images in order to select the rows needed for synchronization. If the two images are different, the synchronization progresses according to synchronization policy. The SAMD algorithm does not use techniques that are dependent on specific database venders; neither does it use triggers, stored procedures or timestamps. The SAMD uses only the standard SQL functions for the synchronization. Therefore the SAMD algorithm can be used in any combinations of server-side database and mobile database because of its independence of database vender. This feature is important in order to build efficient mobile business systems because the upcoming mobile business environment has heterogeneous characteristics in which diverse mobile devices, mobile databases, and RDBMS exist.

Original languageEnglish
Article number5505945
Pages (from-to)392-398
Number of pages7
JournalIEEE Transactions on Consumer Electronics
Volume56
Issue number2
DOIs
Publication statusPublished - 2010 May 1

Fingerprint

Mobile devices
Synchronization
Servers
Industry

Keywords

  • Mobile Database
  • Mobile Device
  • Synchronization

ASJC Scopus subject areas

  • Electrical and Electronic Engineering
  • Media Technology

Cite this

A database synchronization algorithm for mobile devices. / Choi, Mi Young; Cho, Eun Ae; Park, Dae Ha; Moon, Chang Joo; Baik, Doo Kwon.

In: IEEE Transactions on Consumer Electronics, Vol. 56, No. 2, 5505945, 01.05.2010, p. 392-398.

Research output: Contribution to journalArticle

Choi, Mi Young ; Cho, Eun Ae ; Park, Dae Ha ; Moon, Chang Joo ; Baik, Doo Kwon. / A database synchronization algorithm for mobile devices. In: IEEE Transactions on Consumer Electronics. 2010 ; Vol. 56, No. 2. pp. 392-398.
@article{0a4d46b1937c4031a9097aaae8de0f11,
title = "A database synchronization algorithm for mobile devices",
abstract = "This paper proposes an SAMD (Synchronization Algorithms based on Message Digest) algorithm based on message digest in order to facilitate data synchronization between a server-side database and a mobile database. The SAMD algorithm makes the images at the server-side database and the mobile database uses message digest tables to compare two images in order to select the rows needed for synchronization. If the two images are different, the synchronization progresses according to synchronization policy. The SAMD algorithm does not use techniques that are dependent on specific database venders; neither does it use triggers, stored procedures or timestamps. The SAMD uses only the standard SQL functions for the synchronization. Therefore the SAMD algorithm can be used in any combinations of server-side database and mobile database because of its independence of database vender. This feature is important in order to build efficient mobile business systems because the upcoming mobile business environment has heterogeneous characteristics in which diverse mobile devices, mobile databases, and RDBMS exist.",
keywords = "Mobile Database, Mobile Device, Synchronization",
author = "Choi, {Mi Young} and Cho, {Eun Ae} and Park, {Dae Ha} and Moon, {Chang Joo} and Baik, {Doo Kwon}",
year = "2010",
month = "5",
day = "1",
doi = "10.1109/TCE.2010.5505945",
language = "English",
volume = "56",
pages = "392--398",
journal = "IEEE Transactions on Consumer Electronics",
issn = "0098-3063",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
number = "2",

}

TY - JOUR

T1 - A database synchronization algorithm for mobile devices

AU - Choi, Mi Young

AU - Cho, Eun Ae

AU - Park, Dae Ha

AU - Moon, Chang Joo

AU - Baik, Doo Kwon

PY - 2010/5/1

Y1 - 2010/5/1

N2 - This paper proposes an SAMD (Synchronization Algorithms based on Message Digest) algorithm based on message digest in order to facilitate data synchronization between a server-side database and a mobile database. The SAMD algorithm makes the images at the server-side database and the mobile database uses message digest tables to compare two images in order to select the rows needed for synchronization. If the two images are different, the synchronization progresses according to synchronization policy. The SAMD algorithm does not use techniques that are dependent on specific database venders; neither does it use triggers, stored procedures or timestamps. The SAMD uses only the standard SQL functions for the synchronization. Therefore the SAMD algorithm can be used in any combinations of server-side database and mobile database because of its independence of database vender. This feature is important in order to build efficient mobile business systems because the upcoming mobile business environment has heterogeneous characteristics in which diverse mobile devices, mobile databases, and RDBMS exist.

AB - This paper proposes an SAMD (Synchronization Algorithms based on Message Digest) algorithm based on message digest in order to facilitate data synchronization between a server-side database and a mobile database. The SAMD algorithm makes the images at the server-side database and the mobile database uses message digest tables to compare two images in order to select the rows needed for synchronization. If the two images are different, the synchronization progresses according to synchronization policy. The SAMD algorithm does not use techniques that are dependent on specific database venders; neither does it use triggers, stored procedures or timestamps. The SAMD uses only the standard SQL functions for the synchronization. Therefore the SAMD algorithm can be used in any combinations of server-side database and mobile database because of its independence of database vender. This feature is important in order to build efficient mobile business systems because the upcoming mobile business environment has heterogeneous characteristics in which diverse mobile devices, mobile databases, and RDBMS exist.

KW - Mobile Database

KW - Mobile Device

KW - Synchronization

UR - http://www.scopus.com/inward/record.url?scp=77954699779&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=77954699779&partnerID=8YFLogxK

U2 - 10.1109/TCE.2010.5505945

DO - 10.1109/TCE.2010.5505945

M3 - Article

AN - SCOPUS:77954699779

VL - 56

SP - 392

EP - 398

JO - IEEE Transactions on Consumer Electronics

JF - IEEE Transactions on Consumer Electronics

SN - 0098-3063

IS - 2

M1 - 5505945

ER -