Yellowbrick Data was founded in 2014 by Neil Carson, Jim Dawson, and Mark Brinicombe to bring to market a next generation flash storage optimized data warehouse.
Yellowbrick’s first product used hardware consisting of analytic blades with both NVMe flash storage and high performance CPUs, with the blades connected by a high-performance internal network.
The system includes a purpose built execution engine with a primary column store, built in compression, as well as erasure encoding for reliability. The Yellowbrick Data Warehouse supports ANSI SQL and ACID reliability by using a Postgres based front end, allowing any database driver or external connector which supports Postgres to work without modification. The all-flash architecture claims performance and predictability benefits compared to other data warehouses.
In 2019, the company launched two new products – the Yellowbrick Cloud Data Warehouse, and Yellowbrick Cloud DR.The Cloud Data Warehouse is a full service offering run by Yellowbrick using its own hardware available to applications running in AWS, Azure, and GCP public clouds through dedicated network links.This product allows the same speed and reliability advantages as the Data Warehouse, and complements the on-premises product. Cloud DR allows replication of on-premises datasets to the cloud service, or between cloud services at multiple physical locations.
Db2 is a family of data management products, including database servers, developed by IBM. They initially supported the relational model, but were extended to support object–relational features and non-relational structures like JSON and XML.
Amazon Redshift is a data center product that is part of the broader Amazon Web Services cloud-computing network. The name implies moving away from Oracle, with red being an allusion to Oracle, whose corporate color is red and known informally as "Big Red."
BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service that supports querying using ANSI SQL. It also has built-in machine learning capabilities. BigQuery was announced in May 2010 and made generally available in November 2011.
Amazon Aurora is a relational database service developed and offered by Amazon Web Services beginning in October 2014. Aurora is available as part of the Amazon Relational Database Service.
Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.