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

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

Dynatrace

AUGUST 10, 2023

Dynatrace business events address these systemic problems, delivering real-time business observability to business and IT teams with the precision and context required to support data-driven decisions and improve business outcomes. Data is not delivered in real time; it’s often delayed by weeks or longer.

Database 235

Database Metrics Retail Analytics 235

The Netflix TechBlog

FEBRUARY 18, 2022

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

Systems Traffic Architecture Mobile 334

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

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. This guide delves into how these systems work, the challenges they solve, and their essential role in businesses and technology.

Storage 130

Storage Systems Big Data Azure 130

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

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,

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 96

Database Open Source Best Practices Strategy 96

Percona

MAY 9, 2024

Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […] These breaches can be devastating, causing significant financial losses, reputational damage, and even legal repercussions.

Best Practices 120

Best Practices Database Systems 120

Dynatrace

AUGUST 10, 2023

Dynatrace business events address these systemic problems, delivering real-time business observability to business and IT teams with the precision and context required to support data-driven decisions and improve business outcomes. Data is not delivered in real time; it’s often delayed by weeks or longer.

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.

Infrastructure 211

Infrastructure Database Monitoring Metrics 211

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. More in the following sub-section.)

Availability 110

Availability Database Open Source Hardware 110

The Netflix TechBlog

SEPTEMBER 29, 2022

Timestone: Netflix’s High-Throughput, Low-Latency Priority Queueing System with Built-in Support for Non-Parallelizable Workloads by Kostas Christidis Introduction Timestone is a high-throughput, low-latency priority queueing system we built in-house to support the needs of Cosmos , our media encoding platform. Over the past 2.5

Latency 218

Latency Systems Media Serverless 218

Percona

MAY 6, 2024

MongoDB offers powerful features and scalability, but like any database system, it has security challenges that must be addressed to protect sensitive data as well as comply with regulatory standards like GDPR, HIPAA, PCI DSS, and AM/ATF.

Best Practices 90

Best Practices Database Scalability Systems 90

Percona

JUNE 25, 2024

PostgreSQL is a powerful and versatile relational database management system that provides many features for managing and manipulating databases. One such feature is the is_template flag, which can be used to create and manage template databases.

Database 74

Database Systems 74

Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. Database migration is almost always time-consuming, tedious, and full of potential pitfalls. Database migration is complex Let’s start here. What’s your documentation plan?

Database 86

Database Open Source Benchmarking Strategy 86

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 95

Open Source Database Hardware Strategy 95

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 118

Database Open Source Traffic Small Business 118

Percona

OCTOBER 20, 2023

Heck, typing “database migration plan” into Google and reading this blog could constitute planning. In brief, a proper database migration plan includes: Establishing clear objectives: Define what you want to achieve and how open source will get there. Some level of planning is expected when migrating to open source.

Open Source 91

Open Source Database Best Practices Strategy 91

Percona

JANUARY 30, 2023

As Ibrar Ahmed noted in his blog post on Transparent Database Encryption (TDE). PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption. If database files are copied or otherwise exposed in their raw form, exposure does not happen. Does PostgreSQL Need TDE (Transparent Data Encryption)?

Database 127

Database Storage Government Open Source 127

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 240

Operating System Database Metrics Systems 240

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

Percona

DECEMBER 14, 2023

I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. significantly enhanced downgrade compatibility by introducing changes that make it easier for downgraded databases to interoperate with older MongoDB versions.

Database 90

Database Artificial Intelligence Servers Operating System 90

Percona

APRIL 3, 2024

A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source and access data without physically moving the data on a working local database.PostgreSQL implements portions of the SQL/MED specification, allowing access to data that resides outside PostgreSQL using regular SQL queries.

Database 83

Database Systems 83

Percona

MAY 2, 2023

The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other third-party team troubleshoot database-related issues. Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns.

Database 95

Database Systems Open Source Engineering 95

Particular Software

MAY 22, 2023

Is this the best way to build a system, though? For example, you might need the data to be denormalized for performance, or the warehouse data might exist on a physically different system that can’t participate in a database join. For example, one service could be powered by a traditional relational database.

Systems 98

Systems Cache Strategy Database 98

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

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 126

Database Servers Testing Programming 126

Percona

FEBRUARY 9, 2023

Now it is time to get your databases ready for the rest of the year. Second, peruse the accounts on your system to trim away those staff who are no longer with your organization. Check the versions of database connectors, programming languages, and proceed all the way down to the operating system. Welcome to 2023!

Database 93

Database Open Source Hardware Operating System 93

Dotcom-Montior

NOVEMBER 24, 2021

Web developers or administrators did not have to worry or even consider the complexity of distributed systems of today. Do you have a database? Great, your system was ready to be deployed. Once the system was deployed, to ensure everything was running smoothly, it only took a couple of simple checks to verify.

Systems 74

Systems Monitoring Hardware Network 74

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 78

Open Source Database Storage Scalability 78

High Scalability

APRIL 3, 2019

PostgreSQL is an open source object-relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 177

Database Cloud Open Source Systems 177

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 107

Database Benchmarking Latency C++ 107

DZone

JUNE 7, 2019

It's easy for modern, distributed, high-scale applications to hide database performance and efficiency problems. Optimizing performance of such complex systems at scale requires some skill, but more importantly it requires a sound strategy and good observability, because you can't optimize what you can't measure.

Efficiency 124

Efficiency Database Performance Strategy 124