Great, this will extend the usage scenario of IoTDB. Jialin Qiao
Yuan Tian <jackietie...@gmail.com> 于2024年4月7日周日 19:39写道: > > Hi all, > > As introduced in the official documentation( > https://iotdb.apache.org/UserGuide/latest/Basic-Concept/Data-Model-and-Terminology.html), > the previous modeling method of IoTDB was a tree model, which formed a full > path of a sequence from the root node to the leaf node, and a device path > from the root node to the second-to-last layer node. The previous query > syntax of IoTDB was very similar to the standard relational SQL, centered > on the sequence, with the sequence prefix name in `from clause` and the > sequence suffix name in `select clause`. This query syntax is not very > friendly to users who are accustomed to relational SQL, and they cannot > apply their previous query experience to IoTDB. > > Therefore, we are designing a new schema model called table model for > IoTDB. We will provide data to users in a table view in the same way as > relational databases. Each kind of device belongs to a table, and users can > use standard SQL to query this table, which greatly reduces the learning > curve of IoTDB. > > The functional specs for table model can be found in > https://timechor.feishu.cn/docx/C2eodP84VoJ0kuxgbhlc1fejnsh,and our dev > branch is ty/TableModelGrammar。Syntax Definition file for Table model can > be found > in > iotdb-core/relational-grammar/src/main/antlr4/org/apache/iotdb/db/relational/grammar/sql/RelationalSql.g4 > > To support the table model, we also need to change the current tsfile > format, so we need to upgrade tsfile version from V3 to V4, the new file > format for tsfile V4 can be seen in > https://apache-iotdb.feishu.cn/docx/QNeVd7mpVoWaFxxobopcCsw6ne5 > > Our development is currently at a very early stage, and we would like to > invite you to discuss the functionality of the table model. Your feedback > is valuable to us and will help us shape the development of this feature. > > > Best regards, > -------------------------- > Yuan Tian