Fatworm 2013:Code Review 1

Process Check

1. Finish JDBC Driver;
2. You can display the CommonTree generated by antlr;
3. Display your middle representation (Logical Query Plan);
4. Show me your structure of Physical Query Plam.

Basic Questions

1. How do you deal with a simple select statement with only where and from clause?
2. How do you deal with a select statement with a having clause?
3. How do you deal with expression appeared in a select clause?
4. How do you deal with table alias and column alias?
5. How do you deal with a select statement with aggregation functions?
6. What's your design on schema?
7. Can schema in logic plan query be decided statically? Why?
8. How can you update records with a where clause?
9. How do you deal with default values in table definition?
10. Show me you implementation of JDBC interface, and tell how your driver is registered on the DriverManager.
11. Where should some information, like `current database`, be stored?
12. Show me how you find a field by its name according to the schema. (I will give you a sql statement example, like `select a.a from b as a`)
13. How do you deal with a NULL?
14. Describe your overall design and architecture.
15. What is the most challenging problem you faced in this phase?