Re: Named Mistakes and Questionable Practices

-CELKO- wrote:
I presume this is considered a mistake only because of SQL allowing duplicate "rows". In the real RM, no such mistake is possible. <<

No, we would have Dr. Codd's "Degree of Duplication" operator that
nobody mentions. This is how he handled dups in RM II. At least you
can avoid dups in base tables in SQL via constraints and in results via
SELECT DISTINCT.

Teradata used to disallow duplicate rows in its early versions, but
lost out to Standard SQL. My wish is that we had put in a [CREATE |
DECLARE] FILE <name> (<column list>) construct for the non-tables. But
SQL was built on the existing indexed file systems of the day, and we
are stuck with the family legacy (aka "family curse").


Right, why bother with the simple solution when we can think up such complications and obfuscations. So look where we are after thirty-five years. Some progress. Jobs for the boys.


p


ps: I didn't know much about Teradata nor their main competitor whose name I forget but I thought both were on the right track, albeit if baby steps. It is so pathetic how the machine designers look to what the software designers are doing and the software designers look to what the machine designers are doing and all we ever get is cpu's that reflect a lot of bio-feedback. Even then they miss most of what the other side is doing, eg., I doubt if any cpu has yet implemented a double-ended stack, let alone anything approaching db ops. (Maybe I'm being unfair to the System 38 designers.)

.

Relevant Pages

  • Re: Visual Studio Sucks
    ... "Data Environment" I am referring to. ... designers at all since they really have no commonalities between them ... I could bring up a new query builder via the keyboard by doing Shift ... When working with SQL Server - why the heck did they remove the ...
    (microsoft.public.vsnet.ide)
  • Re: Visual Studio Sucks
    ... This is especially true in VS.NET's "Webforms" designers... ... What a complete load of garbage the Query Builder IDE is. ... Why when I choose "Stop Outlining" in a Stored Procedure text window, from the context menu, does it do nothing? ... I have found this to be true of SQL Server Management Studio also, a huge backwards step in terms of usability for anyone who uses the product on a daily basis. ...
    (microsoft.public.vsnet.ide)
  • Re: Visual Studio Sucks
    ... You can't compare WinForms and WebForms ... This is especially true in VS.NET's "Webforms" designers... ... What a complete load of garbage the Query Builder IDE is. ... When working with SQL Server - why the heck did they remove the ...
    (microsoft.public.vsnet.ide)
  • Re: Chicken or Egg: SQL vs Strongly Typed DataSet
    ... That code is in the designers. ... I expect MS thought that it's the purview of ... the tools to do the DDL--VS.NET provides some of those tools, SQL EM more, ... This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Named Mistakes and Questionable Practices
    ... we would have Dr. Codd's "Degree of Duplication" operator that ... This is how he handled dups in RM II. ... lost out to Standard SQL. ... are stuck with the family legacy. ...
    (comp.databases.theory)