Database services

  • Support, design and creation of databases: MS SQL, MySQL, Access, etc. Providing security, consistency and availability of data for end-users.
  • Research and analysis, modification and testing, deployment of new features and further maintenance of existing databases and their applications created in c#, php, VBA, etc.
  • Creating specifications for software products, as well as writing and implementing effective code.
  • Development and implementation of data quality control (QA/QC) procedures.
  • Migration of existing solutions to more modern or suitable technologies, which may include Azure hosted databases or other cloud front-end platforms.
  • Creation of new and support of existing input forms, automation of processes and query optimization.
  • Development and support of data import (several types of sources, various types of files and various data formats), export and subsequent updating processes.
  • Creation and support of SQL stored procedures.
  • Cleaning and bringing to a state of consistency of historical data in databases.
  • Working with cloud-based DB, providing access to them, including from mobile devices for collecting field data.
  • Optimization of reporting processes.

Acceleration of SQL queries

Sometimes an SQL query is executed for a long time, unnecessarily filling the server's RAM and spinning disks into unnecessary dances.

How to increase the efficiency of requests and reduce their resource intensity?

  • Building the right data structure: the structure should correspond to the business objectives of the application, from the point of view of the relational paradigm, be close to 3NF, linking tables by surrogate keys, etc..
  • Semantic query optimization:
    • disclosure of views (abandoning view and returning to tables, if that makes sense),
    • conversion of subqueries into joins,
    • descent of predicates (selection should be performed before joining, if possible),
    • etc...
  • Correct indexing of fields in tables.
  • Clustering of related tables.
  • Partitioning/partitioning/fragmentation/segmentation of tables and indexes.
  • Segmentation of tables.
  • Clustering of database servers (when writing is done on the master, and reading is done on replicas).
Learn More