You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@metamodel.apache.org by Apache Wiki <wi...@apache.org> on 2014/10/01 09:57:03 UTC
[Metamodel Wiki] Trivial Update of "QueryExecutionStrategies" by KasperSorensen
Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Metamodel Wiki" for change notification.
The "QueryExecutionStrategies" page has been changed by KasperSorensen:
https://wiki.apache.org/metamodel/QueryExecutionStrategies?action=diff&rev1=4&rev2=5
* Primary key lookup: Queries that look up records by their primary keys: 'SELECT y FROM x WHERE x.id = 42.
* Groups and aggregates: Are GROUP BY and aggregation functions being delegated natively, or are they calculated in memory?
- || || Plain FROM || Simple COUNT || Simple WHERE || Primary key lookup || Groups and aggregates ||
+ || || '''Plain FROM''' || '''Simple COUNT''' || '''Simple WHERE''' || '''Primary key lookup''' || '''Groups and aggregates''' ||
- || MetaModel-csv || streaming ||<#FFFF00> greedy when exact<<BR>>native when approximated ||<#FFFF00> client-side ||<#FFFF00> no PK ||<#FF0000> greedy ||
+ || MetaModel-csv || streaming ||<#FFFF00> greedy when exact<<BR>>native when approximated ||<#FFFF00> client-side ||<#FFFF00> no PK ||<#FF0000> greedy ||
- || MetaModel-jdbc || streaming || native (incl. all variants) || native || native || native ||
+ || MetaModel-jdbc || streaming || native (incl. all variants) || native || native || native ||
- || MetaModel-excel ||<#FFFF00> streaming .xlsx<<BR>>in-memory .xls || native ||<#FFFF00> client-side ||<#FFFF00> no PK ||<#FF0000> greedy ||
+ || MetaModel-excel ||<#FFFF00> streaming .xlsx<<BR>>in-memory .xls || native ||<#FFFF00> client-side ||<#FFFF00> no PK ||<#FF0000> greedy ||
- || MetaModel-pojo ||<#FF0000> in-memory || native ||<#FFFF00> client-side ||<#FFFF00> no PK ||<#FF0000> greedy ||
+ || MetaModel-pojo ||<#FF0000> in-memory || native ||<#FFFF00> client-side ||<#FFFF00> no PK ||<#FF0000> greedy ||
- || MetaModel-couchdb || streaming || native || native || native ||<#FF0000> greedy ||
+ || MetaModel-couchdb || streaming || native || native || native ||<#FF0000> greedy ||
- || MetaModel-mongodb || streaming || native (incl. WHERE) || native || native ||<#FF0000> greedy ||
+ || MetaModel-mongodb || streaming || native (incl. WHERE) || native || native ||<#FF0000> greedy ||
- || MetaModel-hbase || streaming || native ||<#FFFF00> client-side* || native ||<#FF0000> greedy ||
+ || MetaModel-hbase || streaming || native ||<#FFFF00> client-side* || native ||<#FF0000> greedy ||
- || MetaModel-json || streaming ||<#FFFF00> greedy ||<#FFFF00> client-side ||<#FFFF00> no PK ||<#FF0000> greedy ||
+ || MetaModel-json || streaming ||<#FF0000> greedy ||<#FFFF00> client-side ||<#FFFF00> no PK ||<#FF0000> greedy ||
- || MetaModel-xml ||<#FFFF00> streaming SAX<<BR>>in-memory DOM ||<#FFFF00> greedy ||<#FFFF00> client-side ||<#FF0000> greedy ||<#FF0000> greedy ||
+ || MetaModel-xml ||<#FFFF00> streaming SAX<<BR>>in-memory DOM ||<#FF0000> greedy ||<#FFFF00> client-side ||<#FF0000> greedy ||<#FF0000> greedy ||
- || MetaModel-elasticsearch || paged || native ||<#FFFF00> client-side* ||<#FF0000> greedy* ||<#FF0000> greedy ||
+ || MetaModel-elasticsearch || paged || native ||<#FFFF00> client-side* ||<#FF0000> greedy* ||<#FF0000> greedy ||
- || MetaModel-salesforce || paged || native (incl. WHERE) || native || native ||<#FF0000> greedy* ||
+ || MetaModel-salesforce || paged || native (incl. WHERE) || native || native ||<#FF0000> greedy* ||
- || MetaModel-sugarcrm || paged || native || native ||<#FF0000> greedy ||<#FF0000> greedy ||
+ || MetaModel-sugarcrm || paged || native || native ||<#FF0000> greedy ||<#FF0000> greedy ||
* = improvement is possible (even within the scope of MetaModel)