Archives of the TeradataForum

Message Posted: Fri, 27 Jan 2006 @ 21:13:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

It's been a long time since I looked at that "theory". I do remember, though, that most of what I read looked like description of "best practices", not a clear mathematical theory.

A pure mathematical part is too abstract in nature and it is very far from what we see in real-life RDBMS. RDBMS are just based on the "best practices" part, which ensures their more-or-less compatibility. In my opinion, this is the most important historical contribution of the theory. It had introduced a common language long before ANSI et al. But after that I don't see anything of practical value. All RDBMS are internally built on different, vendor specific algorithms.

I, for one, am not aware of RDBMS which does _not_ support multiset tables. They just simply call them tables. "Multiset" term was probably Teradata's invention? The concept itself is very common across vendors.

Regards,

Victor

	<Prev	Next>		<<First	<Prev	Next>	Last>>