Over the years, our R&D team for Asset tracking software have worked with different kinds of databases ranging from MS SQL to PostgresSQL to MongoDB. Recently we have flexed our data storage competency and added a new genre of databases, the time series ones. Time Series Databases are perfect for data visualization platforms as it is built specifically for handling events such as theft detection, physical distancing, temperature measurements or metrics that are time-stamped and are tracked, monitored and aggregated over time for Asset tracking system.
We had mentioned about sensor data visualization tool, a data cloud platform for our industrial monitoring solutions in one of our earlier blogs. We were on the scout for a good time-series database that could handle large time-series data for complex asset tracking systems. Our search ended with a team of Digital Twin platform developers working on InfluxDB, an opensource time-series solution that provided the perfect ally to asset tracking software development and was pretty robust to setup and deploys. Influx does have a UI to add a database if we install the .deb package. InfluxDB provides both cloud and downloadable versions and is flexible enough for complex deployments; it certainly ticked most of our IT development team’s boxes.
Time series data visualization
Asset tracking using IOT
We also tried to migrate a few of our existing systems running in MongoDB to InfluxDB in asset tracking applications. Though there were some challenges few and far between, especially handling the multi-level management. But we guess that was sorted out soon and the transition was complete. One good thing about InfluxDB we noted was that it does have real-time access out of the gate and quickly identify the patterns and find value for your data. We could add more visualization instances in one of our dashboards, and while we earlier used the sleepy mongoose REST interface, InfluxDB programming allowed us the luxury of connecting it directly to our live graph chart by our Grafana developers.
InfluxDB programming for wireless asset tracking
InfluxDB has a powerful engine that can handle data coming through our large asset tracking IoT deployments. It supports millions of writes per second and with the help of native clustering, all single points of failure are eliminated and users can get faster & accurate real-time values. It can accept data via HTTP, TCP, or UDP protocols. The sensor supported includes ELA innovation, Wirepas & Ruuvi.
Wireless asset tracking systems
Having trouble managing millions of data churned out by the sensors? Are you struggling to find a good visualization solution for your machine data? We at Ripples IOT might just have a perfect solution for you. For more info, Contact RipplesIOT