This was excellent Martin. You answered the question I was trying to ask: How are JEQL and SQL different?
I'll read some more about JEQL when I have some time. Thanks for the additional explanation. Landon On Jan 23, 2008 10:02 AM, Martin Davis <[EMAIL PROTECTED]> wrote: > Landon, > > After pondering your excellent question for a while longer, I realized > there was more that could be said about JEQL vs SQL. So here goes: > > Comparing JEQL directly to SQL, JEQL implements a large (and growing) > subset of SQL, with the language constructs that are most commonly used > for data processing. Of course, there's no such thing as a single "SQL" > - there are numerous versions and dialects. The dialect implemented by > JEQL tries to cherry-pick some of the better, cleaner features of > various existing SQL dialects. JEQL also includes some extensions which > make it easier to express complex processing using SELECT statements > (such as the ability to define named subexpressions in a selected > expression list) > > But a direct comparison to SQL isn't really the right question. To run > SQL you need an engine which can process SQL statements. This usually > means running a database of some kind. Also, you need some sort of > programming language to "glue" together SQL statements. Some databases > have an embedded programming language, some don't. External languages > tend to be verbose and complex to interface to databases (as do some > embedded ones!). Finally, data import and export is not a strong point > of database systems, so that usually means adding some kind of ETL tool > to the mix. > > Once you have this set of tools, you have to: > > - create one or more tables > - import data into the tables > - write a script or program which uses SQL and probably some procedural > logic > - export the results to a destination dataset > - clean up the tables > > With JEQL, you just write a script. > > Now, there's lots of things that the database environment will do which > JEQL > doesn't do. But if you just need to accomplish a small processing task, > all that extra overhead and complexity is a pain. Plus, if you need to > repeat the task a year later, or set up someone else to perform the > task, it's much easier if everything is embodied in a single script. > > A further note: although not currently implemented, JEQL will provide > the ability to directly access tables and queries from databases. Since > there is no "impedance mismatch" between the JEQL data model and the DB > data, this should make for very seamless integration. > > Now, congratulations - you've just contributed the first entry in the > JEQL FAQ! > > > Sunburned Surveyor wrote: > > Martin, > > > > I should have read over the intro page for JEQL more closely. Let me > > do that and then I'll wait for those examples. :] > > > > Landon > > > > On Jan 22, 2008 1:02 PM, Martin Davis <[EMAIL PROTECTED]> wrote: > > > >> Landon, > >> > >> I don't think I can say anything more than is already documented on the > >> JEQL intro page: http://tsusiatsoftware.net/jeql/main.html > >> > >> JEQL actually goes a lot further than SQL. Once I get some examples up > >> it should become a lot clearer. > >> > >> > >> Sunburned Surveyor wrote: > >> > >>> Roger that. > >>> > >>> I look forward to checking out some of the other things you have been > >>> working on. I'm curious about the motivation for JEQL. What advantages > >>> does it have over SQL? > >>> > >>> Landon > >>> > >>> On Jan 22, 2008 11:27 AM, Martin Davis <[EMAIL PROTECTED]> wrote: > >>> > >>> > >>>> Yep, I decided to pull all my various projects into a single place to > >>>> document them. > >>>> > >>>> There *is* no JEQL user guide yet... so I'll remove the link! > >>>> > >>>> > >>>> Sunburned Surveyor wrote: > >>>> > >>>> > >>>>> Martin, > >>>>> > >>>>> Are you the owner/operator of Tsusiat Software? > >>>>> > >>>>> Landon > >>>>> > >>>>> P.S. - The link to the user guide for JEQL was broken. > >>>>> > >>>>> On Jan 22, 2008 11:12 AM, Martin Davis <[EMAIL PROTECTED]> wrote: > >>>>> > >>>>> > >>>>> > >>>>>> At long last JTS has a FAQ (or the beginnings of one). My excuse is > >>>>>> that I wanted to wait until there was a large enough population to have > >>>>>> a statistically valid determination of "frequent" 8^) > >>>>>> > >>>>>> It's at: http://tsusiatsoftware.net/jts/jts-faq/jts-faq.html > >>>>>> > >>>>>> Feel free to make suggestions for more content. > >>>>>> > >>>>>> -- > >>>>>> Martin Davis > >>>>>> Senior Technical Architect > >>>>>> Refractions Research, Inc. > >>>>>> (250) 383-3022 > >>>>>> > >>>>>> _______________________________________________ > >>>>>> jts-devel mailing list > >>>>>> jts-devel@lists.jump-project.org > >>>>>> http://lists.refractions.net/mailman/listinfo/jts-devel > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>> _______________________________________________ > >>>>> jts-devel mailing list > >>>>> jts-devel@lists.jump-project.org > >>>>> http://lists.refractions.net/mailman/listinfo/jts-devel > >>>>> > >>>>> > >>>>> > >>>>> > >>>> -- > >>>> > >>>> Martin Davis > >>>> Senior Technical Architect > >>>> Refractions Research, Inc. > >>>> (250) 383-3022 > >>>> > >>>> _______________________________________________ > >>>> jts-devel mailing list > >>>> jts-devel@lists.jump-project.org > >>>> http://lists.refractions.net/mailman/listinfo/jts-devel > >>>> > >>>> > >>>> > >>> _______________________________________________ > >>> jts-devel mailing list > >>> jts-devel@lists.jump-project.org > >>> http://lists.refractions.net/mailman/listinfo/jts-devel > >>> > >>> > >>> > >> -- > >> Martin Davis > >> Senior Technical Architect > >> Refractions Research, Inc. > >> (250) 383-3022 > >> > >> _______________________________________________ > >> jts-devel mailing list > >> jts-devel@lists.jump-project.org > >> http://lists.refractions.net/mailman/listinfo/jts-devel > >> > >> > > _______________________________________________ > > jts-devel mailing list > > jts-devel@lists.jump-project.org > > http://lists.refractions.net/mailman/listinfo/jts-devel > > > > > > -- > Martin Davis > Senior Technical Architect > Refractions Research, Inc. > (250) 383-3022 > > _______________________________________________ > jts-devel mailing list > jts-devel@lists.jump-project.org > http://lists.refractions.net/mailman/listinfo/jts-devel > _______________________________________________ jts-devel mailing list jts-devel@lists.jump-project.org http://lists.refractions.net/mailman/listinfo/jts-devel
