Conceptual model of the hotelconsolidation process.
The arrows in the diagram represent the process of how the data flows and ends up in SOL (which is the end-goal) and to highlight the processes that are connected to the mastercodes database.
-
The HotelUpdater service pulls the data from the HotelProviders and stores the data into the MasterCodes database.
- The main table of concern is the HotelDescription table. This is the "raw" hoteldata from the providers.
- The HotelConsolidation service reads the data from HotelDescriptions, processes the hotels and updates the consolidation tables.
-
The On-demand sql job reads from the MasterCodes databases and updates Serko Online
-
Mainly converts consolidation tables, but uses additional data from HotelDescription.
The Visio file
HotelConsolidation-Conceptual-Model.vsdx
