Re: dynamically trasnpose rows into columns

--CELKO-- (jcelko212@xxxxxxxxxxxxx) writes:
> Perhaps the problem is that you are trying to destroy the very
> foundation of RDBMS by mixing data and metadata in the schema?
>
> Let's get back to the basics of an RDBMS. Rows are not records; fields
> are not columns; tables are not files. You use the wrong words BECAUSE
> you have the wrong mental model.
>
> Read a book that will teach you about normalization, RDBMS, and data
> modeling. You are not going to get this in a Newsgroup -- you need a
> year or more of education.

So when you come to a site, and the user ask you for a report like this,
do you tell them that they have the wrong mental model, and they should
learn about RDMBS? How long does it then take before that customer cancels
the contract with you.

There is a lot of things out there that users need, that does not align
with the theory of the relational models, and I can tell you these users
does give a single damn about relational theory. They want data and reports
so that they make business, and how this data is produced is immaterial
to them. It is our task as IT craftsmen to produce that data (because these
are typically the guys that pays us, so we can ger bread on the table).

There is absolute no excuse for insulting people, just because they are
looking into solve business problems. Go and dig yourself under a rock.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Getting data from multiple rows into one column
    ... > 1) The foundation of RDBMS, First Normal Form? ... > would overturn 30+ yers of RDBMS and 40+ years of Comp Sci. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: SQL2005 collation vs Oracle
    ... that you port from a RDBMS that allows this to an RDBMS that does not. ... The one that I and Tony raise is real. ... My main instances of SQL Server runs a case-sensitive collation. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Numbering records in query
    ... I wasn't asking if SQL requires, I was asking if SQL Server provides. ... > mental model that is a sequential file system, not an RDBMS. ... Mental model is based on a representation of a RDBMS table as a graphical ...
    (microsoft.public.sqlserver.programming)
  • Re: Among available RDBMS. When to use ...
    ... While comparing MS SQL Server, Oracle and DB2, an author writes in a ... Reliability: Very reliable ... Managebility: difficult. ... RDBMS to use and in what situation, ...
    (comp.databases)
  • Re: Surrogate Key Semantics
    ... What should the "mental model" be? ... you cannot name a surrogate key because it is hidden from you. ... Yeah, they are. ... >>>call a surrogate will depend on the implementation, not on RDBMS. ...
    (comp.databases.theory)