Dennis - 1+2;) The current project will be build with the "classic" relational data modell. On top of it sits a OR-Mapper (not a full-blown-vapor-ware-application server though ;) and the software will be developed in java. The software development team is VERY experienced with object oriented software development (smalltalk, c++, java, you name it, they've done it). I thought about going with objects (in the database that is) in the beginning but I didn't do it. The main reason for not going with that approach is the fact that things might get mixed up. For one thing, I don't really get stuff like inheritance or interfaces, which are quite important. On the other hand, the business logic would be found partially in the database and partially in the application server. So what would be left except for the encapsulation and abstraction ? Afterall, we used an abstraction layer which is the or-mapper.
Right now, I'm just curious if anybody has experience with object relational oracle features and wether it might be a recommandable approach or not. In theory and on my little playground aka laptop it always looks good, but in real life, ... I don't know. Regards, Stefan -----Original Message----- To: Multiple recipients of list ORACLE-L Sent: 12/20/2002 5:39 PM Stefan - I believe the general consensus had emerged that usually object features aren't worth the effort. Often there are few benefits, and if you don't do it correctly you may see bad performance. Two questions: 1. Are your developers/management enamored with the concept of object, or is this just your own curiosity? 2. Is there something about your application that leads you to believe that it might derive significant benefit from the object features? For general business applications it is hard to beat the flexibility of the good old traditional relational data modeling. The lack of discussion may provide part of the answer to your question. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Friday, December 20, 2002 6:35 AM To: Multiple recipients of list ORACLE-L Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive. Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a "normal" relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ? Any input deeply appreciated, TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Stefan Jahnke INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
