diff options
Diffstat (limited to 'reveal.js/timetravel.html')
| -rw-r--r-- | reveal.js/timetravel.html | 127 |
1 files changed, 0 insertions, 127 deletions
diff --git a/reveal.js/timetravel.html b/reveal.js/timetravel.html deleted file mode 100644 index b297e2f..0000000 --- a/reveal.js/timetravel.html +++ /dev/null | |||
| @@ -1,127 +0,0 @@ | |||
| 1 | <!doctype html> | ||
| 2 | <html lang="en"> | ||
| 3 | <head> | ||
| 4 | <meta charset="utf-8"> | ||
| 5 | <title>Solving problems using time travel</title> | ||
| 6 | <meta name="author" content="Simeon Simeonov"> | ||
| 7 | <meta name="apple-mobile-web-app-capable" content="yes"> | ||
| 8 | <meta name="apple-mobile-web-app-status-bar-style" content="black-translucent"> | ||
| 9 | <meta name="viewport" content="width=device-width, initial-scale=1.0"> | ||
| 10 | |||
| 11 | <link rel="stylesheet" href="dist/reset.css"> | ||
| 12 | <link rel="stylesheet" href="dist/reveal.css"> | ||
| 13 | |||
| 14 | <link rel="stylesheet" href="dist/theme/fifty.css" id="theme"> | ||
| 15 | |||
| 16 | <!-- Theme used for syntax highlighting of code --> | ||
| 17 | <link rel="stylesheet" href="plugin/highlight/monokai.css" id="highlight-theme"> | ||
| 18 | <!-- <link rel="stylesheet" href="plugin/highlight/zenburn.css" id="highlight-theme"> --> | ||
| 19 | </head> | ||
| 20 | <body> | ||
| 21 | <div class="reveal"> | ||
| 22 | |||
| 23 | <!-- Any section element inside of this container is displayed as a slide --> | ||
| 24 | <div class="slides"> | ||
| 25 | |||
| 26 | <section> | ||
| 27 | <h2>Solving problems using <em>time travel</em></h2> | ||
| 28 | <h4>Beryl @ Fifty</h4> | ||
| 29 | </br> | ||
| 30 | <p><small>Tomas Robertson (team ACE-OL) & Simeon Simeonov (team Forecasts)</small></p> | ||
| 31 | </section> | ||
| 32 | |||
| 33 | |||
| 34 | <section> | ||
| 35 | <h2>What is <em>time travel</em>???</h2> | ||
| 36 | <br/> | ||
| 37 | <p><em>Time travel</em> - our ability to look at our input data at the state it was at a specific point in time (not only at its last state).</p> | ||
| 38 | <p><em>Time travel</em> is achieved by adding the <em>record_created_time</em> column to our DB tables and storing Kafka's <em>created_time</em> value (converted to UTC).</p> | ||
| 39 | <br/> | ||
| 40 | <p>The main concepts around how and why were presented by Peter Sandberg.</p> | ||
| 41 | </section> | ||
| 42 | |||
| 43 | <section> | ||
| 44 | <h2>Solving problems</h2> | ||
| 45 | <br/> | ||
| 46 | <p>The following spike was observed 2021-10-06 around 10:15 CET @ NO4</p> | ||
| 47 | <img src="images/timetravel/ace_ol_spike.png"></img> | ||
| 48 | </section> | ||
| 49 | |||
| 50 | <section> | ||
| 51 | <h2>Solving problems (cont)</h2> | ||
| 52 | <br/> | ||
| 53 | <p>No spikes shown in Grafana</p> | ||
| 54 | <img src="images/timetravel/ace_ol_spike_grafana.png"></img> | ||
| 55 | </section> | ||
| 56 | |||
| 57 | <section> | ||
| 58 | <h2>Solving problems with <em>time travel</em></h2> | ||
| 59 | <br/> | ||
| 60 | <pre data-id="code-animation"> | ||
| 61 | <code class="sql" data-trim type="text/template"> | ||
| 62 | SELECT record_created_time, start_time, value | ||
| 63 | FROM misc.app_odin_ace_ol_ba_10s_avro_v01 | ||
| 64 | WHERE bidding_area_name = 'NO4' AND start_time = '2021-10-06 08:14:10' | ||
| 65 | ORDER BY record_created_time; | ||
| 66 | </code> | ||
| 67 | </pre> | ||
| 68 | |||
| 69 | <table> | ||
| 70 | <thead> | ||
| 71 | <tr> | ||
| 72 | <th>record_created_time</th> | ||
| 73 | <th>start_time</th> | ||
| 74 | <th>value</th> | ||
| 75 | </tr> | ||
| 76 | </thead> | ||
| 77 | <tbody> | ||
| 78 | <tr> | ||
| 79 | <td>2021-10-06 08:15:52.258</td> | ||
| 80 | <td>2021-10-06 08:14:10</td> | ||
| 81 | <td>-370.37683609008127</td> | ||
| 82 | </tr> | ||
| 83 | <tr> | ||
| 84 | <td>2021-10-06 08:19:06.222</td> | ||
| 85 | <td>2021-10-06 08:14:10</td> | ||
| 86 | <td>25.183745117193457</td> | ||
| 87 | </tr> | ||
| 88 | <tr> | ||
| 89 | <td>2021-10-06 08:21:56.207</td> | ||
| 90 | <td>2021-10-06 08:14:10</td> | ||
| 91 | <td>34.78731922151518</td> | ||
| 92 | </tr> | ||
| 93 | </tbody> | ||
| 94 | </table> | ||
| 95 | </section> | ||
| 96 | |||
| 97 | <section> | ||
| 98 | <h1>Q & A</h1> | ||
| 99 | </section> | ||
| 100 | |||
| 101 | </div> | ||
| 102 | </div> | ||
| 103 | |||
| 104 | <script src="dist/reveal.js"></script> | ||
| 105 | <script src="plugin/zoom/zoom.js"></script> | ||
| 106 | <script src="plugin/notes/notes.js"></script> | ||
| 107 | <script src="plugin/search/search.js"></script> | ||
| 108 | <script src="plugin/markdown/markdown.js"></script> | ||
| 109 | <script src="plugin/highlight/highlight.js"></script> | ||
| 110 | <script> | ||
| 111 | |||
| 112 | // Also available as an ES module, see: | ||
| 113 | // https://revealjs.com/initialization/ | ||
| 114 | Reveal.initialize({ | ||
| 115 | controls: true, | ||
| 116 | progress: true, | ||
| 117 | center: true, | ||
| 118 | hash: true, | ||
| 119 | |||
| 120 | // Learn about plugins: https://revealjs.com/plugins/ | ||
| 121 | plugins: [ RevealZoom, RevealNotes, RevealSearch, RevealMarkdown, RevealHighlight ] | ||
| 122 | }); | ||
| 123 | |||
| 124 | </script> | ||
| 125 | |||
| 126 | </body> | ||
| 127 | </html> | ||