Apache Calcite is an

open source Open source is source code that is made freely available for possible modification and redistribution. Products include permission to use the source code, design documents, or content of the product. The open-source model is a decentralized sof ...

framework for building databases and data management systems. It includes a SQL

parser Parsing, syntax analysis, or syntactic analysis is the process of analyzing a string of symbols, either in natural language, computer languages or data structures, conforming to the rules of a formal grammar. The term ''parsing'' comes from Lati ...

, an

API An application programming interface (API) is a way for two or more computer programs to communicate with each other. It is a type of software Interface (computing), interface, offering a service to other pieces of software. A document or standa ...

for building expressions in

relational algebra In database theory, relational algebra is a theory that uses algebraic structures with a well-founded semantics for modeling data, and defining queries on it. The theory was introduced by Edgar F. Codd. The main application of relational algebra ...

, and a query planning engine. As a framework, Calcite does not store its own data or

metadata Metadata is "data that provides information about other data", but not the content of the data, such as the text of a message or the image itself. There are many distinct types of metadata, including: * Descriptive metadata – the descriptive ...

, but instead allows external data and metadata to be accessed by means of plug-ins. Several other

Apache The Apache () are a group of culturally related Native American tribes in the Southwestern United States, which include the Chiricahua, Jicarilla, Lipan, Mescalero, Mimbreño, Ndendahe (Bedonkohe or Mogollon and Nednhi or Carrizaleño an ...

projects use Calcite.

Hive A hive may refer to a beehive, an enclosed structure in which some honey bee species live and raise their young. Hive or hives may also refer to: Arts * ''Hive'' (game), an abstract-strategy board game published in 2001 * "Hive" (song), a 201 ...

uses Calcite for cost-based query optimization;Julian Hyde
"Cost-based query optimization in Apache Hive 0.14"

Hortonworks
', 24 September 2014.

Drill A drill is a tool used for making round holes or driving fasteners. It is fitted with a bit, either a drill or driverchuck. Hand-operated types are dramatically decreasing in popularity and cordless battery-powered ones proliferating due to ...

and Kylin use Calcite for SQL parsing and optimization; Samza and

Storm A storm is any disturbed state of the natural environment or the atmosphere An atmosphere () is a layer of gas or layers of gases that envelop a planet, and is held in place by the gravity of the planetary body. A planet retains an atmos ...

use Calcite for streaming SQL. ,

Apex The apex is the highest point of something. The word may also refer to: Arts and media Fictional entities * Apex (comics), a teenaged super villainess in the Marvel Universe * Ape-X, a super-intelligent ape in the Squadron Supreme universe *Apex ...

Phoenix Phoenix most often refers to: * Phoenix (mythology), a legendary bird from ancient Greek folklore * Phoenix, Arizona, a city in the United States Phoenix may also refer to: Mythology Greek mythological figures * Phoenix (son of Amyntor), a ...

and

Flink ''Flink'' (full name: ''The Misadventures of Flink'' according to the title screen) is a 2D scrolling platform video game developed by former members of Thalion and published by Psygnosis. The Amiga CD32 and Mega CD versions are reliant on CD- ...

have projects under development that use Calcite.

References

{{Apache Software Foundation Relational database management systems

Calcite Calcite is a Carbonate minerals, carbonate mineral and the most stable Polymorphism (materials science), polymorph of calcium carbonate (CaCO3). It is a very common mineral, particularly as a component of limestone. Calcite defines hardness 3 on ...

Software using the Apache license Free software programmed in Java (programming language)