This article was originally published in InfoWorld and is reposted here with permission. The compactor handles critical post-ingestion and pre-query workloads in the background on a separate server, enabling low latency for data ingestion and high performance for queries. The demand for high volumes of data has increased the need for databases that can handle both data ingestion and querying with the lowest possible latency (aka high performance).

In industrial operations, time is money. The more efficient processes and machinery are, the better it is for business. Providing proactive monitoring and maintenance of industrial machines, however, is not an easy task. This is especially true as these machines become increasingly complex and distributed. It’s not possible to have maintenance crews on site for every asset in a distributed system. The edge is where the physical world meets the digital world.

SAN FRANCISCO – March 21, 2023 – InfluxData, creator of the leading time series platform InfluxDB, today announced it has received the ISO/IEC 27001:2013 certification, a globally recognized standard for Information Security Management Systems (ISMS). The certificate scope comprises the ISMS supporting the operations underlying the InfluxDB database cloud and enterprise offerings. It also includes ISO/IEC 27018:2019 compliance for the protection of personally identifiable information.

SQL databases have several functions that reduce the complexity of working with date and time. Using these functions and a date and time type column, you can depend on SQL for the logic to write and read data with date and time. In this post, you’ll learn how to use the SQL date and time functions to get the current date and time.

For a very long time, businesses in various industries have been using smart sensors. However, with the development of the Internet of Things (IoT), their significance has increased. Sensors represent the beginning of a data collection chain that, when processed by IoT platforms, generates essential insights for assertive decision-making and even for developing new business ideas. Generally, a smart sensor has three main components: This technology is already used in many countries.

In the world of databases, cardinality refers to the number of unique sets of data stored in a database. If we drill down a little further, we can think of cardinality as the total number of unique values possible within a table column or database equivalent. When thinking about time series data, we can ask some specific questions about cardinality. What does cardinality look like in practice? When does cardinality become a problem? How do we prevent cardinality issues?

Deduplication is an effective alternative to transactions for eventually consistent use cases of a distributed database. Here’s why. Building a distributed database is complicated and needs to consider many factors. Previously, I discussed two important techniques, sharding and partitioning, for gaining greater throughput and performance from databases.

Time-varying entities may contain multiple time-varying and static attributes, making mapping them a particular challenge. Time is notorious in modeling tasks. Indeed, the temporal aspect exacerbates the complexity of the modeling task, making simple diagrams look pretty complex. The temporal dimension becomes particularly nasty when it takes part in identifying entities. The figure on the right visualizes the typical database example.

From time to time throughout my career, I have been involved in projects with dramatic releases when we built and delivered something very new and very special. The release of InfluxDB Cloud, powered by IOx (referred to as “InfluxDB IOx” for short below) absolutely meets those criteria. I want to explain my personal views of why this release is so impactful and why I am so excited to be part of it.

In different techniques, entities and relationships remain central. However, their nature and roles are reinterpreted according to the business goals. Data modeling is the process of defining and representing the data elements in a system in order to communicate connections between data points and structures. In his impactful book “Designing Data-Intensive Applications,” Martin Kleppmann describes data modeling as the most critical step in developing any information system.