Serialization and deserialization of data in communication between Android devices and Microsoft SQL server case study: “Best interest assessment in child protection”

Abstract

Due to integrating most of possible activities – whether are governmental or non-governmental, businesses and services with modern technologies and implementing the ICT use in all possible facilities for strong integrity, confidentiality, security and accessibility, as this is the main vision of our country, to put effort in ICT tools and infrastructure to ease its accessibility to everyone, including enabling 4G in mobile networking for better connectivity. This project studied and analyzed the serialization and deserialization approaches as more secured process of communication between Android devices and Microsoft SQL Server in exchanging data with high speed and security, using web services, instead of using unsecured Java libraries that are available in the market right now. Taking “Best Interest of the Child in Child Protection” as the case study of this communication, this project highlighted all required technologies and security configurations for all involved platforms like Android operating system, in terms of security and necessary configurations and the code to serialize and deserialize the SQL Server request or response, as the project also studied the Microsoft SQL Server’s behavior, its configuration and security settings required for it, and the (IIS) as the web server to host the web application and Webservice files which handles all communications between Android application and SQL Server. This research analyzed all required configuration for IIS as the Webserver of the project, and types of all responses which serialize the data for Android device. This study investigated how serialization works using KSoap2 and Json arrays, and this research highlighted the difference between them. During simulation of this project, software development methodologies and programming languages were used in all platforms to simulate the system; Java was used to power Android code, which contains deserialization classes, As Java Custom Data Adapter was used to display the multiple serialized records from Microsoft SQL Server, and XML language was used for Android as graphical user interface design language. Microsoft Visual BASIC.net as a modern language developed by Microsoft was used to run the Webserver part and serialization classes to send data to Android devices. Microsoft ASP.net and other web technologies like JavaScript were used to build graphical user interface for web client. This study reveals how is important to put all SQL syntaxes for Microsoft SQL Server on the Webservice file for better security, and how serialization and deserialization class is formatted to process the data it received and then send back to Android devices or Microsoft SQL Server.