I'm having difficulty expressing something in ORM. Given these facts: An Episode(id) has exactly one ShowType(cd). A ShowType(cd) is allowed zero or more...
763
Bill MacLean
bmaclean@...
May 2, 2001 2:20 pm
I am not sure exactly what a ProgramReferral is, but the pattern of problem you outline can be solved via a join subset constraint. If you join the Episode and...
764
joseph_w_newcum@...
May 2, 2001 2:25 pm
Pat, you wrote: "Joseph - I am only getting one side of this conversation - who is the other side? I am getting all of your responses, but to what? Pat...
765
Scot A. Becker
scotb@...
May 2, 2001 2:58 pm
Hi Don, ... To elaborate on what Bill said: 1) The fact that an Episode has Program referrals is completely derivable because it plays a mandatory functional...
766
Don E Tonner
don.tonner@...
May 3, 2001 12:47 am
Thanks Scot, et al. ... Funny you mention that. I'm designing changes to an existing database where One of the application teams has had the most say in how...
767
John Miller
jMiller@...
May 3, 2001 1:10 am
Hello all, I've been asked by Microsoft to write an introduction to Object Role Modeling for data modelers paper for publication on their MSDN site in ...
768
Tanase, Gabriel (CAP,...
gabriel.tanase@...
May 3, 2001 2:05 pm
Hello to all ORMers, There's fresh article out, maybe of interest for anyone who looks at XML + UML effects on modeling: "Visual Schema Design with UML", by...
769
Tanase, Gabriel (CAP,...
gabriel.tanase@...
May 3, 2001 2:05 pm
So we've got the first hint as to when: "... in Visio 2002". Should be worth the wait... Regards, Gabriel Tanase Database Modeler GE Insurance Holdings GEIS...
770
Bill MacLean
bmaclean@...
May 3, 2001 7:11 pm
I'm not sure that the fact about Episode and ProgramReferral is derivable, because the way I read it, a Showtype has a number set of allowable ...
771
Don E Tonner
don.tonner@...
May 3, 2001 7:56 pm
... That's true. I drew in the derived fact, and Scott's recommended constraint, then realized that the derived fact was not derived! But I do believe the ...
772
John G Harris
niam@...
May 5, 2001 6:27 pm
In article <71AFA730AA65DF4AA60D02A1BF4129A72A4A@...>, John Miller <jMiller@...> writes <snip> ... <snip> Actually, ORM lacks an...
773
Pat Hallock
path@...
May 5, 2001 7:52 pm
Nicely expressed. Pat ... From: "John G Harris" <niam@...> To: <jcm@yahoogroups.com> Sent: Saturday, May 05, 2001 1:19 PM Subject: Re: [JCM]...
774
michael.dunkin@...
May 17, 2001 8:36 pm
Hello all, I was reading posts from years past when I came across the message below, which suggests that there may be a mechanism for translating between ORM...
775
Pat Hallock
path@...
May 17, 2001 11:19 pm
David is the writter of that software, I"ll let him reply. But, please note that the Beta2 of MSVisio2002 will be available soon. This has the first version of...
776
Don E Tonner
don.tonner@...
May 17, 2001 11:19 pm
If the purpose is to model a relational database, optimized for flexibility and growth, then here's an approach I have used in the past. "Model" the database...
777
RandolphS. Kahle
RandyKahle@...
May 17, 2001 11:42 pm
[...] ... version ... Is there a way to get on the beta testing list? Randy Kahle...
778
Pat Hallock
path@...
May 18, 2001 1:29 am
There are a couple of ways. If your subscribe to MSDN (expensive) you gt all betas and software form MS. You can only us it on a dedicated machine. Visit MSDN...
779
Terry Halpin
TerryHa@...
May 18, 2001 5:52 pm
The versions of Visio 2002 being released at the end of the month are Standard and Professional. These do not include the deep ORM solution that...
780
Larry Lynn
llynn@...
May 18, 2001 11:13 pm
Terry - does this mean that to use ORM we have to buy into .Net, or will we be able to get if in Visio?...
781
geverest@...
May 19, 2001 12:54 pm
BACK TO BASICS! We would all agree that "Ann Smiles" is an elementary fact sentence (per Halpin text, though I prefer smiling to smoking). Is "Ann smiles...
782
John G Harris
niam@...
May 20, 2001 8:50 pm
<snip> ... I agree, almost. Another example is Ann is a "frequent flyer" In the airline's database this is certainly a derived fact. There's a detailed rule...
783
Hugo Kornelis
HKor@...
May 20, 2001 8:50 pm
Hi Gordon, ) We would all agree that "Ann Smiles" is an elementary fact sentence Yes. ... Yes. Even though this one example is not yet sufficient to see is...
784
Patrick Hallock
path@...
May 20, 2001 9:30 pm
... Pat - A derived fact or not a derived fact type is different than elementary. I would assume that a derived fact type has been reduced to elementary. I...
785
geverest@...
May 21, 2001 2:14 pm
... Is smiling and being happy while performing NIAM okay as well? Best, Hugo REPLY FROM G. EVEREST. Absolutely, since NIAM is the precursor to ORM, and unless...
786
joseph_w_newcum@...
May 21, 2001 2:14 pm
Why does how a database will be designed have any impact on whether or not a particular sentence is, or is not, a FACT in the UoD?...
787
Tanase, Gabriel (CAP,...
gabriel.tanase@...
May 21, 2001 2:32 pm
Hi, I'm a bit surprised to hear that ORM 'avoids' normalisation. Maybe I'm too much of a newbie in ORM, but, as far as I can tell, the quest for elementary ...
788
Terry Halpin
TerryHa@...
May 21, 2001 5:23 pm
A public announcement has just gone out. The deep ORM solution will be part of Microsoft(r) Visual Studio.NET Enterprise Architect (VSEA). You can see the...
789
Joe Maguire
joemag@...
May 21, 2001 5:24 pm
ORM is one of several modeling techniques that avoid normalization. The goal is to have a database whose relations are in high normal form -- third normal...
790
Bill MacLean
bmaclean@...
May 21, 2001 5:24 pm
You're right about the functional dependencies, but from a practical standpoint, it always seems to me like I'm not doing any normalization when doing ORM....
791
Pat Hallock
path@...
May 22, 2001 12:41 am
... From: <joseph_w_newcum@...> To: <jcm@yahoogroups.com> Sent: Monday, May 21, 2001 8:10 AM Subject: Re: [JCM] Elementary fact sentences ... a ... ?...
