More with tags:
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 […]
devops, Databricks, Azure, big-data, data-warehouse, data platform, cloud-migration, business intelligence, SQL Server, Azure Data Factory, ETL, Oracle
EDW to Azure Databricks Migration
ABCloudz recently completed a significant project migrating an Enterprise Data Warehouse (EDW) from an on-premises SQL Server 2014 to Azure Databricks for a leading global retailer operating 3,000 offline stores across 40 countries. This migration was essential for addressing physical server limitations and outdated technology that hindered data processing and storage capabilities. Embracing Big Data […]
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, LLM, text-processing, RAG, NLP, prompt-management, GenerativeAI, higher-education, PostgreSQL, AI case studies
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 […]
CI/CD, deployment, devops, ai, ChatGPT, Amazon Bedrock, Amazon RDS, AWS, LLM, RAG, Embeddings, Neo4j, PostgreSQL, Amazon ECR, backend, GenerativeAI, prompt-management, AI case studies
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 […]
ai, ChatGPT, GenerativeAI, prompt-management, LLM, Amazon Bedrock, RAG, Amazon RDS, Neo4j, PostgreSQL, Embeddings, graphdb, vectordb, AWS, AI case studies
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 […]
AWS, BLE, IoT, firmware, connected-devices, mobile-apps, web-app, application-development, backend, .NET, PostgreSQL, React
Over-the-Air Firmware Updates via Bluetooth for Heavys Headphones
We collaborated with Heavys, a specialized headphone manufacturer for Heavy Metal enthusiasts, to develop a mobile app and web admin panel that allow the company to swiftly and conveniently deliver firmware updates for its headphones over the air. These headphones do more than just play music; they’re designed to precisely render sound, enhanced by continually […]
Case Study: Fast and secure media content delivery with Amazon CloudFront and Lambda@Edge
This case study shows how ABCloudz engineering team resolved site performance issues using Amazon CloudFront and Lambda@Edge of AWS. Challenge Our partner iCleanse offers its clients the Swift UV devices, designed to disinfect hands and mobile phones. As the device disinfects a phone within 15 seconds, it simultaneously displays sponsored video content, generating advertising revenue. […]
Case Study: Boosting Online Building Materials Marketplace Performance with Amazon CloudFront and Lambda@Edge
Our client aimed to develop an online marketplace for building materials, designed to manage intricate online transactions and ensure a top-notch global user experience, supported by stringent security and exceptional performance standards. This case study details how ABCloudz utilized Amazon CloudFront, coupled with Lambda@Edge for dynamic content delivery. By deploying CloudFront, we significantly reduced web […]
machine learning, ChatGPT, LLM, RAG, GenerativeAI, prompt-management, ai, Embeddings, PostgreSQL, Redis, LangChain, ai-model-training
Building an Intelligent Chatbot with OpenAI LLM using RAG
Chatbots as they come are not something new under the sky. They have populated the web since long ago leaving behind an impressive trail of user annoyance and frustration. Wild repetitions, endless question-answer loops, and downright stupidity were the common laments to splash in jokes among the cubicle drones. The only improvements seemed to be […]
SaaS Platform Modernization and Database Migration to PostgreSQL on Amazon RDS
Executive Summary Challenge: To modernize its Project and Portfolio Management (PPM) SaaS platform, OpenText (formerly Micro Focus) made the call to shift its products from on-premises Oracle servers to PostgreSQL on Amazon RDS. They faced various hurdles due to inconsistencies within the database and the legacy architecture of their app. They also requested a reusable […]
Fault-tolerant algorithm for migrations from MySQL to MongoDB
When it comes to seamless data system management, our international IT client needed a solution to migrate their client’s legacy MySQL solution to a fully-managed MongoDB environment. Our team at ABCloudz was up for the challenge and delivered a fault-tolerant algorithm that ensures the migration process is reliable and user-friendly. The need for fault-tolerance and […]
Sophisticated migration of an IT infrastructure from on-premise data center to the AWS cloud
ConcertAI, one of the leading providers of medical research software, faced a common scenario for a mature healthcare data center. Over the years, its infrastructure had become highly sophisticated but inconsistent. Some of the servers were running outdated, end-of-life operating systems and urgently needed upgrading. The client decided to implement a cloud-based solution for infrastructure […]
Custom data migration solution for a complex Oracle to PostgreSQL migration project using AWS DMS
In this post we’d like to share with you our experience in delivering a sophisticated database migration solution on top of AWS DMS for one of our large enterprise customers. The client is a large technology corporation that provides software solutions and services for telecom giants and mid-size companies. They ran numerous Oracle databases where […]
Data management strategy: How to reduce costs and eliminate downtime
Data infrastructure is what powers the proper performance of your software. However, unexpected issues can occur making your system unavailable. That’s where the notion of a downtime, a time period when the system is not available, comes in. Downtime may have different causes and outcomes. But one thing is certain, downtime can be extremely expensive. […]