Query Processing

[Anthony4m]

• Design basic query execution engine
  • Create the core components to interpret and execute SQL queries, including support for basic operators like scans and predicates
• Implement sequential scan operator
  • Build a scan operator that can efficiently read all records from a table
• Create predicate evaluation
  • Implement the logic to evaluate filter conditions specified in query predicates
• Build simple query plan representation
  • Develop a data structure to represent the steps involved in executing a SQL query