What data storage algorithm would you suggest?

Question

Algorithms

In general, a program with a remote mssql database fell on me.
I myself am a system administrator, but my friends are asking for help ....
The problem is the following field of the table, which must be filled in.
The field is filled in if the patient came.
Even with protection in the program from saving empty results in the described field of the table.
I understand that in the function of saving the form in mssql, part of the data is lost due to partial failures in the connection, since the database is geographically located in the USA, and the employees are in Europe.
Advise on how to choose the right algorithms for the program to work with a remote database. I know that client-server programs are often used to accurately store the results of the client program

Answer 1

1) Write a layer on the server. Itself to take data from the local database, then long and hard to try to send it over the network to our application.
2) We take any mssql library for our language, then we try long and hard to unload data from the database. Most libraries allow you to easily connect to a remote host via ip, provided that ports are forwarded and tcp / ip access is enabled in the database properties.

Answer 2

if the problem is data loss, it is obvious that the data must somehow not be lost. Since you are a system administrator, obviously, you will not write normal noise-tolerant and loss-proof code for programmers, but you will surely find a solution for configuring your and Western equipment in such a way that at a lower (if you follow osi terminology) level to implement packet loss protection , albeit at the cost of increasing the delay / channel width. Here is an article without practical implementation, but as a starting point .