Versions Compared

Key

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

...

statussupport of IN/EXCEPT trueYellowIN PROGRESS
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

INTERSECT/MINUS

subtletrue
titleOPEN TO TAKE

Status
subtletrue
titleOPEN TO TAKE

MERGE

Status
subtlecolourtrueGreen
titleOPEN TO TAKEDONE

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

Status

subtle

colour

Green
title

DONE


Phase 2: Base performance optimization and extend SQL possibilities

Hash ?
TaskContributorsReadiness Estimated TimeCurrent state
Schema management

Status
colourGreen
titleDONE

Sort based aggregates, index spools


Status
colourGreen
titleDONE

Index Nested Loop Join/Merge Join

Status
colourGreen
titleDONE

Schema management
Statistics/cost model (simple statistics)


Status
subtletrue
colourYellowGreen
titleIN PROGRESSDONE

Hash index spools/ Hash join

Merge aggregates, Merge join, index spools, hash index spools


true
Status
subtle
colourYellowGreen
titleIN PROGRESSDONE

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

MERGE

Status
subtletrue
titleOPEN TO TAKE

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













Phase 3: Usability and performance

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


Status
subtletrue
colourYellow
title

OPEN TO TAKE
IN PROGRESS

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


Status
subtletrue
titleOPEN TO TAKE
Statistics/cost model (simple statistics)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)

Status
subtletrue
titleOPEN TO TAKE

Planner hintsEvgeny Stanilovsky

Status
subtletrue
titlecolourOPEN TO TAKE

H2 syntax support

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

















...