Quality Functions in the Time-series Database

Data quality issues can have a huge impact on data applications, seriously affecting various fields in the information society. According to statistics, over 25% of critical data in the world’s top 1000 companies is incorrect. In 2009, Dell’s Taiwan website sold 19-inch monitors priced at 4800 New Taiwan Dollars for 500 New Taiwan Dollars, resulting …

Quality Functions in the Time-series Database Read More »

CancellationToken: A must-read dangling pointer disaster case for programmers

In modern multi-threaded and asynchronous programming, CancellationToken is a common tool for timely and safe cancellation of long-running tasks or operations. However, careless handling of such objects can lead to the serious problem of dangling pointers, which can lead to program crashes or unpredictable behavior. This article will explore the dangling pointer problem caused by the use …

CancellationToken: A must-read dangling pointer disaster case for programmers Read More »

Major Update: v2.3.5 Aquarius Is Here! An Analysis of Function Optimization and Bug Fixes

In the v2.3.5 Aquarius release, we bring you a series of function optimizations and bug fixes to enhance the system’s performance and stability. Here are the main updates: Function Optimization Added compression tasks for incremental files.。#1945 Changed compaction operations for the same Vnode to run in a single thread. #2002 Bug Fixes Fixed an LRU …

Major Update: v2.3.5 Aquarius Is Here! An Analysis of Function Optimization and Bug Fixes Read More »

Innovative Integration of Real-Time Industrial Control Systems: Efficient Data Collection and Storage with PLC4X and CnosDB

  In contemporary industrial automation systems, real-time monitoring and data analysis have become crucial. This article introduces how to achieve efficient data collection and storage from PLC devices in industrial control systems by integrating Apache PLC4X and CnosDB, providing engineers with more powerful data analysis and monitoring tools. Definition of PLC PLC stands for Programmable …

Innovative Integration of Real-Time Industrial Control Systems: Efficient Data Collection and Storage with PLC4X and CnosDB Read More »

Database Fault Tolerance: System Clock Failure

This article discusses the CnosDB system clock failure and proposes a solution to the system clock failure in a stand-alone environment and a cluster environment, which has very important guiding significance. Database fault tolerance: system clock failure   Discussions arising from situations that may not exist One day, CnosDB intern Xiao Shao was designing time-sequential …

Database Fault Tolerance: System Clock Failure Read More »

CnosDB 2.3.4 Apus released! #Database Update #Performance Optimization #Problem Fix

Recently, the CnosDB team has released a series of exciting updates to improve user experience and system performance. Here are some of the important changes : New Function Adapt to Vector. [#1618] Added increase function, http_limiter and metrics: [#1629] Route write requests and SQL requests to the query server: [#1760] Support HTTP compression: [#1762] Support dump DDL: [#1782] Starting services via configuration: [#1789] …

CnosDB 2.3.4 Apus released! #Database Update #Performance Optimization #Problem Fix Read More »

Connect to CnosDB through DBeaver

Hey database explorers: How could you avoid using DBeaver in your CnosDB journey? Let me teach you step by step how to do it once and for all. Connect to CnosDB through DBeaver   Adding Arrow Flight SQL’s JDBC driver to the DBeaver driver can be downloaded here: https://mvnrepository.com/artifact/org.apache.arrow/flight-sql-jdbc-driver/13.0.0  1. Add driver 1. In the menu bar, …

Connect to CnosDB through DBeaver Read More »

CnosDB Data Update and Deletion

In time series data, data errors or anomalies may occur. At this time, the data needs to be cleaned and repaired. If the update operation is not supported, it will become very difficult. In addition, some business scenarios may require adjustments to existing data, such as changes in device information. Supporting data updates provides greater …

CnosDB Data Update and Deletion Read More »

Lessons From RocksDB in Large-scale Distributed System Applications

  RocksDB is a high-performance persistent key-value storage engine created by Facebook in 2012. It is based on Google’s LevelDB code. RocksDB is LSM-based, optimized for SSDs, and serves as a storage engine for multiple databases. It is used in stream processing, log queue services, index services, and SSD caching. Engine Architecture MemTable and WAL …

Lessons From RocksDB in Large-scale Distributed System Applications Read More »

Efficient Data Transmission: Easily Connect Kafka Real-time Data to CnosDB

In this article, we will mainly introduce how to implement a Kafka+Telegraf+CnosDB synchronous real-time acquisition and storage solution of streaming data in the Ubuntu 22.04.2 LTS environment. In this operation, the CnosDB version is 2.3.0, the Kafka version is 2.5.1, and the Telegraf version is 1.27.1 Efficient data transmission: Easily connect Kafka real-time data to CnosDB …

Efficient Data Transmission: Easily Connect Kafka Real-time Data to CnosDB Read More »