Task Details

Epic: #2978 (Phase 4: Query & Quality)
Priority: CRITICAL
Effort: 5 days
Dependencies: None

Description

Design abstraction for unified query execution across all languages (SQL, Cypher, Gremlin, etc.).

Steps

1. Analyze current query execution patterns
2. Design LogicalPlan abstraction
3. Design PhysicalPlan abstraction
4. Design Operator interface
5. Design query optimization framework
6. Create architecture diagram
7. Write ADR
8. Review with team

Files to Create

• query-core/src/main/java/com/arcadedb/query/plan/LogicalPlan.java
• query-core/src/main/java/com/arcadedb/query/plan/PhysicalPlan.java
• query-core/src/main/java/com/arcadedb/query/plan/Operator.java
• query-core/src/main/java/com/arcadedb/query/optimizer/QueryOptimizer.java
• docs/architecture/ADR-005-unified-query-pipeline.md

Query Pipeline Design

Parse → LogicalPlan → Optimize → PhysicalPlan → Execute → ResultSet

Logical Plan Nodes: Scan, Filter, Project, Join, Aggregate, Sort, Limit
Physical Operators: IndexScan, TableScan, FilterOperator, ProjectOperator, NestedLoopJoin, HashJoin, HashAggregate, SortOperator, LimitOperator

Acceptance Criteria

• Pipeline design complete
• All operators defined
• ADR written and approved
• Team buy-in achieved