<!DOCTYPE html><htmllang='en'><head><title>Documentation | Taos Data</title><metaname='description'content='TDengine is an open-source big data platform for IoT. Along with a 10x faster time-series database, it provides caching, stream computing, message queuing, and other functionalities. It is designed and optimized for Internet of Things, Connected Cars, and Industrial IoT. Read the documentation for TDengine here to get started right away.'><metaname='keywords'content='TDengine, Big Data, Open Source, IoT, Connected Cars, Industrial IoT, time-series database, caching, stream computing, message queuing, IT infrastructure monitoring, application performance monitoring, Internet of Things,TAOS Data, Documentation, programming, coding, syntax, frequently asked questions, questions, faq'><metaname='title'content='Documentation | Taos Data'><metaproperty='og:site_name'content='Taos Data'/><metaproperty='og:title'content='Documentation | Taos Data'/><metaproperty='og:type'content='article'/><metaproperty='og:url'content='https://www.taosdata.com/en/documentation'/><metaproperty='og:description'content='TDengine is an open-source big data platform for IoT. Along with a 10x faster time-series database, it provides caching, stream computing, message queuing, and other functionalities. It is designed and optimized for Internet of Things, Connected Cars, and Industrial IoT. Read the documentation for TDengine here to get started right away.'/><linkrel='canonical'href='https://www.taosdata.com/en/documentation'/><script src='lib/jquery-3.4.1.min.js'type='application/javascript'></script><linkhref='lib/bootstrap.min.css'rel='stylesheet'><linkhref='styles/base.min.css'rel='stylesheet'><linkrel='stylesheet'href='lib/docs/taosdataprettify.css'><linkrel='stylesheet'href='lib/docs/docs.css'><linkrel='stylesheet'href='/styles/documentation/index.min.css'><script src='lib/docs/prettify.js'></script><script src='lib/docs/prettyprint-sql.js'></script></head><body><script>$('#documentation-href').addClass('active')</script><divclass='container-fluid'><mainclass='content-wrapper'><sectionclass='documentation'><h1>Documentation</h1><p>TDengine is a highly efficient platform to store, query, and analyze time-series data. It works like a relational database, but you are strongly suggested to read through the following documentation before you experience it.</p><ahref='getting-started/index.html'><h2>Getting Started</h2></a><ul><li><ahref='getting-started/index.html#Quick-Start'>Quick Start</a>: download, install and experience TDengine in a few seconds</li><li><ahref='getting-started/index.html#TDengine-Shell'>TDengine Shell</a>: command-line interface to access TDengine server</li><li><ahref='getting-started/index.html#Major-Features'>Major Features</a>: insert/query, aggregation, cache, pub/sub, continuous query </li></ul><ahref='data-model-and-architecture/index.html'><h2>Data Model and Architecture</h2></a><ul><li><ahref='data-model-and-architecture/index.html#Data-Model'>Data Model</a>: relational database model, but one table for one device with static tags</li><li><ahref='data-model-and-architecture/index.html#Architecture'>Architecture</a>: Management Module, Data Module, Client Module</li><li><ahref='data-model-and-architecture/index.html#Writing-Process'>Writing Process</a>: records recieved are written to WAL, cache, then ack is sent back to client</li><li><ahref='data-model-and-architecture/index.html#Data-Storage'>Data Storage</a>: records are sharded in the time range, and stored column by column </li></ul><ahref='taos-sql/index.html'><h2>TAOS SQL</h2></a><ul><li><ahref='taos-sql/index.html#Data-Types'>Data Types</a>: support timestamp, int, float, double, binary, nchar, bool, and other types</li><li><ahref='taos-sql/index.html#Database-Management'>Database Management</a>: add, drop, check databases</li><li><ahref='taos-sql/index.html#Table-Management'>Table Management</a>: add, drop, check, alter tables</li><li><ahref='taos-sql/index.html#Inserting-Records'>Inserting Records</a>: insert one or more records into tables, historical records can be imported</li><li><ahref='taos-sql/index.html#Data-Query'>Data Query</a>: query data with time range and filter conditions, support limit/offset</li><li><ahref='taos-sql/index.html#SQL-Functions'>SQL Functions</a>: support aggregation, selector, transformation functions</li><li><ahref='taos-sql/index.html#Downsampling'>Downsampling</a>: aggregate data in successive time windows, support interpolation</li></ul><ahref='super-table/index.html'><h2>Super Table</h2></a><ul><li><ahref='super-table#What-is-a-Super-Table'>What is a Super Table</a>: an innovated way to aggregate tables</li><li><ahref='super-table#Create-a-STable'>Create a STable</a>: it is like creating a standard table, but with tags defined</li><li><ahref='super-table#Create-a-Table-via-STable'>Create a Table via STable</a>: use STable as the template, with tags specified</li><li><ahref='super-table#Aggregate-Tables-via-STable'>Aggregate Tables via STable</a>: group tables together by specifying the tags filter condition</li><li><ahref='super-table#Create-Table-Automatically'>Create Table Automatically</a>: create tables automatically with a STable as a template</li><li><ahref='super-table#Management-of-STables'>Management of STables</a>: create/delete/alter super table just like standard tables</li><li><ahref='super-table#Management-of-Tags'>Management of Tags</a>: add/delete/alter tags on super tables or tables </li></ul><ahref='advanced-features/index.html'><h2>Advanced Features</h2></a><ul><li><ahref='advanced-features/index.html#Continuous-Query'>Continuous Query</a>: query executed by TDengine periodically with a sliding window</li><li><ahref='advanced-features/index.html#Publisher/Subscriber'>Publisher/Subscriber</a>: subscribe to the newly arrived data like a typical messaging system </li><li><ahref='advanced-features/index.html#Caching'>Caching</a>: the newly arrived data of each device/table will always be cached</li></ul><ahref='connector/index.html'><h2>Connector</h2></a><ul><li><ahref='connector/index.html#C/C++-Connector'>C/C++ Connector</a>: primary method to connect to the server through libtaos client library</li><li><ahref='connector/index.html#Java-Connector'>Java Connector</a>: driver for connecting to the server from Java applications using the JDBC API</li><li><ahref='connector/index.html#Python-Connector'>Python Connector</a>: driver for connecting to the server from Python applications </li><li><ahref='connector/index.html#RESTful-Connector'>RESTful Connector</a>: a simple way to interact with TDengine via HTTP</li><li><ahref='connector/index.html#Go-Connector'>Go Connector</a>: driver for connecting to the server from Go applications</li><li><ahref='connector/index.html#Node.js-Connector'>Node.js Connector</a>: driver for connecting to the server from node applications</li></ul><ahref='connections-with-other-tools/index.html'><h2>Connections with Other Tools</h2></a><ul><li><ahref='connections-with-other-tools/index.html#Telegraf'>Telegraf</a>: pass the collected DevOps metrics to TDengine </li><li><ahref='connections-with-other-tools/index.html#Grafana'>Grafana</a>: query the data saved in TDengine and visualize them </li><li><ahref='connections-with-other-tools/index.html#Matlab'>Matlab</a>: access TDengine server from Matlab via JDBC</li><li><ahref='connections-with-other-tools/index.html#R'>R</a>: access TDengine server from R via JDBC </li></ul><ahref='administrator/index.html'><h2>Administrator</h2></a><ul><li><ahref='administrator/index.html#Directory-and-Files'>Directory and Files</a>: files and directories related with TDengine</li><li><ahref='administrator/index.html#Configuration-on-Server'>Configuration on Server</a>: customize IP port, cache size, file block size and other settings</li><li><ahref='administrator/index.html#Configuration-on-Client'>Configuration on Client</a>: customize locale, default user and others </li><li><ahref='administrator/index.html#User-Management'>User Management</a>: add/delete users, change passwords</li><li><ahref='administrator/index.html#Import-Data'>Import Data</a>: import data into TDengine from either script or CSV file</li><li><ahref='administrator/index.html#Export-Data'>Export Data</a>: export data either from TDengine shell or from tool taosdump</li><li><ahref='administrator/index.html#Management-of-Connections,-Streams,-Queries'>Management of Connections, Streams, Queries</a>: check or kill the connections, queries</li><li><ahref='administrator/index.html#System-Monitor'>System Monitor</a>: collect the system metric, and log important operations</li></ul><ahref='more-on-system-architecture/index.html'><h2>More on System Architecture</h2></a><ul><li><ahref='more-on-system-architecture/index.html#Storage-Design'>Storage Design</a>: column-based storage with optimization on time-series data </li><li><ahref='more-on-system-architecture/index.html#Query-Design'>Query Design</a>: an efficient way to query time-series data</li><li><ahref='https://www.taosdata.com/en/blog/?categories=3'>Technical blogs</a> to delve into the inside of TDengine</li></ul><ahref='https://www.taosdata.com/en/faq'><h2>Tutorials & FAQ</h2></a><ul><li><ahref='https://www.taosdata.com/en/faq'>FAQ</a>: a list of frequently asked questions and answers </li><li><ahref='https://www.taosdata.com/en/blog/?categories=4'>Use cases</a>: a few typical cases to explain how to use TDengine in IoT platform</li></ul><ahref='../index.html'>Back</a></section></main></div><?php include($s.'/footer.php'); ?><script>$('pre').addClass('prettyprint linenums');PR.prettyPrint()</script><script src='lib/docs/liner.js'></script></body></html>
