Pat Gunn (dachte) wrote,
Pat Gunn

Minds and Datamines

Shower thought: the principles behind database normalisation and those of "deep processing" in human memory are curiously analogous - one could make a strong case that the less normalised a database is, the better the kind of representation it is for being powerfully/usefully remembered by a person. There's an invertedness in that "direction of goodness" though - databases that are far from normal are harder to work with - redundancy becomes a management problem in a database because updates need to think about multiple locations, constraints can only be used in the context of transactions when redundancy is involved, and beyond the runtime concerns, the person writing the query has to think harder to avoid problems (an aside: for those who haven't read much about database philosophy, the 「closed world assumption」 versus 「open world assumption」 is an interesting topic). This isn't so much of a problem for most types of memory in the brain, although if we see the brain as powerfully-non-database-normal, how do updates happen? Perhaps they don't - if database people want to come to some understanding of human memory through this metaphor, they could say that most types are database tables without primary keys, the strongest memories are the least normal (extending normalisation a bit so it could apply to tuples), and imagine a very bizarre query (query optimisation is an interesting analogy-node) manager.


  • Still alive

    Been feeling a bit nostalgic. Not about to return to LiveJournal - their new ownership is unfortunate, but I wanted to briefly note what's been up…

  • Unplugging LJ

    It's about time I pulled the plug on the LJ version of my blog: 1) I'm much more active on G+ than I am with general blogging. I post many times a…

  • Mutual Trust

    I don't know which should be considered more remarkable: That a cat should trust a member of a far larger and stronger species that it can't…

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded