A Domain Specific Query Language Engine

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


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


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.


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/).


  • Biography


    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


    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)

    Author of the Sports Data Query Language

    News Reporter and Public Affairs Host at Portland Radio Station KBOO (2010 – present)

    Author of the Pythonic Query Language

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


Leave a private comment to organizers about this proposal