Re: Define "flatten database" ?
From: pc <toledobythesea_at_oohay.moc>
Date: Fri, 28 Jan 2005 03:34:08 GMT
Message-ID: <QoiKd.158145$KO5.52664_at_clgrps13>
>
>
> Hi Fred,
>
> The only situations where I have heard this term is when (part of) the
> contents of a database are copied to one or more sequential files. The
> reason to do this is usually to speed up a batch process (using balanced
> line processing to process many thousands of transactions against the
> flattened contents of the database, then rebuilding the database).
>
> Best, Hugo
Date: Fri, 28 Jan 2005 03:34:08 GMT
Message-ID: <QoiKd.158145$KO5.52664_at_clgrps13>
Hugo Kornelis wrote:
> On 27 Jan 2005 11:41:39 -0800, silversw2000_at_yahoo.com wrote:
>
>
>>Can someone define "flatten database" for me, in 100 words or less (OK >>500 words is fine).
>
>
> Hi Fred,
>
> The only situations where I have heard this term is when (part of) the
> contents of a database are copied to one or more sequential files. The
> reason to do this is usually to speed up a batch process (using balanced
> line processing to process many thousands of transactions against the
> flattened contents of the database, then rebuilding the database).
>
> Best, Hugo
unless it's put on paper, i think Mikito is right (i don't know how to re-combine posts, pardon me) when he says ""Flatten database" means removing all the curvatures. Start applying slicing and dicing intil the database get above the 1st normal form. If there is no schema to begin with, then use stylesheet transformations generously. I could go on, but it would exhaust your limit of 500 words."
i hope i would've asked interviwer "define flat?" and if they dodged, "alright, how flat?", but i avoid wine before interviews. maybe i should apply that to newsgroups too!
p
all Received on Fri Jan 28 2005 - 04:34:08 CET