Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

metricfire

Using ClickHouse with MetricFire

In the analytics domain, fast and reliable storage is an important aspect for businesses to handle a large amount of data. There are different types of data storage including RDBMS, NoSQL, data lake, data warehouse, and graph database. Among these, the most widely used is RDBMS that powers various systems and applications of companies of all sizes. RDBMS is easy to use and straightforward to understand thanks to its table-based (or column-based) data format.

icinga

Less is more ... or more is more? Decide for yourself with Icinga DB Web list view modes

With Icinga DB Web you can now customise Icinga Web’s list views to your needs. While in one scenario you might be more interested to see as many objects as possible at a glance, in another scenario detail attributes of only a few objects will be more important to you. Yet, in the first case, you would even be distracted by more detailed information.

scout

Understanding N+1 Database Queries

N+1 queries are the most common problems among developers. N+1 database query problems occur when you have to call the database for N items, and those N items have again N additional data fields which are not in the same table, and those extra N data fields are required for the use case. Generally, this issue is handled at the time of database designing, but every problem cannot be solved efficiently by one solution, some need to be solved by brute force.

cloudzero

The Ultimate RDS Instance Types Guide: What You Need To Know

Amazon’s Relational Database Service (Amazon RDS) offers a variety of database instances, which can be confusing at first. In this guide, we'll clarify what each RDS instance class, family, type, and size means in under 15 minutes. Let's start at the beginning.

metricfire

Redis: Open Source vs. Enterprise

Are you curious about the difference between open-source Redis and Redis enterprise? Of course, Redis Enterprise is a hosted service that runs Redis db on behalf of its customers, while open-source Redis is available for anyone to use. However, there's also a key difference between open source and enterprise in how the clusters are implemented. In order to understand the difference, we need to know what Redis Clusters are. ‍

influxdata

InfluxDB is 5x Faster vs. MongoDB for Time Series Workloads

At InfluxData, one of the common questions we regularly get asked by developers and architects alike the last few months is, “How does InfluxDB compare to MongoDB for time series workloads?” This question might be prompted for a few reasons. First, if they’re starting a brand new project and doing the due diligence of evaluating a few solutions head-to-head, it can be helpful in creating their comparison grid.

influxdata

Scaling Throughput and Performance in a Sharding Database System

Understand the two dimensions of scaling for database query and ingest workloads, and how sharding can make scaling elastic — or not. Scaling throughput and performance are critical design topics for all distributed databases, and sharding is usually a part of the solution. However, a design that increases throughput does not always help with performance and vice versa. Even when a design supports both, scaling them up and down at the same time is not always easy.

redgate

Where Financial Services businesses should focus their digital transformation efforts in 2023

Like every business sector, Financial Services has been on a rollercoaster ride over the past couple of years. The pandemic forced a change in the way businesses work, and the way products and services are delivered to customers. Deloitte summed it up beautifully in the introduction to its ‘Finance 2025 Revisited report’1: “COVID-19 has sped up business innovation and stress-tested the concept of 100% remote work.”