Hi All:
Thanks Davor, for the info ...
Some more queries on querying ORDBMS ...
1. Is it wise to go for ORDBMS/ODBMS if my data has too many
many-to-many relationships? (However, the data is low in volume and
transaction-frequency).
2. Imagine a scenario where I have a base Class/Type ... and 4 derived
Class/Type ... I represent it as usual in RationalRose-UML... what does it
create nested-table or nested-types?
3. How can I get to the correct subClass/subType data at run-time ?
Does the ORDBMS(Oracle) retrieve the correct-sub-type-data dynamically?
(some-what like dynamic-binding in C++)
Thanks in advance
Prem
-----Original Message-----
From: Gornik, Davor [mailto:[EMAIL PROTECTED]]
Sent: 31 March 2001 2:40
To: PREMKUMAR, N [Non-Pharmacia/8042];
'[EMAIL PROTECTED]'
Subject: RE: (ROSE) OBJECT - RELATIONAL Database
Modeling
Lets go for the first 3. Do not know the answer to the last
two.
Davor
-----Original Message-----
From: PREMKUMAR, N [Non-Pharmacia/8042]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 11:24 AM
To: '[EMAIL PROTECTED]'
Subject: (ROSE) OBJECT - RELATIONAL Database Modeling
Hi All,
I have to represent complex-biology-data in a
database that would
require more abstractions to be built-in so that the db
would answer all the
generic queries.
Can anyone tell me about:
* the advantages of using OBJECT-RELATIONAL features
in database
in terms of application-coding,
generic-context-related-search etc.
dg> ORDBMS will give you the ability to be more flexible in
defining your
tables by using domains, user defined data types, etc.
however do not expect
to be able to store multidimensional data with less effort
than in RDBMS.
The ORDBMS offer more possibilities for relationships
between tables.
Storing bio-data (and here i do not know about the kind of
data you are
talking about - bio is huge) always depends on some
primitive factors:
amount of data, size of data, type (or kind) of data, etc. -
there can not
be an overall suggestion to go for ORDBMS, OODBMS, or even
an RDMBS, which
would still be the first choice in 90% of cases.
* to what extent oracle supports ORDB functionalities.
Besically the support of ORDBMS is the same at all of the
major companies.
The offer some typing possibilities, and some additional
relationships. They
offer inheritance, etc. Do not forget that using any of
these with huge
amount of data costs huge amount of time.
* to what extent RationalRose supports ORDB designing.
Rational Rose supports user defined domains
* Any sample-implementations (app-side and db-side )
available in
public-domain?
do not know.
* Any helpful sites .. regarding this.
sorry
Thanks verymuch in advance
Prem
-----Original Message-----
From: Patrick Kennedy
[mailto:[EMAIL PROTECTED]]
Sent: 30 March 2001 8:06
To: R Thirunavukkarasu;
[EMAIL PROTECTED]
Subject: Re: (ROSE) Primary Key in
Data modeler
Assumming you have 2001 (feature did not
exist yet in 2000e)
right click on the attribute in question in
the Rose
Browser,
Data Modeler, Part of object Identity. It
will now be used
as the PK when you transform.
Patrick Kennedy
Rational Support
On Mar 29, 17:23, R Thirunavukkarasu wrote:
> Subject: (ROSE) Primary Key in Data
modeler
>
> Hi all,
>
> While transforming a package from logical
view to
> schema, Rose adds primary key for each
table. Instead
> I want to define one of the attributes in
the class as
> the identifier and use that as primary
key. Can
> anybody tell how to change this option in
Rose?
>
> Thanks in advance
>
> R.Thiru
>
>
__________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo!
Mail.
>
http://personal.mail.yahoo.com/?.refer=text
>
************************************************************************
> * 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 R Thirunavukkarasu
************************************************************************
* 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
*
*************************************************************************
************************************************************************
* 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
*
*************************************************************************
RE: (ROSE) OBJECT - RELATIONAL Database Modeling
PREMKUMAR, N [Non-Pharmacia/8042] Sat, 31 Mar 2001 07:05:23 -0800
- RE: (ROSE) OBJECT - RELATIONAL Database ... Gornik, Davor
- (ROSE) OBJECT - RELATIONAL Database... PREMKUMAR, N [Non-Pharmacia/8042]
- RE: (ROSE) OBJECT - RELATIONAL Data... Shaik, Siraj
- PREMKUMAR, N [Non-Pharmacia/8042]
