Re: The wisdom of the object mentors (Was: Searching OO Associations with RDBMS Persistence Models)
Date: 2 Jun 2006 09:39:47 -0700
Message-ID: <1149266387.659268.240660_at_g10g2000cwb.googlegroups.com>
<< In my opinion SQL does a fabulos job even with poor system of
datatypes. VARCHAR2(20) what a humpback!>>
You are rightfully entitled to your opinion so am I. I am not
impressed at all by SQL for I face its limitations everyday. The fact
that SQL is the best we have to get closer to relational implementation
does not make me happy. Quite the opposite in fact.
<<I also don't see how particular SQL syntax quirks impede an ability
to write assertions(constraints).>>
Complex assertions can even be implemented via basic
Redundant non intuitive code when constraints get more exhaustively
implemented.
Breaking independence between the physical and logical layer
(materialized/indexed views)
*Complex* is a relative thing. Can you define user defined operators
using SQL ? How do you define a data type as being another relvar
using SQL ? How would the SQL DBMS implement operators on that? -->
It can't.
<<Again, overthrowing SQL would require a deaper insight.>>
Overthrowing SQL is not the point and it is not the intent. My intent
is about trying to identify in OO mechanisms that could be useful
paliating at known SQL weaknesses.
<<For example,
select ename, sal2 from emp, (sal2=2*sal) f
where f.sal = emp.sal
as a "pure" relationaly styled version of
select ename, sal*2 from emp>>
Is allowing predicates in the "where" clause give us any benefits?>>
I am not positive what you mean by the two last questions. Thank you
I gave examples but they seem to be unsufficient...
I will supply you with some code on that as soon as possible.
> constraints (CHECK, UNIQUE, FOREIGN KEY) on materialized views.
Yes but at what cost?
what if we treat functions as relations? Shouldn't we write
I do not understand what you are actually
Please do not consider me as anti-SQL as I am not. Just aware of its limitations. Received on Fri Jun 02 2006 - 18:39:47 CEST