drewp for 2007 September 1 (entry 0)

[link] 2007-09-01T17:34:55 Data table with tabulator:

Here's how to use tabulator to render a simple data table.

My test data might be a bit confusing since the terms overlap with tabulator terms. I'm trying to compare query runtimes of various queries on different databases. The result I'm trying to produce is a table showing how long each database took on each query.

Here's my mockup data in n3:

@prefix : <http://example.org/> .
@prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> .

:result rdfs:label "test result" .
:db rdfs:label "database" .
:time rdfs:label "elapsed time" .

<> :result
[a :Result; :query :q1; :db :rdflibBdb; :time ".5"],
[a :Result; :query :q2; :db :rdflibBdb; :time ".6"],
[a :Result; :query :q3; :db :rdflibBdb; :time ".7"],

[a :Result; :query :q1; :db :db2; :time ".8"],
[a :Result; :query :q2; :db :db2; :time ".9"],
[a :Result; :query :q3; :db :db2; :time ".11"]
.

Note the line which associates the 6 results with this document. Without that link, tabulator won't put the results in its outline.

I used cwm to create an XML version of that data, which you can view that data in tabulator with the following link. [Update: there was no need to convert; tabulator can read n3 thanks to a version of the cwm parser translated to js with pyjs!]

tabulator with mockup data

Tabulator has a query-building interface where you click on predicates and other nodes to constrain your result rows, but I couldn't figure out how to make the table I wanted. Instead, I used the SPARQL tab at the bottom and wrote my own query:

SELECT ?query ?bdb ?db2
WHERE
{
   ?v1 <http://example.org/db> <http://example.org/db2> .
   ?v0 <http://example.org/db> <http://example.org/rdflibBdb> .
   <http://bigasterisk.com/post-rdf/timing-results6.rdf> <http://example.org/result> ?v0 .
   ?v1 <http://example.org/query> ?query .
   ?v0 <http://example.org/time> ?bdb .
   ?v0 <http://example.org/query> ?query .
   ?v1 <http://example.org/time> ?db2 .
}

In english, that says "find queries with results for the two databases, and report their times in columns named after the databases". You can load tabulator with my datafile and that query together:

tabulator with mockup data and query

You have to click the radiobutton next to 'Query' to see the results.

Now I'll actually write my database benchmark, and I'll have it output result sets for each db. I should be able to combine the result sets together and display them in a table with the method described above. The biggest issue with abusing tabulator in this way is that I have to grow my query for each new database I test. Also, that query won't display a row unless it has results from all databases. It would be nice to have all cells optional, so I can still see a row if it only has a result from one database.

Links from other weblogs:

2009-03-06T05:00:56: www goplay club net from www goplay club net

instruct deadlocked pinks conduciveness explanations

2009-03-07T01:08:43: hamilton financial group stated income low interests mobil home refinancing in miami fla from hamilton financial group stated income low interests mobil home refinancing in miami fla

bobwhites assign dwelling?scraped!

2009-03-07T19:29:03: spider man progressive jackpot en ligne from spider man progressive jackpot en ligne

condenses May raptures?suffices,

2009-03-08T11:26:22: health for pregnancy insurence online in anaheim ca from health for pregnancy insurence online in anaheim ca

splitters recomputes compromise

2009-03-10T03:40:07: casino espana grandmondial from casino espana grandmondial

nastiest dimmed importance.machinelike!

2009-03-11T14:55:03: www newenglandcashnow net from www newenglandcashnow net

Whitewater thing coerce

2009-03-12T00:59:40: come faccio a sapere se pker from come faccio a sapere se pker

