Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Anyone with experience with MMOG and databases?
with all due respect, it looks to me that you are debating just for the sport of
disagreeing.
that's a nice sport, by the way, and it keeps you sharp -- but this is just too
easy...
there are *no* ISO SQL compliant DBMSses at all. period. and maybe that's a good thing -- the standard has it's own problems, and backward compatibility issues caused by horrible mistakes made in earlier versions of the standard.
you mention SQL/PSM as an example of standards non-compliance, and when I say that it is not part of the standard, you say that it is important. duh. to whom? even many ISO standardization committee members (I know quite a few of them) more or less agree that SQL/PSM is not important as a standard.
portability does *not* matter -- portability is a wet dream. if you think that an application written in fully ANSI/ISO standard SQL is portable from SQL Server to Oracle, or the other way around, you are sorely mistaken -- because the applications will behave differently. Just think about the rather unique and sophisticated non-locking read consistency model implemented by Oracle. Just search Tom Kyte's website for some nice threads on this topic.
proprietary extensions being crap? give me a break, and don't generalize ...
please, let's forget about D -- until it is implemented. it is a promising theoretical framework, and as such highly interesting -- but it will need another revolution, just like Ted Codd started one around 1970, to make it mainstream.
kind regards,
Lex.
oracle-l-bounce_at_freelists.org gravou em 2005-08-12 15:26:04:
> You are one schizo dude. Now you don't like the ISO SQL either?
> You were complaining that Oracle was not ISO compliant and now you are
> saying you don't like the ISO SQL?
I do think every SQL DBMS should be ISO compliant. I do think ISO SQL isn't any good.
The thing is that there is a value in a standard by itself -- portability matters.
On the other hand, most proprietary extensions are just crap. So standards help getting some minimum quality.
Finally, the thing I'd like to see instead of ISO SQL is not SQL at all, but The Third Manifesto's D.
-- Leandro Guimarães Faria Corcete DUTRA Administrador de Bases de Dados +55 (11) 4390 5383 Toyota do Brasil Ltda ldutra_at_toyota.com.br São Bernardo do Campo, SP BRASIL This message (including any attachments) is confidential and may be privileged and intended solely for the use of the person/entity to whom it is addressed. If you have received it by mistake please notify the sender by returning via e-mail as well as delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is prohibited. Please note that e-mails are susceptible to change. TOYOTA DO BRASIL LTDA (including its group companies) shall not be liable for the improper or incomplete transmission of the information contained in this communication, neither for personal, nonbusiness related information nor opinion sent through this email or even for any delay in its receipt or damage to your system. TOYOTA DO BRASIL LTDA (or its group companies) does not guarantee that the integrity of this communication has been kept nor that this communication is free of viruses, interceptions or interference. -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 12 2005 - 13:51:02 CDT