Database for OLTP

150 pts.
Tags:
Microsoft SQL Server
OLTP
Oracle SQL
Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>.

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Akansha
    to be more specefic, does oracle 10g standard edition supports OLTP? Does Microsoft SQl 2008 enterprise edition support OLTP? Which is better?
    150 pointsBadges:
    report
  • carlosdl
    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).
    68,495 pointsBadges:
    report
  • Akansha
    cost wise OLTP is cheaper in which database? Is it Oracle 10g standard edition or Microsoft SQL 2008 enterprise edition?
    150 pointsBadges:
    report
  • carlosdl
    Mrdenny gave you a link to his blog, where he compared prices and features. Did you take a look ?
    68,495 pointsBadges:
    report
  • Akansha
    yes i had looked at the pricing. But at some point or other both cost the same.
    150 pointsBadges:
    report
  • Kccrosser
    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
    report
  • Akansha
    [...] Database for OLTP asked by Akansha and answered by MrDenny and [...]
    0 pointsBadges:
    report
  • Akansha
    [...] Database for OLTP, asked by Akansha and answered by MrDenny and [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following