Scalegrid

MAY 12, 2025

Database normalization is the process of structuring data in a relational database to eliminate redundancy and enforce data consistency. This article explains how normalization works, its importance , and where it fits into database design. What Is the Role of Design in Database Structure? Normalization follows modeling.

Database 130

Database Storage Scalability Efficiency 130

Scalegrid

MAY 22, 2025

Database performance issues, such as slow queries and high CPU usage, can severely impact your applications. Implementing appropriate indexes is a critical strategy for optimizing database performance, as it helps identify frequently used columns in search conditions and enhances query efficiency.

Database 130

Database Performance Hardware Traffic 130

Percona

JUNE 25, 2025

Percona Everest is a free and open source tool for running and managing databases like PostgreSQL, MySQL, and MongoDB inside Kubernetes. It simplifies things by providing three ways to work with your databases: a web interface (UI), a set of commands (API), and direct access through Kubernetes itself using built-in tools like kubectl. >

Database 105

Database Open Source Cloud Software 105

DZone

AUGUST 28, 2024

Teams often consider external caches when the existing database cannot meet the required service-level agreement (SLA). This is a clear performance-oriented decision. However, external caches are not as simple as they are often made out to be.

Cache 278

Cache Database Latency Traffic 278

DZone

APRIL 15, 2025

Each SQL Server database contains a transaction log file (.ldf) This log file is an important part of the database, and SQL Server uses it to restore the database to a consistent state in case of system failure. While attaching the SQL database, you also require the transaction log file, along with the MDF file.

Database 130

Database Servers Systems 130

Dynatrace

FEBRUARY 1, 2024

Maintaining optimal application performance is crucial for businesses, and fast databases are vital in achieving this goal. For an effective approach to database performance, it’s crucial to have a comprehensive overview of all databases, including server-side DBs.

Database 246

Database Monitoring Games Metrics 246

DZone

OCTOBER 2, 2024

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

Database Systems Scalability Traffic 279

Dynatrace

SEPTEMBER 5, 2023

Running Databases efficiently is crucial for business success Monitoring databases is essential in large IT environments to prevent potential issues from becoming major problems that result in data loss or downtime. However, horizontal scaling of these databases can take time and effort.

Database 246

Database Metrics Monitoring Servers 246

DZone

NOVEMBER 15, 2023

These are measurements of search speed by key and data types for the key on the database side. I will use a PostgreSQL database and a demo Java service to compare query speeds. In this article, I want to share my knowledge and opinion about the data types that are often used as an identifier. Today we will touch on two topics at once.

Database 298

Database Java Performance Speed 298

DZone

DECEMBER 26, 2024

Migrating from Amazon RDS to DynamoDB can be a significant challenge, especially when transitioning from a relational database like RDS (PostgreSQL, MySQL, etc.) This allows you to keep both databases in sync during the transition, minimizing downtime and reducing the risk of data inconsistency. to DynamoDB, a NoSQL, key-value store.

Strategy 278

Strategy Scalability Best Practices Database 278

Dynatrace

SEPTEMBER 8, 2023

In part 2, we’ll show you how to retrieve business data from a database, analyze that data using dashboards and ad hoc queries, and then use a Davis analyzer to predict metric behavior and detect behavioral anomalies. Similar to the tutorial extension, we created an extension that performs queries against databases.

Database 290

Database Artificial Intelligence Metrics Monitoring 290

DZone

NOVEMBER 25, 2023

We often dwell on the technical aspects of database selection, focusing on performance metrics , storage capacity, and querying capabilities. Yet, the impact of choosing the right NoSQL database goes beyond these parameters; it affects your business outcomes.

Database 278

Database Latency Speed Metrics 278

DZone

SEPTEMBER 16, 2024

As applications grow in complexity and user base, the demands on their underlying databases increase significantly. Efficient database scaling becomes crucial to maintain performance, ensure reliability, and manage large volumes of data. This cheatsheet provides an overview of essential techniques for database scaling.

Strategy 263

Strategy Database Scalability Performance 263

DZone

SEPTEMBER 28, 2023

Previously, our application was using one database; developers knew how it worked, and the deployment rarely happened. A single database administrator was capable of maintaining the database, optimizing the queries, and making sure things worked as expected. Cloud and microservices changed the world.

Database 288

Database Software Engineering Software Software 288

DZone

JULY 10, 2023

In today's fast-paced digital landscape, performance optimization plays a pivotal role in ensuring the success of applications that rely on the integration of APIs and databases. Efficient and responsive API and database integration is vital for achieving high-performing applications.

Database 250

Database Strategy Performance Scalability 250

Percona

OCTOBER 28, 2024

Inspired by this comment in the Hacker News discussion, I posted polls on my LinkedIn network about the tendency (or perception of tendency) to abandon features without deprecating them in some of the most popular open source databases – MySQL, MariaDB, and PostgreSQL.

Open Source 125

Open Source Database Network 125

DZone

FEBRUARY 27, 2024

Understanding the structures within a Relational Database Management System (RDBMS) is critical to optimizing performance and managing data effectively. Partition Partitioning in an RDBMS is a technique to divide a large database table into smaller, more manageable pieces, called partitions, without changing the application's SQL queries.

Database 264

Database Tuning Systems Performance 264

DZone

JANUARY 10, 2025

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

Servers Performance Database Efficiency 278

DZone

DECEMBER 1, 2023

In the era of the Internet of Things ( IoT) , the continuous influx of spatial and temporal data from interconnected devices has given rise to a vast and intricate landscape, demanding a sophisticated approach to database management.

