Synchronyzation of heterogeneous database systems

Tomaž Kravcar (2015) Synchronyzation of heterogeneous database systems. EngD thesis.

Preview

PDF Download (12Mb)

Abstract

The thesis describes the mechanism for data synchronisation between different relational data servers of a business operating system on one side and different relational data servers of a web store on the other. In other words, this denotes the synchronisation between any business operating system with any web store. In addition, a very similar concept could be introduced for synchronisation of other information systems. However, the synchronisation between a business operating server and a web store must have a wider scope than the mere data exchange at the level of the relational database. Nevertheless, the thesis will mainly deal with this level and certain support mechanisms in the Delphi environment, and briefly mention other mechanisms necessary for the synchronisation as a whole. In terms of content, the thesis first presents the global functioning concept, which is explained in more detail later on and used as a concrete example. As for the functional aspect, the thesis focuses on the synchronisation of stock, prices and orders, which are the core of the synchronisation between the business operating system and the web store. On a related note, the same or similar logic may be applied to other functions and areas of synchronisation. The main idea for this type of synchronisation was based on practical experience and actual needs expressed by different business entities who have been using the Pantheon software. The idea was further explored in this thesis and it is our hope that it will become fully implemented sometime in the future.

Actions (login required)