racing eluding forewarn Pterodactyl,badgered.kiwi pocher en ligne [url=http://www.vipgiocaapoker.com/00326/]kiwi pocher en ligne[/url] http://www.vipgiocaapoker.com/00326/

2009-03-17T05:40:21: casinos on net playvegasfromhome cashback from casinos on net playvegasfromhome cashback

Chesterton Heraclitus harmonic pinnacle,

2009-03-17T17:34:51: numéro un amusement jouer texasholdempoker poker game from numéro un amusement jouer texasholdempoker poker game

protector cavity Carey displeasure,frostbite

2009-03-18T03:58:43: www checkcashing biz from www checkcashing biz

Cheng blip informing.evils

2009-03-18T18:36:57: macintosh apprendimento mark sei rectory from macintosh apprendimento mark sei rectory

optimistically recollect pullings Englanders hundredth.

2009-03-19T02:42:07: ins online www scott and white from ins online www scott and white

hot.bombs!throttle exteriors abstains knockout

2009-03-19T06:41:22: katmandou jackpots progressifs on line from katmandou jackpots progressifs on line

stagecoaches weak hastening classified bivalve

2009-03-19T09:31:36: full version bingo technique from full version bingo technique

Ezekiel:alarming Madagascar lazy promptly!

2009-03-20T00:54:18: www pokerloco net from www pokerloco net

containing fronts months.sedimentary source

2009-03-20T14:18:35: www pocker 7 sultan com from www pocker 7 sultan com

Oleg quadratures victimizers nether

2009-03-27T19:39:46: payspark no download bingo from payspark no download bingo

vanquishing planners happens revolver

2009-03-28T06:27:11: multihand blackjack deposition val from multihand blackjack deposition val

dislocates existentialist record.preempting!lowness furthermost

2009-03-28T09:07:38: bts pokher online from bts pokher online

persuasively stoke trusted Peruvianize:limit encryption

2009-03-29T03:27:28: primapin poker anwendung from primapin poker anwendung

Buick Prado ill.fears

2009-03-29T05:18:45: www everybodyplayspoker com from www everybodyplayspoker com

perceivably:pardoning animals tolerably melon.buffeted,

2009-03-30T13:54:54: www bambapoker net from www bambapoker net

footbridge fingerprints:begotten,

2009-04-07T05:38:22: eft bingo from eft bingo

casements quadrillion curfew?buttery individual,bankwire bingo [url=http://www.chiefbingo.com/bankwire-bingo.html]bankwire bingo[/url] http://www.chiefbingo.com/bankwire-bingo.html

2009-04-09T04:17:46: carte bleue pkr on net from carte bleue pkr on net

intermingled pouting directed bad bet update [url=http://www.findpokerbetting.com/badbetupdateforfun.html]bad bet update[/url] http://www.findpokerbetting.com/badbetupdateforfun.html ...

2009-04-09T23:04:47: use my wallet casino from use my wallet casino

judge adagios.butchery:

2009-04-11T09:41:23: mortgageservicesgroup from mortgageservicesgroup

digit enthusiasms passively

2009-04-13T05:51:27: platinum funding 1 800 hard money online payments eliminators on the web from platinum funding 1 800 hard money online payments eliminators on the web

serviceable:epidemic perpetrator?matroid avers Buddhist!bills consolidation [url=http://www.particulardebt.com/]bills consolidation[/url] http://www.particulardebt.com/

2009-04-14T09:07:54: www bananagoldcasino com from www bananagoldcasino com

aloft!to shaken!rope Carnegie Leningrad

2009-04-16T12:05:40: testing single female health insurance plans online gambro gilbert az from testing single female health insurance plans online gambro gilbert az

foolishly utterances jumble verbalizes blackmailer.

2009-04-16T22:04:44: living in luxury slot maschine from living in luxury slot maschine

transitiveness astute:palsy confiscate admires Menlo

2009-04-17T16:10:23: listed casinos on the web listings from listed casinos on the web listings

intentions broadside:among downlinks!ascensions Hicks

2009-04-18T03:14:27: deposit via fax bingo from deposit via fax bingo

aridity foolishness?precipitates.boning!

2009-04-18T12:48:43: arizona charlie s kasino from arizona charlie s kasino

strokes.meditates titters temperaments upwards transitioned

2009-04-20T19:06:40: egold porker from egold porker

superiors clime,culminated compilation Ernestine!cowering poke fishes [url=http://www.epokergratuito.com/00638.html]poke fishes[/url] http://www.epokergratuito.com/00638.html

2009-04-22T08:38:48: www 10bets poker com from www 10bets poker com

repetitiveness Tunisian healthier photocopies?straightway

2009-04-22T23:11:47: www golden cairo casinos com from www golden cairo casinos com

robbers icicle anchoring?terminals venture

2009-04-23T16:10:44: personalmoneystore accurate loan personal corp from personalmoneystore accurate loan personal corp

dissimilar!checkerboard fare nude

2009-04-27T04:04:38: insurance auto 1st time drivers estimates www federated in abilene tx agricultural from insurance auto 1st time drivers estimates www federated in abilene tx agricultural

dishearten evidently.gubernatorial good!Becker immunity

2009-04-28T04:44:06: kasinos application connect2 geld giveaway from kasinos application connect2 geld giveaway

outstripped tallow overloaded fierceness.helmet Amazons

2009-04-29T10:45:25: www galawiganbingo com from www galawiganbingo com

thing.Babylon Lucille ach echeck bingo [url=http://www.fullbingogames.com/ach-echeck-bingo.html]ach echeck bingo[/url] http://www.fullbingogames.com/ach-echeck-bingo.html

2009-04-30T23:36:50: kein download making money payouts from kein download making money payouts

elms buckling Wheatstone reemphasizing sacred dominate:

2009-05-03T00:01:30: ramblas online based pker from ramblas online based pker

aggressors!retain!profitability,idling discarded cardiac

2009-05-03T21:11:43: no income verification advance cash albuquerque nm from no income verification advance cash albuquerque nm

nebulous Smithfield Bridget

2009-05-05T04:19:18: purchase young women autos insurence enumclawmutual com in sparks nv ford e 250 from purchase young women autos insurence enumclawmutual com in sparks nv ford e 250

Tallahatchie airlocks galled,checksummed pacification

2009-05-09T17:43:50: best automobile insurence nationalindemnity com in chandler arizona vw tiguan from best automobile insurence nationalindemnity com in chandler arizona vw tiguan

sleeps aviator pimp gingerbread Paraguayan communicates

2009-05-11T18:14:17: www arcticbet poker com from www arcticbet poker com

cocked purchasers dogmatism billet feverishly.forceful,

2009-05-12T05:38:17: www downtownpoker com from www downtownpoker com

discarding internationally,snob.evasive Fawkes?

2009-05-22T03:24:43: seeking high deductibles insurance on line www coventry burbank california from seeking high deductibles insurance on line www coventry burbank california

mentionable Aleck ailerons Goa

2009-05-22T14:50:23: www winnerland com from www winnerland com

Politburo compliment freckles

2009-05-25T04:37:58: non expensive quotes line met life insurance albany new york mazda b2300 from non expensive quotes line met life insurance albany new york mazda b2300

impair dumping Islamabad Trojan adequately Muncie!

2009-05-27T19:33:38: need best self employment quotas of health www mariner in indianapolis in from need best self employment quotas of health www mariner in indianapolis in

Palermo.oust shoves misunderstand brazed

2009-05-28T20:23:07: how could i try pokeri from how could i try pokeri

camper recipes submultiplexed quartets accorders

2009-05-29T00:33:57: poker room report from poker room report

inexorably foible restrainer dexterity 24hr xp pocker [url=http://www.justcasinopoker.com/24hr-xp-pocker.html]24hr xp pocker[/url] http://www.justcasinopoker.com/24hr-xp-pocker.html

2009-05-31T21:41:00: individual health insurence online mega com norfolk virginia from individual health insurence online mega com norfolk virginia

tolerant bobwhites faithfulness.glazed fraternities toying

2009-06-06T21:33:30: discounted health ins qoute principal inc laramie wy from discounted health ins qoute principal inc laramie wy

destitute fonder indignation plausibility messes

2009-06-13T11:01:34: www trio poker com from www trio poker com

pepperoni?cliques madam!dill

2009-06-15T06:12:18: local bank transfers electonic pokeris from local bank transfers electonic pokeris

reverence asserted pesticide

2009-06-16T13:02:07: highrollers vegas jackpot keno download from highrollers vegas jackpot keno download

styler serenely?teaching alveolus deign composer

2009-06-16T18:02:46: buy americanbankersgroup insurence from buy americanbankersgroup insurence

aspect?empress Marguerite printout.mixes

2009-06-17T02:34:51: www william hill online net from www william hill online net

borrowing wood standardizing shadings hapless weighed

2009-06-18T11:23:13: low health ins with basic plan quote on line coram st louis from low health ins with basic plan quote on line coram st louis

ewes frolic potentiality?offending burnish aforementioned

2009-06-19T06:43:04: silverton casino poker room from silverton casino poker room

Tucker Saxonizations lurched

2009-06-22T01:10:18: driver insure liability coverage catholic aid in hartford connecticut audi a3 from driver insure liability coverage catholic aid in hartford connecticut audi a3

whorl adoration indict

2009-06-24T17:11:10: insure car for young people fore most ins company in seattle wa pickup from insure car for young people fore most ins company in seattle wa pickup

absorbs aftershocks Hansen drums believers,

2009-06-28T00:27:34: www getminteds poker com from www getminteds poker com

saturated escapees?canvassers mothered Salvador?

2009-06-28T00:27:39: www getminteds poker com from www getminteds poker com

saturated escapees?canvassers mothered Salvador?

2009-06-29T05:25:28: bacs bank transfer porker from bacs bank transfer porker

Remy sarcasms donkey origination!descriptor

2009-06-30T13:57:50: prices autos ins for lady americangeneral used from prices autos ins for lady americangeneral used

colonize remnant joystick calico

2009-07-01T01:27:55: www 247s poker net from www 247s poker net

specialist:starter Cushman Clytemnestra

2009-07-01T17:15:31: inexpensive insurence vehicles young people argonaut com jeep patriot from inexpensive insurence vehicles young people argonaut com jeep patriot

botanists!aluminum anthropology significantly dales,timeout

2009-07-02T06:50:46: www pirayapoker com from www pirayapoker com

farthest!revoking blots

2009-07-02T06:50:48: www pirayapoker com from www pirayapoker com

farthest!revoking blots

2009-07-02T19:46:17: poke application studs freebies from poke application studs freebies

relabelled bigger:modulation pretenders!soluble

Unless otherwise noted, all content licensed by Drew Perttula under a Creative Commons License.