Re: Informix vs Oracle vs DB2. SQL Query optimization.

Ian Michael Gumby wrote: > On Oct 13, 12:43 am, DA Morgan <damor...@psoug.org> wrote: >> Ian Michael Gumby wrote: >>> On Oct 12, 3:26 pm, Mark Townsend <markbtowns...@sbcglobal.net> wrote: >>>> > I think the reason >>>>> is that Oracle still has issues with derivative data types. (You call >>>>> them cartridges, IDS calls them datablades.) But then again,. my >>>>> client isn't your ordinary user of spatial data. >>>> To be clear here - cartridges are extensions to the Oracle server, in a >>>> fashion similar to Datablades in Informix. But Spatial (and the other >>>> native data types supported in Oracle) are not implemented as cartridges >>>> in the Oracle engine - they are data types supported by the kernel >>>> directly. They may have been implemented as cartridges in earlier >>>> releases, but over time have been bought into the fold (or died) >>> Ah. So you're saying that spatial is now a native data type? That >>> makes the issue worse. >>> Sorry. >> Only with respect to your profound ignorance which has again been >> pointed out. No doubt your next foray will be to tell us that interval >> data types should not be in the kernel. How about LOBs? >> -- >> Daniel A. Morgan >> University of Washington >> damor...@x.washington.edu (replace x with u to respond) > > Daniel, I deal with multiple versions of databases on a daily basis. > Its difficult to keep on top of all of the little changes that occur > over time. > The fact that Mark said that the spatial data types are now no longer > a derived data type doesn't make things look better for Oracle's > spatial. Also it doesn't make sense. I seem to recall that talking > with DBAs that you got Oracle spatial as part of Enterprise Edition, > but not with the other editions. Of course some of the confusion is > that these Oracle DBAs have been working with Oracle for years and as > Mark points out. It wasn't until a recent release that they are now > native. > Is that 11 or 10g? > > See, you really should go back and teach your extended education class > and leave the software development to the professionals. > BTW, I don't consider myself a DBA since I'm not an engine jockey. > I'll do the logical design and the app work but I'm not tied to the > engine. > > -G Gumby, I'm terrible with math. I can count, but don't push me beyond that the wheels fall off. I have to stay with the basics when it comes to math. Aren't most data types 'derived' on a system? Beyond integer and float, the two that are really bound to the hardware, aren't all the rest of these masks of these two primary data types? Doesn't the term 'derived' point to masks on top of integer & float? Maybe there is another meaning behind 'derived', please advise. I'm too dense about this I'm sure. ?<8o/ http://scv.bu.edu/documentation/tutorials/F90/constructs/DERIVED_TYPE.html http://msdn.microsoft.com/en-us/library/ms761405(VS.85).aspx http://www.linux-mag.com/id/1332 -- Build a man a fire, and he'll be warm for a day. Set a man on fire, and he'll be warm for the rest of his life. Terry Pratchett

On Oct 13, 10:46 pm, InDeep <ind...@indeep.com> wrote: > Ian Michael Gumby wrote: > > On Oct 13, 12:43 am, DA Morgan <damor...@psoug.org> wrote: > >> Ian Michael Gumby wrote: > >>> On Oct 12, 3:26 pm, Mark Townsend <markbtowns...@sbcglobal.net> wrote: > >>>>  > I think the reason > >>>>> is that Oracle still has issues with derivative data types. (You call > >>>>> them cartridges, IDS calls them datablades.)  But then again,. my > >>>>> client isn't your ordinary user of spatial data. > >>>> To be clear here - cartridges are extensions to the Oracle server, in a > >>>> fashion similar to Datablades in Informix. But Spatial (and the other > >>>> native data types supported in Oracle) are not implemented as cartridges > >>>> in the Oracle engine - they are data types supported by the kernel > >>>> directly. They may have been implemented as cartridges in earlier > >>>> releases, but over time have been bought into the fold (or died) > >>> Ah. So you're saying that spatial is now a native data type? That > >>> makes the issue worse. > >>> Sorry. > >> Only with respect to your profound ignorance which has again been > >> pointed out. No doubt your next foray will be to tell us that interval > >> data types should not be in the kernel. How about LOBs? > >> -- > >> Daniel A. Morgan > >> University of Washington > >> damor...@x.washington.edu (replace x with u to respond) > > > Daniel, I deal with multiple versions of databases on a daily basis. > > Its difficult to keep on top of all of the little changes that occur > > over time. > > The fact that Mark said that the spatial data types are now no longer > > a derived data type doesn't make things look better for Oracle's > > spatial. Also it doesn't make sense. I seem to recall that talking > > with DBAs that you got Oracle spatial as part of Enterprise Edition, > > but not with the other editions. Of course some of the confusion is > > that these Oracle DBAs have been working with Oracle for years and as > > Mark points out. It wasn't until a recent release that they are now > > native. > > Is that 11 or 10g? > > > See, you really should go back and teach your extended education class > > and leave the software development to the professionals. > > BTW, I don't consider myself a DBA since I'm not an engine jockey. > > I'll do the logical design and the app work but I'm not tied to the > > engine. > > > -G > > Gumby, > > I'm terrible with math.  I can count, but don't push me beyond that the > wheels fall off.  I have to stay with the basics when it comes to math. > > Aren't most data types 'derived' on a system? > Yes and no. To a point. But when you get away from the core, geospatial is more of a derived data type because you have things like x,y and zed coordinates (at a minimum, then you have other fields that control the amount of allowable tolerance. If two points are within . 5 meters, are they the same point? To your point, DECIMAL would be a derived data point. The point I was trying to make in this thread is that IDS, Oracle and I'm pretty sure DB2 will not utilize the underlying table index when dealing with a collection which is a subset of the table. I saw this in Oracle and wanted to see if it was true in IDS and DB2 as well. IMHO, its not that difficult to implement, although its not a trivial thing either. Other data types which could be considered derived would be time series. K?