Re: OO vs. RDB challenge

From: Alfredo Novoa (alfredo_novoa_at_hotmail.com)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 12:35:59 +0100

On Mon, 14 Mar 2005 18:12:47 +0100, bruno modulix <onurb@xiludom.gro>
wrote:

>> If something can not enforce the business logic then it is not a DBMS.
>
>Ho, yes ?-) So no one of us never ever worked with a DBMS, cause such a
>thing does not exists (by your definition).

What a nonsense!

Of course they exist: Oracle, DB2, SQL Server, etc.

>May I remind you that a DBMS is a program that has it's own business
>logic (it's business being, as the accronym implie, to manage data), and
>that a not-so-small part of this logic (the one dealing with internal
>data and indexes representation, IO access, request optimisation etc
>etc...) cannot be enforced by a DBMS ?

What a nonsense!

You don't know what business logic is.

>That is not business logic!
>Unless of course you define 'business logic' as 'any rule my favorite
>RDBMS can enforce, and no other', which would make your assertion a
>tautology - and would be a bit unfair too...

Of course my statement was tautology!

Business logic are: database structure, database constraints and
database derivation rules.

And an RDBMS is a software system that can enforce all that.

But it is not my definition, it is the definition you can find on any
book or web about business rules.

http://www.businessrulesgroup.org/
http://www.brcommunity.com/
http://www.computerworld.com/printthis/2003/0,4814,84500,00.html

>> Of course, but if we compare OODBMS's to RDBMS's then OODBMS's don't
>> have any technical pro.
>
>What you mean 'technical' pro ?-)

An objective pro.

>I've worked (and still have to) with RDBMS based CMS. At least half the
>code is related to connecting to the RDBMS, building SQL queries,

Your testimonial is irrelevant. It is very probable that you were not
using the SQL DBMS correctly, and SQL DBMS's are a lot worse than
RDBMS's.

Regards

Relevant Pages

  • Re: Object oriented database
    ... By 'dbms' do you mean VAX DBMS? ... line from digital's database folks to be incredibly interesting. ... It made input from files with repeating groups "look ... rdbms has this where the actual implementation of the database is ...
    (comp.databases.theory)
  • Re: MV and SQL
    ... >>> Are you sure that a column in Pick is equivalent to a column in an SQL ... > You can also change the type from varchar to array if your SQL DBMS support ... > for variables that store the data retrieved from the database. ... >>> SQL is not the only language. ...
    (comp.databases.theory)
  • Re: About Databases...
    ... design, normalization (and when to violate normalization), and SQL. ... I'd probably avoid any book that has chapters on Hierarchical DBMS, ... and converted back to binary by the RDBMS server. ...
    (comp.lang.python)
  • Re: File-System or DBMS? (non-flammable clothing optional)
    ... You are simply distinguishing Pick/MV DBMSs from the rest on the ... DBMS's contain all data formatting and logical testing within the Database ... There is no generally-accepted definition of what a true DBMS is, ... I understand it) to a SQL DBMS, but it is precisely because it is Pick ...
    (comp.databases.pick)
  • Re: Numbering records in query
    ... I think you are asking if SQL requires a stable sort; ... mental model that is a sequential file system, not an RDBMS. ... PHYSICAL database storage can be re-arranged on the fly without the user ...
    (microsoft.public.sqlserver.programming)