Skip to content

georgia-tech-db/circleci-testing

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

5 Commits
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

EVA AI-SQL Database System

EVA DB is a database system for building simpler and faster AI-powered applications.

EVA DB is an AI-SQL database system for developing applications powered by AI models. We aim to simplify the development and deployment of AI-powered applications that operate on structured (tables, feature stores) and unstructured data (videos, text, podcasts, PDFs, etc.).

EVA DB accelerates AI pipelines by 10-100x using a collection of performance optimizations inspired by time-tested SQL database systems, including data-parallel query execution, function caching, sampling, and cost-based predicate reordering. EVA supports an AI-oriented SQL-like query language tailored for analyzing both structured and unstructured data. It has first-class support for PyTorch, Hugging Face, YOLO, and Open AI models.

The high-level SQL API allows even beginners to use EVA in a few lines of code. Advanced users can define custom user-defined functions that wrap around any AI model or Python library. EVA DB is fully implemented in Python and licensed under the Apache license.

Quick Links

Features

  • ๐Ÿ”ฎ Build simpler AI-powered applications using short SQL-like queries
  • โšก๏ธ 10-100x faster AI pipelines using AI-centric query optimization
  • ๐Ÿ’ฐ Save money spent on GPUs
  • ๐Ÿš€ First-class support for your custom deep learning models through user-defined functions
  • ๐Ÿ“ฆ Built-in caching to eliminate redundant model invocations across queries
  • โŒจ๏ธ First-class support for PyTorch, Hugging Face, YOLO, and Open AI models
  • ๐Ÿ Installable via pip and fully implemented in Python

Illustrative Applications

Here are some illustrative EVA-powered applications (each Jupyter notebook can be opened on Google Colab):

Documentation

Quick Start

  • Install EVA using the pip package manager. EVA supports Python versions >= 3.8:
pip install evadb
cursor = connect_to_server()
  • Load a video onto the EVA server (we use ua_detrac.mp4 for illustration):
LOAD VIDEO "data/ua_detrac/ua_detrac.mp4" INTO TrafficVideo;
  • That's it! You can now run queries over the loaded video:
SELECT id, data FROM TrafficVideo WHERE id < 5;
  • Search for frames in the video that contain a car:
SELECT id, data FROM TrafficVideo WHERE ['car'] <@ Yolo(data).labels;
Source Video Query Result
Source Video Query Result
  • Search for frames in the video that contain a pedestrian and a car:
SELECT id, data FROM TrafficVideo WHERE ['pedestrian', 'car'] <@ Yolo(data).labels;
  • Search for frames with more than three cars:
SELECT id, data FROM TrafficVideo WHERE ArrayCount(Yolo(data).labels, 'car') > 3;
  • Use your custom deep learning model in queries with a user-defined function (UDF):
CREATE UDF IF NOT EXISTS Yolo
TYPE  ultralytics
'model' 'yolov8m.pt';
  • Chain multiple models in a single query to set up useful AI pipelines.
   -- Analyse emotions of faces in a video
   SELECT id, bbox, EmotionDetector(Crop(data, bbox)) 
   FROM MovieVideo JOIN LATERAL UNNEST(FaceDetector(data)) AS Face(bbox, conf)  
   WHERE id < 15;
  • EVA runs queries faster using its AI-centric query optimizer. Two key optimizations are:

    ๐Ÿ’พ Caching: EVA automatically caches and reuses previous query results (especially model inference results), eliminating redundant computation and reducing query processing time.

    ๐ŸŽฏ Predicate Reordering: EVA optimizes the order in which the query predicates are evaluated (e.g., runs the faster, more selective model first), leading to faster queries and lower inference costs.

Consider these two exploratory queries on a dataset of dog images:

  -- Query 1: Find all images of black-colored dogs
  SELECT id, bbox FROM dogs 
  JOIN LATERAL UNNEST(Yolo(data)) AS Obj(label, bbox, score) 
  WHERE Obj.label = 'dog' 
    AND Color(Crop(data, bbox)) = 'black'; 

  -- Query 2: Find all Great Danes that are black-colored
  SELECT id, bbox FROM dogs 
  JOIN LATERAL UNNEST(Yolo(data)) AS Obj(label, bbox, score) 
  WHERE Obj.label = 'dog' 
    AND DogBreedClassifier(Crop(data, bbox)) = 'great dane' 
    AND Color(Crop(data, bbox)) = 'black';

By reusing the results of the first query and reordering the predicates based on the available cached inference results, EVA runs the second query 10x faster!

Architecture Diagram

This diagram presents the key components of EVA DB. EVA's AI-centric Query Optimizer takes a parsed query as input and generates a query plan that is then executed by the Query Engine. The Query Engine hits multiple storage engines to retrieve the data required for efficiently running the query:

  1. Structured data (SQL database system connected via sqlalchemy).
  2. Unstructured media data (on cloud buckets or local filesystem).
  3. Vector data (vector database system).
Architecture Diagram

Screenshots

๐Ÿ”ฎ Traffic Analysis (Object Detection Model)

Source Video Query Result
Source Video Query Result

๐Ÿ”ฎ MNIST Digit Recognition (Image Classification Model)

Source Video Query Result
Source Video Query Result

๐Ÿ”ฎ Movie Emotion Analysis (Face Detection + Emotion Classification Models)

Source Video Query Result
Source Video Query Result

๐Ÿ”ฎ License Plate Recognition (Plate Detection + OCR Extraction Models)

Query Result
Query Result

Community and Support

๐Ÿ‘‹ If you have general questions about EVA, want to say hello or just follow along, we'd like to invite you to join our Slack Communityand to follow us on Twitter.

EVA Slack Channel

If you run into any problems or issues, please create a Github issue and we'll try our best to help.

Don't see a feature in the list? Search our issue tracker if someone has already requested it and add a comment to it explaining your use-case, or open a new issue if not. We prioritize our roadmap based on user feedback, so we'd love to hear from you.

Contributing

PyPI Version CI Status Documentation Status

EVA is the beneficiary of many contributors. All kinds of contributions to EVA are appreciated. To file a bug or to request a feature, please use GitHub issues. Pull requests are welcome.

For more information, see our contribution guide.

License

Copyright (c) 2018-present Georgia Tech Database Group. Licensed under Apache License.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages