On Fri, 29 Mar 2013 11:56:23 -0400 Miles Fidelman <[email protected]> wrote:
> > Interesting. This is the first time I have ever seen the word > > "cleverly" used in connection with data bases. Every time I look at a > > schema I think, what an incredibly stupid way to look at the world > > :-) Perhaps somebody can explain to me why tables aren't brain dead. > > The basic underlying principal of relational databases is that data can > be "normalized" into tables - which makes it a lot easier to organize, > store, and compute. Rigth - one DB I made and use has ~30,000 fish-net records which relate to ~5,000,000 fish records, and I want to query out small subsets of fish for an interactive web app. For a particular question, like male fish caught in region MI-7 by the Michigan DNR in June-Dec, I could probably code up something fast enough, probably needing to resort to C(++). Indexes would need to be built of course. I'd have to code each question separately. The DB's cleverness is in working out how to answer all kinds of variations on that sort of question quickly, without bothering me with the details. Cheers -Terry -- You received this message because you are subscribed to the Google Groups "leo-editor" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/leo-editor?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
