When mapping a relational database to Java one needs to use an O/R mapping layer of some type. Most work best, and most consistently, if the underlying...
Randolph S. Kahle
RandyKahle@...
Mar 3, 2003 2:45 pm
1365
We as well often use user-meaningless keys. For example Person (id) is the system "id". Another fact, Person has Employee (number) is another fact which is...
If you use external facts to specify surrogate keys then you can't use the "Add to object type name" naming option that is available for internal reference...
John Miller
jMiller@...
Mar 3, 2003 5:58 pm
1367
Journal of Conceptual Modeling May 2003 Issue: 28 <http://www.inconcept.com/jcm> Editor's Corner by Patrick Hallock What Do You Mean? by Fabian Pascal Most...
Hello, I've been playing with Visio ORM and came across this interesting situation: I have the constraints between department and Employee: [Department] has...
Wolfgang Baeck
wbaeck@...
Jun 11, 2003 7:00 pm
1369
I got the same results - however it all depends on how you define the subtype. If you allowed for default mapping then the manager is part of the Employee...
Pat, Thanks for trying it out. I did exactly what you did before I posted and it doesn't create the three tables. I use Visio EA 10.0.2705 Did you do something...
Wolfgang Baeck
wbaeck@...
Jun 11, 2003 8:10 pm
1371
Sorry - yes I did and an attribute to manager. I tried that first. It did not work because of the option for subtype mapping. So now between the 2 fo use we...
Doesn't work for me in my settings. Attached is a zip file if you would be so kind and look at it. Open the Logical1.vsd as the logical diagram having all...
Wolfgang Baeck
wbaeck@...
Jun 11, 2003 8:44 pm
1373
Wolfgang, your original solution is fine (see attachment for conceptual and logical models). The Department table allows the same employee to manage many ...
This is what you got and I think it is correct. You have a manager table. Your have a department table. In your ORM model you put: Notice the uniqueness...
Here is another thought: I did not check this out, but assume you wish to record when the manager began managing the Department. Then you would have to create...
Is there a way in VISIO EA ORM to provide the derivation rules for facts in such a way that when the Physical Data-type SQL Server is selected it will end up...
Wolfgang Baeck
wbaeck@...
Jun 14, 2003 4:31 pm
1377
The RMAP routine does not create derived columns (virtual columns). I assume you mean columns that are not actually part of the table as such, but can be...
Pat is correct that there isn't any to use ORM to specify the rules. However, you could mark a fact as derived and stored, which will make an actual physical...
bmaclean@...
Jun 15, 2003 3:57 pm
1379
Pat is correct that there isn't any to use ORM to specify the rules. However, you could mark a fact as derived and stored, which will make an actual physical...
bmaclean@...
Jun 15, 2003 3:57 pm
1380
Hi, I need to extend the following model and would like your input. The following are some facts that are not necessarily part of this model but are required...
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 5:42 pm
1381
Sorry for trying to have the pictures in the message. They are attached now. Wolfgang Hi, I need to extend the following model and would like your input. The ...
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 6:06 pm
1382
Hello, Mr. Baeck: Why do your customers want to assign tasks directly to individuals? Is it because they relate better to the people performing the roles,...
Stone, Ken
Ken.Stone@...
Jun 16, 2003 6:42 pm
1383
Ken, It is because they can envision tasks being assigned that are neither due to a FosterHome or a FosterChild. I would argue that they should use the...
Wolfgang Baeck
wbaeck@...
Jun 16, 2003 8:06 pm
1384
Wolfgang, Why not integrate your workflow management system with Outlook, to publish all tasks on the Outlook task list? Regarding your model and the problem...
Stone, Ken
Ken.Stone@...
Jun 17, 2003 12:29 am
1385
Ken, Thanks for the additional abstractions, they are helpful. Now to the integration with Outlook. The problem here is, and that's why it has been abondoned,...
Wolfgang Baeck
wbaeck@...
Jun 17, 2003 2:19 am
1386
Wolfgang, Automatic reassignment may be impractical in Outlook as-is, but it might be easy in other workflow engines/toolsets that work with queues of tasks ...
Or, perhaps, instead of using the _user's_ Exchange mailbox, have a seperate "folder" in the "Public Folders" area and then just assign/reassign it with ...
Darryl L. Rowe
darrylr@...
Jun 18, 2003 11:37 pm
1388
Hi, The general principle of a full span UC on nested facts I'm happy with. However I've come across a problem when the fact is representing temporal ...
Chris Bruce
chris@...
Jun 27, 2003 1:35 pm
1389
Hi Chris, I've argued that the full spanning UC requirement for nesting unnecessarily contributes to the instability of the model and your scenario is another...
John Miller
jMiller@...
Jun 27, 2003 4:33 pm
1390
... From: John Miller [mailto:jMiller@...] Sent: Friday, June 27, 2003 10:38 AM To: jcm@yahoogroups.com Subject: RE: [JCM] Problem with mandated full...
Sometime the ternary do get broken down because of the current rule. That rule will change in the future. However, now you have set of binaries and no ternary...