离线解决方案和数据同步 [英] Offline solution and data sync up

问题描述

要求如下：



步骤1：用户登录系统并将5万条记录下载到本地计算机（系统连接到数据库）位于服务器 - SQL Server数据库是后端）。

步骤2：用户断开网络连接并处理此本地数据。他将逐行编辑并将其保存到本地计算机。这个过程将持续数周甚至数月。 （目前用户正在使用excel - 完全手动工作 - 没有存储 - 所以我们应该摆脱excel使用）

步骤3：用户完成编辑所有5万字节记录并准备同步它回到远程数据库。他再次将数据提交给系统，系统可以将其与中央或远程数据库同步。

步骤4：当下一个周期到来时，用户再次下载新的数据集。多个用户必须处理不同的记录集（我们目前有一种处理数据操作安全性的方法）。



我们正在考虑解决方案的以下输入;



- 考虑到在Web应用程序中我们还需要处理具有挑战性的本地数据库这一事实，Winodws应用程序更适合此要求。我们再次需要一些可靠的结论来得出结论（在性能方面，减轻这一特定要求中的挑战）。

- 关于数据下载，我们正在考虑将其置于本地数据库并提供解决方案，以便用户可以轻松地按记录导航，以便他可以在不连接到网络的情况下修改详细信息。

- 需要看看同一个应用程序如何处理本地数据库。



关于如何使用解决方案的任何建议？

The requirement is given below;

Step 1 : User logs in to a system and download 5 lakhs records to his local machine (the system connects to a database located in a server - SQL Server database is the backend).
Step 2 : User disconnect from the network and he work on this local data. He will edit row by row and save it to his local machine. This process will go for weeks or even months. (currently the users are doing in excel - completely manual work - no storage - so we should get rid of excel usage)
Step 3 : User finishes editing all the 5 lakhs records and he is ready to sync it back to the remote database. He submits the data to the system again and the system has the capability to sync it back with its central or remote database.
Step 4 : When the next cycle comes user again download new set of data. Multiple users have to work on different set of records (we have an approach currently to handle security in manipulating data).

We are thinking of the below inputs for the solution;

- Winodws application is more suitable for this requirement considering the fact that in a web application also we need to deal with a local db which is challenging. Again we need some solid points to derive a conclusion (in terms of performance, mitigating the challenges in this particular requirement).
- With respect to downloading of data, we are thinking to have it in a local database and provide a solution so that the user can easily navigate record by record so that he can modify the details without connecting to the network.
- Need to look at how the same application can deal with local database.

Any suggestions on how to go with the solution?

推荐答案

您好Sunil，我曾在我们将使用计时器的相同场景，每隔x分钟我们检查互联网连接，如果连接可用，我们正在检查本地和服务器的数据库，如果两者都相同则不需要更新它们，如果它们不相同，我们将提示用户询问他是否要更新本地数据库。如果他单击是，那么我们将更新本地数据库。检查所有内容的互联网连接将在后台线程中完成，并且提示仅在主ui线程中使用。根据我的观点，Windows应用程序更好地处理。一旦你开始工作，你就会有很多想法发挥作用。试着用基本功能实现并检查。它不是很复杂。



任何疑问都发布在这里

谢谢

Ganesh

Hi Sunil, I have worked in the same scenario where we will using a timer, for every x min we are checking internet connection and if connection available, we are checking databases of local and server, if both are same no need to update it and if they are not same, we will prompt to user asking whether he wants to update local database or not. If he click Yes, then we will update local database. The internet connection checking everything will be done in background thread and the prompt is only used in main ui thread. As per my opinion Windows application is better to deal with. Once you start working u have many ideas come into play. Just try to implement with basic functionality and check. Its not much complex thing.

Any queries just post it here
Thanks
Ganesh

这篇关于离线解决方案和数据同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！