Category Archives

Archive of posts published in the category: SQL

SQLxD Part 11 — JOINs

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…

SQLxD Part 10 — WHERE and tests

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:…

SQLxD Part 9 — WHERE and LIKE operator

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…

SQLxD Part 8 — WHERE with joined predicates

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…

SQLxD Part 7 — WHERE with simple 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…

SQLxD Part 6 — FROM

This is the sixth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We already know how to transform XML nodes into SQL-like rows. Now it is time…

SQLxD Part 5 — Generating columns

This is the fifth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We already have the model, can parse XML document, and know how to refer to…

SQLxD Part 4 — Selectors

This is the fourth part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation Now we can implement classes representing multi-part identifiers. We start with the following:

This…

SQLxD Part 3 — Model and parsing XML

This is the third part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation We want to represent nodes in the following way:

Node has its type, name,…

SQLxD Part 2 — Grammar

This is the second part of the SQLxD series. For your convenience you can find other parts in the table of contents in Part 1 – XML Transformation In order to implement SQLxD database, we need to know, what kind of queries we…

SQLxD Part 1 — XML Transformation

This is the first part of the SQLxD series. For your convenience you can find other parts using the links below : Part 1 — XML Transformation Part 2 — Grammar Part 3 — Model and parsing XML Part 4 — Selectors Part…