You Can contact us by filling the form below:

Thank you, your message was sent successfully!

Please, wait our respond.

Sorry, the error has occured.


You Can contact us by filling the form below:

Thank you, your message was sent successfully!

Please, wait our respond.

Sorry, the error has occured.


Horse racing database

ABOUT


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.

 

 

PROPERTIES


Databases: 4
Total size: ~ 55 Gb
Number of tables: ~ 140
Number of views: 20
Number of stored procedures: ~ 320
Number of user-defined functions: 60
Number of assemblies: 2

Features


Common language runtime (CLR) stored procedures and functions
SQL Server Agent jobs
SQL Server Reporting Services reports
SQL Server Integration Services packages and catalog

 

EFFORT


1000 man-hours

 

Services


Stored procedures
Triggers
Jobs
Linq to Entities
CLR objects
Database Upgrade
Data Merge
Database Optimization
Database Deployment
Query tuning
Performance Troubleshooting
Reporting solutions

Tools and Technologies


Contact us
Feel free to contact us.
Our work hours:
Monday-Friday 8am - 8pm

Thank you, your message was sent successfully!

Please, wait our respond.


Sorry, the error has occured.


Our location:

Megapolis Office Center, Office 607,
Moskovskiy av. 179-B Kharkiv, 61068, Ukraine