>>>
Hi,I have a litle question, i am modeling a system with Rational Rose
and I like to know if I can import this model from Rational to any
oracle tool in order to simplify our work and how can I do this.
<<<
Depending upon exactly what version (98, 2000, 2000e, 2001) and
edition (Enterprise, professional J, professional Data Modeler,etc.)
there are two Data modeling tools that allow you to generate and
reverse engineer Oracle.
Oracle 8 addin ships wiht Rose 98 and later Enterprise edtions.
Data Modeler addin ships with Rose 2000e & 2001 Enterprise and
Professional Data Modeler edtions.
The technote below gives more information on these addins:
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
************************************************************************
* 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
*
*************************************************************************
