Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

TaskContributorsReadiness Estimated TimeCurrent state
Support of Indexes

Status
colourGreen
titleDONE

initial support of DML (SELECT, INSERT)

Status
colourGreen
titleDONE

Aggregate functions (sum, min, max, avg, ...), enables GROUP BY/DISTINCT commands

Status
colourGreen
titleDONE

UNION/UNION ALL commands

Status
colourGreen
titleDONE

support of IN/EXCEPT 

true
Status
subtle
colourYellowGreen
titleIN PROGRESSDONE

Type system (just review, seems it may be used as-is + write many tests) + support of date/time data types.

Status
colourGreen
titleDONE

Documentation

Status
subtletrue
titleOPEN TO TAKE


Phase 2: Base performance optimization and extend SQL possibilities

TaskContributorsReadiness Estimated TimeCurrent state
Planner hints (ENFORCE JOIN ORDER, Alg of join)

Status
subtletrue
titleOPEN TO TAKE

Schema management?

Status
subtletrue
colourYellowGreen
titleIN PROGRESSDONE

Sort based aggregates, index spools


Status
colourGreen
titleDONE

Index Nested Loop Join/Merge Join

Status
colourGreen
titleDONE

Statistics/cost model (simple statistics)

Status
subtletrue
titleOPEN TO TAKE

Hash join

Status
subtlecolourtrueGreen
titleOPEN TO TAKEDONE

Hash index spools/ Hash join

Status
subtlecolourtrueGreen
titleOPEN TO TAKEDONE

Initial support of DDL (create/drop for table and index)

Status
subtlecolourtrueGreen
titleOPEN TO TAKEDONE

Type system including support of date/time data types.


Status
subtletrue
colourYellow
titleOPEN TO TAKEIN PROGRESS

MERGEINTERSECT/MINUS

Status
subtletrue
titleOPEN TO TAKE

MERGE
Planner hints (ENFORCE JOIN ORDER, Alg of join)

Status
subtletrue
titleOPEN TO TAKE

Planner hints (the potentially concrete plan of executing)

Status
subtletrue
titleOPEN TO TAKE

Documentation

Status
subtletrue
titleOPEN TO TAKE












...

TaskContributorsReadiness Estimated TimeCurrent state
Statistics/cost model (advanced statistics)

Status
subtletrue
colourYellow
titleIN PROGRESS

support of DDL (user, grants, ....)


Status
subtletrue
titleOPEN TO TAKE
Expressions interpreter

Status
subtletrue
titleOPEN TO TAKE

Views

Status
subtletrue
titleOPEN TO TAKE

Tracing, statistics, cancellation, views

Status
subtletrue
titleOPEN TO TAKE

Memory managment management and offloading

Status
subtletrue
titleOPEN TO TAKE

Expressions interpreter (kind of optimisationoptimization, may be omitted at the first step here a type system is used)

Status
subtletrue
titleOPEN TO TAKE

Correlated queries support (may be omitted at the first step)Evgeny Stanilovsky

Status
subtletrue
titleOPEN TO TAKE

H2 syntax support

colourYellow
Status
subtletrue
titleOPEN TO TAKEIN PROGRESS

VolcanoPlanner overhaul

Status
subtletrue
titleOPEN TO TAKE

Distributed joins/aggregation/subqueries algorithms

Status
subtletrue
titleOPEN TO TAKE

Join/aggregation algorithms

Status
subtletrue
titleOPEN TO TAKE

Partition prunningpruning

Status
subtletrue
titleOPEN TO TAKE

Explain/ExplainAnalyze

Status
subtletrue
titleOPEN TO TAKE

Query compilation

Status
subtletrue
titleOPEN TO TAKE

JDBC/ODBC/Thin, other clients (including partition awareness)

Status
subtletrue
titleOPEN TO TAKE

Documentation

Status
subtletrue
titleOPEN TO TAKE

















...