Blog

One of our customers aimed to modernize their on-premises project and replace the aging AS/400 system with Microsoft SQL Server. Having an enormous amount of code, the existing program was almost maintainable and cried for a smart solution. DB Best developed a brand-new way to manage epic projects. We required a smart solution to optimize costs and streamline the process. Our team leveraged the latest DevOps practices to create a solution that allows for managing the epic systems in layers. […]

Every retailer knows that product position within their store has a direct influence on revenue. But how do you apply this knowledge? Would you win more by selling a batch of cheaper goods or a few high priced items? Will the product placed on the same position in two different outlets get equal attention from the consumers? DB Best leveraged neural networks and machine learning algorithms to develop a solution that allows for increasing sales and doubling the retailer’s revenue […]

For retail businesses with distributed point of sales (POS) systems, you can often run into the problem where stores fail to synchronize their data with the centralized data warehouse. If you are not aware of this situation, you can end up taking faulty business decisions when making seasonal adjustments for your supply chain. The top-selling product for the last week at a given store ends up not getting resupplied. Even worse is when last week’s hot seller, no longer is.

In this blog post, we’ll discuss how machine learning anomaly detection for retail POS systems can identify sites that fail to consistently report data into a centralized data warehouse.

DB Best has released a new version of Migration Platform, a well-rounded program for automating database migration processes. This newer 1.2 version improves error handling practices for Test Organizer by creating additional mapping rules for matching different error messages and codes. We also added the partial data backup and restore functionality along with the capability to add and remove tables from existing datasets for the Data Store module. On top of that, we enabled command timeouts for several major modules.

In this blog post, we describe how we applied our knowledge in machine learning and computer vision to prevent one of the most common safety breaches among builders. The DB Best team came up with a solution utilizing the YOLO object detection algorithm for a neural network to detect those not wearing hard hats on a construction site. Our algorithms reached 98% accuracy in identifying troublemakers analyzing video materials in real-time!

DB Best has released a new version of Database Compare Suite. This version supports MariaDB, a popular fork of MySQL database platform. Another major improvement of the latest release is virtual views. Read this blog post to discover how to use these data objects and when you need to create them.

For mobile healthcare applications with many connected devices, complex database migration projects, and huge enterprise-level desktop multiplatform products, a solid DevOps environment is critical. In this blog, we’ll show how we used the TestNG and Appium frameworks for mobile app test automation using a CI/CD pipeline. We’ll also look at how we used AWS CloudFormation and PowerShell to deploy the test environment as well. The result was a 3.6 times reduction in testing person-hours and a reduction of the full-regression test cycle time by 25%.

This case study features our experience of measuring data science algorithms to optimize the ETL processing for data cleansing.

In this blog, our Chief Technology Storyteller Bill Ramos shows how to use the array sub-expression operator and “splatting” with hash tables to build the parameters needed for the Invoke-Sqlcmd cmdlet.

DB Best released a new version of Migration Platform, our ultimate product for automating database migrations. In this release we added new features to the Test Organizer module, a unique and unrivaled feature of the DB Best Migration Platform. We also made several improvements of the user interface. Read this blog post to learn more about these new application features.