Database for OLTP
Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 19, 2010 11:26 AM
UPDATED:
April 22, 2010 6:32 PM
Answer Wiki:
Both Oracle and SQL server are suited for OLTP. Other factors need to be considered to decide for one or the other, or to choose the specific edition (of any of them) that best suits your needs.
-------------
Either one will work just fine for an OLTP database. You need to evaluate the features that both have in the various editions (Express, Standard, Enterprise, etc) to see which one has the features that you want.
And then you'll need to look at the price of the packages to see which one fits in your budget.
I did some of the pricing analysis <a href="http://itknowledgeexchange.techtarget.com/sql-server/sql-2008-r2-is-pricy-but-so-is-that-other-database/">on my blog</a>.
To see all answers submitted to the Answer Wiki: View Answer History.
to be more specefic, does oracle 10g standard edition supports OLTP?
Does Microsoft SQl 2008 enterprise edition support OLTP?
Which is better?
Both Oracle 10g standard edition and SQL Server 2008 enterprise edition support OLTP.
‘Which is better’ is a question that won’t easily get a definitive answer. You have been asking different questions about these platforms, and I assume you are also using other research sources. When you have enough information you will probably make a decision about which one is better for you (in terms of features, cost, etc).
cost wise OLTP is cheaper in which database?
Is it Oracle 10g standard edition or Microsoft SQL 2008 enterprise edition?
Mrdenny gave you a link to his blog, where he compared prices and features. Did you take a look ?
yes i had looked at the pricing. But at some point or other both cost the same.
The first question you might ask is “Do I need to care?”.
Do you know the volume of transactions that you are planning to support?
Unless you are building a very serious high-volume transaction system, chances are that either system would work fine.
The Transaction Processing Performance Council (TPC) has defined standard measures of performance for transaction processing system and regularly publishes the results.
The latest results show Oracle as the fastest under the TPC-C processing model, with Oracle handling over 7.6 Million transactions per minute (on a $15 Million Sun SPARC cluster).
The fastest SQL Server reported is 1.23 Million transactions per minute (on a $6 Million HP Integrity Superdome system).
If you need more than 1 Million transactions per minute, then you should stick with Oracle (or even DB2).
Since you are mentioning “standard edition”, my guess is that you are looking for a system to do at most tens of thousands of transactions per minute, and even old Microsoft SQL Server 2000 Standard Edition could do over 10,000 transactions per minute on Proliant boxes 7-8 years ago.
If you look at the results by the platform, you will see that for the lower to middle of the performance spectrum, the two databases are relatively close in performance.
So – either system should easily handle the requirements.
The TPC results are available at:
http://www.tpc.org/tpcc/results/tpcc_results.asp?print=false&orderby=system&sortby=asc