IoT 290

IoT Database Internet Internet 290

Percona

JULY 3, 2025

Welcome to this first installment of the blog series, which explores how PostgreSQL and MySQL deal with different aspects of relational databases.

Database 89

Database Open Source Technology Technology 89

Dynatrace

AUGUST 10, 2023

There are also many cases where business data—transactional, inventory, or financial—is at rest or in use , stored in a database. Dynatrace extensions can easily query data from various databases and store the results in Grail™, the Dynatrace data lakehouse. This can be accomplished using Dynatrace extensions.

Database 246

Database Metrics Retail Analytics 246

The Netflix TechBlog

JULY 10, 2025

Initial Tudum data architecture The high-level diagram above focuses on storage & distribution, illustrating how we leveraged Kafka to separate the write and read databases. The write database would store internal page content and metadata from our CMS.

Architecture 177

Architecture Cache Latency Database 177

DZone

JANUARY 2, 2025

When we are working with a database, optimization is crucial and key in terms of application performance and efficiency. Selection of Right Partition Key Choosing an appropriate partition key is vital for distributed databases like Cosmos DB.

Best Practices 245

Best Practices Azure Performance Efficiency 245

Dynatrace

FEBRUARY 27, 2025

Top takeaways: Key OpenTelemetry trends in 2025 Semantic Conventions ensure alignment: Semantic Conventions provide consistent telemetry data interpretation, correlation, and automation, with HTTP spans now stable and other domains like databases and messaging nearing stabilization. OpenTelemetry Collector 1.0

Tuning 310

Tuning Open Source Innovation Monitoring 310

DZone

AUGUST 1, 2024

Editor's Note: The following is an article written for and published in DZone's 2024 Trend Report, Database Systems: Modernization for Data-Driven Architectures. Time series data has become an essential part of data collection in various fields due to its ability to capture trends, patterns, and anomalies.

Database 260

Database Analytics Software Software 260

DZone

DECEMBER 13, 2024

Some databases prioritize organizing data based on its time of generation, while others focus on different functionalities. However, unless it is processed and stored effectively, it holds little value. A significant evolution is taking place in the way data is organized for further analysis.

Social Media 235

Social Media Database Media Processing 235

DZone

OCTOBER 21, 2024

PostgreSQL has grown remarkably over the years, and with each major release, it has become a more robust, reliable, and responsive database for both mission-critical and non-mission-critical enterprise applications.

Performance 281

Performance Open Source Google Database 281

DZone

OCTOBER 30, 2024

Log-Structured Merge Trees (LSM trees) are a powerful data structure widely used in modern databases to efficiently handle write-heavy workloads. They offer significant performance benefits through batching writes and optimizing reads with sorted data structures.

Strategy 244

Strategy Storage Efficiency Database 244

DZone

NOVEMBER 1, 2024

When deployed on bare-metal clusters or cloud VMs, database administrators are responsible for adding and removing nodes in a clustered system, planning the changes at times of low load to minimize disruption to production workloads.

Monitoring 263

Monitoring Scalability Database Cloud 263

Uber Engineering

JUNE 4, 2025

Database backups are critical for business continuity. Learn how Uber scaled stateful fleet backup and recovery across 10K database applications.

Database 67

Database 67

Scalegrid

OCTOBER 18, 2024

Due to its versatility for storing information in both structured and unstructured formats, PostgreSQL is the fourth most used standard in modern database management systems (DBMS) worldwide 1. To conclude, GUIs are a vital addition to ease the lives of database users and developers.

Open Source 147

Open Source Database Cloud Operating System 147

Scalegrid

MARCH 10, 2025

A graphical user interface (GUI) helps simplify how you interact with your MySQL databases. Whether youre a developer, database administrator, or data analyst, a good GUI can make everyday tasks faster, clearer, and less error-prone. Thats where MySQL GUIs come in. Lets dive into the top picks.

Open Source 162

Open Source Database Design Cloud 162

DZone

FEBRUARY 4, 2025

Understanding Teradata Data Distribution and Performance Optimization Teradata performance optimization and database tuning are crucial for modern enterprise data warehouses.

Performance 173

Performance Tuning Analytics Strategy 173

Scalegrid

APRIL 28, 2025

Monitoring MySQL databases is essential for maintaining performance, detecting issues early, and ensuring efficient resource use by tracking critical metrics. With MySQL supporting various applications, its important to have the right tools in place to monitor database health and performance.

Monitoring 147

Monitoring Open Source Analytics Metrics 147

The Polyglot Developer

MAY 10, 2025

This is particularly more of a problem with Docker volumes that contain SQLite databases with write-ahead log (WAL) or databases in general. The post Easy Automated Docker Volume Backups That Are Database Friendly appeared first on The Polyglot Developer. There’s good news though!

Database 59

Database Servers Systems Development 59

Dynatrace

FEBRUARY 4, 2025

Davis CoPilot explains problems in clear language Optimize database performance: Understand query execution plans Query execution plans provide detailed information on how a database will execute an SQL query.

Database 130

Database Efficiency Availability Speed 130

Dynatrace

MAY 21, 2025

Also, their legacy monitoring system ingested monitoring events into a SQL database , from which our customer had to tail/parse the recent log records. With OneAgent observing their SQL server, they have entered the next level of database observability. Creating correlation and context between these wasnt easy.

Retail 184

Retail Airlines Healthcare Transportation 184