Report this

What is the reason for this report?

AI - Time series analysis with which DBMS?

Posted on October 9, 2020

Hi guys,

does anyone deal with AI? I recently visited an online forum on AI, because I’m very interested in it and I’m thinking about taking this direction professionally - neuroinformatics and artificial intelligence is very interesting and forward-looking. There I learned a lot about the functioning of artificial neural networks, especially regarding the multilayer perceptron as feedforward network, which is used for time series analysis.

What I think is that you need a really good DBMS to process and manage all the data. Especially for time series analysis you work a lot with Big Data, a high scalability of the database is essential. I have read several times that a non-relational NoSQL database would be suitable, because the performance is better with a large amount of data than with an SQL database. Especially when it comes to time series analysis I came across InfluxDB, which stores, loads and provides such time series data relatively fast. I would manage it via the DBaaS provider Aiven to integrate it into a cloud. I could also visualize the data with InfluxDB. And everything would be open source, so there would be no initial costs.

Can any of you recommend anything or have you already made experiences with a DBMS like InfluxDB for time series?

Thanks in advance



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Heya,

Just came across this answer and decided to write some general guidelines for anyone who comes across this in the future despite the old question.

For time series analysis and working with large amounts of data, a NoSQL database like InfluxDB is definitely a good choice. InfluxDB is designed specifically for handling time series data and provides high performance, scalability, and ease of use.

You can easily deploy an InfluxDB instance on DigitalOcean using our Managed Databases service. This will take care of database management tasks such as backup, recovery, and scaling so you can focus on building your AI and time-series projects. Additionally, you can use our DigitalOcean Spaces service for storage of large datasets if needed.

To visualize your data, InfluxDB supports visualization tools like Grafana, which you can also easily deploy on DigitalOcean using our one-click app.

For more information about deploying InfluxDB on DigitalOcean, please visit our page: https://www.digitalocean.com/customers/influxdb

Remember to check the current pricing for our services at: https://digitalocean.com/pricing

Hope that this helps!

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.