Analytics for the Internet of Things (IoT)

Pulling together the data

IoT data is typically stored using big data technology such as Hadoop (HDFS specifically). Joining together tables in SQL statements for dashboards typically decreases performance, sometimes significantly in these systems.

Pull together the data into as few tables as possible, so the table joins are only done during batch processing instead of every time a dashboard is used by someone. When considering what information to include in the dataset, reference the question tree and include what is needed to answer the questions.