article thumbnail

Optimizing Database Performance in Middleware Applications

DZone

In the realm of modern software architecture, middleware plays a pivotal role in connecting various components of distributed systems. One of the most significant challenges faced by middleware applications is optimizing database interactions.

Database 222
article thumbnail

A Comprehensive Guide to Database Sharding: Building Scalable Systems

DZone

In this article, we’ll dive deep into the concept of database sharding, a critical technique for scaling databases to handle large volumes of data and high levels of traffic. We’ll start by defining what sharding is and why it’s essential for modern, high-performance databases.

Database 279
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

What is Greenplum Database? Intro to the Big Data Database

Scalegrid

Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware. What is an MPP Database?

Big Data 321
article thumbnail

Catching up with OpenTelemetry in 2025

Dynatrace

In fact, observability is essential for shaping how we design smarter, more resilient systems for the future. As an open-source project, OpenTelemetry sets standards for telemetry data sets and works with a wide range of systems and platforms to collect and export telemetry data to backend systems. OpenTelemetry Collector 1.0

Tuning 310
article thumbnail

Optimizing SQL Server Performance With AI: Automating Query Optimization and Predictive Maintenance

DZone

SQL Server is a powerful relational database management system (RDBMS), but as datasets grow in size and complexity, optimizing their performance becomes critical. Leveraging AI can revolutionize query optimization and predictive maintenance, ensuring the database remains efficient, secure, and responsive.

Servers 278
article thumbnail

Rapid Event Notification System at Netflix

The Netflix TechBlog

To this end, we developed a Rapid Event Notification System (RENO) to support use cases that require server initiated communication with devices in a scalable and extensible manner. In this blog post, we will give an overview of the Rapid Event Notification System at Netflix and share some of the learnings we gained along the way.

Systems 334
article thumbnail

How to Move System Databases to Different Locations in SQL Server on Linux

DZone

Linux is a complex operating system, undoubtedly very secure but complex, especially for users who never had experience working on the Linux platform. In this article, I will explain how we can move the system databases to different locations in Ubuntu Linux. I am using root user.

Servers 246