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 

Status
subtletrue
titleOPEN TO TAKE

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
colourYellow
titleIN PROGRESS

Sort based aggregates, Merge join, index spools, 


Status
subtletrue
colourYellow
titleIN PROGRESS

Index Nested Loop Join/Merge Join

Status
colourGreen
titleDONE

Statistics/cost model (simple statistics)

Status
subtletrue
titleOPEN TO TAKE

Hash join

Status
subtletrue
titleOPEN TO TAKE

Hash index spools

Status
subtletrue
titleOPEN TO TAKE

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

Status
subtletrue
titleOPEN TO TAKE

Type system including support of date/time data types.


Status
subtletrue
titleOPEN TO TAKE

INTERSECT/MINUS

Status
subtletrue
titleOPEN TO TAKE

MERGE

Status
subtletrue
titleOPEN TO TAKE

Planner hints (the potentially concrete plan of executing)

Status
subtletrue
titleOPEN TO TAKE

Documentation

Status
subtletrue
titleOPEN TO TAKE













Phase 3: Usability and performance

TaskContributorsReadiness Estimated TimeCurrent state
support of DDL


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 and offloading

Status
subtletrue
titleOPEN TO TAKE

Expressions interpreter (kind of optimisation, 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)

Status
subtletrue
titleOPEN TO TAKE

H2 syntax support

Status
subtletrue
titleOPEN TO TAKE

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 prunning

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

















...