A Domain Specific Query Language Engine*
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
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/).
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)