Note that there are two database addins in Rose.
Oracle8 and Data Modeler (see technote below).
They don't mix.
To generate DDL you must have a data model.
To convert a object model to data model, hightlight the package in the
Rose browser containing your object model, right click, Data Modeler:Transform
to Data Model. Then hightlight the schema <<Schema name>> package in the
Rose browser, Data Modeler:Forward Engineer.
See online help, contents tab, Rose Data Modeler, How to.
For more details.
And after updating either the Data or Object model you can use
Transform again to sycn them up.
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, 2000, IBM DB/2 OS390 5 & 6 and DB/2 UDB 5 & 6
and Sybase 12.
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.
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: 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 Jun 26, 8:56, Luca Del Bon wrote:
> Subject: (ROSE) Newbe: generating database scheme with Oracle 8 add-in
>
>
>
>
> Hi,
> I'm using Rational Rose 2001 Enterprise Edition and I want to generate
> a database scheme with Oracle 8 add-in from an Object Model containing single
o
> multiple inheritance.
>
> If I try "Tools->Oracle 8->Schema Generation" selecting one or more
relational
> table
> the resulting message is : "WARNING : Inheritance is not currently supported.
> It will be ignored"
>
> I know the Data Modeler functionality translates inheritance into
"Identifying"
> relationships but is it possible to go back to the Object Model after any
> modification to
> the Data Model ?
>
>
> Thank you,
>
> L.d.B.
>
> ====
>
> Luca Del Bon
> Sirti S.p.A.
> Software Engineering Specialist
>
> Cassina de Pecchi - Milano (Italy)
> [EMAIL PROTECTED]
>
>
> ************************************************************************
> * 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 Luca Del Bon
************************************************************************
* 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
*
*************************************************************************
