Hi Kevin,
I just finished migrating a Dspace instance away from Oracle, so have run the
same Dspace instance under both Postgres and Oracle. I also saw a dramatic
speed bump after running under Postgres, but the hardware was newer, so cannot
be completely certain it was just due to the migration.
I felt (as do many fortune 500 companies, from my research) that Postgres is a
better solution for medium and small sized databases. My three main reasons for
migrating were:
1) price
2) footprint / speed
3) ease of administration
Oracle really shines when your datasets are so large, or used so heavily, that
your database is hosted over multiple boxes. Another reason for using Oracle,
is if you already have Oracle in place for other projects, and don't want to
host both Postgres AND Oracle.
Having said that, properly admin'ing Oracle requires a great deal more
knowledge than admin'ing Postgres. It is very common (and a quick search on
Google verifies this) for an entire team of DBAs to be needed to host Oracle in
the same manner that Postgres can be admin'ed by one DBA.
Also, the data stored in the database for Dspace is mostly metadata, not the
actual archived files, which are stored on disk. Oracle cannot be justified for
data set used by Dspace. One Postgres instance is likely to handle anything a
typical Dspace app can throw at it.
Finally, Oracle has a much larger footprint than Postgres. Honestly, Oracle is
a resource hog. If you migrate to Oracle, isolate it on its own box, and I
suggest making that a pretty beefy box, also.
Hope that helps.
Best regards,
Terrance Davis
-----
Web Applications Programmer
Institute for Clean and Secure Energy
University of Utah
http://www.ices.utah.edu/
On Jul 27, 2010, at 6:54 AM, Evans, Kevin wrote:
> Hi,
>
> Just a general question.
>
> We currently have two Dspace repositories running Postgres and are about to
> build another. We are considering using Oracle for the new database.
>
> Can anyone give pros and cons of using Oracle?
>
> Cheers
>
> Kevin
>
>
> Kevin Evans MA
> Web Services Developer,
> Integration and Webservices,
> Room 901,
> 9th Floor, Laver Building,
> University of Exeter
> North Park Road,
> Exeter,
> EX4 4RN
> 01392 725573
> 07775027574
> http://my.exeter.ac.uk
>
> This email and any attachment may contain information that is confidential,
> privileged, or subject to copyright, and which may be exempt from disclosure
> under applicable legislation. It is intended for the addressee only. If you
> received this message in error, please let me know and delete the email and
> any attachments immediately. The University will not accept responsibility
> for the accuracy/completeness of this e-mail and its attachments. The
> University cannot guarantee that this message and any attachments are virus
> free. Any views or opinions expressed in this message are my own and do not
> necessarily represent those of the University....don't waste your life
> reading this trash and get out and live.
>
> <Evans, Kevin.vcf><smime.p7s><ATT00001..txt><ATT00002..txt>
------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://ad.doubleclick.net/clk;226879339;13503038;l?
http://clk.atdmt.com/CRS/go/247765532/direct/01/
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
