Founded in 2008 in the Silicon Valley of USA, Pervasync specializes in database synchronizations for Oracle, MySQL and SQLite databases. The name “Pervasync” was derived from the words “Pervasive” and “Synchronization” indicating that our products enable you to run smaller databases on pervasively available devices while keeping them in sync with a bigger central database. Based on deep understanding of the synchronization problem, we created the innovative sync solution that has brought pleasant surprises to enterprise database users who had been treading water with their previous third party or homemade sync solutions.
One current trend in computing is the proliferation of mobile devices. As the devices become more and more capable and pervasive, it is getting both feasible and necessary to run a database system on the devices for the management of the large amount of data that could be stored locally on devices. The device databases would need to exchange data with a central database for data backup, data collection and data distribution purposes. The exchange of data between the local and central databases is called database synchronization. Another trend in computing is the globalization of economy in which an enterprise’s geographically distributed employees, partners and customers access central servers via the Internet. All is good until there is a poor Internet connection or a network outage. More and more enterprises are considering adding local servers to resolve this issue. Here again, the databases of the local servers and those of the central servers need to be synchronized in order to have the best of both worlds: fast, reliable access to the information and centralization of the information.
Pervasync software provides a data synchronization infrastructure for synchronizing distributed local databases with a central database. It supports SQLite (on Android and Blackberry devices), MySQL and Oracle databases (including Express, Standard and Enterprise editions). Typically you would run MySQL or the Oracle Enterprise Edition on the server side (in your data center or in the Cloud), while on the client side (Linux, Windows desktops, laptops, netbooks, mobile devices), you may choose SQLite, MySQL, the Oracle Express Edition or the Oracle Standard Edition.
The Pervasync data synchronization server and client for MySQL and Oracle are written in pure Java. They can run on any platforms that support Java SE. This includes Windows, Linux and Mac OS X. The sync clients for Android and Blackberry devices are written in OS native Java. Sync clients could run in standalone mode or be embedded into your client applications on devices.
Pervasync server comes with a web based admin console for administrators and developers to create publications and subscriptions of the sync objects. On the device side there is a sync client GUI application for end users to start or schedule synchronization sessions. The sync system can be set up quickly and you can get your central DB synchronized with your local databases without writing a single line of code. Nevertheless, we also provide client and server Java API that can perform the same tasks in case you need to integrate the sync functionality seamlessly with your applications.
From ground up, the system is designed to support data subsetting, so that each client can synchronize its private data as well as shared data with a central server. We introduced the concept of logical transaction for synchronization of the data subsets. Server side logical transactions are computed using the state comparisons of the data subsets. They are used to refresh client side data. Client side logical transactions are tentative and local until they are checked-in on server. The logical transaction based synchronization scheme contrasts with traditional physical transaction based replication schemes, which do not apply to subsets of data and cannot scale due to divergences.
Last but not least, the biggest differentiators of Pervasync compared with other sync solutions are performance and scalability. The number of sync clients and amount of data in your organization tend to grow rapidly over time. So it is important to test the scalability of the sync solutions before you commit to one of them. We are confident that Pervasync will stand out in your tests.