Re: [Modeling-users] Re: Implementing inheritance through vertical mapping
Status: Abandoned
Brought to you by:
sbigaret
From: Sebastien B. <sbi...@us...> - 2003-10-22 18:14:41
|
Hi, Federico Heinz <fh...@vi...> wrote: > On Sat, 2003-10-04 at 11:35, Sebastien Bigaret wrote: > > Prerequisite (at least for me:) > > * define a sample model, one root entity A, two sub-entities B and > > C, and at least one sub-entity D for B (we need a sub-sub-entity to > > make sure that the support for vertical mapping will support an > > inheritance tree of any depth). Given this sample model, define: > > - the derived db-schema, > > - SQL statements for selecting, inserting, updating and deleting all > > those 4 entities. >=20 > Well, I've done these, please find them attached. I extended the > StoreEmployee model to add a special kind of SalesClerk, the > AreaSupervisor who gets a commission on the area's sales. I'm providing > the pymodel, the SQL schema as Modiling creates it today, the vertical > mapping schema, and the examples. As you might expect, there are no big > surprises in any of these... Thanks a lot! Unfortunately I probably won't be able to study this in detail in the next two or three weeks; I'm currently fighting against a medical problem, nothing serious, but kind of tiring and I won't probably find the energy to concentrate on that until the surgery... but if I do I'll drop a line or two here of course ;) Sorry for the delay, and again, thanks for the examples. -- S=E9bastien. |