Selective Database Replication in unstable Environments

Abstract

Cloud based systems like SaaS offer many advantages, as long as the internet connection is fast and stable. This study focus on this disadvantage and introduces a on-premise server solution, focusing on the database, where data is synced to and from a cloud back-end. The study have successfully developed and implemented an algorithm, allowing for selective one-way sync, and to only use necessary bandwidth where the term necessary has shifted into meaning quite little . The selective one-way sync functions exactly as the requirement specification suggest, keeping data from getting into wrong hands. A sample software solution have been implemented as a "proof-of-concept", utilizing features like message queues for scalability. The implemented solution requires scarce resources, making it a good fit for commodity hardware as well as cloud-scale environments.