A Domain Specific Query Language Engine

*
Accepted Session
Short Form
Beginner
Scheduled: Wednesday, June 22, 2016 from 10:00 – 10:45am in B304

Excerpt

This presentation is about the shortest line between a database and data exploration.

Description

This presentation is about the shortest line between a database and data exploration. I assume the database and the graphic tool kits and consider agile data access.

The ‘shortest line’ part suggests domain specific query languages connecting databases to visualization tools. A general query language, like SQL, knows little of the user’s intent and is thereby rendered verbose. Domain specific query languages exploit expert knowledge to craft agile access to data.

In this presentation I describe a domain specific query language engine called the Pythonic Query Language. Python provides a happy basis for our query language engine with its handy string splitting, build in methods, and import Anything.
Examples will be presented for plotly and matplotlib.

Tags

Domain Specific Query Language, python, DSQL

Speaking experience

I've lectured widely as a PhD Physicist and am currently an instructor at Reed College. I've given versions of this talk at the Portland Python meetup and the Portland Data Science meetup (http://www.meetup.com/Portland-Data-Science-Group/).

Speaker

  • Biography

    Education:

    Undergraduate Study, 1980-1983 DePaul University

    Masters in Physics, 1986, Brown University

    PhD in Physics, 1990, Brown University

    Awards and Fellowships:

    American Physical Society Summer Research Fellowship, 1983, Bell Telephone Laboratories, Murray Hill, NJ

    Sigma Chi Outstanding Doctoral Thesis Award, 1990, Brown University

    Alexander von Humboldt Fellowship, 1992-1994, University of Ulm, Ulm, Germany

    European Research Fellow, 1994, Denmark Technical University, Lyngby, Denmark

    Experience:

    Project Manager, Fox River Learning, Fox River, IL, (1997-1998)

    Director of Quantitative Research, Fox River Financial Resources, Fox River, IL, (1999-2000)

    Full time Dad, (1999-2015)

    Owner / Operator of the Sports Data Web Site SportsDatabase.com (1999 – present)
    http://SportsDatabase.com

    Author of the Sports Data Query Language
    http://SDQL.com

    News Reporter and Public Affairs Host at Portland Radio Station KBOO (2010 – present)
    http://kboo.fm/search/node/joe%20meyer

    Author of the Pythonic Query Language
    http://PyQL.org

    Physical Education Instructor, Reed College, Portland, Oregon, (2015 – present)

    Sessions

Leave a private comment to organizers about this proposal