Using LLM to automatically generate documentation for a database
june 21, 2025 Using LLM to automatically generate documentation for a database High-quality database documentation is an essential part of a successful project. It offers a number of key benefits: Simplifies and speeds up onboarding for new developers. Facilitates faster development and reduces the risk of errors. Minimises risks related to team turnover. Increases transparency […]
Apache Superset — Frequently Asked Questions (FAQs)
may 27, 2025 Apache Superset: Frequently Asked Questions (FAQs) Frequently Asked Questions Is it possible to join/query multiple tables at once? Not in the Explore or visualisation UI. A Superset SQLAlchemy datasource can only be a single table or view. When working with multiple tables, a common solution is to materialise a table that contains […]
Big Data is no longer an experiment: businesses are expecting quick results
may 12, 2025 Big Data is no longer an experiment: businesses are expecting quick results How popular were Big Data projects last year? Demand for big data solutions continues to grow at an average rate of 30% per year. In 2024, the number of Big Data and BI projects remained consistently high. The majority of requests […]
Analytical DBMS: Greenplum or ClickHouse?
may 14, 2025 Analytical DBMS: Greenplum or ClickHouse? Among the most popular analytical DBMS solutions on today’s market, two open-source projects stand out as particularly interesting: Greenplum and ClickHouse. Both of these DBMSs handle a wide range of data analytics use cases very well, and when used together in a single stack, they can provide […]
How to connect to ClickHouse from Apache Superset
april 14, 2025 How to connect to ClickHouse from Apache Superset Connecting to ClickHouse from Apache Superset 3.1.1 In order to install the ClickHouse driver for Apache Superset when deploying via DOCKER COMPOSE, you simply need to add a requirements-local.txt file to the docker directory (this file is not present by default): Inside the requirements-local.txt […]
Comparison of multidimensional and tabular models in SSAS
march 27, 2025 Comparison of multidimensional and tabular models in SSAS Introduction Since the emergence of the tabular model, the question has arisen: which technology is better suited for project development? Should one switch to the tabular model or stay with the tried and tested multidimensional model? In our practice, we have worked with and […]
Installing Arenadata components on a cluster of nodes running Ubuntu 22.04
february 13, 2025 Installing Arenadata components on a cluster of nodes running Ubuntu 22.04 Our first experience Our first experience with Arenadata was very positive. The installation of the components went smoothly without significant issues, thanks to well-documented processes and the user-friendly ADCM interface. Despite initial concerns about setting up host providers, SSH connections worked […]
Comparative analysis of approaches to DWH modelling: Dimensional Modeling (Snowflake), Data Vault 2.0, Anchor Modeling
december 13, 2024 Comparative analysis of approaches to DWH modelling: Dimensional Modeling (Snowflake), Data Vault 2.0, Anchor Modeling Data Warehouses (DWH) play a key role in supporting analytical and business decisions by providing structured data for reporting and analysis. Proper data modelling is crucial for the successful functioning of a DWH. In this article, we […]
Comparison of Anchor Modeling and Dimensional Modeling
november 27, 2024 Comparison of Anchor Modeling and Dimensional Modeling Choosing the right data modeling methodology for a data warehouse at the design stage is crucial. It ensures the necessary level of flexibility and scalability while aligning with business objectives. In this article, we will review the strengths and weaknesses of two popular methodologies—Anchor Modeling […]
Partitioning in SQL Server
november 13, 2024 Partitioning in SQL Server Partitioning of data is the process of dividing large volumes of data into smaller, more manageable parts known as partitions. It is an essential tool for optimising database performance, especially in high-volume and high-load environments. Data partitioning allows large tables to be split into smaller, independent parts that […]