Re: Oracle transactions and DDL statements.

DA Morgan skrev:

> peter.koch.larsen_at_gmail.com wrote:
>
> > The table creation has nothing at all to do with temporary tables. The
> > fact is that when we deliver our software we have no idea what tables
> > there should be.
> >
> > /Peter
> >> Jim
>

Hi Daniel

> This statement is horrifying. I read your original post and reread it
> again just now. It appears that faced with a business problem you
> chose a solution independent of best practice and independent of the
> architecture of products, such as Oracle, on which you might implement
> it.

First let me get this straight with you. This is not a new product as it has been in production for probably more than fifteen years. It currently runs on a wide variety of databases and operating systems all over the world. And it is by most regarded as the market leader in its domain.
It is also important to add- in case you haven't realised this already - that this software is not shrink wrap software. We do not sell a new product every day - and probably not one each month. Also I should add that the configuration is not performed by ordinary end-users, but by highly skilled users - most likely IT-professionals in cooperation with domain specialists.
>
> I'd suggest that you both reconsider you choices and reconsider the
> above statement. The above statement is so bad that I have kept a
> copy of it to present to my Oracle students as an example of why
> projects fail.

As you might guess, this is not a failed product, but a market leading and highly successful product that thrives very well in its niche.

> You've earned the dubious honor of being a "bad example"
> at the University of Washington (though I did remove your name from
> the slide).

Honor the fool ;-)
So please be explicit when critizicing our product. So far as I guess, our solution will not differ from e.g. large accounting system such as SAP where customisation is a major part of the product. Also how could shrink-wrapped software work properly on Oracle? Typically there will be an installation phase where the tables are created. If this fails midway (or the power fails), the poor programmers will now have to manually undo the part that actually made it. Most unsatisfactory if you ask me.

>
> Seriously ... your statement equates with ... I don't care about
> security, stability, scalability, performance, or maintainability.

Please motivate that statement. I have a really har time detecting what e.g. security has to do with all this.

Kind regards
Peter
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Wed May 10 2006 - 12:29:04 CDT