Databases & OO applications (was RE: J2EE Question)

From: Pardee, Roy E <roy.e.pardee_at_lmco.com>
Date: Thu, 24 Apr 2003 08:11:53 -0800
Message-ID: <F001.00588773.20030424081153@fatcity.com>

Of possible interest--an influential OO guy writes about using SQL in OO applications:

http://martinfowler.com/articles/dblogic.html

<quote>
Many application developers, particularly strong OO developers like myself, tend to treat relational databases as a storage mechanism that is best hidden away. Frameworks exist who tout the advantages of shielding application developers from the complexities of SQL.

Yet SQL is much more than a simple data update and retrieval mechanism. SQL's query processing can perform many tasks. By hiding SQL, application developers are excluding a powerful tool.

In this article I want to explore the pros and cons of using rich SQL queries that may contain domain logic. I have to declare that I bring a OO bias to the discussion, but I've lived on the other side too. (One former client's OO expert group ran me out of the company because I was a "data modeler".)
</quote>

Cheers,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-----Original Message-----
Sent: Thursday, April 24, 2003 7:47 AM
To: Multiple recipients of list ORACLE-L

I hit this constantly...

the developers say "oh, but the open source object program we are using can't handle concatenated keys, we need you to put another key in there"

they aren't lying to you, but how something in this day and age, with databases and relational theory matured, can NOT handle concatenated keys drives me nuts

• DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
  > We are in the process of creating some significant new schemas.
  > Everything
  > is being normalized, by the book. Now the Java developers are saying
  > that on
  > the associative entities, where many-to-many relationships are
  > resolved by
  > an extra table, they want an artificial key to be added. Normally
  > these
  > tables have two keys, one from each parent table. But the developers
  > want an
  > additional sequential key added to help them track this entity. They
  > say it
  > makes it easier to keep track of this object in the EJBs. Has anyone
  > encountered this situation? Not being familiar with J2EE, I haven't a
  > clue
  > whether this is a reasonable request.
  >
  > Dennis Williams
  > DBA, 40%OCP, 100% DBA
  > Lifetouch, Inc.
  > dwilliams_at_lifetouch.com
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.net
  > --
  > Author: DENNIS WILLIAMS
  > INET: DWILLIAMS_at_LIFETOUCH.COM
  >
  > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
  > San Diego, California -- Mailing list and web hosting services
  > ---------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  >
  

  ---

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo http://search.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  INET: roy.e.pardee_at_lmco.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Apr 24 2003 - 11:11:53 CDT