abcloudz

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 […]

Faster, Cheaper Multi-Cloud CI/CD Pipeline

In this blog post, we will introduce our custom multi-cloud CI/CD (continuous integration and continuous delivery) pipeline, built to facilitate the deployment of applications across various cloud environments. Our solution allows seamless deployments with minimal customization, ensuring faster results and reduced costs for our clients. Whether working with AWS, Azure, or Google Cloud, we can […]

AWS Confirms The High Quality of Our GenAI Solutions

At ABCloudz, we are committed to delivering quality and trustworthiness in every solution we create. Recently, two of our AI-powered solutions, Natural Language Interface for Data Platform and AI Text Classification and Matching, successfully passed the rigorous AWS Foundational Technical Review (FTR). This achievement validates our technical expertise and reinforces our commitment to delivering reliable, […]

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 […]

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 […]

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. […]

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 […]

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 […]

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 […]

Calculate the Total Cost of a RAG-Based Chatbot 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. How to estimate the cost of a RAG chatbot correctly? Start by separating infrastructure, model usage, embedding usage, and expected traffic, then calculate each layer on its […]

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 […]

ABCloudz achieves Amazon CloudFront Delivery Partner Status

We are thrilled to announce that ABCloudz has achieved the status of Amazon CloudFront Delivery Partner as of early June. This prestigious recognition by AWS underscores our deep expertise in content delivery network (CDN) services and our commitment to providing top-notch solutions that adhere to the highest industry standards. Achieving the Amazon CloudFront Delivery Partner […]

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 […]

Dusker Audio Integration with Sleepbar via BLE

This story is about our collaboration with Dusker, a renowned company dedicated to creating audio products that enhance bedtime experiences. Dusker’s Sleepbar v2.0 is a standout innovation in their product line. This advanced sleep speaker uses bone conduction technology to deliver audio directly through a pillow, making it ideal for listening to music, audiobooks, sleep […]

The Smart Water Bottle Solution

Imagine a bottle that does more than just hold water—a bottle that communicates with your smartphone, tracks your hydration levels, and nudges you towards healthier habits while conserving the environment. That’s the reality we’ve created with a solution that marries the simplicity of hydration with the complexity of technology. By integrating the bottle with iOS […]
12345...

Hi there! How can I help you?