Abstract
Last decades, software systems use SQL database to handle structured data between server and clients that hold text and integer value in column-store format. Nowadays, emergence of media entertainment had introduced unstructured data like images that acquires big memory allocation to be stored in database. Hence, some of software and mobile application developers tend to implement schema-less databases, which known as NoSQL. They handle synchronization process for unstructured data in a simple and fast manner. However, dissimilar database structure and framework make software developers tend to implement only either one type of databases: SQL or NoSQL, but not both. No interaction between SQL and NoSQL databases will prevent data sharing and accessibility. Hence, one-way image synchronization framework for heterogeneous databases in mobile environment has been developed and new sync gateway is introduced to synchronize images from client NoSQL database to server SQL database regardless of different schema and database structure.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Domingos, J., Simões, N., Pereira, P., Silva, C., Marcelino, L.: Database synchronization model for mobile devices. In: Iberian Conference on Information Systems and Technologies (2014)
Zaia, G.P., Ronaldo, C.M., Messias, C., Eduardo, R.G., Olivete, C.J.: MySQLite Sync Middleware for stored data synchronization in mobile devices and DBMSs. In: Proceedings Latin American Computing Conference, pp. 1–7 (2014)
Strauch, C.: NoSQL Databases (2011). http://www.christofstrauch.de/nosqldbs.pdf/. Accessed 15 Nov 2014
Maan, P.K.: Database for unstructured, semi structured data - NoSQL focus on availability. Int. J. Adv. Res. Comput. Eng. Technol. (IJARCET), pp. 466–469 (2015)
Nasholm, P.: Extracting data from NoSQL databases: a step towards interactive visual analysis of NoSQL data. Master’s thesis, University of Gothenburg, Sweden (2012)
Das, M.E., Suresh, S.: A synchronization algorithm of mobile database by using SAMD algorithm. In: International Conference Computing Control Engineering (2012)
Balakumar, V., Sakthidevi, I.: An efficient database synchronization algorithm for mobile devices based on secured message digest. In: International Conference on Computing, Electronics and Electrical Technologies, pp. 937–942 (2012)
Li, Z., Wilson, C., Jiang, Z., Liu, Y., Zhao, B., Jin, C., Zhang, Z.-L., Dai, Y.: Efficient batched synchronization in Dropbox-like cloud storage services. In: Eyers, D., Schwan, K. (eds.) Middleware 2013. LNCS, vol. 8275, pp. 307–327. Springer, Heidelberg (2013). doi:10.1007/978-3-642-45065-5_16
Thomas, G., Glenn, R.T., Chin-Wan, C., Edward, B., Carter, F., Marjorie, T., Stephen, F., Berl, H.: Heterogeneous distributed database systems for production use. ACM Comput. Surv. 22(3), 238–266 (1990)
Singh, R., Dutta, C.: A synchronization algorithm of mobile database for cloud computing. Int. J. Appl. Innov. Eng. Manag. (IJAIEM) 2(3), 491–497 (2013)
Leavitt, N.: Will NoSQL databases live up to their promise? Computer 43, 12–14 (2010)
Hecht, R., Jablonski, S.: NoSQL evaluation: a use case oriented survey. In: 2011 International Conference Cloud and Service Computing (CSC), pp. 336–341. IEEE (2011)
Konstantinou, I., Angelou, E., Boumpouka, C., Tsoumakos, D., Koziris, N.: On the elasticity of NoSQL databases over cloud management platforms. In: Proceedings of the 20th ACM International Conference on Information and Knowledge Management, pp. 2385–2388 (2011)
Sharma, A., Kansal, V.: Replication management and optimistic replication challenges in mobile environment. Int. J. Database Manag. Syst. 3, 81–99 (2011)
Cattell, R.: Scalable SQL and NoSQL data stores. In: ACM SIGMOD, vol. 1, pp. 12–27. ACM Digital Library, New York (2010)
Moniruzzaman, A.B., Hosaain, S.A.: NoSQL database: new era of databases for big data analytics - classification, characteristics and comparison. Int. J. Database Theory Appl. 6, 1–14 (2013)
Abadi, D.J.: Data management in the cloud: limitations and opportunities. IEEE Data Eng. Bull. 32, 3–12 (2009)
Stonebraker, M., Hong, J.: Saying good-bye to DBMSs, designing effective interfaces. Commun. ACM 52(9), 12–13 (2009)
Sedivy, J., Barina, T., Morozan, I., Sandu, A.: MCSync – distributed, decentralized database for mobile devices. In: IEEE International Conference on Cloud Computing in Emerging Markets, pp. 1–6. IEEE Press (2012)
Alhaj, T.A., Taha, M.M., Alim, F.M.: Synchronization wireless algorithm based on message digest (SWAMD) for mobile device database. In: International Conference on Computing, Electrical and Electronic Engineering Synchronization, pp. 259–262 (2013)
Gopta, K., Kumar R., Loothra S.: Smartphone security and contact synchronization. In: 2014 Fourth International Conference on Communication Systems and Network Technologies, pp. 621–625 (2014)
Sethia, D., Mehta, S., Chodhary, A., Bhatt, K., Bhatnagar, K.: MRDMS-mobile replicated database management synchronization. In: International Conference Signal Processing Integrate Networks, pp. 624–631 (2014)
Abdullahi, A.I., Basri, S., Ahmad, R.: An efficient data synchronization model for heterogeneous mobile device databases and server side database. Unpublished Master’s thesis, Universiti Teknologi PETRONAS, Perak, Malaysia (2016)
Choi, M.Y., Cho, E.A., Park, D.H., Bae, J.Y., Moon, C.J., Baik, D.K.: A synchronization algorithm of mobile database for ubiquitous computing. In: Fifth International Joint Conference on INC, IMS IDC, NCM, pp. 416–419 (2009)
Calhoun, D.: When to Base64 encode images (and When Not To) (2011). http://davidbcalhoun.com/2011/when-to-base64-encode-images-and-when-not-to/. Accessed 02 Dec 2016
Sinitsyn, A.: A synchronization framework for personal mobile servers. In: Second IEEE Annual Conference on Pervasive Computing and Communications Workshops, p. 208 (2004)
Russell, B.C., Torralba, A., Murphy, K.P., Freeman, W.T.: LabelMe: a database and web-based tool for image annotation. Int. J. Comput. Vis. 77(3), 157–173 (2008)
Acknowledgments
This research is fully supported by Ministry of Education Malaysia (MOE) under Fundamental Research Grant Scheme (FRGS) for extensive research on Software Engineering. Any opinions, findings, and conclusions stated in this paper are those of authors and do not necessarily reflect those of the MOE.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Zulkafli, A.Z., Basri, S., Ahmad, R., Imam, A.A. (2017). A Framework for Image Synchronization from Mobile NoSQL Database to Server-Side SQL Database. In: Silhavy, R., Silhavy, P., Prokopova, Z., Senkerik, R., Kominkova Oplatkova, Z. (eds) Software Engineering Trends and Techniques in Intelligent Systems. CSOC 2017. Advances in Intelligent Systems and Computing, vol 575. Springer, Cham. https://doi.org/10.1007/978-3-319-57141-6_19
Download citation
DOI: https://doi.org/10.1007/978-3-319-57141-6_19
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-57140-9
Online ISBN: 978-3-319-57141-6
eBook Packages: EngineeringEngineering (R0)