Database Development Expertise
The most of the applications we developed have access to database storages like Microsoft SQL Server, MySQL, Oracle, PostgreSQL or Sqlite.
We provide the following database related services:
- Logical and physical design
- Indexing strategy development
- Queries and T-SQL development
- Queries optimization and performance tuning (also for hopeless ones)
- Backup and recovery strategy development
- Replication development
- Update and migration applications
- Local and in-memory storages
- Integration with reporting and business intelligence services
Using developed databases we implement reporting modules with Microsoft Reporting Services, JasperReports, Crystal Reports etc. Developed reports have user-friendly design, required data content, graphics and are friendly to export in Word, Excel, PDF, HTML formats.
To support business intelligence in applications we can implement OLAP solution with Microsoft Analysis Services. Developed solution provides access to cubes data, calculates KPI, and also the queried data can be used in reporting module.
The description of our projects is available upon request within the Customer Workspace.