As far as what is released, you have a choice of oracle 8 addin or
Data Modeler. Data Modeler is newer and in general gives you more
features. However at the moment there are a couple of things the
o8 addin will do for you that the DM addin won't, namely
views and objects. At some point in the future the plan is to
roll this into the Data Modeler addin. Besides that, not much
I can tell you about any unreleased or future plans. What finally
makes it into the product and when (not just a vague "some future release"),
is something I could not give you any definitive information on.
New features are something we usually don't discuss until a release
is forthcoming.
Here's more info on o8 addin vs DM addin.
TechnoteID: 11964
PRODUCT: 2000e
OS: Windows/WindowsNT
DEFECT #: N/A
PATCH #: N/A
REFERENCES: N/A
CREATED: 6/1/00
REVISED:
QUESTION: Which addin should I use, Oracle 8 Addin or Data Modeler?
ANSWER:
The main difference is Object-Relation vs. Relational features.
If you are using Oracle 8 and taking full advantage of the
specific object-relational features in Oracle 8 (such as; user
defined types, arrays and nested tables) that were not available
in Oracle 7, then you want to be using the Oracle 8 add-in.
If you are just using Oracle as a relational database and just
using the features that are not object specific, you can
use the Data Modeler add-in.
There are also some other differences between the products.
Oracle 8 add-in ONLY support Oracle 8x.
The Data Modeler add-in supports Oracle 7.x & 8.x, Microsoft SQL
Server 6.5 & 7.x, IBM DB/2 OS390 5 & 6 and DB/2 UDB 5 & 6.
It also supports SQL-92 DDL scripts as the ANSI standard for
most databases.
Data Modeler has suport for both the logical and physical model
Oracle 8 add-in only supports the logical model.
In addition, Oracle 8 add-in supports views as opposed
to the current version of Data Model which does not.
Q) What are Rose/Oracle8's product capabilities?
A) The product capabilities are:
Wizard Assisted, syntactically correct, creation of
Relational tables
Relational Views
Object Types
Object Views
VARRAYS
Nested Tables
Object Tables
Wizard Assisted Schema generation: (via script file or
direct database connection)
Relational:
Tables, Views
Columns
Primary Keys, Foreign Keys
Indexes
Object Relational:
Object Types, Object Tables, Object Views
Attributes, Methods, Map and Order Methods
Collections: VARRAYS, Nested Tables
REF
Wizard Assisted Schema Reverse Engineering: (via direct
database connection)
Relational
Tables, Views
Columns
Primary Keys, Foreign Keys
Indexes
Object Relational
Object Types, Object Tables, Object Views
Attributes, Methods, Map and Order Methods
Collections: VARRAYS, Nested Tables
REF
Wizard Assisted Report Generation
Classes
Columns
Methods
Dependencies
Associations
Sorted by class name
Sorted
For more information on Data Modeler Addin see,
http://www.rational.com/products/rose/datamodel.jsp
Patrick Kennedy
Rational Support
On Nov 27, 17:30, John Jairo Cortes M wrote:
> Subject: Re: (ROSE) Data modeler & Oracle 8
>
> Hi, Patrick Kennedy
>
> This's a good time to ask the rational support people when will be a nice
> (easy and intuituve to use) tool to model relational data.
>
> I mean, it's hard to handle foraing keys, relation and the entity relation
> models on rose. I wish something like the class modeler but that apply to
> Entities (something like the Oracle Designer ). I heard that rational was
> working on it and it'll be ready to december of 2000, it's true?.
>
> john Cortes
>
>
> ----- Original Message -----
> From: "Christophe Geraud" <[EMAIL PROTECTED]>
> To: "Rose Forum" <[EMAIL PROTECTED]>
> Sent: Monday, November 27, 2000 11:00 AM
> Subject: (ROSE) Data modeler & Oracle 8
>
>
> >
> >
> > I want to design a database schema for Oracle 8.1.6 with Rose 2000
> > Enterprise Edition.
> > May I use the "data modeler" or "tool/Oracle8/data type creation wizard"
> > ?
> >
> > Both seems to give good results.
> > But it seems that the data modeler don't permit to create Views or
> > Object Table. Is'nt it ?
> >
> > Thanks for answering
> >
> > Christophe Geraud
> >
> > ************************************************************************
> > * Rose Forum is a public venue for ideas and discussions.
> > * For technical support, visit http://www.rational.com/support
> > *
> > * Admin.Subscription Requests: [EMAIL PROTECTED]
> > * Archive of messages:
> http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
> > * Other Requests: [EMAIL PROTECTED]
> > *
> > * To unsubscribe from the list, please send email
> > *
> > * To: [EMAIL PROTECTED]
> > * Subject:<BLANK>
> > * Body: unsubscribe rose_forum
> > *
> > *************************************************************************
> >
> >
>
>
> ************************************************************************
> * Rose Forum is a public venue for ideas and discussions.
> * For technical support, visit http://www.rational.com/support
> *
> * Admin.Subscription Requests: [EMAIL PROTECTED]
> * Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
> * Other Requests: [EMAIL PROTECTED]
> *
> * To unsubscribe from the list, please send email
> *
> * To: [EMAIL PROTECTED]
> * Subject:<BLANK>
> * Body: unsubscribe rose_forum
> *
> *************************************************************************
>
>-- End of excerpt from John Jairo Cortes M
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
