Data Painting with Entrance and MySQL
Tod Landis
MySQL conference on Wednesday, April 14th, 7pm:
http://en.oreilly.com/mysql2010/public/schedule/presentations/Ignite+MySQL
Slides for the talk are here:
http://dbentrance.com/misc/painting_ignite.ppt
Slide 3 is complete chart over-kill, but stay with it.
Here is the real point ...
If you know a little SQL, it is easy to chart
data in a MySQL database using Entrance PLOT. Then
you can use SQL to paint colors are the chart using
SQL techniques you are familiar with... things like
UPDATE, IF(), and so on.
The PLOT syntax document is here:
http://dbentrance.com/newdocs/plotsyntax.html
You can also paint data interactively by dragging out
boxes out over data points in a chart The technique
works a lot like the "brushing" techniques introduced
by William Cleveland (eg. see "Brushing Scatterplots" by
Becker and Cleveland, Technometrics, May 1987).
What makes the Entrance approach different and interesting
is that we write color names back into underlying database where
they are visible to other applications. Even on other workstations,
web servers, etc.
This kind of color painting is supported by both our IDE and
Community versions.
Both community and enterprise versions also contain Java
underpinnings in support of painting and data exploration.
So far, they're sparsely documented, but the documentation is
coming. The point of the API is to make it possible for Java
developers
to add new charts by extending Chart., and these extensions can be
either explorable or not exploraable without breaking things.
- Tod
|