Скачать презентацию Entrance http dbentrance com Tod Landis MA Скачать презентацию Entrance http dbentrance com Tod Landis MA

ae246f1e360de24f7436cce70461703a.ppt

  • Количество слайдов: 48

Entrance http: //dbentrance. com/ Entrance http: //dbentrance. com/

Tod Landis MA, Mathematics, UC, Berkeley, 1976 Parlett-Landis Algorithms ONR, Eureka, North. Star, Micro. Tod Landis MA, Mathematics, UC, Berkeley, 1976 Parlett-Landis Algorithms ONR, Eureka, North. Star, Micro. Pro, Island Graphics, Adobe, Borland

Entrance was written with Shane Duan. Entrance was written with Shane Duan.

Entrance Commercial Open Source GPL v. 2 Community Version $50 IDE Version Site Licenses Entrance Commercial Open Source GPL v. 2 Community Version $50 IDE Version Site Licenses Encouraged!

PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND year < 2007;

PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND year < 2007;

PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND year < 2007;

PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND PLOT AXISLABELS, RED LINE SELECT year, average FROM cpi WHERE year >= 1960 AND year < 2007;

 Entrance Bubbles. . . Entrance Bubbles. . .

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

An Entrance Earth. Chart. . . An Entrance Earth. Chart. . .

 . . . and the script that made it: PLOT EARTHCHART X, VERY . . . and the script that made it: PLOT EARTHCHART X, VERY SMALL FILLED YELLOW CIRCLE SELECT LON, LAT FROM ACCESS_LOCIDS ;

 Entrance Rotated Bars. . . Entrance Rotated Bars. . .

 . . . and the script that made them: PLOT ROTATEDBARCHART AXISLABELS, LIGHT . . . 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;

 An Entrance Scatter Chart. . . An Entrance Scatter Chart. . .

 . . . and its script: PLOT SCATTER X, RED FILLED CIRCLE WITH . . . 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 "#. ##u 00 B 0" SCALE Y -4000 12000 4000 TITLE Y 2 "Degrees Centigrade" FORMAT Y 2 DECIMAL "#u 00 B 0" SCALE Y 2 -2240 6649 2222. 25 TITLE X "Element Number" SELECT number, F FROM boiling;

 Bars with color overrides. . . Bars with color overrides. . .

 . . . and how to make them: PLOT BARCHART LIGHT BLUE BARS, . . . 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;

 Entrance supports named colors. Entrance supports named colors.

 See http: //dbentrance. com/blog/ for more examples. (A good one: search for “Benson”) See http: //dbentrance. com/blog/ for more examples. (A good one: search for “Benson”)

 PLOT scripts can also be run from the command line or Entrance. Servlet. PLOT scripts can also be run from the command line or Entrance. Servlet. (The servlet makes us cloud friendly)

 Use Entrance to make simple, clear data graphics. (No 2. 5 D, no Use Entrance to make simple, clear data graphics. (No 2. 5 D, no chart junk)

 Use Entrance + My. SQL to perform data analysis. Use Entrance + My. SQL to perform data analysis.

This script “tags” inflection points. PLOT AXISLABELS, SKYBLUE LINE, DATALABELS ABOVE, DATALABELS BELOW WITH This script “tags” inflection points. PLOT AXISLABELS, SKYBLUE LINE, DATALABELS ABOVE, DATALABELS BELOW WITH PAGE "sanserif" plain 13 TITLE CENTER "Monthly Average Stock Prices, 1928 -1932" NO SIDES NO YAXIS N 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, price_earnings a, price_earnings b, price_earnings c where b. date > 1928 and b. date < 1933 and a. rownum b. rownumbers - 1 and b. rownumbers = c. rownumbers - 1 ;

. . . to make plots like these: Tagging data items. . . . to make plots like these: Tagging data items.

This script uses a COLOR OVERRIDE: PLOT VERY THICK SKYBLUE LINE, COLOR OVERRIDE NO This script uses a COLOR OVERRIDE: PLOT VERY THICK SKYBLUE LINE, COLOR OVERRIDE NO YAXIS NO XAXIS NO SIDESSELEC >= 1960 and year <= 1980, 'red', '') FROM CPI where year >= 1920 ;

. . . to highlight a section of a line: . . . to highlight a section of a line:

Scripting the Red-Blue States: name who ---------- Alabama strong mccain Alaska strong mccain Arizona 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 . . .

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

. . . to make the “Red Blue States” map: . . . to make the “Red Blue States” map:

The basic system can be extended: PLOT MAPCHART -- Map. Quest API RED CIRCLE, The basic system can be extended: PLOT MAPCHART -- Map. Quest API RED CIRCLE, LON, DATALABELS LEFT WITH MAP 37. 14421218525334 -122. 1341232266594 MAP SCALE 350000 SELECT 37. 14421218525334, -122. 134123 "OUR HOUSE";

. . . for custom applications: . . . for custom applications:

And now, the live demo. And now, the live demo.

 Hans Rosling’s interesting demonstrations are similar: http: //gapminder. org/ Hans Rosling’s interesting demonstrations are similar: http: //gapminder. org/

Requirements Entrance is cross platform. It requires Java JRE 1. 5 or greater + Requirements Entrance is cross platform. It requires Java JRE 1. 5 or greater + access to a My. SQL server. * There are ways to use Entrance with other JDBC databases, too.

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

 Use Entrance Tools | Import to load data into a local copy of Use Entrance Tools | Import to load data into a local copy of My. SQL. Entrance Import can import data directly from the web, eg. we use it to import PHP script output.

 Use Edit | Paste as table. . . to paste clipboard data into Use Edit | Paste as table. . . to paste clipboard data into a local copy of My. SQL

 Door. Door.

Entrance http: //dbentrance. com/blog Entrance Help | PLOT Syntax Entrance Google Group http: //twitter. Entrance http: //dbentrance. com/blog Entrance Help | PLOT Syntax Entrance Google Group http: //twitter. com/todlandis & we follow #entrance Tod Landis [email protected] com