entrance n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Entrance PowerPoint Presentation
Download Presentation
Entrance

Loading in 2 Seconds...

play fullscreen
1 / 48

Entrance - PowerPoint PPT Presentation


  • 205 Views
  • Uploaded on

Entrance. http://dbentrance.com /. Tod Landis MA, Mathematics, UC, Berkeley, 1976 Parlett-Landis Algorithms ONR, Eureka, NorthStar, MicroPro, Island Graphics, Adobe, Borland. Entrance was written with Shane Duan.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Entrance' - terrel


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
entrance
Entrance
  • http://dbentrance.com/
slide2

Tod LandisMA, Mathematics, UC, Berkeley, 1976Parlett-Landis AlgorithmsONR, Eureka, NorthStar, MicroPro, Island Graphics, Adobe, Borland

slide8

Use Entrance PLOT to make charts. PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND year < 2007;

slide9

Essentially any MySQL SELECT statement works. PLOT AXISLABELS, RED LINESELECT year, average FROM cpi WHERE year >= 1960 AND year < 2007;

slide10

Chart setup is simple.PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND year < 2007;

slide11

Just be sure the chart series match up1-to-1 with result set columns. PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND year < 2007;

slide15

. . . and the script that made them:

    PLOT SCATTER        X, FILLED CIRCLE, DATALABELS CENTERED,        SIZE OVERRIDE, COLOR OVERRIDE      WITH        SCALE X 0 75 25        SCALE Y 0 120 40        NO XAXIS        NO YAXIS        NO SIDES    SELECT x,y, l, s, c        FROM t;

slide17

. . . and the script that made it:

PLOT EARTHCHART

X, VERY SMALL FILLED YELLOW CIRCLE

SELECT LON, LAT

FROM ACCESS_LOCIDS

;

slide19

. . . and the script that made them:

PLOT ROTATEDBARCHART

AXISLABELS, LIGHT RED BAR

WITH

FONT "sans serif" PLAIN 24

NO SIDES

NO XAXIS

NO LABELS X

NO TICKS X

SELECT

CONCAT(application_area, ' - ', count(*)),

count(*)

FROM lead_capture

GROUP BY application_area

ORDER BY count(*) DESC;

slide21

. . . and its script:

PLOT SCATTER

X,RED FILLED CIRCLE

WITH

FONT "sanserif" plain 18

TITLE "Boiling Points of the Elements"

TITLE " "

GRIDLINES

TITLE Y "Degrees Fahrenheit"

FORMAT Y DECIMAL "#.##\u00B0"

SCALE Y -4000 12000 4000

TITLE Y2 "Degrees Centigrade"

FORMAT Y2 DECIMAL "#\u00B0"

SCALE Y2 -2240 6649 2222.25

TITLE X "Element Number"

SELECT

number, F

FROM boiling;

slide23

. . . and how to make them:

PLOT BARCHART

LIGHT BLUE BARS, COLOR OVERRIDE

WITH

FONT "sans serif" plain 24

LEGEND RIGHT

LIGHT RED LEGENDITEM "Interesting"

NO YAXIS

NO SIDES

SELECT

jan AS 'Not interesting',

IF(year = 1920 or year = 1921,

'light red', '') FROM CPI

LIMIT 12;

slide25

See http://dbentrance.com/blog/

for more examples.

(A good one: search for “Benson”)

slide26

PLOT scripts can also be run from the command line or EntranceServlet.

(The servlet makes us cloud friendly)

slide27

Use Entrance to make

simple, clear data graphics.

(No 2.5D, no chart junk)

slide28

Use Entrance + MySQL

to perform data analysis.

slide29

This script “tags” inflection points.

PLOT AXISLABELS, SKYBLUE LINE, DATALABELS ABOVE, DATALABELS BELOW WITH PAGE HALF FONT "sanserif" plain 13 TITLE CENTER "Monthly Average Stock Prices, 1928-1932" NO SIDES NO YAXIS NO XAXIS COLLARSELECT b.date,b.p, IF(b.p > a.p and b.p > c.p, b.date, ''), IF(b.p < a.p and b.p < c.p, b.date, '') FROM price_earnings a, price_earnings b, price_earnings c where b.date > 1928 and b.date < 1933 and a.rownumbers = b.rownumbers - 1 and b.rownumbers = c.rownumbers - 1 ;

slide31

This script uses a COLOR OVERRIDE:

PLOT VERY THICK SKYBLUE LINE, COLOR OVERRIDE NO YAXIS NO XAXIS NO SIDESSELECT jan, IF(year >= 1960 and year <= 1980, 'red', '') FROM CPI where year >= 1920 ;

slide33

Scripting the Red-Blue States:

 name                  who               --------------------  --------------    Alabama               strong mccain     Alaska                strong mccain     Arizona               strong mccain     Arkansas              strong mccain     California            strong obama      Colorado              strong obama      Connecticut           strong obama      Delaware              strong obama     

...

slide34

Use a COLOR OVERRIDE:

PLOT USColoringBook LAYER, COLOR OVERRIDE WITH -- maintain the frame aspect ratio 500:375 PAGE 0 0 500 375 BACKGROUND gray FOREGROUND white SELECT name, CONCAT( if(who LIKE 'leaning%', 'light', ''), ' ', if(who LIKE '%mccain', 'red', 'blue')) FROM election_projection WHERE who NOT LIKE 'tossup'UNIONSELECT name, 'very light yellow' FROM election_projection WHERE who LIKE 'tossup'UNIONSELECT "states_outline", "white";

slide36

The basic system can be extended:

PLOT MAPCHART -- MapQuest API RED CIRCLE, LON, DATALABELS LEFT WITH MAP CENTER 37.14421218525334 -122.1341232266594 MAP SCALE 350000SELECT 37.14421218525334, -122.1341232266594, "OUR HOUSE";

slide42

Hans Rosling’s interesting

demonstrations are similar:

http://gapminder.org/

slide43

RequirementsEntrance is cross platform.It requires Java JRE 1.5 or greater + access to a MySQL server.* There are ways to use Entrance with other JDBC databases, too.

slide44

Access to the MySQL server isa problem with some ISPs. Install a local copy of MySQL and download data in those cases.(You can also tunnel if SSH is available)

slide45

Use Entrance Tools | Import to load

data into a local copy of MySQL.

Entrance Import can import data

directly from the web, eg. we use

it to import PHP script output.

slide46

Use Edit | Paste as table...

to paste clipboard data into

a local copy of MySQL

entrance1
Entrance
  • http://dbentrance.com/blog
  • Entrance Help | PLOT Syntax
  • Entrance Google Group
  • http://twitter.com/todlandis
  • & we follow #entrance
  • Tod Landis
  • tod@dbentrance.com