This is the eleventh part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Today we implement various JOIN operators. Let’s start with interfaces: Let’s start with the simplest join — CROSS JOIN: We simply implement nested loop algorithm and add … Continue reading SQLxD Part 11 — JOINs

This is the tenth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Today we are going to test our code. First, we need to have some mocks: We start with tests for WHERE clause: And now tests for simple … Continue reading SQLxD Part 10 — WHERE and tests

This is the ninth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation As the last predicate we implement LIKE operator. It is not that simple so the implementation is pretty long. By the way, did you know that there … Continue reading SQLxD Part 9 — WHERE and LIKE operator

This is the eighth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We continue implementing the predicates. Today we will join them to construct logic expressions. In order to be able to handle complex expressions we need to introduce … Continue reading SQLxD Part 8 — WHERE with joined predicates

This is the seventh part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Last time we saw how to handle FROM clause. Today we are going to implement filtering logic for handling WHERE. We start with the clause logic: As … Continue reading SQLxD Part 7 — WHERE with simple predicates