RE: Anyone with experience with MMOG and databases?

oracle-l-bounce_at_freelists.org gravou em 2005-08-12 15:25:19:

> PostgreSQL is not a commercial product.

        Yes, it is. There are several vendors to it. From the top of my head, at least SRA and dbExperts, but I am sure there are others. Fujitsu is funding it, BTW.

> I will not comment on that one; Ingres
> used to be quite good in the old days.

        It is still there, but I understand QUEL has been corrupted.

> About IBM DB2, which DB2 flavor do you mean? it was a brilliant move
from IBM
> marketing to call all their (mutually nonexchangeable and even
non-comparable)

        What do you mean by 'nonexchangeable and even non-comparable'?

> database products "DB2". If you refer to the mainframe product, I
> sort of agree
> -- although even that product lacks some serious stuff.

        For example?

> The other products they
> call DB2 are inferior to Oracle.

        Can you specify why do you think it so? I'd be grateful.

> SQL/PSM is *not* part of core SQL

        Yet it is important.

> and I personally think the Oracle
> proprietary PL/SQL language is much better and more efficient

        Why?

> The other two issues you mention (DATE datatype and
> CONNECT BY) were implemented many, many years before even the very first
and
> lousy SQL standard (SQL86) was established.

        And badly so.

> Backward compatibility issues make
> it tough to "fix" such things

        Borland dit that in a quite elegant way: a switch specifying proprietary or compliant behaviour settable by each application as it gets ported to ISO SQL.

--
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-l