What is Cost-based Optimization?

• Apache Calcite

  28 4,376 9.0 Java

  Apache Calcite

  

In Apache Calcite, the cost is modeled as a scalar representing the number of rows being processed.

• Apache Spark

  101 38,414 10.0 Scala

  Apache Spark - A unified analytics engine for large-scale data processing

  

In Catalyst, the Apache Spark optimizer, the cost is a vector of the number of rows and the number of bytes being processed. The vector is converted into a scalar value during comparison.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• Trino

  44 9,597 10.0 Java

  Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

  

In Presto/Trino, the cost is a vector of estimated CPU, memory, and network usage. The vector is also converted into a scalar value during comparison.

• cockroach

  100 29,148 10.0 Go

  CockroachDB - the open source, cloud-native distributed SQL database.

  

In CockroachDB, the cost is an abstract 64-bit floating-point scalar value.

Suggest a related project