{"id":59290,"date":"2025-09-26T10:45:15","date_gmt":"2025-09-26T10:45:15","guid":{"rendered":"https:\/\/becolve.com\/blog\/time-series-database-what-is-it-for-why-is-it-important\/"},"modified":"2025-09-26T10:45:15","modified_gmt":"2025-09-26T10:45:15","slug":"time-series-database-what-is-it-for-why-is-it-important","status":"publish","type":"blog","link":"https:\/\/becolve.com\/en\/blog\/time-series-database-what-is-it-for-why-is-it-important\/","title":{"rendered":"Time Series Database: What is it for? Why is it important?"},"content":{"rendered":"

In the frenetic hour of Big Data, IoT, Cloud<\/strong> and other initiatives of IT\/OT systems, Wonderware<\/strong> has more than 20 years of experience and more than 20,000 Historian systems in production in the temporal database market. Today, Time-Series databases, also called timestamped or time series databases, are experiencing the greatest growth in the market. Since the emergence of IoT, Time-Series databases have become a source of interest for companies. <\/p>\n

Indeed, they allow storing one or other monitoring systems. So, what are they for? Why are they a strong link in an industrial information system?<\/strong><\/p>\n

Here is a market analysis<\/strong> accessible on the web DB-Engines.com<\/a>:<\/p>\n

\"database<\/p>\n

\n

The first question that is often asked is: Why set up a Time-Serie type database?<\/strong> <\/p>\n<\/blockquote>\n

First, a Time-Series type database<\/strong> is characterized by the ability to store a large volume of data, being able to record it at regular intervals (every second, for example) or in an event (end of Batch, for example).<\/p>\n

The other characteristic it has is the possibility of enriching the stored variables with meta-data<\/strong> (zones, equipment, alarms…)<\/p>\n

There are some important characteristics<\/strong> to consider when choosing a Time-Serie database. Here are some of the things to keep in mind: <\/p>\n

I<\/span> Scalability<\/strong>:<\/h3>\n

The Time-Serie database must be able to evolve in terms of the volume of data to be collected, but also in terms of architectures. Wonderware Historian<\/strong> offers a solution to collect in real time from 100 to 2,000,000 variables for the data server. It offers the possibility of creating multi-level architectures<\/strong> (Level 1, Level 2, Level 3 …) that allow distributing the volume of data collected and stored among different servers (between machines, workshops, factory and company level). <\/p>\n

\"Wonderware<\/p>\n

I<\/span> Performance<\/strong><\/h3>\n

The Time-Serie database must be able to store in real time a large volume of data from heterogeneous sources. Wonderware Historian can record up to 300,000 state changes per second<\/strong>. Performance also applies to operations. Wonderware Historian, therefore, uses a very high data compression mechanism<\/strong> to quickly find the stored data for use in its reporting tools or dashboards. <\/p>\n

I<\/span> <\/strong>Industrial Connectivity<\/strong><\/h3>\n

The Time-Serie database must be able to connect to all types of data sources, regardless of the protocol used. Wonderware Historian allows collecting data from IoT systems through OPC-UA, MQTT or HTTP-Rest.<\/strong> In addition, it natively offers more than 250 communication drivers, to be able to access virtually any industrial or IoT device. Wonderware Historian also collects and archives data from csv files. This \u201coffline\u201d acquisition mode allows, among other things, to recover data from specific or disconnected systems. <\/p>\n

I<\/span> <\/strong>High Availability<\/strong><\/h3>\n

The Time-Serie database must always remain available because it is often a real-time data source for operators. Wonderware Historian offers different levels of availability<\/strong>. In case of loss of communication between the collection system and the database, the system manages the disconnection with a Store & Forward<\/strong> mechanism. In addition, to increase the level of availability, you can opt for a redundant Historian. This level of availability is offered through a very simple configuration. <\/p>\n

I<\/span> <\/strong>Alarms and Events<\/strong><\/h3>\n

<\/strong>The Time-Serie database must allow the context of the data collected by alarms and events when the data collection system transmits them. With System Platform and Wonderware Historian<\/strong>, it becomes possible for alarms and events to be available directly in the context of historical variables.<\/p>\n

I<\/span> <\/strong>Cloud Ready<\/strong> <\/h3>\n

A current Time-Series database must be able to integrate quickly and simply with a cloud solution. Wonderware Historian allows local systems to connect to the Wonderware-Aveva InSight cloud<\/strong>. This rapid integration makes it possible to offer value-added services such as mobility or a simplified automatic learning engine. Aveva InSight also offers as standard a graphic editor in the cloud<\/strong> that allows displaying machine data in different formats such as trends, dahsboards or superimposed on industrial graphics. <\/p>\n

In this post<\/a><\/strong> we show you how to create an account in the Insight cloud with full functionality for 45 days, without any cost.<\/span><\/p>\n