More from our Blog
solution-design, database-migration, modernization roadmap, Ora2Pg, Oracle to PostgreSQL migration, oracle-workload-migration, PostgreSQL, aws-sct, PowerBI, ETL
Solution design for banking system migration
When it comes to complex database migrations, especially for mission-critical systems in the financial sector, cutting corners in the early stages can turn into an expensive gamble. Yet, we often encounter organizations that view the discovery and solution design phase as an optional step — one they can skip or downsize to save time or […]
Oleksii Svitlychnyi
Performance upgrades in PostgreSQL 17
PostgreSQL continues to be the database of choice for applications demanding high performance, reliability, and scalability. The release of PostgreSQL 17 further reinforces these capabilities, bringing a series of targeted performance enhancements that directly address common pain points — reducing memory usage, optimizing complex queries, and accelerating data scanning. In this post, we’ll dive into […]
Oleksandr Polyvanyi
JSON upgrades in PostgreSQL 17
PostgreSQL 17 significantly expands its JSON support, empowering developers to work effortlessly with semi-structured data directly within SQL. In this article, you’ll discover how the new JSON_TABLE() function and extended JSON Path capabilities simplify data extraction, transformation, and filtering, making JSON in PostgreSQL feel like a first-class relational citizen. Whether you’re dealing with deeply nested […]
Oleksandr Polyvanyi
Incremental backups in PostgreSQL 17
Effective database backups are crucial for protecting data integrity and ensuring swift recovery. PostgreSQL 17 introduces a significant upgrade in the form of incremental backups, providing a faster, storage-efficient alternative to traditional full backups. In this article, you’ll not only learn how incremental backups work in PostgreSQL 17 but also discover why they may completely […]
Oleksandr Polyvanyi
oracle-workload-migration, solution-design, Microsoft Azure, Oracle, Oracle to SQL Server, Oracle to PostgreSQL migration, database-migration, architecture
Press Release: ABCloudz's Oracle Workload Migration Solution Now Available in the Microsoft Azure Marketplace
Microsoft Azure customers worldwide now gain access to ABCloudz’s Oracle Workload Migration services to take advantage of the scalability, reliability, and agility of Azure to drive application development and shape business strategies. ABCloudz, a global leader in data migration and modernization, today announced the availability of its Oracle Workload Migration offerings in the Microsoft Azure […]
Adam Robertson
database-migration, SaaS, Data-warehouse, data-lake, ETL, application-modernization, aws, Oracle to PostgreSQL migration, cloud-migration, PostgreSQL, Oracle, Improving the performance, AWS Batch, Amazon S3
Modernizing the Oracle ODS Data Warehouse for SaaS flexibility with PostgreSQL on AWS
Imagine trying to keep up with the evolving needs of higher education institutions while ensuring your systems are cost-effective and scalable. This was the challenge faced by our client, a company providing a suite of software solutions for educational institutions. They needed to modernize one of their core components—an Operational Data Storage (ODS) system, which […]
Oleksii Savchenko (DB Developer), Oleksii Svitlychnyi (Technical writer)
aws-sct, aws, Database conversion errors, database-migration, Ora2Pg, Oracle to PostgreSQL migration, Oracle, PostgreSQL
Database migration with AWS SCT: Solutions for typical conversion issues
Migrating Oracle databases to PostgreSQL or MySQL with AWS Schema Conversion Tool (AWS SCT) can present a range of challenges, from unsupported data types to limitations in automated code conversion and potential performance issues. AWS SCT offers powerful capabilities to automate these migrations, but it may not always deliver optimal results or handle complex Oracle […]
Oleksii Svitlychnyi
Handling null and empty string differences in Oracle and PostgreSQL
When migrating from Oracle to PostgreSQL, one of the most important differences to consider is the treatment of null and empty string values. In Oracle, null and empty string are treated as the same entity, but in PostgreSQL, they are distinct. Failing to account for this distinction during migration can lead to logical errors and […]
Oleksii Savchenko
Handling PostgreSQL Routines with More Than 100 Arguments
When working with PostgreSQL, database developers may encounter a limitation when attempting to create routines with more than 100 arguments. PostgreSQL enforces this restriction by setting FUNC_MAX_ARGS to 100 during the server build. Although this limitation is rarely an issue, complex procedures, particularly those migrated from Oracle, may have a significantly higher number of arguments. […]
Oleksii Savchenko
How to Optimize Oracle-to-PostgreSQL Migrations Using AWS SCT Extension Pack
The AWS SCT Extension Pack is designed to emulate Oracle’s system functions, procedures, and other database objects within PostgreSQL. This emulation is achieved by creating a special schema in PostgreSQL, named aws_oracle_ext, where these functions and objects are stored. This pack simplifies migration by replacing Oracle-specific calls with their PostgreSQL equivalents, ensuring that the code […]
Oleksii Savchenko
Natural Language Interface for Data Platform
Imagine a business analyst whose task is to extract necessary information from a data warehouse to generate various reports. They need to be proficient in crafting SQL queries of any complexity—a challenging and time-consuming feat that requires deep understanding of database structures and SQL language. But what if this business analyst had an AI assistant […]
Maksym Kurhanetskyi, Oleksii Svitlychnyi
AI Text Classification and Matching for Better Decisions
Picture this: You have an AI-powered assistant that helps manage your team’s growth. It works with three types of text data: job descriptions, employee skills, and training programs. You give it a job description and an employee’s skill set, and it pinpoints the perfect training programs to bridge any skill gaps. It’s like having a […]
Maksym Kurhanetskyi, Oleksii Svitlychnyi
ai, LLM, RAG, Amazon Bedrock, chatgpt, Embeddings, aws, Application Development, GenerativeAI, prompt-management
Calculate the Total Cost of a RAG-Based Solution
This blog post examines the operational expenses of the AI-powered chatbot solution introduced in our previous blog posts, Custom AI chatbot using RAG and Deployment of AI-Powered Chatbot. This solution operates on the AWS cloud while integrating OpenAI’s language model. We will discuss the financial aspects of infrastructure costs and analyze how to estimate expenses […]
Oleksii Svitlychnyi
CI/CD, deployment, devops, ai, chatgpt, Amazon Bedrock, Amazon RDS, aws, LLM, RAG, Embeddings, Neo4j, PostgreSQL, Amazon ECR, backend, GenerativeAI, prompt-management
Deployment of AI-Powered Chatbot
This blog post focuses on the architecture and deployment of the AI-powered Chatbot solution that we described in our earlier blog post Custom AI Chatbot Development Using RAG. This solution is built for the AWS cloud but uses OpenAI as an LLM. We’ll dive deep into the CI/CD process and AWS deployment architecture of the […]
Kostiantyn Odynets, Oleksii Svitlychnyi
ai, chatgpt, GenerativeAI, prompt-management, LLM, Amazon Bedrock, AWS, RAG, Amazon RDS, Neo4j, PostgreSQL, Embeddings, GraphDB, VectorDB
Custom AI Chatbot Development Using RAG
You have probably seen and heard about AI-powered chatbots that can converse with the user about website content, or some piece of knowledge related to a company. The world is full of buzz on all things AI, with chatbots driving the headlines. In this article, we’ll share our experience building a full-blown solution from scratch […]
Maksym Kurhanetskyi, Oleksii Svitlychnyi
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!