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 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

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

Scalegrid

MAY 13, 2020

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

Big Data Database Artificial Intelligence Open Source 321

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 223

Database Scalability Servers Performance 223

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

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 247

Database Strategy Performance Scalability 247

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 287

Database Software Engineering Software Software 287

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

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 101

Open Source Database Network 101

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

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

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 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

Scalegrid

MARCH 4, 2019

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. SQL Databases.

Database 255

Database Metrics Systems Strategy 255

Scalegrid

DECEMBER 6, 2023

The choice of self-managed cloud databases vs DBaaS is a common debate among those who are looking for the best option that will cater to their particular needs. Database as a Service (DBaaS) and managed databases offer distinct advantages along with certain challenges.

Database 130

Database Cloud Hardware Storage 130

High Scalability

MARCH 6, 2019

Wondering which databases are trending in 2019 ? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. SQL vs. NoSQL.

Database 278

Database Metrics Engineering Software 278

Scalegrid

APRIL 28, 2020

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on their database hosting. MongoDB® Database. EC2 instances.

Azure 344

Azure AWS Database Latency 344

Scalegrid

AUGUST 26, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. We measure latency in ms 95th percentile latency.

Azure 299

Azure Benchmarking Database Latency 299

InfoQ

NOVEMBER 6, 2024

Pinterest has modernized and enhanced its Goku time-series database. The recent updates focus on optimizing storage and resource usage without compromising service quality. By Mohit Palriwal

Database 90

Database Efficiency Storage Scalability 90

DZone

JUNE 11, 2020

It's challenging to troubleshoot issues in a distributed database because the information about the system is scattered in different machines. TiDB is an open-source, distributed SQL database that supports Hybrid Transactional/Analytical Processing (HTAP) workloads. Before version 4.0, Before version 4.0,

Database 246

Database Open Source Analytics Architecture 246

Percona

NOVEMBER 13, 2023

To maintain competitiveness and operational efficiency — not to mention ensure security and compliance when your database version reaches End of Life (EOL) – it’s crucial to upgrade your database systems from time to time. One of the most compelling reasons to choose a professional service is the reduced risk.

Database 99

Database Open Source Best Practices Strategy 99

High Scalability

MAY 11, 2020

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on their database hosting. Comparing Cloud Instance Costs.

Azure 290

Azure AWS Database Cloud 290

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

Percona

MAY 9, 2024

Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […] Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records?

Best Practices 123

Best Practices Database Systems 123

Scalegrid

MARCH 30, 2021

March 30, 2021 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced support for Oracle Cloud Infrastructure (OCI) through their fully managed database hosting plans. PALO ALTO, Calif., Oracle […].

Database 243

Database Cloud Azure AWS 243

Percona

MARCH 25, 2024

Anyone working with databases knows that data is the driving force behind every online activity, and data security is always a top concern.

Best Practices 108

Best Practices Database 108

Scalegrid

OCTOBER 14, 2020

October 14, 2020 – ScaleGrid, a leading Database-as-a-Service (DBaaS) provider, has just announced the launch of Google Cloud Platform (GCP) hosting through their fully managed DBaaS plans. Google Cloud Platform is the second most popular cloud provider for open source database hosting according to the 2019 Open Source Database Report.

Google 246

Google Database Cloud Open Source 246

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

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 130

Database Metrics Retail Analytics 130

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly. Avoid false positives with auto-adaptive baselining.

Infrastructure 214

Infrastructure Database Monitoring Metrics 214

Scalegrid

JUNE 4, 2020

ScaleGrid is a fully managed DBaaS that supports MySQL, PostgreSQL and Redis™, along with additional support for MongoDB® database and Greenplum® database. Along with many popular cloud providers, DigitalOcean also provides a Managed Databases service. So, which database service is right for your application? Single Node.

Database 230

Database Latency Benchmarking Performance 230

DZone

SEPTEMBER 25, 2023

The error is like this one: Msg 26019, Level 16, State 1, Line 1 BACKUP detected corruption in the database log. This error usually happens when you are doing a backup of the transaction log. Check the errorlog for more information. BACKUP LOG is terminating abnormally.

Database 147

Database Servers 147

Scalegrid

JUNE 22, 2020

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. MySQL on DigitalOcean is a natural fit, but what’s the best way to deploy your cloud database? In this benchmark, we compare equivalent plan sizes between ScaleGrid MySQL on DigitalOcean and DigitalOcean Managed Databases for MySQL.

Database 217

Database Benchmarking Latency Performance 217

High Scalability

JUNE 27, 2019

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy?

Open Source 196

Open Source Database Cloud Strategy 196

Uber Engineering

OCTOBER 29, 2024

Learn about how the Storage team at Uber significantly reduced costs and improved speed for backups of its Petabyte-scale, MyRocks-based distributed databases by devising a Differential Backups solution.

Database 73

Database Storage Speed 73

Percona

APRIL 26, 2024

Cloud-native databases are becoming the norm, and containerized databases are a common trend (see the report from Dynatrace and Figure 1). Kubernetes—the de facto standard for platform engineers—and operators simplify database deployment and management.

Database 89

Database Performance Cloud Servers 89