Apache IoTDB vs AWS IoT SiteWise

Apache IoTDB is an open-source industrial IoT time-series database for collecting, storing, managing, and analyzing device data across edge and cloud deployments. The project describes high-speed writes for millions of networked devices alongside fast reads. Query features include aligning time across devices and sensors, time-series computation, and aggregation by time dimensions. Ingestion options include IoTDB-SQL, JDBC, Java, C++, Python, and Go native APIs, REST, MQTT, CSV, and TsFile. Named analysis ecosystem examples include Hadoop, Spark, Flink, and Grafana. Deployment options include cloud installation, a desktop terminal tool, and synchronization between cloud and on-premise machines. The REST service is disabled by default and uses Basic Authentication except for the health check endpoint. Data and cluster permissions can be managed through users, roles, and privileges. The homepage states disk storage can cost less than $0.23 per GB. The project lists energy, aerospace, transportation, steel, and other IoT scenarios. Its JDBC documentation cautions that insert operations may not provide high-performance writing and recommends the Java Native API for Java applications.

AWS IoT SiteWise is a managed service for collecting, storing, organizing, and monitoring industrial equipment data. Asset models structure information at enterprise, site, area, and machine levels. SiteWise Edge runs on local Linux or Microsoft Windows Server devices, gathering and processing data before sending it to AWS Cloud. It supports OPC-UA, MQTT, and partner protocols, and can transfer data to Amazon S3, AWS IoT SiteWise, AWS IoT Core, Amazon Timestream, and Amazon Kinesis. Storage includes hot and warm tiers plus a customer-managed cold tier using Amazon S3. The service offers real-time stream processing, custom dashboards, SQL querying, anomaly detection, and machine-learning tools. Internet communication uses TLS, with cloud transfer over MQTT or HTTPS; AWS KMS customer-managed keys can encrypt specified cloud values. The free Data Collection Pack transfers industrial data, while the Data Processing Pack costs $200 a month per active gateway. Broader SiteWise usage is paid with no listed price.