Re: Among available RDBMS. When to use ...

Rohit <rpk.general@xxxxxxxxx> wrote:

This is a common question on forums. But they just compare the
features. At present RDBMS industry has matured a lot and the big
three have strong competitors too like EnterpriseDB, MySQL etc.

While comparing MS SQL Server, Oracle and DB2, an author writes in a
book:

IBM DB2
--------------
Reliability: Very reliable
Situation: Large to very large databases
Managebility: easy.

Oracle
--------------
Reliability: Very reliable
Situation: Medium to large databases
Managebility: difficult.

SQL Server
--------------
Reliability: low
Situation: small to medium sized databases
Managebility: easy.

Though, the above is the view of that author, I want to know which
RDBMS to use and in what situation, including open source.

If one is working in a company than it is the headache of the
company's project manager or product specialist to make this choice.
But I am running a mISV, so all decisions depend upon me. When you
have plenty of choices, you have to select carefully depending upon
customer's budget, data-size, scalability etc.

For SQL Server, I am not sure, if Microsoft continues to support old
SQL Server formats. Or they , as usual, at a point force to shift to a
new version.

Oracle is unnecessarily complicated and you have to involve a
dedicated DBA. Even, as Oracle claims it suitable for small-to-mid-
sized companies, it's cost and cryptic working is very difficult.
All the heavies in the industry except MySQL offer a free, freely
distributable, RDBMS. See <http://database.profectus.com.au>. Some of
them limit the scale and/or operating system but for most applications
a comparison of the features, which may include ease of
administration, is all you need.
.

Relevant Pages

  • Among available RDBMS. When to use ...
    ... At present RDBMS industry has matured a lot and the big ... While comparing MS SQL Server, Oracle and DB2, an author writes in a ... Reliability: Very reliable ... Managebility: difficult. ...
    (comp.databases)
  • Re: Getting data from multiple rows into one column
    ... > 1) The foundation of RDBMS, First Normal Form? ... > would overturn 30+ yers of RDBMS and 40+ years of Comp Sci. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Numbering records in query
    ... I wasn't asking if SQL requires, I was asking if SQL Server provides. ... > mental model that is a sequential file system, not an RDBMS. ... Mental model is based on a representation of a RDBMS table as a graphical ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL2005 collation vs Oracle
    ... that you port from a RDBMS that allows this to an RDBMS that does not. ... The one that I and Tony raise is real. ... My main instances of SQL Server runs a case-sensitive collation. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: DTSFTPTask
    ... codputer writes ... >did try to use your control, but it too could not seem to connect. ... existing tasks, mine or MS, when it came to reliability. ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)