Given Oracle’s licensing handling[a] (and, to a lesser extent, cost) I have always been wondering what the deciding factors would be for choosing Oracle over Postgre or MySQL.

My company is nearly always choosing Oracle (XE where possible), even for small projects where there is just a single simple Windows server box running the database without any dedicated DB administration. (Note that small does not mean the data will always fit the rather small size constraints of Oracle XE.)

I have always questioned this choice, but it has the benefit that we at least are exposed to only one database product.

Still, given a new project, where you need a RDBMS, but the project and scope of the database is pretty small, based on which unique features of Oracle running on simple Windows server boxes (without too much dedicated administration) would you choose Oracle over another RDBMS?

Additional Context: A lot of our database deployments run at customer sites in a, lets call it, “low-administration” mode. That is, the database is set up once. There is some initial testing on its correct behavior and performance on site. After this, the database just run’s on its on. No regular administration done. Only if somethings broken will a technician (not a dedicated DBA) check the datbase, trying to figure out what’s up. Backup is mostly done as offline backup. In some projects, the customers don’t even care there’s a RDBMS involved. They just see their app as a black box that works (or not).

via database recommendation – What features of Oracle make it an attractive choice for small projects? – Database Administrators – Stack Exchange.

Annunci