The solution includes 4 databases apart from databases supporting embedded services such as SQL Server Reporting Services, Data Collection, SSIS Catalog, etc.
The databases contain operative information about horse racing in Great Britain, Ireland and some other countries and contain information about race schedule, participants (horses, jockeys, trainers), analytical data about them, odds etc., as well as horses, their pedigrees, the amount of prize money earned, statistics, etc.
The SQL Server instance processes the input data about races, competitors and bets, calculates various analytical metrics, validates data. It also manages completely the crawlers and bets runs by SQL Server Agent jobs and its scheduler. SQL Server Agent sends requests for a crawler start using stored procedures from SSIS catalog invoking the Web Service Task.
The SQL Server Reporting Services Reports contain reports which show current state of the system.
More than 400 SQL Server Agent jobs perform tasks for the crawlers and bots start, the database maintenance, totals calculation, data verification, notification about errors and failures etc.
Tools and Technologies