Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

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 pondering the Monastery: (9)
As of 2020-05-26 13:42 GMT
Find Nodes?
    Voting Booth?
    If programming languages were movie genres, Perl would be:

    Results (150 votes). Check out past polls.