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...
Don E Tonner
don.tonner@...
May 2, 2001 3:37 am
763
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...
Bill MacLean
bmaclean@...
May 2, 2001 2:20 pm
764
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...
joseph_w_newcum@...
May 2, 2001 2:25 pm
765
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...
Scot A. Becker
scotb@...
May 2, 2001 2:58 pm
766
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...
Don E Tonner
don.tonner@...
May 3, 2001 12:47 am
767
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 ...
John Miller
jMiller@...
May 3, 2001 1:10 am
768
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...
Tanase, Gabriel (CAP,...
gabriel.tanase@...
May 3, 2001 2:05 pm
769
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...
Tanase, Gabriel (CAP,...
gabriel.tanase@...
May 3, 2001 2:05 pm
770
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 ...
Bill MacLean
bmaclean@...
May 3, 2001 7:11 pm
771
... 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 ...
Don E Tonner
don.tonner@...
May 3, 2001 7:56 pm
772
In article <71AFA730AA65DF4AA60D02A1BF4129A72A4A@...>, John Miller <jMiller@...> writes <snip> ... <snip> Actually, ORM lacks an...
John G Harris
niam@...
May 5, 2001 6:27 pm
773
Nicely expressed. Pat ... From: "John G Harris" <niam@...> To: <jcm@yahoogroups.com> Sent: Saturday, May 05, 2001 1:19 PM Subject: Re: [JCM]...
Pat Hallock
path@...
May 5, 2001 7:52 pm
774
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...
michael.dunkin@...
May 17, 2001 8:36 pm
775
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...
Pat Hallock
path@...
May 17, 2001 11:19 pm
776
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...
Don E Tonner
don.tonner@...
May 17, 2001 11:19 pm
777
[...] ... version ... Is there a way to get on the beta testing list? Randy Kahle...
RandolphS. Kahle
RandyKahle@...
May 17, 2001 11:42 pm
778
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...
Pat Hallock
path@...
May 18, 2001 1:29 am
779
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...
Terry Halpin
TerryHa@...
May 18, 2001 5:52 pm
780
Terry - does this mean that to use ORM we have to buy into .Net, or will we be able to get if in Visio?...
Larry Lynn
llynn@...
May 18, 2001 11:13 pm
781
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...
geverest@...
May 19, 2001 12:54 pm
782
<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...
John G Harris
niam@...
May 20, 2001 8:50 pm
783
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...
Hugo Kornelis
HKor@...
May 20, 2001 8:50 pm
784
... 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...
Patrick Hallock
path@...
May 20, 2001 9:30 pm
785
... 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...
geverest@...
May 21, 2001 2:14 pm
786
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?...
joseph_w_newcum@...
May 21, 2001 2:14 pm
787
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 ...
Tanase, Gabriel (CAP,...
gabriel.tanase@...
May 21, 2001 2:32 pm
788
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...
Terry Halpin
TerryHa@...
May 21, 2001 5:23 pm
789
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...
Joe Maguire
joemag@...
May 21, 2001 5:24 pm
790
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....
Bill MacLean
bmaclean@...
May 21, 2001 5:24 pm
791
... From: <joseph_w_newcum@...> To: <jcm@yahoogroups.com> Sent: Monday, May 21, 2001 8:10 AM Subject: Re: [JCM] Elementary fact sentences ... a ... ?...