Re: OO vs. RDB challenge

From: frebe (fredrik_bertilsson_at_passagen.se)
Date: 03/18/05 

Date: 18 Mar 2005 08:43:21 -0800

> In real business, ANSI SQL can never stand by itself
Did someone claim it could?

> So I stand by my original position, it's not a case of DBMS versus
OOP
> they can work well together
Indeed

> In the end, I only use DB's if my client demands the extra sex appeal
> that comes by having one and not because they do anything for me.
Lets have an simple example. Lets say you have a list of customers and
you want to find every customer above a given age living in a specific
city. How would you do without a RDBMS? Traverse all customers and
evaluate the criteria, or creating two maps, one for the birth_of_date
property and one for the city property? Or would you have another
solution? In SQL, the solution would be:
select * from customers where (today-date_of_birth)<? and city=?

Fredrik Bertilsson
http://butler.sourceforge.net