In previous article we talked about migrating from OLTP databases to the ClickHouse database. This migration technology tool will soon be available in the ChistaDATA DBaaS and you can enjoy the advantages of ClickHouse database with only a single click. Today we’ll start by showing you how to migrate from an Oracle database to Kafka, […]
ClickHouse is a powerful open source relational database management system that offers high performance, scalability, reliability and data security. As ClickHouse is widely used in various industries, it is important to ensure that it is performing optimally and meeting the needs of the business. To achieve this, ChistaDATA offers an Ultra-Low-Level Performance Audit service for […]
Each new release includes new features, improvements, and numerous bug fixes, and the ChistaDATA team is always on top of the latest releases. On 26th April 2023, ClickHouse version 22.4 (April 2023) was released, and this version contains 15 new features, 11 performance optimizations, and 36 bug fixes. For further details, please see the official […]
Top-n queries extract the top or bottom n rows from a result set. In other words, they identify the best or worst examples, such as the top 10 place in a particular area, the 5 worst performing retailers, etc. The most common use of this type of query is in business intelligence, where it’s important […]
As we mentioned earlier part, migrating data from OLTP to OLAP is possible. This tutorial shows you how to set up a Postgres Docker image for usage with Debezium to gather change data (CDC). Then, a Kafka topic is written containing the captured bulk data and modifications. Eventually, we’ll migrate all the data to the […]
A quick calculation of analytical business data using metrics for modeling, planning, or forecasting is possible with OLAP only. Also a lot of business applications for reporting, simulation models, information-to-knowledge transfers, and trend and performance management are supported by OLAP which is also the cornerstone of analytics. Regarding OLAP requirements, migration to a ClickHouse database […]
Among DBAs, there is much debate regarding the significance of database performance tuning. As we now understand, various data types really power the business world. It should be operating very effectively and always be accessible to ensure that the data is quickly and easily accessible for all beneficiaries. ClickHouse supports advanced compression to improve speed […]
Among DBAs, there is much debate regarding the significance of database performance tuning. As we now understand, various types of data are what really power the business world. It should be operating very effectively and always be accessible to ensure that the data is quickly and easily accessible for all beneficiaries. Getting a regular database […]
Among DBAs, there is much debate regarding the significance of database performance tuning. As we now understand, various types of data are what really power the business world. It should be operating very effectively and always be accessible to ensure that the data is quickly and easily accessible for all beneficiaries. Pexels Getting a regular […]
Every new release includes new features, enhancements, and numerous bug fixes, and the ChistaDATA team always stays on top of the latest releases. On October 25, 2022, ClickHouse version 22.10 (October 2022) was released, and this version contains 12 new features, 11 performance optimizations, and 40 bug fixes. For further details, please see the official […]