Building a Semantic Search API with MySQL Vector Search, Oracle Cloud, and an NBA Kaggle Dataset

Semantic search enables users to ask for “a 3-and-D wing who can guard multiple positions” (as described in The Kings Beat article) and retrieve the correct NBA players, rather than simply a keyword match on “3,” “wing,” or “defense.” By combining MySQL Vector Search, Oracle Cloud’s Generative AI Embeddings, and a real NBA dataset from Kaggle, you can build a powerful natural-language search API that understands the meaning behind a query.As I love sports, I think this would be a great demonstration. In this tutorial, you’ll build: We’ll use the…

Hands-On Implementation: Building Big Data and Analytics Solutions with Oracle Autonomous AI Database and Oracle Analytics Cloud (OAC)

Modern data analytics projects often take place in shared or restricted Oracle Cloud Infrastructure (OCI) environments, where not all users have administrative privileges. In such cases, demonstrating an end-to-end data pipeline from data ingestion and transformation to visualization can seem challenging. This post uses Oracle Autonomous AI Database (AADB) , the evolution of Autonomous Data Warehouse (ADW) and ATP, along with Oracle Analytics Cloud (OAC). It highlights how users can still build and test data engineering workflows without elevated IAM permissions or access to Oracle Data Flow or Big Data…

Implementing the Model Context Protocol (MCP) in Oracle Database 26ai

As applications using AI evolve, databases are no longer just data stores since they are becoming intelligent endpoints that can interact directly with large language models (LLMs) and AI agents. The Model Context Protocol (MCP) is the key standard that makes this possible: it provides a uniform way for AI agents to query, reason, and act on data sources such as relational databases. In this post, I will walk through two practical implementations of MCP: Finally, we will take a look at a concise rundown of what changed from Oracle…

52 Kilometers, Two Races, One Cloud Migration — Stockholm Marathon Meets MySQL HeatWave and Oracle DB 23ai

At Oracle Sweden, we take health and wellbeing seriously — so seriously, in fact, that many of us participated in both the Stockholm Marathon and Blodomloppet in 2025 as part of our internal Oracle Run Club. These events not only reflect our commitment to wellness but also serve as a perfect opportunity to demonstrate how Oracle’s modern cloud technologies can support real-world, diverse data use cases. Oracle is no longer just a relational database company — it now delivers powerful cloud-native services, including MySQL HeatWave and Oracle Database 23ai, both…

Master the “Become an OCI AI Foundations Associate (2024)” Exam with Oracle’s Free Course

If you’ve ever been curious about Artificial Intelligence (AI), Machine Learning (ML), and Generative AI but felt intimidated by the technicalities or lacked prior experience, Oracle has just made it easier for you to step into the AI space. Oracle’s OCI AI Foundations Learning Path is designed to guide you through the fundamental concepts of AI, ML, Deep Learning, and Generative AI with a practical approach using Oracle Cloud Infrastructure (OCI). Even better, it’s tailored for beginners with no prerequisites—no coding, no prior experience required. Why This Course is a…

From Stockholm Marathon to Multi-cloud (OCI, AWS, Azure, GCP) Strategy

Running a marathon is a monumental undertaking. Even though I had been preparing for 1.8 years, it wasn’t until a few weeks ago that I truly grasped the significance of this feat. The turning point came when I made the decision to run for a charity organization in Brazil, specifically Casa da Crianca Paralítica de Campinas (https://www.ccp.org.br/web/). This organization provides vital medical, dental, and pedagogical support to children with physical and mental disabilities in Campinas, Sao Paulo State, Brazil. Moreover, during my preparations, I delved into the origin of the…

Installing Oracle Database on macOS using Oracle Docker Images

Technology is constantly evolving, and with it, the methods of installation have changed. For DBAs who once relied on CDs or diskettes to install Oracle databases, the ability to quickly and easily create and deploy a database using Docker images provided by Oracle is truly impressive. In this post, I will cover the deployment of Oracle database 18.4 using the free and simplified edition, Oracle Express, on MacOS Monterrey 12.6.5. To begin, I would like to share the necessary tools that one must download in order to achieve this goal.…

Oracle Cloud: Sign up failed “Error processing transaction”

I have already configured many accounts to use Oracle Cloud. Especially, since December 2020 I started to face some problems on the step where you must provide a credit card to simulate a payment but in fact, it works like a personal identification. So I have used the same card that I used previously in some setups, two other new cards and even asked some friends in different countries using their own cards and some of them have experienced the same erros while others could create their account successfully. Follow…

Example of how to use Oracle Cloud Infrastructure (OCI) Gen 2 with Terraform – Macbook Pro OS – part 2

This is the second article of these series where I will be covering the use of Terraform with Oracle Cloud Infrastructure from scratch. If you haven’t seen the first article I do recommend you check it out here https://www.techdatabasket.com/2020/10/21/example-of-how-to-use-oracle-cloud-infrastructure-oci-gen-2-with-terraform-macbook-pro-os-part-1/ , before you proceed with the following steps here. On the first article, how to create your account at Oracle Cloud was shown and a glimpse on Terraform. Now we are going through some examples that show what Terraform can really do while using it with OCI. So, let’s try to build an…

Example of how to use Oracle Cloud Infrastructure (OCI) Gen 2 with Terraform – MacBook Pro OS – part 1

Terraform is becoming more and more relevant in DBA’s activities. Therefore, I decided to start a series of articles where I will be covering the use of Terraform with Oracle Cloud Infrastructure from the scratch. It is important to mention that both Oracle Infrastructure and Terraform has been evolving daily and modifications on the steps can arise after a while. The steps here are from October 2020 and may be accurate for the next nearest months. Before we start let’s learn new concepts. What is Terraform? To answer this question…