Re: Replace Oracle with Open Source DB?
Date: Thu, 19 Mar 2009 12:42:00 -0700 (PDT)
Message-ID: <b4d33332-d9ea-48c9-befa-41766325522b_at_13g2000yql.googlegroups.com>
On Mar 15, 10:09 pm, Lee <L..._at_JamToday.com> wrote:
> BACKGROUND
> We have an Oracle 10g installation. There seems to be one important
> application implemented in Oracle; a kind of Content Management System
> to control information for eventual publication on N or more different
> web sites.
>
> Information professionals arrange materials into a hierarchy, add
> descriptive metadata (The sort of information one might find in Library
> Catalogs), declare the material "ready for prime time" and assign
> materials to the different web sites. They also control the production
> of images (digital pictures mostly) from the "real world" objects; but
> Oracle does not store the actual images themselves.
>
> Some of the materials are "born digital" and dont need digitization
> control.
>
> Data entry (descriptive metadata and arrangement) is entered into the
> Oracle schema holding the actual data via a web front end written in
> pl/sql using Apache and the pl/sql gateway. THe application is in a
> separate schema from the production data but has "rights" to read the
> tables and to execute packaged procedures living in the production
> schema for insert/update etc.
>
> Independant applications running JVM's "Extract" the data by making SQL
> calls into Oracle, format the data into XML files, and also index the
> information with Lucene.
>
> The XML files and the Lucene indexes are sent off to web farms.
>
> The actual bit streams (pictures, sound files, etc) that are the
> "content" are stored outside of the Oracle system in a set of "image"
> servers, where "image" can be taken to be a visual image, a sound file,
> or any sort of media file.
>
> The actual production data exclusive of indexes and other support
> structures isnt more than 2 or 3 GBytes worth.
>
> The pl/sql code to implement the data entry application is maybe 60
> KSLOC of pl/sql.
>
> As a practical matter there are never more than a small handful of (say
> half a dozen tops?) simultatneous data entry operators simultaneously
> active.
>
> Adding everthing togather there's less than 4 or 5 GBytes of data and
> 70KSLOC of pl/sql code in the whole ORacle portion system.
>
> The heavy lifting, 24x7 web availability to consumers around the globe,
> is borne by the web farms and the image delivery mechanis, all outside
> of and only loosely coupled to Oracle through the extraction system.
>
> I have no idea what the Oracle license fees are like. The only possibly
> relevant fact being that we are a non profit public institution.
>
> THE QUESTION (at last)
> The institution now favors using open source products wherever it makes
> sense to do so. The decision to go Oracle for this particular project
> was taken in or around the year 2000.
>
> There are many more choices now and some options, such as mySql, which
> were "weak tea" then, have since become "contenders".
>
> The situation is complicated by lack of information on my part. I am
> given to believe that some departments plan to acquire XML database
> tools, but I dont know which ones.
>
> I can imagine that storing, retreiving, parsing, querying and
> ransforming XML documents will be increasingly important in the future.
>
> With Oracle,we have XML DB, the xml data type and a whole panoply of XML
> integration tools. If we were to dump Oracle, and go completely "open
> source", (lets say that means mySql , but that's not certain either)
> I'm not sure how , if at all, we could recreate that easy access between
> the RDBMS and the XML incarnations of the information.
>
> Does it make sense to port the application to "something" else.
>
> If so why so, if not why not?
>
> What options does the group think are viable?
>
> How would we recreate the beauty of the XNL DB features in mySql or
> berkely DB or INNODB or whatever?
It is all a cost versus features trade off. Boiled down to simplest terms:
Assume there is equivalent functionality in the open source to match Oracle or that the equivalent can be built. (After all, if it cannot work, then there is no sense in converting.)
Consider the costs -
ORACLE DBMS
development costs W = $0 (they are already paid)
training costs V = $/new developer/year (how stable is the
IT staff?)
license costs U = $/year (can they get some charity
discount?)
Maintenance costs T = $/year (bug fixed and enhancements)
Support costs S = $/year
Total Annual Oracle Cost C = V+U+T
Open Source DBMS - say MySQL
development costs M = $ (one time conversion)
training costs N = $/new developer/year license costs P = $/year (can they get some charitydiscount?)
Maintenance costs R = $/year (bug fixed and enhancements) Support costs Q = $/year
Total Annual MySQL Cost D = N+P+R+Q
The per year cost difference is C - D
The key question is how many years will it take to save the costs of
conversion?
Assume W is $0 (the current system has been in place long enough that
initial implementation costs has been amortized).
So
M = Y * (C-D) or Y = M/(C-D)
where Y=number of years for payoff.
making those estimates will be tricky. You might consider some of the individual costs.
Will support costs for Open source Q be less than Oracle support S. Note that Q will be a variable cost while S is fairly fixed. It's like the difference between annual insurance costs and being self insured.When the accident happens, will you have the funds to pay it? It may be possible to get support for open source, but will it be less than Oracle?
During the years for payoff, will the maintenance costs (R open source versus T Oracle) be higher because your staff is less familiar with the new software? that could stretch out the payoff period.
Training costs are likely to be MUCH higher for the first year or so
of the new system. Suppose the costs are identical per developer. but
you have to train the entire staff on the new system. just for
comparison, assume your staff has a turnover or one developer per
year.
Oracle training cost you: 1*N
you have a staff of J number of developers.
Your first year training costs then will be: J*N
Maybe you bury that cost in the conversion costs (M)
Just some thoughts to consider.
Ed
(disclaimer: I am part of a company that does hosting)
And finally one other idea to consider:
outsource the application.
The CMS can be used remotely, the total costs might be less (again
have to do the estimation work). The reason is the oracle licensing
will be amortized over more applications by the hosting company. you
can still do the enhancements. You might have some reduced work
(backups and such) Contact me if that is something you would like to
consider.
Ed Prochak
Magic Interface, Ltd.
http://www.magicinterface.com
ed prochak at magic interface dot com
Received on Thu Mar 19 2009 - 20:42:00 CET