<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p.m-1603704270247114584msolistparagraph, li.m-1603704270247114584msolistparagraph, div.m-1603704270247114584msolistparagraph
        {mso-style-name:m_-1603704270247114584msolistparagraph;
        mso-margin-top-alt:auto;
        margin-right:0cm;
        mso-margin-bottom-alt:auto;
        margin-left:0cm;
        font-size:12.0pt;
        font-family:"Times New Roman",serif;}
span.StileMessaggioDiPostaElettronica18
        {mso-style-type:personal;
        font-family:"Calibri",sans-serif;
        color:windowtext;}
span.StileMessaggioDiPostaElettronica19
        {mso-style-type:personal-compose;
        font-family:"Calibri",sans-serif;
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;
        mso-fareast-language:EN-US;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:70.85pt 2.0cm 2.0cm 2.0cm;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="IT" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US">Regarding the open points:<br>
<br>
Checkpoint = the “Consistent” option is not clear or the doc link provided is not clear? dbdb.io 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” &#43; “Blocking” (see PostgreSQL entry for some background around “Consistent”
<a href="https://dbdb.io/db/postgresql">https://dbdb.io/db/postgresql</a>)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US">Joins = dbdb.io 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?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US">Storage Architecture = it’s related to where the data is saved (disk, memory or both)…since we are planning about &nbsp;<a href="https://github.com/diennea/herddb/issues/401">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 dbdb.io terminology)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US">Storage Model = &quot;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<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US">Storage Organization = I will keep both &quot;Log-structured&quot; and &quot;Heaps&quot; since we store data both on data file and on the Bookie log<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language: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?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US">Query Compilation = “Code Generation”: is this related to our usage of Apache Calcite?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US">Query Execution = “Vectorized Model”: is this related to our usage of Apache Calcite?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:13.0pt;font-family:&quot;Arial&quot;,sans-serif">Alessandro Luccaroni</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">
<br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif">Platform Manager @ Diennea - MagNews<br>
</span><span lang="EN-US" style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif">Tel.:&nbsp;(&#43;39)&nbsp;0546&nbsp;066100 Int. 924 - Mob.:
</span><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif">(&#43;39) 393 7273519</span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"><br>
</span><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif">Viale G.Marconi 30/14 - 48018 Faenza (RA) - Italy</span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">Da:</span></b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> herddb-dev-bounces@lists.herddb.org [mailto:herddb-dev-bounces@lists.herddb.org]
<b>Per conto di </b>Enrico Olivelli<br>
<b>Inviato:</b> martedì 2 luglio 2019 00:02<br>
<b>A:</b> Herddb developers &lt;herddb-dev@lists.herddb.org&gt;<br>
<b>Oggetto:</b> Re: [Herddb-dev] Herddb entry on dbdb.io<o:p></o:p></span></p>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div>
<div>
<p class="MsoNormal">Great idea Alessandro,<o:p></o:p></p>
<div>
<p class="MsoNormal">some comments inline below<o:p></o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p>&nbsp;</o:p></p>
<div>
<div>
<p class="MsoNormal">Il gio 27 giu 2019, 16:09 Alessandro Luccaroni - Diennea &lt;<a href="mailto:alessandro.luccaroni@diennea.com">alessandro.luccaroni@diennea.com</a>&gt; ha scritto:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Hi all,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">I’ve grouped up a bunch of information about Herd, can you check if everything seems correct?</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Checkpoints =&nbsp; &quot;Consistent&quot; (<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><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">This is not clear to me.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">We are always respecting ACID properties. And this is not related to checkpoints.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Foreign Keys = &quot;Not Supported&quot; (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Ok<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Data Model = &quot;Relational&quot;&nbsp; (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)<o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok (relational usually means 'with tables')<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Indexes =&nbsp; &quot;B-Link&quot; &quot;BRIN&quot; (<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><o:p></o:p></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&nbsp;<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Isolation Levels = &quot;Read Committed&quot; (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Joins = &quot;Nested Loop join&quot; (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">This is not true indeed.&nbsp;<o:p></o:p></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.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">We can write Joins -supported various types, as driven by Apache Calcite SQL Planner<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Query Interface = &quot;SQL&quot; &quot;Command-line/Shell&quot; (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">JDBC, proprietary API and command line<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Storage Architecture = &quot;Hybrid&quot;</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Not sure what it means<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Storage Model = &quot;Key/Value&quot; &quot;N-ary Storage Model (Row/Record)&quot; (<a href="https://github.com/diennea/herddb/wiki/Data-storage" target="_blank">https://github.com/diennea/herddb/wiki/Data-storage</a>)</span><o:p></o:p></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<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Storage Organization = &quot;Log-structured&quot; &quot;Heaps&quot; (<a href="https://github.com/diennea/herddb/wiki/Data-storage" target="_blank">https://github.com/diennea/herddb/wiki/Data-storage</a>)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Something like that<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Stored Procedures = &quot;Not Supported&quot; (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">System Architecture =&nbsp; &quot;Shared-Nothing&quot; (<a href="https://github.com/diennea/herddb/wiki/Replication" target="_blank">https://github.com/diennea/herddb/wiki/Replication</a>)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Views = &quot;Not Supported&quot; (<a href="https://github.com/diennea/herddb/wiki/SQL-Support" target="_blank">https://github.com/diennea/herddb/wiki/SQL-Support</a>)</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Ok<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">“Concurrency Control”</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">1)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Deterministic Concurrency Control</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Maybe this one<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">2)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Multi-version Concurrency Control (MVCC)</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">3)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Optimistic Concurrency Control (OCC)</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">4)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Timestamp Ordering</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">5)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Two-Phase Locking (Deadlock Detection)</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">6)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Two-Phase Locking (Deadlock Prevention)</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">“Query Compilation”</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">1)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Code Generation</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal">Something like that<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">2)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">JIT Compilation</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">3)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Not Supported</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">4)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Stored Procedure Compilation</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">“Query Execution”</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">1)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Materialized Model</span><o:p></o:p></p>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">2)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Tuple-at-a-Time Model</span><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
</div>
<div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<div>
<p class="MsoNormal">Maybe this one<o:p></o:p></p>
</div>
<div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="m-1603704270247114584msolistparagraph"><span lang="EN-US">3)</span><span lang="EN-US" style="font-size:7.0pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US">Vectorized Model</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><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><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:13.0pt;font-family:&quot;Arial&quot;,sans-serif">Alessandro Luccaroni</span></b>
<br>
<span style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif">Platform Manager @ Diennea - MagNews<br>
</span><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif">Tel.:&nbsp;(&#43;39)&nbsp;0546&nbsp;066100 Int. 924 - Mob.: (&#43;39) 393 7273519</span><br>
<span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif">Viale G.Marconi 30/14 - 48018 Faenza (RA) - Italy</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">&nbsp;<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:black"><br>
CONFIDENTIALITY &amp; 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><o:p></o:p></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><o:p></o:p></p>
</blockquote>
</div>
</div>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Black" size="2"><br>
CONFIDENTIALITY &amp; 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>
</body>
</html>