2d:null 2e:["$","title",null,{"children":"Benchmark Analaysis | Kasi Viswanath | Observable"}] 33:T44c,barChart = { let target = []; for (let data of rawData) { let res = {}; res["comb"] = data.comb; res["duckdb"] = data?.duckDB?.filter_time / 1000; res["arquero"] = data?.arquero?.filter_time / 1000; res["nativeJS"] = data?.nativeJS?.filter_time / 1000; res["dataset"] = data.dataset; target.push(res); } let data = []; if (target.length) { data = aq .from(target) .fold(["duckdb", "arquero", "nativeJS"], { as: ["backend", "time"] }) .objects(); } const label = vl .markText({ dx: 5, dy: 5, align: "start", fontSize: "8" }) .encode( vl.y().fieldN("backend"), vl.x().median("time").title("Median Time with IQR"), vl.text().median("time").format(".4f") ) .height(100) .width(100); const bar = label .markBar({ tooltip: true, opacity: 0.6 }) .encode(vl.color().fieldN("backend")) .height(100) .width(100); const error = bar.markErrorbar({ extent: "iqr" }); return vl .layer(label, bar, error) .facet(vl.fieldN("comb")) .columns(6) .data(data) .render(); }34:T7c5,chartWithFaster = { const height = 400; const hover = vl.selectSingle().on("mouseover").nearest(true).empty("none"); const base = vl .markRule({ color: "#ccc" }) .encode(vl.x().fieldN("key"), vl.detail().count()); const line = base.markLine().encode( vl .color() .fieldN("faster") .scale({ domain: ["Arquero", "duckDB"], range: ["#1f77b4", "#ff7f0e"] }), vl.detail().fieldN("index"), vl.opacity().if(hover, vl.value(1)).value(0.3), vl.y().fieldQ("norm_val").axis(null), vl.tooltip([...attribs, "comb", "faster"]) ); const points = line .markCircle() .select(hover) .encode(vl.size().if(hover, vl.value(50)).value(5)); // Generates a spec to show tick values at an specific value of y0 const tick = (y0) => vl .layer( base.markText({ style: "label" }).encode(vl.text().max("max")), base.markTick({ style: "tick", size: 8, color: "#ccc" }) ) .encode(vl.y().value(y0)); // Create an array with *numTicks* ticks const ticks = Array.from({ length: 3 }).map((_, i) => tick((height / (3 - 1)) * i) ); return vl .layer(base, line, points, ...ticks) .data(data_without_nativeJS) .transform( // vl.filter(attribs.map((a) => `datum["${a}"] != null`).join(" && ")), vl.window(vl.count().as("index")), vl.fold(attribs), vl .groupby("key") .joinaggregate(vl.min("value").as("min"), vl.max("value").as("max")), vl .calculate("(datum.value - datum.min) / (datum.max - datum.min)") .as("norm_val"), vl.calculate("(datum.min + datum.max) / 2").as("mid") ) .config({ axisX: { domain: false, labelAngle: 0, tickColor: "#ccc", title: null }, view: { stroke: null }, style: { label: { baseline: "middle", align: "right", dx: -5 }, tick: { orient: "horizontal" } } }) .width(width - 100) .height(height) .render(); }35:T742,chart = { const height = 400; const hover = vl.selectSingle().on("mouseover").nearest(true).empty("none"); const base = vl .markRule({ color: "#ccc" }) .encode(vl.x().fieldN("key"), vl.detail().count()); const line = base .markLine() .encode( vl.color().fieldN("comb"), vl.detail().fieldN("index"), vl.opacity().if(hover, vl.value(1)).value(0.3), vl.y().fieldQ("norm_val").axis(null), vl.tooltip([...attribs, "comb"]) ); const points = line .markCircle() .select(hover) .encode(vl.size().if(hover, vl.value(50)).value(5)); // Generates a spec to show tick values at an specific value of y0 const tick = (y0) => vl .layer( base.markText({ style: "label" }).encode(vl.text().max("max")), base.markTick({ style: "tick", size: 8, color: "#ccc" }) ) .encode(vl.y().value(y0)); // Create an array with *numTicks* ticks const ticks = Array.from({ length: 3 }).map((_, i) => tick((height / (3 - 1)) * i) ); return vl .layer(base, line, points, ...ticks) .data(data_) .transform( // vl.filter(attribs.map((a) => `datum["${a}"] != null`).join(" && ")), vl.window(vl.count().as("index")), vl.fold(attribs), vl .groupby("key") .joinaggregate(vl.min("value").as("min"), vl.max("value").as("max")), vl .calculate("(datum.value - datum.min) / (datum.max - datum.min)") .as("norm_val"), vl.calculate("(datum.min + datum.max) / 2").as("mid") ) .config({ axisX: { domain: false, labelAngle: 0, tickColor: "#ccc", title: null }, view: { stroke: null }, style: { label: { baseline: "middle", align: "right", dx: -5 }, tick: { orient: "horizontal" } } }) .width(width - 100) .height(height) .render(); }36:[{"id":"88cc394af0179b58e5ed929ab6c2d46cbbdfc3a85ed4a1ae19c937e7b4692f5d94a7a967ff89b06a813535309613a6e8570a6afb204cec1eaf71b9df150b3437","href":"https://static.observableusercontent.com/files/88cc394af0179b58e5ed929ab6c2d46cbbdfc3a85ed4a1ae19c937e7b4692f5d94a7a967ff89b06a813535309613a6e8570a6afb204cec1eaf71b9df150b3437","name":"task2.json","type":"application/json","lastModified":1714541622639.468,"size":1773109},{"id":"a17a8b0345c562da7d44e9ea266227113f3c1d8c7443395eff2db6cfd1179a651759886b51c7690cdbe0eeb03d76db44d477fe1f0a9f3a37df506b576131acec","href":"https://static.observableusercontent.com/files/a17a8b0345c562da7d44e9ea266227113f3c1d8c7443395eff2db6cfd1179a651759886b51c7690cdbe0eeb03d76db44d477fe1f0a9f3a37df506b576131acec","name":"data.zip","type":"application/zip","lastModified":1682890578692.673,"size":26903724}] 31:{"id":"cde6cad2da8ff04d","slug":"benchmark-analaysis","title":"Benchmark Analaysis","thumbnail":"c24b2acd6783f68ac18e70785f112428dcb3d69a314c2e84cd4bbc054fb46b2b","access_level":"public","create_time":"$D2023-04-30T18:30:38.335Z","update_time":"$D2024-05-01T05:34:18.787Z","view_time":null,"first_public_time":"$D2023-04-30T18:30:38.335Z","has_unpublished_edits":null,"fork":{"id":"a878f2cd5daf16ea","slug":null,"title":"Benchmarking Arquero, DuckDB-WASM, and VanillaJS backends V2","owner":{"id":"b760ea566a896d7d","login":"kasivisu4","name":"Kasi Viswanath"}},"stars":0,"starred":false,"owner":{"type":"team","id":"b760ea566a896d7d","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":"starter_2024"},"version":2474,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"fcd94e1c1ca12ae9","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":null}],"members":[{"type":"individual","id":"be0076fec73aa550","login":"john-guerra","name":"John Alexis Guerra Gómez","avatar_url":"https://avatars-next.observableusercontent.com/21638cee44bb0ea70798da725b57111a5d3e2acebcd14524565992f7d1594aed","tier":null,"role":"editor"},{"type":"individual","id":"fcd94e1c1ca12ae9","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"48467ca908df504b","slug":"archive","title":"Archive","owner":{"id":"b760ea566a896d7d","login":"kasivisu4","name":"Kasi Viswanath"}},"type":"notebook","body":{"title":"Benchmark Analaysis","cells":[{"id":0,"value":"# Benchmark Analaysis\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2389,"value":"rawData = (await FileAttachment(\"data.zip\").zip())\n .file(\"data (1).json\")\n .json({ typed: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1022,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2470,"value":"task2 = FileAttachment(\"task2.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2272,"value":"attribs = [\"arqueroExecTime\", \"duckDBExecTime\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2298,"value":"viewof time = Inputs.range([200, 1000], { step: 1 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2304,"value":"viewof comb = {\n let combs = [\n \"1Q-@V\",\n \"1Q-RV\",\n \"1Q-NV\",\n \"1C-@V\",\n \"1C-RV\",\n \"1C-NV\",\n \"1C-@V+1Q-@V\",\n \"1C-@V+1Q-@V+1Q-RV\",\n \"1C-@V+1Q-@V+1Q-RV+1Q-NV\",\n \"1C-RV+1Q-@V\",\n \"1C-RV+1Q-@V+1Q-RV\",\n \"1C-RV+1Q-@V+1Q-RV+1Q-NV\",\n \"1C-NV+1Q-@V\",\n \"1C-NV+1Q-@V+1Q-RV\",\n \"1C-NV+1Q-@V+1Q-RV+1Q-NV\",\n \"2C-@V+1Q-@V\",\n \"2C-@V+1Q-@V+1Q-RV\",\n \"2C-@V+1Q-@V+1Q-RV+1Q-NV\",\n \"2C-RV+1Q-@V\",\n \"2C-RV+1Q-@V+1Q-RV\",\n \"2C-RV+1Q-@V+1Q-RV+1Q-NV\",\n \"2C-NV+1Q-@V\",\n \"2C-NV+1Q-@V+1Q-RV\",\n \"2C-NV+1Q-@V+1Q-RV+1Q-NV\"\n ];\n return searchCheckbox(combs, { label: \"Select Combinations\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2345,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2269,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2292,"value":"import { vl } from \"@vega/vega-lite-api\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2461,"value":"data_without_nativeJS = {\n function check(a, b, c) {\n if (a <= b) {\n return \"Arquero\";\n }\n if (b <= a) {\n return \"duckDB\";\n }\n }\n let data_ = rawData\n .map((d) => {\n return {\n comb: d[\"comb\"],\n arqueroExecTime: d[\"arquero\"][\"filter_time\"],\n duckDBExecTime: d[\"duckDB\"][\"filter_time\"]\n };\n })\n .map((d) => {\n return {\n ...d,\n faster: check(d[\"arqueroExecTime\"], d[\"duckDBExecTime\"])\n };\n })\n .filter(\n (d) =>\n comb.includes(d[\"comb\"]) &&\n d[\"arqueroExecTime\"] <= time &&\n d[\"duckDBExecTime\"] <= time\n );\n return data_;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2276,"value":"data_ = {\n function check(a, b, c) {\n if (a <= b && a <= c) {\n return \"Arquero\";\n }\n if (c <= a && c <= b) {\n return \"nativeJS\";\n }\n if (b <= a && b <= c) {\n return \"duckDB\";\n }\n }\n let data_ = rawData\n .map((d) => {\n return {\n comb: d[\"comb\"],\n arqueroExecTime: d[\"arquero\"][\"filter_time\"],\n duckDBExecTime: d[\"duckDB\"][\"filter_time\"],\n nativeJSExecTime: d[\"nativeJS\"][\"filter_time\"]\n };\n })\n .map((d) => {\n return {\n ...d,\n faster: check(\n d[\"arqueroExecTime\"],\n d[\"duckDBExecTime\"],\n d[\"nativeJSExecTime\"]\n )\n };\n })\n .filter(\n (d) =>\n comb.includes(d[\"comb\"]) &&\n d[\"arqueroExecTime\"] <= time &&\n d[\"duckDBExecTime\"] <= time &&\n d[\"nativeJSExecTime\"] <= time\n );\n return data_;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":721,"value":"import { multiAutoSelect } from \"@john-guerra/multi-auto-select\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"import {\n constants,\n clipBoardCopy,\n downloadFile,\n feedBackButton,\n monitorMemory\n} from \"@kasivisu4/filterer-utilities\";\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"import { searchCheckbox } from \"@john-guerra/search-checkbox\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":600,"value":"import { mongodbClient } from \"@kasivisu4/mongodb-local\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2442,"value":"new Set(rawData.map((d) => d.dataset))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 32:"$31:body"