Redis Search and SQL Query Comparisons

Contents

1. Summary
2. Features
3. Prerequisites
4. Installation
5. Usage

Summary

This is a series of comparisons of equivalent SQL and Redis Search commands against the Chinook dataset. Oracle Enterprise (OE) is used as the relational database with Redis Data Integration (RDI) used to populate a Redis Enterprise (RE) database via Change Data Capture (CDC.)

Features

• Builds out a full RE with RDI and OE environment to include: 1-node RE Cluster, 1-node OE, and RDI.

Prerequisites

• Ubuntu 20.x
• Docker Compose
• Docker
• python3
• java
• nodejs
• .net
• Oracle container registry credentials

Installation

git clone https://github.com/redis-developer/search-sql.git && cd search-sql

Usage

Docker Containers Start-up

./start.sh

Docker Containers Stop

./stop.sh