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

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

NOVEMBER 5, 2024

In today’s world where data drives everything, managing large-scale databases and their security is both a necessity and a challenge. A few factors that organizations consider when choosing databases are primary are its cost, flexibility, and support from hosting providers. An open-source database is your best bet for many reasons.

Open Source 243

Open Source Database Strategy Performance 243

Dynatrace

APRIL 21, 2022

While applications are built using a variety of technologies and frameworks, there is one thing they usually have in common: the data they work with must be stored in databases. Now, Dynatrace has gone a step further and expanded its coverage and intelligent observability into the next layer: database infrastructure.

Database 245

Database DevOps Analytics Servers 245

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 279

Database Artificial Intelligence Metrics Monitoring 279

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

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 261

Strategy Database Scalability Performance 261

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 196

Database Monitoring Games Metrics 196

DZone

APRIL 15, 2022

Recently, I faced an issue related to a very high load on the database layer. The database was having too many connections in parallel. I had to review my application’s database connection pool (DBCP) properties very closely.

Database 245

Database Code Big Data Performance 245

DZone

JUNE 28, 2023

Database sharding is a powerful technique employed to manage large databases more effectively. It involves partitioning a large database into smaller, more manageable parts, known as shards. The above diagram presents a visual representation of a sharded database.

Database 232

Database Scalability Servers Performance 232

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

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 214

Database Metrics Monitoring Servers 214

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

Dynatrace

NOVEMBER 4, 2024

Monitoring the health and performance of your databases is essential to ensuring optimal application functionality. While infrastructure-level monitoring provides valuable insights, it might not reveal the root causes of database-related slowdowns. Top Queries and Execution Plans are available in the Databases app.

Database 194

Database Performance Metrics Monitoring 194

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 236

Database Metrics Retail Analytics 236

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 200

Social Media Database Media Processing 200

DZone

APRIL 19, 2023

In this article, I will explain how we can move the system databases to different locations in Ubuntu Linux. Still, it does not support MMC consoles in Linux which makes the administration of the SQL Server a little bit complicated.

Servers 246

Servers Database Systems Operating System 246

DZone

JUNE 28, 2023

When database problems arise, they can disrupt even the most well-crafted applications. That's why knowing how to debug mobile app database problems and optimize data storage performance is essential for developers seeking excellence. These are signs of database challenges. These are signs of database challenges.

Storage 203

Storage Mobile Database Performance 203

DZone

FEBRUARY 9, 2024

Always-on availability group support failover the environment for a discrete set of user databases, known as availability databases, that failover together. They also support a set of read-write primary databases and several sets of corresponding secondary databases.

Availability 288

Availability Database Servers 288

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Of the organizations in the Kubernetes survey, 71% run databases and caches in Kubernetes, representing a +48% year-over-year increase. Java, Go, and Node.js

Open Source 351

Open Source Java Operating System Programming 351

DZone

JANUARY 2, 2024

Sharding, a database architecture pattern, involves partitioning a database into smaller, faster, more manageable parts called shards. Each shard is a distinct database, and collectively, these shards make up the entire database. What Is Sharding?

Architecture 270

Architecture Database Scalability Servers 270

DZone

JUNE 13, 2024

Relational Databases are the bedrock of any FinTech application, especially for OLTP (Online transaction Processing). So, it is imperative that all database activities are monitored closely in the production environment and issues like long-running queries are tracked and resolved.

FinTech 262

FinTech Tuning AWS Database 262

DZone

OCTOBER 8, 2024

PostgreSQL is one of the most popular SQL databases. It’s a go-to database for many projects dealing with Online Transaction Processing systems. How It All Started Historically, we focused on two distinct database workflows: Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP).

Analytics 263

Analytics Database Processing Systems 263

DZone

SEPTEMBER 16, 2024

Among numerous database management systems, ClickHouse stands out for its originality and, one could say, a specific niche, which, in my opinion, complicates its expansion in the database market. In data analysis, the need for fast query execution and data retrieval is paramount.

Speed 262

Speed Database Systems 262

DZone

FEBRUARY 15, 2023

Nowadays, many people migrate their applications from traditional, single-server relational databases to distributed database clusters. In this article, I’m going to demonstrate how you can migrate a comprehensive web application from MySQL to YugabyteDB using the open-source data migration engine YugabyteDB Voyager.

Open Source 298

Open Source Scalability Database Servers 298

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. Load and 2.

Benchmarking 308

Benchmarking Latency C++ Database 308

DZone

OCTOBER 23, 2023

NoSQL databases emerge as ideal candidates to meet these requirements, and cloud platforms such as AWS offer managed and highly resilient data ecosystems. In this article, I am not going to determine which AWS NoSQL database is better: the concept of a better database only exists within a specific purposeful context.

AWS 275

AWS Performance Database Architecture 275

DZone

SEPTEMBER 17, 2024

Memory usage is one of the most important aspects of the database system. In this blog post, we are going to understand how databases (and PostgreSQL specifically) manage memory and how to troubleshoot low free-memory scenarios. How Databases Read Data To understand how to deal with memory, we need to understand how things work.

Operating System 245

Operating System Database Metrics Systems 245

Scalegrid

DECEMBER 16, 2020

Mysqldump is a client utility that is used to perform logical backups of the MySQL database. This popular migration tool is useful for various use cases of MySQL such as: Backup and restore of databases. Migrating data from one server to another. Migrating data across different managed MySQL service providers.

Best Practices 290

Best Practices Database Servers Performance 290

Scalegrid

SEPTEMBER 5, 2024

Managing High Availability (HA) in your PostgreSQL hosting is very important to ensuring your database deployment clusters maintain exceptional uptime and strong operational performance so your data is always available to your application. Standby servers are activated when the primary server fails.

Availability 257

Availability Servers Database Open Source 257

DZone

JULY 19, 2021

However, these deployments add significant complexity to database operations and data consistency suffers. CockroachDB was built to address these challenges and we’ve recently simplified a multi-region deployment of a consistent database down to a few simple, declarative SQL statements applied as DML.

Latency 246

Latency Database Performance Availability 246

Dynatrace

AUGUST 27, 2024

The vulnerability, identified as CVE-2024-6632, allows the abuse of a form submission during the setup process to make unauthorized modifications of the database. The submitted data is used in a database statement, but the user input is not going through proper input validation. As a result, the attacker can modify the query.

Database 247

Database Analytics Processing Servers 247

The Netflix TechBlog

APRIL 27, 2023

Ruchir Jha , Brian Harrington , Yingwu Zhao TL;DR Streaming alert evaluation scales much better than the traditional approach of polling time-series databases. It allows us to overcome high dimensionality/cardinality limitations of the time-series database. It opens doors to support more exciting use-cases.

Storage 300

Storage Cache Metrics Database 300

Scalegrid

JANUARY 15, 2021

Data protection rules, such as the new GDPR regulations, are becoming increasingly stringent to protect user data, so it’s important that your database audits are set up properly […].

Infrastructure 319

Infrastructure Database Technology Technology 319

DZone

MARCH 22, 2024

This is beyond databases that just store information. Knowledge graphs are a giant web of information where elements and ideas are linked to show how they are related in the real world. Knowledge graphs also store the connections between information. This makes knowledge graphs very useful in various fields. Here are a few examples:

Database 290

Database 290

DZone

OCTOBER 16, 2023

Choosing the right data types in PostgreSQL can significantly impact your database's performance and efficiency. Whether you're designing tables for a new project or optimizing an existing database, these insights will help you make informed decisions.

Best Practices 284

Best Practices Speed Database Efficiency 284