<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno mar 2 lug 2019 alle ore 10:51 Alessandro Luccaroni - Diennea <<a href="mailto:alessandro.luccaroni@diennea.com">alessandro.luccaroni@diennea.com</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="IT">
<div class="gmail-m_678160040958348063WordSection1">
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">Regarding the open points:<br>
<br>
Checkpoint = the “Consistent” option is not clear or the doc link provided is not clear? <a href="http://dbdb.io" target="_blank">dbdb.io</a> provide the following options: “Blocking”, “Consistent”, “Fuzzy”, “Non-Blocking”, “Not Supported”. Since the checkpoint freeze the DB (and in a checkpoint there
are all the info needed to bring up a replica), I think it should be “Consistent” + “Blocking” (see PostgreSQL entry for some background around “Consistent”
<a href="https://dbdb.io/db/postgresql" target="_blank">https://dbdb.io/db/postgresql</a>)</span></p></div></div></blockquote><div><br></div><div>We are blocking only writes, but Consistent + Blocking is okay <br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="IT"><div class="gmail-m_678160040958348063WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">Joins = <a href="http://dbdb.io" target="_blank">dbdb.io</a> provide the following options: “Broadcast Join”, “Has Join”, “Index Nested Loop Join”, “Nested Loop Join”, “Not Supported”,
“Semi Join”, “Shuffle Join”, “Sort-Merge Join”. Which ones do we choose? Is it going to change after the Calcite 1.20 upgrade?</span></p></div></div></blockquote><div>Nested Loop, Sort-Merge-Join (but actually there is some bug in Calcite and it is never used), Hash Join<br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="IT"><div class="gmail-m_678160040958348063WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">Storage Architecture = it’s related to where the data is saved (disk, memory or both)…since we are planning about <a href="https://github.com/diennea/herddb/issues/401" target="_blank">https://github.com/diennea/herddb/issues/401</a>
I think our use case is “Hybrid” (it means that you can choose between the two in <a href="http://dbdb.io" target="_blank">dbdb.io</a> terminology)</span></p></div></div></blockquote><div>I would say "disk" <br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="IT"><div class="gmail-m_678160040958348063WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">Storage Model = "N-ary storage model” means that the column are stored together in a row-by-row basis (like a very wide csv?). I think
we can safely say only “Key/Value” in our case</span></p></div></div></blockquote><div>We are saving all of the columns of a row into the same page, all packed<br></div><div> </div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="IT"><div class="gmail-m_678160040958348063WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">Storage Organization = I will keep both "Log-structured" and "Heaps" since we store data both on data file and on the Bookie log</span></p></div></div></blockquote><div>Mostly like "Log-structured" <br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="IT"><div class="gmail-m_678160040958348063WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">Concurrency Control = “Deterministic Concurrency Control “: is this guaranteed by Bookkeeper? Can you point me in the code and/or documentation
where we can extrapolate that?</span></p></div></div></blockquote><div>Concurrency Control....we are using "pessimistic row level locking", before accessing to a record the client acquires a lock (read or write).</div><div>Each Transaction that modifies a record holds the new copy of the record in a local buffer, and this new version is not visible to other transactions until the tx is committed.<br></div><div>BookKeeper is out of the game, we are using it only for the WAL<br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="IT"><div class="gmail-m_678160040958348063WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">Query Compilation = “Code Generation”: is this related to our usage of Apache Calcite?</span></p></div></div></blockquote><div>We are not "compiling" code, we have an access plan that is prepared by Apache Calcite and then translated to an internal representation. <br></div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="IT"><div class="gmail-m_678160040958348063WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">Query Execution = “Vectorized Model”: is this related to our usage of Apache Calcite?</span></p></div></div></blockquote><div>Where did you find the list of available values ?</div><div>I feel "Vectorized Model" is not out option</div><div><br></div><div><br></div><div><br></div><div>Cheers</div><div>Enrico<br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="IT"><div class="gmail-m_678160040958348063WordSection1"><p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:13pt;font-family:"Arial",sans-serif" lang="EN-US">Alessandro Luccaroni</span></b><span style="font-size:11pt;font-family:"Calibri",sans-serif" lang="EN-US">
<br>
</span><span style="font-size:10pt;font-family:"Arial",sans-serif" lang="EN-US">Platform Manager @ Diennea - MagNews<br>
</span><span style="font-size:8.5pt;font-family:"Arial",sans-serif" lang="EN-US">Tel.: (+39) 0546 066100 Int. 924 - Mob.:
</span><span style="font-size:8.5pt;font-family:"Arial",sans-serif">(+39) 393 7273519</span><span style="font-size:11pt;font-family:"Calibri",sans-serif"><br>
</span><span style="font-size:8.5pt;font-family:"Arial",sans-serif">Viale G.Marconi 30/14 - 48018 Faenza (RA) - Italy</span><span style="font-size:11pt;font-family:"Calibri",sans-serif"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:"Calibri",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:"Calibri",sans-serif">Da:</span></b><span style="font-size:11pt;font-family:"Calibri",sans-serif"> <a href="mailto:herddb-dev-bounces@lists.herddb.org" target="_blank">herddb-dev-bounces@lists.herddb.org</a> [mailto:<a href="mailto:herddb-dev-bounces@lists.herddb.org" target="_blank">herddb-dev-bounces@lists.herddb.org</a>]
<b>Per conto di </b>Enrico Olivelli<br>
<b>Inviato:</b> martedì 2 luglio 2019 00:02<br>
<b>A:</b> Herddb developers <<a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a>><br>
<b>Oggetto:</b> Re: [Herddb-dev] Herddb entry on <a href="http://dbdb.io" target="_blank">dbdb.io</a><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">Great idea Alessandro,<u></u><u></u></p>
<div>
<p class="MsoNormal">some comments inline below<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12pt"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">Il gio 27 giu 2019, 16:09 Alessandro Luccaroni - Diennea <<a href="mailto:alessandro.luccaroni@diennea.com" target="_blank">alessandro.luccaroni@diennea.com</a>> ha scritto:<u></u><u></u></p>
</div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Hi all,</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">I was thinking about sending an email to Carnagie Mellon Database Group about the entry of Herddb on
<a href="https://dbdb.io/db/herddb" target="_blank">https://dbdb.io/db/herddb</a></span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">I’ve grouped up a bunch of information about Herd, can you check if everything seems correct?</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">Checkpoints = "Consistent" (<a href="https://github.com/diennea/herddb/wiki/Data-storage" target="_blank">https://github.com/diennea/herddb/wiki/Data-storage</a>
<a href="https://github.com/diennea/herddb/wiki/Checkpoints-configuration" target="_blank">
https://github.com/diennea/herddb/wiki/Checkpoints-configuration</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">This is not clear to me.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">We are always respecting ACID properties. And this is not related to checkpoints.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Foreign Keys = "Not Supported" (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Ok<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal">Data Model = "Relational" (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)<u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok (relational usually means 'with tables')<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Indexes = "B-Link" "BRIN" (<a href="https://github.com/diennea/herddb/blob/master/herddb-utils/src/main/java/herddb/index/blink/BLink.java" target="_blank">https://github.com/diennea/herddb/blob/master/herddb-utils/src/main/java/herddb/index/blink/BLink.java</a>
<a href="https://github.com/diennea/herddb/tree/master/herddb-core/src/main/java/herddb/index/brin" target="_blank">
https://github.com/diennea/herddb/tree/master/herddb-core/src/main/java/herddb/index/brin</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Our own BRIN is not strictly speaking the official BRIN you can find in literature, so maybe it is better to write something like BRIN-like <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Isolation Levels = "Read Committed" (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Joins = "Nested Loop join" (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">This is not true indeed. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">IIRC we are supporting several kinds of join, driven by Apache Calcite. Maybe the most common join you will find on simple plan is the hash join, but it really depends on data and on the planner.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">We can write Joins -supported various types, as driven by Apache Calcite SQL Planner<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Query Interface = "SQL" "Command-line/Shell" (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">JDBC, proprietary API and command line<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Storage Architecture = "Hybrid"</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Not sure what it means<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Storage Model = "Key/Value" "N-ary Storage Model (Row/Record)" (<a href="https://github.com/diennea/herddb/wiki/Data-storage" target="_blank">https://github.com/diennea/herddb/wiki/Data-storage</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">I don't know. HerdDB is mostly a key-value store, on top of which we have built an sql engine<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Storage Organization = "Log-structured" "Heaps" (<a href="https://github.com/diennea/herddb/wiki/Data-storage" target="_blank">https://github.com/diennea/herddb/wiki/Data-storage</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Something like that<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Stored Procedures = "Not Supported" (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">System Architecture = "Shared-Nothing" (<a href="https://github.com/diennea/herddb/wiki/Replication" target="_blank">https://github.com/diennea/herddb/wiki/Replication</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US">Views = "Not Supported" (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">I’m still in doubt about some other definition, see below with some “option” using the
<a href="http://dbdb.io" target="_blank">dbdb.io</a> “nomenclature”:</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">“Concurrency Control”</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">1)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Deterministic Concurrency Control</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Maybe this one<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">2)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Multi-version Concurrency Control (MVCC)</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">3)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Optimistic Concurrency Control (OCC)</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">4)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Timestamp Ordering</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">5)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Two-Phase Locking (Deadlock Detection)</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">6)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Two-Phase Locking (Deadlock Prevention)</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">“Query Compilation”</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">1)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Code Generation</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Something like that<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">2)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">JIT Compilation</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">3)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Not Supported</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">4)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Stored Procedure Compilation</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">“Query Execution”</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">1)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Materialized Model</span><u></u><u></u></p>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">2)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Tuple-at-a-Time Model</span><u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Maybe this one<u></u><u></u></p>
</div>
<div>
<div>
<blockquote style="border-color:currentcolor currentcolor currentcolor rgb(204,204,204);border-style:none none none solid;border-width:medium medium medium 1pt;padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="gmail-m_678160040958348063m-1603704270247114584msolistparagraph"><span lang="EN-US">3)</span><span style="font-size:7pt" lang="EN-US">
</span><span lang="EN-US">Vectorized Model</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US">But we could also use some terminology that is not currently cover (for example currently there are no DBMS mapped with either BRIN or B-Link indexes, but we
support them).</span><u></u><u></u></p>
<p class="MsoNormal"><span lang="EN-US"> </span><u></u><u></u></p>
<p class="MsoNormal"><b><span style="font-size:13pt;font-family:"Arial",sans-serif">Alessandro Luccaroni</span></b>
<br>
<span style="font-size:10pt;font-family:"Arial",sans-serif">Platform Manager @ Diennea - MagNews<br>
</span><span style="font-size:8.5pt;font-family:"Arial",sans-serif">Tel.: (+39) 0546 066100 Int. 924 - Mob.: (+39) 393 7273519</span><br>
<span style="font-size:8.5pt;font-family:"Arial",sans-serif">Viale G.Marconi 30/14 - 48018 Faenza (RA) - Italy</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div class="MsoNormal" style="text-align:center" align="center">
<hr width="100%" size="2" align="center">
</div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Arial",sans-serif;color:black"><br>
CONFIDENTIALITY & PRIVACY NOTICE<br>
This e-mail (including any attachments) is strictly confidential and may also contain privileged information. If you are not the intended recipient you are not authorised to read, print, save, process or disclose this message. If you have received this message
by mistake, please inform the sender immediately and destroy this e-mail, its attachments and any copies. Any use, distribution, reproduction or disclosure by any person other than the intended recipient is strictly prohibited and the person responsible may
incur in penalties.<br>
The use of this e-mail is only for professional purposes; there is no guarantee that the correspondence towards this e-mail will be read only by the recipient, because, under certain circumstances, there may be a need to access this email by third subjects
belonging to the Company.</span><u></u><u></u></p>
</div>
<p class="MsoNormal">_______________________________________________<br>
herddb-dev mailing list<br>
<a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
<a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
</div>
<br>
<hr>
<font size="2" face="Arial" color="Black"><br>
CONFIDENTIALITY & PRIVACY NOTICE<br>
This e-mail (including any attachments) is strictly confidential and may also contain privileged information. If you are not the intended recipient you are not authorised to read, print, save, process or disclose this message. If you have received this message
by mistake, please inform the sender immediately and destroy this e-mail, its attachments and any copies. Any use, distribution, reproduction or disclosure by any person other than the intended recipient is strictly prohibited and the person responsible may
incur in penalties.<br>
The use of this e-mail is only for professional purposes; there is no guarantee that the correspondence towards this e-mail will be read only by the recipient, because, under certain circumstances, there may be a need to access this email by third subjects
belonging to the Company.<br>
</font>
</div>
_______________________________________________<br>
herddb-dev mailing list<br>
<a href="mailto:herddb-dev@lists.herddb.org" target="_blank">herddb-dev@lists.herddb.org</a><br>
<a href="http://lists.herddb.org/mailman/listinfo/herddb-dev" rel="noreferrer" target="_blank">http://lists.herddb.org/mailman/listinfo/herddb-dev</a><br>
</blockquote></div></div>