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