Re: database market share 2003

> With Oracle (a little more than some other RDBMS's) programmers and users
> who access the data want to know (or need to know depending on your point of
> view) a little bit about the way the data is physically organized. This
> includes things like rowids, certain kinds of indexes, etc. In a pure
> relational model, the physical structure of the data is isolated from the
> logical structure.
>

I'm still confused - you mean product specific features/techniques that improve performance but are not a pure relational model and/or part of the ANSI SQL Standard ? Perhaps some of the things mentioned in articles like
http://www-106.ibm.com/developerworks/db2/library/techarticle/0204pooloth/0204pooloth.html Or this
http://www-106.ibm.com/developerworks/db2/library/tips/dm-0403wilkins/index.html#appendixb Or this
http://www7.software.ibm.com/vadd-bin/ftpdl?1/vadc/dmdd/db2/dm-0312stolze/0312stolze.pdf Or this
http://www-106.ibm.com/developerworks/db2/library/tips/dm-0312yip/index.html Or the "Resolving Lock Problems" section of this http://www-106.ibm.com/developerworks/db2/library/techarticle/0310wilkins/0310wilkins.html Or this
http://www-106.ibm.com/developerworks/db2/library/techarticle/0306arocena/0306arocena.html Or this
http://db2mag.com/db_area/archives/2003/q2/welgan.shtml Or this
http://www.db2mag.com/db_area/archives/2003/q2/deng.shtml Or this
http://www.redbooks.ibm.com/redbooks/SG246917/css/SG246917_bmark.html# or this
http://www-106.ibm.com/developerworks/db2/library/techarticle/0303kuznetsov/0303kuznetsov.html Or this
http://www-106.ibm.com/developerworks/db2/library/techarticle/0302kuznetsov/0302kuznetsov.html Or this
http://www-106.ibm.com/developerworks/db2/library/techarticle/0301mullins/0301mullins.html Or this
http://www-106.ibm.com/developerworks/db2/library/techarticle/0208kuznetsov/0208kuznetsov.html Or this
http://www-106.ibm.com/developerworks/db2/library/techarticle/0208zubiri/0208zubiri.pdf Or this
http://www-106.ibm.com/developerworks/db2/library/techarticle/0203milligan/0203milligan.html

 >
 > This movement away from a pure relational model is done for
 > performance reasons or to add features that some programmers may want.
 > Nevertheless these features (no matter how much people want them)
 > often are in violation of both Codd's rules and ANSI SQL standards.
 >

Thanks for the heads up. By all means Stay Pure (TM). Received on Thu Jun 17 2004 - 00:59:29 CDT