More from our Blog
Why Use Microservices Architecture?
A Practical Guide
What is a Microservices Architecture? Microservices architecture is a style that structures an app as a set of predetermined services. At its core, such app is split into smaller independent segments that perform their own functions. This approach permits to view microservices as a group of undivided apps that handle their own features. As a […]
Maevskiy Konstantine, Starov Yevgen
Why Use Monolithic Architecture?
A Practical Guide
What is monolithic architecture? Monolithic architecture is known as a traditional approach to software development that is based on a single-unit design. This means that a program is basically a self-contained and independent unit. It consists of a database, client-side user interface, and server-side application. As it is possible to clearly see, a monolithic app […]
Konstantyn Maevskiy, Yevgen Starov
Oracle to PostgreSQL migration with AWS SCT: How to convert INSERT ALL statement
In this post we continue exploring the technical aspects of Oracle to PostgreSQL migration using AWS SCT. AWS SCT promises a very high level of migration efforts, however it is very rare that 100% automation is achieved. In this article we’ll look into conversion of INSERT ALL statements, which are quite popular in Oracle code. […]
Oleksii Savchenko
Oracle to PostgreSQL migration with AWS SCT: How to handle unsupported data types
In this post we explore the technical aspects of Oracle to PostgreSQL migration using AWS SCT. We’ll look into conversion of Oracle “aliases”. We were using AWS SCT build #660 to convert one of our Oracle test databases. The challenge Oracle’s subtype declaration allows creating an “alias” for some datatype declaration, which can be re-used […]
Oleksii Savchenko
Preparing a healthcare application for HIPAA audit
HIPAA (Health Insurance Portability and Accountability Act) is one of the most important United States federal statutes which has a great impact on the development of medical software. This act stands for the safety of the protected health information (PHI) and defines security standards that each digitized medical business should follow. HIPAA sets numerous requirements […]
Kirill Karpenko, Roman Muzyka
Migrating from SAS to Big Data for a global retailer
When a global retailer in the beauty industry needed a new and cost-effective data processing solution, they knew the search would require a high level of expertise. That is why they decided to seek advice from ABCloudz. The company had a massive amount of data and utilized SAS software for data processing, both powerful but […]
Andrey Khudyakov (DB architect), Roman Muzyka (writer)
Modernizing advanced engineering application from Oracle to SQL Server
Proprietary database features often create significant obstacles for developers. To demonstrate as an example, we will take a look at one of Oracle’s most valuable proprietary features – Oracle Call Interface (OCI). It ensures efficient communication between the database and the application code. Surely, you may use other options for connecting to Oracle. However, once […]
Andrii Koval
Improving SQL Server statistics update: How do you make it 1000 times faster than traditional approaches?
One of our clients contacted ABCloudz to request help with their SQL Server app’s performance issues. They upgraded from SQL Server 2008 R2 to SQL Server 2019 and began experiencing problems shortly after. We analyzed their database system and discovered a complex issue with updating SQL Server statistics. These stats are used by the Query […]
Roman Muzyka, Andrey Khudyakov
Ready to start the conversation?
ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!
