AI Solution

Building a Recommendation Engine with Oracle Autonomous Database and Generative AI


This workshop uses natural language and large language models (LLMs) hosted by Oracle Cloud Infrastructure (OCI) Generative AI to analyze an organization’s private data in Oracle Autonomous Database. The project will be published as a RESTful service that can then be invoked from any application. A React app is used to surface the analytics.

In our scenario, customers of MovieStream—a fictitious movie streaming company—will receive a targeted promotion with recommended movies. The recommendations will be generated by the LLM, based on movies that the customer previously enjoyed. The promotional offer, based on the customer’s geographic location, will use Autonomous Database’s spatial APIs. Architecturally, this workshop creates an open RESTful service that generates the targeted offer.


Demo: Use Generative AI to analyze your data in Autonomous Database (1:38)

Prerequisites and setup

  1. Oracle Cloud account—sign-up page
  2. Oracle Cloud Infrastructure—documentation
  3. OCI Generative AI—documentation
  4. Oracle Autonomous Database—documentation
  5. Your tenancy subscribed to the US Midwest (Chicago) region