Detecting data omissions for an intermittently-connected application

摘要

A system, method and computer program product for detecting data omissions between intermittently-connected devices. An example system includes a client device configured to execute client queries on a client data set, and generate client result sets. The client queries and client result sets are stored on a query queue as queued queries and queued result sets. The system includes a server device with a data omission detector and server database. The data omission detector receives the queued queries and queued result sets after detecting a network connection, executes server queries on the server database and generates server result sets. The server queries are based on the queued queries. The data omission detector compares the server result sets with queued result sets to determine if there are data omissions. Data omissions include data absent in the queued result set that is present in a server result set.

主权项

1. A method for detecting data omissions between intermittently-connected devices comprising:
executing a client query on a client data set stored on a client device; generating a client result set based on the client query; storing the client query and client result set in a client queue as a queued query and queued result set, the client queue located on the client device; detecting a network connection between the client device and a server device; after detecting the network connection, reading the query queue and executing a server query an a server database, the server database stored on the server device, the server query based on the queued query; generating a server result set based on the server query; comparing the server result set and queued result set to at least determine if there is data omission, the data omission including data absent in the queued result set that is present in the server result set; wherein if there is data omission, the method further comprises replicating the data absent in the client data set from the server database; and wherein if there is data omission, the method further comprises flagging the queued result set and displaying an error message.