On Thu, Dec 29, 2011 at 9:21 AM, Ville M. Vainio <[email protected]> wrote: > On Thu, Dec 29, 2011 at 2:57 PM, Seth Johnson <[email protected]> > wrote: > >>>> No reason you can't query a flat file; just no joins involved, is all. >>> >>> Yeah, and you would have to implement sql engine yourself ;-). >> >> >> Huh? Why? If you're talking about tree traversal, I've addressed >> that elsewhere in this thread. But querying a flat table in SQL . . . >> what are you going on about? > > Naive assumption is that database == sql database, unless explicitly > stated otherwise (e.g. "object database", nosql database, etc...). If > we venture outside standard databases, we are talking about custom > binary formats more than anything else - and that's a whole different > conversation that is not of interest to me at this time (seems like > premature optimization when both xml and sqlite seem to perform > acceptably).
Many people do star schemas in SQL; it's just a design for a particular kind of use -- data mining. I'm an old school dBASE coder. Everything I'm talking about here is traditional databases, whether dBASE or SQL. When I say it's compatible with big data, I mean it being flat tables makes it optimal for putting in those environments. The tree traversal I do is the most esoteric thing we're talking about, and it's done using dBASE indexes, aside from the general idea of universal outline contexts. Seth > Overall, threads like this are too long and abstract for me to read. I > trust that relevant bits get summarized under new subject line, as is > usually the case :). -- You received this message because you are subscribed to the Google Groups "leo-editor" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/leo-editor?hl=en.
