Enterprise DB implements the Oracle SQL dialect. I am not sure if it implements PL/SQL, and if so, how much of PL/SQL is implemented.
There's no question that SQL92-wise, the different databases mostly stack up well against each other. If you will be mostly using JDBC, ODBC, that kind of thing -- there's little to choose between the different databases. The things that differentiates Oracle from all the others, are things that non-Oracle users either never have heard of, or simply aren't aware exists. Things like - transparent data encryption (data on disk, data acrossd the wire) - multi-factor authentication of users (e.g. by IP, by time, in addition to by user) - database realms (e.g. even the DBA cannot read the data belonging to HR and thus pull out the salary data) - the DBA should manage the dataBASE not the data - things like Oracle InterMedia and Oracle Spatial (these are FREE components of Oracle 10g R2) which can do sophisticated things like store/extract metadata from audio/video files, store geographic information and do location-based searches; and do image "looks like" matching e.g. find all the images which look like this one - features like Flashback (e.g. SELECT this_item FROM table as it was at 8:00 a.m. today) - Oracle DB can serve as an authentication store for both MIT and Microsoft (a.k.a. Active Directory) Kerberos users, and tie in to Oracle's Identity Management services As I said, Oracle has a TON of features that open-source guys have never heard of, far more than I can even touch in a single email. And if you've never heard of it, you won't use it, and you'll falsely believe that the open-source offering has almost as much functionality as Oracle. I used to believe this, myself. And it's very very far from the truth. And of course I'm biased. :) On 4/26/07, Carlos Yu <[EMAIL PROTECTED]> wrote:
Hi Orly, Just curious, since you are Oracle user, how does the PostgreSql Enterprise DB stack up against Oracle? From, Carlos Yu CYWare Inc. _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
-- Orlando Andico Senior Sales Consultant - Embedded GTMi Oracle (Philippines) Corporation The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
