Friday, March 9, 2012

OODBMS vs RDBMS

What applications/cases benefit from OODBMS as opposed to RDBMS.
We are considering OODBMS to replace some SQL Server instances but dont
really know if we are making the right choice.
Can someone just provides pros and cons of both ?
ThanksOn 21 Apr, 03:01, "Hassan" <has...@.hotmail.com> wrote:
> What applications/cases benefit from OODBMS as opposed to RDBMS.
> We are considering OODBMS to replace some SQL Server instances but dont
> really know if we are making the right choice.
> Can someone just provides pros and cons of both ?
> Thanks
As far as I'm aware there is no reliable and standard definition of
what constitutes an OODBMS. You might get more help if you tell us the
product name.
Why are you considering a change if you don't know what the benefits
are?
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||ObjectStore and Versant
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1177162193.874920.238980@.y80g2000hsf.googlegroups.com...
> On 21 Apr, 03:01, "Hassan" <has...@.hotmail.com> wrote:
>> What applications/cases benefit from OODBMS as opposed to RDBMS.
>> We are considering OODBMS to replace some SQL Server instances but dont
>> really know if we are making the right choice.
>> Can someone just provides pros and cons of both ?
>> Thanks
> As far as I'm aware there is no reliable and standard definition of
> what constitutes an OODBMS. You might get more help if you tell us the
> product name.
> Why are you considering a change if you don't know what the benefits
> are?
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||Comparisons of only loosely related technologies without reference to the
requirements are pointless. You will need to say what you're trying to do
from an application point of view.
Each of the options - SQL Server, ObjectStore (I don't know Versant) has its
strengths and weaknesses, so it all depends on what you're trying to do.
"Hassan" <hassan@.hotmail.com> wrote in message
news:OYb2zdChHHA.4140@.TK2MSFTNGP05.phx.gbl...
> ObjectStore and Versant
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:1177162193.874920.238980@.y80g2000hsf.googlegroups.com...
>> On 21 Apr, 03:01, "Hassan" <has...@.hotmail.com> wrote:
>> What applications/cases benefit from OODBMS as opposed to RDBMS.
>> We are considering OODBMS to replace some SQL Server instances but dont
>> really know if we are making the right choice.
>> Can someone just provides pros and cons of both ?
>> Thanks
>> As far as I'm aware there is no reliable and standard definition of
>> what constitutes an OODBMS. You might get more help if you tell us the
>> product name.
>> Why are you considering a change if you don't know what the benefits
>> are?
>> --
>> David Portas, SQL Server MVP
>> Whenever possible please post enough code to reproduce your problem.
>> Including CREATE TABLE and INSERT statements usually helps.
>> State what version of SQL Server you are using and specify the content
>> of any error messages.
>> SQL Server Books Online:
>> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
>> --
>

No comments:

Post a Comment