import{_ as l,r,o as d,c,b as t,d as e,a,w as s,e as o}from"./app-Bx8hKGcu.js";const p={},h=o(`<h1 id="data-model" tabindex="-1"><a class="header-anchor" href="#data-model"><span>Data Model</span></a></h1><p>A wind power IoT scenario is taken as an example to illustrate how to creat a correct data model in IoTDB.</p><p>According to the enterprise organization structure and equipment entity hierarchy, it is expressed as an attribute hierarchy structure, as shown below. The hierarchical from top to bottom is: power group layer - power plant layer - entity layer - measurement layer. ROOT is the root node, and each node of measurement layer is a leaf node. In the process of using IoTDB, the attributes on the path from ROOT node is directly connected to each leaf node with &quot;.&quot;, thus forming the name of a timeseries in IoTDB. For example, The left-most path in Figure 2.1 can generate a timeseries named <code>root.ln.wf01.wt01.status</code>.</p><center><img style="width:100%;max-width:800px;max-height:600px;margin-left:auto;margin-right:auto;display:block;" src="https://alioss.timecho.com/docs/img/github/122668849-b1c69280-d1ec-11eb-83cb-3b73c40bdf72.png"></center><p>Here are the basic concepts of the model involved in IoTDB.</p><h2 id="measurement-entity-storage-group-path" tabindex="-1"><a class="header-anchor" href="#measurement-entity-storage-group-path"><span>Measurement, Entity, Storage Group, Path</span></a></h2><h3 id="measurement-also-called-field" tabindex="-1"><a class="header-anchor" href="#measurement-also-called-field"><span>Measurement (Also called field)</span></a></h3><p>It is information measured by detection equipment in an actual scene and can transform the sensed information into an electrical signal or other desired form of information output and send it to IoTDB. In IoTDB, all data and paths stored are organized in units of measurements.</p><h3 id="entity-also-called-device" tabindex="-1"><a class="header-anchor" href="#entity-also-called-device"><span>Entity (Also called device)</span></a></h3><p><strong>An entity</strong> is an equipped with measurements in real scenarios. In IoTDB, all measurements should have their corresponding entities.</p><h3 id="storage-group" tabindex="-1"><a class="header-anchor" href="#storage-group"><span>Storage Group</span></a></h3><p><strong>A group of entities.</strong> Users can set any prefix path as a storage group. Provided that there are four timeseries <code>root.ln.wf01.wt01.status</code>, <code>root.ln.wf01.wt01.temperature</code>, <code>root.ln.wf02.wt02.hardware</code>, <code>root.ln.wf02.wt02.status</code>, two devices <code>wt01</code>, <code>wt02</code> under the path <code>root.ln</code> may belong to the same owner or the same manufacturer, so d1 and d2 are closely related. At this point, the prefix path root.vehicle can be designated as a storage group, which will enable IoTDB to store all devices under it in the same folder. Newly added devices under <code>root.ln</code> will also belong to this storage group.</p><blockquote><p>Note1: A full path (<code>root.ln.wf01.wt01.status</code> as in the above example) is not allowed to be set as a storage group.</p><p>Note2: The prefix of a timeseries must belong to a storage group. Before creating a timeseries, users must set which storage group the series belongs to. Only timeseries whose storage group is set can be persisted to disk.</p></blockquote><p>Once a prefix path is set as a storage group, the storage group settings cannot be changed.</p><p>After a storage group is set, the ancestral layers, children and descendant layers of the corresponding prefix path are not allowed to be set up again (for example, after <code>root.ln</code> is set as the storage group, the root layer and <code>root.ln.wf01</code> are not allowed to be set as storage groups).</p><p>The Layer Name of storage group can only consist of characters, numbers and underscores, like <code>root.storagegroup_1</code>.</p><h3 id="path" tabindex="-1"><a class="header-anchor" href="#path"><span>Path</span></a></h3><p>A <code>path</code> is an expression that conforms to the following constraints:</p><div class="language-sql line-numbers-mode" data-ext="sql" data-title="sql"><pre class="language-sql"><code>path       
    : layer_name <span class="token punctuation">(</span><span class="token string">&#39;.&#39;</span> layer_name<span class="token punctuation">)</span><span class="token operator">*</span>
    <span class="token punctuation">;</span>
layer_name
    : wildcard? id wildcard?
    <span class="token operator">|</span> wildcard
    <span class="token punctuation">;</span>
wildcard 
    : <span class="token string">&#39;*&#39;</span> 
    <span class="token operator">|</span> <span class="token string">&#39;**&#39;</span>
    <span class="token punctuation">;</span>
</code></pre><div class="line-numbers" aria-hidden="true"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div>`,19),m=t("code",null,"id",-1),u=t("p",null,[e("We call the part of a path divided by "),t("code",null,"'.'"),e(" as a layer ("),t("code",null,"layer_name"),e("). For example: "),t("code",null,"root.a.b.c"),e(" is a path with 4 layers.")],-1),g=t("p",null,[e("The following are the constraints on the layer ("),t("code",null,"layer_name"),e("):")],-1),f=o("<li><p><code>root</code> is a reserved character, and it is only allowed to appear at the beginning layer of the time series mentioned below. If <code>root</code> appears in other layers, it cannot be parsed and an error will be reported.</p></li><li><p>Except for the beginning layer (<code>root</code>) of the time series, the characters supported in other layers are as follows:</p><ul><li>Chinese characters: <code>&quot;\\u2E80&quot;</code> to <code>&quot;\\u9FFF&quot;</code></li><li><code>_</code> <code>:</code> <code>@</code> <code>#</code> <code>$</code> <code>{</code> <code>}</code></li><li><code>&quot;A&quot;</code> to <code>&quot;Z&quot;</code>, <code>&quot;a&quot;</code> to <code>&quot;z&quot;</code>, <code>&quot;0&quot;</code> to <code>&quot;9&quot;</code></li></ul></li>",2),y=t("p",null,[e("In addition to the beginning layer ("),t("code",null,"root"),e(") of the time series and the storage group layer, other layers also support the use of special strings referenced by ` or "),t("code",null,'" '),e(" as its name. It should be noted that the quoted string cannot contain "),t("code",null,"."),e(" characters. Here are some legal examples:")],-1),b={href:"http://root.sg",target:"_blank",rel:"noopener noreferrer"},w={href:"http://root.sg",target:"_blank",rel:"noopener noreferrer"},v=o("<li><p>Layer (<code>layer_name</code>) cannot start with a digit unless the layer(<code>layer_name</code>) is quoted with ` or <code>&quot;</code>.</p></li><li><p>In particular, if the system is deployed on a Windows machine, the storage group layer name will be case-insensitive. For example, creating both <code>root.ln</code> and <code>root.LN</code> at the same time is not allowed.</p></li>",2),x=o('<h3 id="path-pattern" tabindex="-1"><a class="header-anchor" href="#path-pattern"><span>Path Pattern</span></a></h3><p>In order to make it easier and faster to express multiple timeseries paths, IoTDB provides users with the path pattern. Users can construct a path pattern by using wildcard <code>*</code> and <code>**</code>. Wildcard can appear in any layer of the path.</p><p><code>*</code> represents one layer. For example, <code>root.vehicle.*.sensor1</code> represents a 4-layer path which is prefixed with <code>root.vehicle</code> and suffixed with <code>sensor1</code>.</p><p><code>**</code> represents (<code>*</code>)+, which is one or more layers of <code>*</code>. For example, <code>root.vehicle.device1.**</code> represents all paths prefixed by <code>root.vehicle.device1</code> with layers greater than or equal to 4, like <code>root.vehicle.device1.*</code>, <code>root.vehicle.device1.*.*</code>, <code>root.vehicle.device1.*.*.*</code>, etc; <code>root.vehicle.**.sensor1</code> represents a path which is prefixed with <code>root.vehicle</code> and suffixed with <code>sensor1</code> and has at least 4 layers.</p><blockquote><p>Note1: Wildcard <code>*</code> and <code>**</code> cannot be placed at the beginning of the path.</p></blockquote><h2 id="timeseries" tabindex="-1"><a class="header-anchor" href="#timeseries"><span>Timeseries</span></a></h2><h3 id="timestamp" tabindex="-1"><a class="header-anchor" href="#timestamp"><span>Timestamp</span></a></h3>',7),_=o('<h3 id="data-point" tabindex="-1"><a class="header-anchor" href="#data-point"><span>Data point</span></a></h3><p><strong>A &quot;time-value&quot; pair</strong>.</p><h3 id="timeseries-1" tabindex="-1"><a class="header-anchor" href="#timeseries-1"><span>Timeseries</span></a></h3><p><strong>The record of a measurement of an entity on the time axis.</strong> Timeseries is a series of data points.</p><p>A measurement of an entity corresponds to a timeseries.</p><p>Also called meter, timeline, and tag, parameter in real time database.</p><p>For example, if entity wt01 in power plant wf01 of power group ln has a measurement named status, its timeseries can be expressed as: <code>root.ln.wf01.wt01.status</code>.</p><h3 id="aligned-timeseries" tabindex="-1"><a class="header-anchor" href="#aligned-timeseries"><span>Aligned timeseries</span></a></h3><p>There is a situation that multiple measurements of an entity are sampled simultaneously in practical applications, forming multiple timeseries aligned on a time column.</p><p>By using aligned timeseries, the timestamp columns of a group of aligned timeseries need to be stored only once in memory and disk when inserting data, instead of once per timeseries.</p><p>It would be best if you created a group of aligned timeseries at the same time.</p><p>You cannot create non-aligned timeseries under the entity to which the aligned timeseries belong, nor can you create aligned timeseries under the entity to which the non-aligned timeseries belong.</p><p>When querying, you can query each timeseries separately.</p><p>When inserting data, it is allowed to insert null value in the aligned timeseries.</p><img style="width:100%;max-width:800px;max-height:600px;margin-left:auto;margin-right:auto;display:block;" src="https://alioss.timecho.com/docs/img/github/114125919-f4850800-9929-11eb-8211-81d4c04af1ec.png"><p>In the following chapters of data definition language, data operation language and Java Native Interface, various operations related to aligned timeseries will be introduced one by one.</p><h2 id="schema-template" tabindex="-1"><a class="header-anchor" href="#schema-template"><span>Schema Template</span></a></h2>',17),T=t("strong",null,"schema template",-1),k=t("p",null,"In the following chapters of, data definition language, data operation language and Java Native Interface, various operations related to schema template will be introduced one by one.",-1);function q(D,I){const n=r("RouteLink"),i=r("ExternalLinkIcon");return d(),c("div",null,[h,t("p",null,[e("You can refer to the definition of "),m,e(" in "),a(n,{to:"/UserGuide/V0.13.x/Reference/Syntax-Conventions.html"},{default:s(()=>[e("Syntax-Conventions")]),_:1}),e(".")]),u,g,t("ul",null,[f,t("li",null,[y,t("ul",null,[t("li",null,[t("a",b,[e("root.sg"),a(i)]),e('."select"."+-from="."where""where"""."$", which contains 6 layers: root, sg, select, +-from, where"where", $')]),t("li",null,[t("a",w,[e("root.sg"),a(i)]),e('.````.`select`.`+="from"`.`$`, which contains 6 layers: root, sg, `, select, +-"from", $')])])]),v]),x,t("p",null,[e("The timestamp is the time point at which data is produced. It includes absolute timestamps and relative timestamps. For detailed description, please go to "),a(n,{to:"/UserGuide/V0.13.x/Data-Concept/Data-Type.html"},{default:s(()=>[e("Data Type doc")]),_:1}),e(".")]),_,t("p",null,[e("In the actual scenario, many entities collect the same measurements, that is, they have the same measurements name and type. A "),T,e(" can be declared to define the collectable measurements set. Schema template helps save memory by implementing schema sharing. For detailed description, please refer to "),a(n,{to:"/UserGuide/V0.13.x/Data-Concept/Schema-Template.html"},{default:s(()=>[e("Schema Template doc")]),_:1}),e(".")]),k])}const B=l(p,[["render",q],["__file","Data-Model-and-Terminology.html.vue"]]),M=JSON.parse('{"path":"/UserGuide/V0.13.x/Data-Concept/Data-Model-and-Terminology.html","title":"Data Model","lang":"en-US","frontmatter":{"description":"Data Model A wind power IoT scenario is taken as an example to illustrate how to creat a correct data model in IoTDB. According to the enterprise organization structure and equi...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/V0.13.x/Data-Concept/Data-Model-and-Terminology.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/V0.13.x/Data-Concept/Data-Model-and-Terminology.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"Data Model"}],["meta",{"property":"og:description","content":"Data Model A wind power IoT scenario is taken as an example to illustrate how to creat a correct data model in IoTDB. According to the enterprise organization structure and equi..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2023-07-10T03:11:17.000Z"}],["meta",{"property":"article:modified_time","content":"2023-07-10T03:11:17.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"Data Model\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2023-07-10T03:11:17.000Z\\",\\"author\\":[]}"]]},"headers":[{"level":2,"title":"Measurement, Entity, Storage Group, Path","slug":"measurement-entity-storage-group-path","link":"#measurement-entity-storage-group-path","children":[{"level":3,"title":"Measurement (Also called field)","slug":"measurement-also-called-field","link":"#measurement-also-called-field","children":[]},{"level":3,"title":"Entity (Also called device)","slug":"entity-also-called-device","link":"#entity-also-called-device","children":[]},{"level":3,"title":"Storage Group","slug":"storage-group","link":"#storage-group","children":[]},{"level":3,"title":"Path","slug":"path","link":"#path","children":[]},{"level":3,"title":"Path Pattern","slug":"path-pattern","link":"#path-pattern","children":[]}]},{"level":2,"title":"Timeseries","slug":"timeseries","link":"#timeseries","children":[{"level":3,"title":"Timestamp","slug":"timestamp","link":"#timestamp","children":[]},{"level":3,"title":"Data point","slug":"data-point","link":"#data-point","children":[]},{"level":3,"title":"Timeseries","slug":"timeseries-1","link":"#timeseries-1","children":[]},{"level":3,"title":"Aligned timeseries","slug":"aligned-timeseries","link":"#aligned-timeseries","children":[]}]},{"level":2,"title":"Schema Template","slug":"schema-template","link":"#schema-template","children":[]}],"git":{"createdTime":1688958677000,"updatedTime":1688958677000,"contributors":[{"name":"CritasWang","email":"critas@outlook.com","commits":1}]},"readingTime":{"minutes":4.53,"words":1358},"filePathRelative":"UserGuide/V0.13.x/Data-Concept/Data-Model-and-Terminology.md","localizedDate":"July 10, 2023","autoDesc":true}');export{B as comp,M as data};