3 ms·
What's the difference whit regular ORM?(genuine ask)
by imachine1980_ 5y ago
What's the difference whit regular ORM?(genuine ask)
- michaelmior 5y agoORMs map relational databases to objects. Calcite does not do that. Calcite takes different data sources (potentially with different data models) and presents them all in the relational model. You interact with your data entirely in SQL while ORMs typically have some DSL which uses whatever object model the ORM defines. ORMs are also typically designed to connect to a single data source at a time. I'm personally not familiar with any ORMs that allow combining data from multiple sources within the same application. The primary advantage of Calcite for connecting multiple data sources are 1) easily joining data sources that use completely different APIs (assuming there is a Calcite adapter available) and 2) supporting more complex queries than the original data source supports without having to write code (other than SQL) to do the processing.
- gavinray 5y agoDon't forget having two industrial-grade academic query planners/optimizer implementations that took collective decades of engineering effort! And the project being founded by someone who has written multiple RDBMS. Calcite is a wonder.