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.


Crawlers database

ABOUT


The solution has 6 databases on 2 local servers and 2 servers in Azure. apart from databases supporting embedded services such as SQL Server Reporting Services, replication, Data Collection etc.

 

The databases contain information about products collected from sites, namely: name, ID, model, manufacturer, category, price, short description, ratings and reviews etc. Processed and aggregated data is stored in the databases aimed at further usage for business analysis. These data warehouses are needed for calculation of certain macro indicators, such as the dynamics of the products number on the website, manufacturers’ ranking, price index, etc. The aggregated data is replicated to a local webserver where it is accessed for customers via SQL Server Reporting Services Reports and into Azure SQL Database where it is accessed via a web-site developed using ASP.NET technology and DevExpress controls.

 

More than 100 SQL Server Agent jobs perform tasks for the database maintenance, replication, totals calculation, keeping up to date the list of proxy servers, etc.

 

 

PROPERTIES


Databases: 8
Total size: ~1200 Gb
Number of tables: ~ 480
Number of views: ~160
Number of stored procedures: ~550
Number of user-defined functions: ~150
Number of assemblies: 36

Features


Common language runtime (CLR) stored procedures and functions
SQL Server Agent jobs
SQL Server Reporting Services reports
SQL Server Integration Services packages
Partitioning
Replication
OLTP In-Memory tables and stored procedures

 

EFFORT


5000 man-hours

 

Services


Database development
Database support
Data analysis
Stored procedures
Triggers
Data export
Data import
Execution plans
Linq to SQL
Jobs
Linq to Entities
CLR objects
Database Upgrade
Database Replication
Database Repair
Data Merge
Database Optimization

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