DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

Yellowbrick


Yellowbrick is a relational data warehouse that is optimized for flash-based storage.[04][05][06]

Country of Origin
US
Start Year
2014 [11]
Project Type
Commercial
Written in
C, C++, Go, Java, Python
Derived From
PostgreSQL
Compatible With
PostgreSQL
Operating Systems
Hosted, Linux
License
Proprietary

Database Entry

Yellowbrick


Yellowbrick is a relational data warehouse that is optimized for flash-based storage.[04][05][06]

Concurrency Control


Data Model


Foreign Keys[07]


Hardware Acceleration


Indexes


Joins[08]


Yellowbrick supports hash, sort-merge, and nested loop joins.

Query Compilation[06]


Yellowbrick partitions query plans into segments and converts them into C++ code. Segments are then compiled into machine code in parallel using a modified version of LLVM which is memory-resident with its ASTs pre-loaded. Compiled object files are cached and reused.

Query Execution


Query Interface


SQL

Storage Architecture


Storage Model


Stored Procedures[09]


Yellowbrick supports PL/pgSQL stored procedures (CREATE PROCEDURE) but not user-defined functions (CREATE FUNCTION). Unlike in PostgreSQL, stored procedures in Yellowbrick can return values and be called from SELECT statements, but only when there is no table-referencing FROM clause.

Triggers are not supported.

System Architecture


Views[10]


Yellowbrick supports virtual views only.

Derivative Systems
Floe Floe

Citations

11 sources
  1. Yellowbrick SQL Data Platform | Secure. Efficient. Anywhere yellowbrick.com
  2. https://yellowbrick.com/docs yellowbrick.com Dead — Check Archive
  3. Yellowbrick Data - Wikipedia wikipedia.org
  4. Yellowbrick Data Enters Cloud Data Warehouse Wars - eWEEK eweek.com
  5. https://yellowbrick.com/yellowbrick-data-warehouse/ yellowbrick.com Dead — Check Archive
  6. Inside the Yellowbrick Data Warehouse - Yellowbrick data yellowbrick.com
  7. https://docs.yellowbrick.com/6.1/ybd_sqlref/create_table_examples.html yellowbrick.com Dead — Check Archive
  8. Yellowbrick: An Elastic Data Warehouse on Kubernetes (Mark Cusack) - YouTube youtube.com
  9. https://docs.yellowbrick.com/6.1/ybd_sqlref/create_procedure.html yellowbrick.com Dead — Check Archive
  10. https://docs.yellowbrick.com/6.1/ybd_sqlref/create_view.html yellowbrick.com Dead — Check Archive
  11. https://www.crunchbase.com/organization/yellowbrick-data crunchbase.com
Revision #15 Last Updated: