Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re^2: Array values into a database help!

by aquarium (Curate)
on Nov 28, 2010 at 22:38 UTC ( #874143=note: print w/ replies, xml ) Need Help??

in reply to Re: Array values into a database help!
in thread Array values into a database help!

but on the other other hand, maintaining data in unnormalised table is horrible and easy to you end up essentially having to enforce a relational join in code, rather than at the structural/DB level. any and every operation on the table will have the capacity to ruin/corrupt the data.
i think it essential that the relational model and normalisation is understood and first tried, before if/any decision to de-normalise. such de-normalisation decisions should be based on quantitative performance measurements; not on mere pondering. As a possible guideline using current technology, millions of rows in a normalised table with two or more relationships (joins) would make for a possible candidate for de-normalisation. And if performance metrics and other factors dictated de-normalisation, central functions are developed that will always be used to Create Read Update Delete the table, to avoid data corruption.
not trying to be too hard-up about this..but maintaining a relational database through code is not easy or desirable at the outset. Better chance of success using normalised tables instead.

the hardest line to type correctly is: stty erase ^H

Comment on Re^2: Array values into a database help!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://874143]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (13)
As of 2015-11-30 14:57 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (774 votes), past polls