Denormalising CSV tables

[Mike Doub]

Basically createa direct access to all the child tables.

On Sunday, March 15, 2015, Mike Doub <mikedoub at gmail.com> wrote:

> Would it not be better to make the child table into an array indexed by
> its ID, then make a single pass thru the parent table using the child ID
> into the array.
>
> Mike
>
> On Sunday, March 15, 2015, Keith Clarke <keith.clarke at me.com
> <javascript:_e(%7B%7D,'cvml','keith.clarke at me.com');>> wrote:
>
>> Folks,
>> Is there a ‘smart’ way to denormalise ‘child' & ‘parent' CSV tables
>> extracted from an RDBMS in LiveCode or is it down to iterating through
>> lists using chunk functions?
>>
>> I have four tables, related in the database as
>> Child-Parent-GrandParent-GreatGrandParent. Each file has its own record ID
>> & the ID of its direct parent. I need to create a ‘DenormalisedChild' file
>> with GrandParent & GreatGrandParent IDs appended to each row.
>>
>> I’m currently assuming the only way forward is to build a
>> tDenormalisedChild variable by repeated iteration at each ‘level’:
>> Iterating through lines of the Child file to compare its ChildParentId
>> with each row in the the Parent file, until ParentRowId = ChildParentId;
>> Repeat (1) on Parent file rows to find ParentGrandParent values;
>> Repeat (1) on GrandParent file rows to get GreatGrandParent values
>>
>> Is their a more efficient approach?
>> Best,
>> Keith..
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>