Data Extraction Formulation for Efficient Data Synchronization Between Mobile Databases and Server-Side Database

Big data volume coupled with affordable small electronic devices with faster processing speed and reasonable amount of memory have engendered higher demand in accessing corporate information from anywhere. Considering the limitations of mobile devices such as CPU, memory and bandwidth, it is important to seek a solution that can address these limited capacities. In this paper, a formula is devised for minimizing the usage of these resources for data synchronization between the mobile devices and the server. Experimental approach (exploratory and confirmatory) is deployed to achieve this goal. A synchronization log was created on the mobile device to save the status of the synch process. Numbers of staging areas are reduced from 4 to 2. The formula was empirically validated in a real-life context. Results obtained indicate a profound improvement in the utilization of mobile resources and data transmission speed.