Introduction. RDBMS. Transform. XQuery versus SQL/XML, Part Deux « Native XML Database. July 25, 2008 Some of you have been asking for more information about XQuery versus SQL/XML.
In particular, it appears that you are interested in understanding the levels of support for common operations. I’ll take a few moments to compare both XQuery and SQL/XML in IBM DB2 9. Comparative Data Modeling: Relational versus XML « Maclochlainn’ The MarkLogic 2008 user Conference presentation, by Michael Bowers, makes the case that normalization can lose data context.
It qualifies three steps to normalize data. They are: (1) Normalizing the data; (2) Orthogonalizing the data; and (3) Generalizing the data. You remove redundancies in tables when you normalize tables. You make sure there isn’t data duplicated between tables, which mean you orthogonalize the model. You generalize the data by creating tables that are super types. XQuery for the SQL programmer – Updating your database.