Re: database design patterns for the desperate
Re: database design patterns for the desperate
- Subject: Re: database design patterns for the desperate
- From: Michael Gargano <email@hidden>
- Date: Thu, 12 May 2011 08:23:42 -0700
- Acceptlanguage: en-US
- Thread-topic: database design patterns for the desperate
I work on reporting apps against a warehouse, so I have to straddle the line between objects and things people load in the backend and report off of directly.
On May 11, 2011, at 4:51 PM, Mark Wardle wrote:
> Can you re-imagine your problem as objects instead of thinking of the
> database or do you have other code accessing SQL directly?
>
> Mark
>
> On 11 May 2011 20:14, Michael Gargano <email@hidden> wrote:
>> I was just talking to David Holt about this and he suggested I tap the brain trust. :)
>>
>> I was wondering if there is a database design pattern for a situation where I have some template structure
>> let's say
>>
>> tA <->> tB <->> tC (records across these tables are the template, the template is a whole object graph rooted at one record in tA)
>>
>> where the templates can be configured on a per tenant basis (so, the templates themselves are records that define defaults and new ones can be added when new tenants or templates are added). I need to make a copy of a template that a tenant uses and make it local to a user (under that tenant) who can then customize the values in that template for their needs.
>>
>> It's basically a class/instance kind of structure, but at the data level in the database. It's as if I need to copy an EOs from one table to another where the destination table has a few more attributes than the source table did. It's made more complicated by the fact that I need to copy that template object graph, not just one EO.
>>
>> Any suggestions?
>> *Hopes beyond hope*
>>
>> Thanks.
>> -Mike
>>
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>>
>>
>
>
>
> --
> Dr. Mark Wardle
> Specialist registrar, Neurology
> Cardiff, UK
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden