01 December 2015

The Treeless Plain

Yet another example of the underlying fact about data in the real world: it's all relational, not hierarchical. Codd and Date are right. Being able to deal with hierarchies inside a relational engine was the best thing ever done. Try doing it the other way 'round. Yeah, you xml kiddies have been attempting that for about a decade and a half.

I hadn't known that SQLite had done so. What's funny? MySql runs on the Oracle (from before they bought it) engine, InnoDB. While Oracle didn't write InnoDB from the start, they've owned it for a decade, so there's no excuse. If nothing else, Oracle could supply CONNECT BY, which Oracle engines have had since long before IBM/DB2 invented formal CTE and got it into the standard.

He He He.

No comments: