Simform

JULY 24, 2022

The post Multi-region databases: The why, design principles, and what does AWS offer? By early afternoon that day, the bank had a backlog of roughly 400,000 unprocessed payments, and it had to request customers not to resend the payments since it could result in duplication. appeared first on Simform - Product Engineering Company.

AWS 52

AWS Design Database Engineering 52

All Things Distributed

MAY 19, 2017

In many, high-throughput, OLTP style applications the database plays a crucial role to achieve scale, reliability, high-performance and cost efficiency. For a long time, these requirements were almost exclusively served by commercial, proprietary databases.

Database 120

Database Design Cloud Storage 120

SQL Performance

JULY 8, 2021

I want to talk about UI design choices that lead to data access patterns that are awkward to implement using SQL Server. It’s also a good way to not overwhelm the database servers … usually. Consider this design: The data behind this example requires counting and processing the entire dataset in order to report the number of results.

Design 92

Design Software Architecture Database Servers 92

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 272

Best Practices Speed Database Efficiency 272

DZone

FEBRUARY 12, 2024

Optimizing complex MySQL queries is crucial when dealing with large datasets, such as fetching data from a database containing one million records or more. Poorly optimized queries can lead to slow response times and increased load on the database server, negatively impacting user experience and system performance.

Performance 161

Performance Database Strategy Efficiency 161

DZone

MARCH 24, 2021

If so, the database is updated. At irregular intervals (usually six times a year) team X produces a varying number of tab-separated files for team Y to process in a classic extract/transform/load (ETL) process, supplied in a zip file from an HTTPS address using Basic Authentication (i.e. with a username and password).

Design 193

Design Testing Software Performance Database 193

High Scalability

FEBRUARY 25, 2019

This structure works surprisingly well for many important workloads like database, search, and analytics. The admission window provides a small region for recency bursts to avoid consecutive misses when an item is building up its popularity.

Cache 200

Cache Design Analytics Google 200

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. HammerDB has always used stored procedures as a design decision because the original benchmark was implemented as close as possible to the example workload in the TPC-C specification that uses stored procedures. What is a stored procedure?

Benchmarking 62

Benchmarking Database Network C++ 62

DZone

NOVEMBER 2, 2023

In this blog, you’ll discover what a web app architecture is, how a web application architecture diagram looks, and how you can design the right architecture for web apps. Choosing the right design defines your company's growth, reliability, interoperability, and future IT needs.

Architecture 262

Architecture Mobile Website Servers 262

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

MARCH 29, 2024

Check out the following related resources to learn more: Dynatrace announces support of Google Cloud’s AlloyDB for PostgreSQL metrics ingest – Blog Dynatrace has achieved Google Cloud Ready – AlloyDB designation in support of an extended integration to Google Cloud’s AlloyDB for PostgreSQL.

Google 266

Google Innovation Cloud Analytics 266

DZone

NOVEMBER 16, 2023

The circuit breaker is a design pattern that prevents cascading failures and improves the overall availability and performance of a system. A circuit breaker is a component that monitors the health of a dependency, such as a remote service, an external API, or a database. What Is a Circuit Breaker?

Latency 258

Latency Network Database Monitoring 258

The Morning Paper

JUNE 16, 2019

Towards multiverse databases Marzoev et al., The central idea behind multiverse databases is to push the data access and privacy rules into the database itself. Such a design rules out an entire class of application errors, protecting private data from accidentally leaking. HotOS’19. Managing universes.

Database 90

Database Cache Benchmarking Efficiency 90

Percona

JANUARY 17, 2023

This blog is in continuation of my previous blog on the basic understanding of corruption with the subject line The Ultimate Guide to Database Corruption: Part 1 – An Overview. Every database object has a pre-defined format. This is because data cannot be scanned by a database product; however, this is not true with the format.

Database 117

Database Hardware Storage Programming 117

DZone

FEBRUARY 9, 2024

In the paradigm of zero trust architecture , Privileged Access Management (PAM) is emerging as a key component in a cybersecurity strategy, designed to control and monitor privileged access within an organization.

Strategy 183

Strategy Architecture Network Database 183

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Strategic Tech

JULY 21, 2020

Before jumping into either of those scenarios, have a look at what Strategic Domain-Driven Design can offer you. This means a software architecture should be purposely designed for the most favourable business consequences. It also means that understanding the business model is a pre-requisite for designing a software architecture.

Architecture 98

Architecture Design Software Architecture Strategy 98

Dynatrace

MARCH 29, 2023

Today, Dynatrace is announcing that it has successfully achieved Google Cloud Ready – AlloyDB designation in support of an extended integration to Google Cloud’s AlloyDB for PostgreSQL. AlloyDB is a fully managed, PostgreSQL-compatible database service for highly demanding enterprise database workloads.

Google 224

Google Metrics Cloud Analytics 224

DZone

JUNE 30, 2023

Modern languages and frameworks often also abstract away the need to write raw queries, offering high-level interfaces around our database models. Unfortunately, that's not enough to thwart away SQL injections once and for all, as these APIs can still present subtle bugs or nuances in their design.

Infrastructure 263

Infrastructure Database Servers Design 263

Dynatrace

JANUARY 31, 2024

The RAG process begins by summarizing and converting user prompts into queries that are sent to a search platform that uses semantic similarities to find relevant data in vector databases, semantic caches, or other online data sources.

Cache 208

Cache Azure Infrastructure Monitoring 208

Dynatrace

MARCH 6, 2024

IBM i is designed to integrate seamlessly with legacy and modern applications, allowing businesses to run critical workloads and applications. It also includes various built-in software components for database management, security, and application development. How does the extension work?

Monitoring 239

Monitoring Infrastructure Metrics Analytics 239

DZone

JANUARY 20, 2023

Having a distributed and scalable graph database system is highly sought after in many enterprise scenarios. Do Not Be Misled Designing and implementing a scalable graph database system has never been a trivial task.

Scalability 201

Scalability Big Data Hardware Internet 201

DZone

SEPTEMBER 6, 2022

For example, each deliverable in the project, like the requirements, design, code, documents, user interface, etc., Testing can also be divided based on the sub-stages or activities in testing, for instance, test case generation and design, test case execution and verification building of the testing database, etc.

Testing 246

Testing Programming Design Code 246

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

DZone

JANUARY 13, 2023

Using some sample data sets, you will learn how designated timestamps work and how to use extended SQL syntax to write queries on time-series data. Introduction Traditionally, SQL has been used for relational databases and data warehouses.

IoT 174

IoT Analytics Database Metrics 174

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

O'Reilly Software

JUNE 12, 2018

Data is all-important—vital for the continued success of our businesses—but has also been seen as a massive constraint in how we design and evolve our systems. This meant a lot of time was spent on things like cycle time analysis, build pipeline design, test automation, and infrastructure automation.

Database 72

Database Cache Architecture Latency 72

O'Reilly Software

DECEMBER 21, 2017

Despite being consumed directly by machines, APIs are made to satisfy the needs of human beings, so designing them should follow a user-centered process, but often it doesn’t. It's common to find APIs that merely expose database functions, without considering what the end users will do with them.

Architecture 92

Architecture Design Mobile Database 92

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. DBMS enhances data security with encryption, implements various access controls, and enables improved data sharing and concurrent access, thus facilitating quick response to changes and maintaining consistent database accuracy.

Efficiency 147

Efficiency Storage Database Scalability 147

The Netflix TechBlog

MARCH 10, 2023

Production Use Cases Real-Time APIs (backed by the Cassandra database) for asset metadata access don’t fit analytics use cases by data science or machine learning teams. This feature support required a significant update in the data table design (which includes new tables and updating existing table columns).

Media 237

Media Traffic Processing Design 237

SQL Shack

JANUARY 13, 2020

In this article, we will discuss the best practices that should be followed in order to keep the TempDB database in a healthy state and prevent any unexpected growth of the database, in addition to the procedure that can be followed to detect this unexpected growth once occurred. TempDB overview The TempDB database is one […].

Database 83

Database Best Practices Design Performance 83

SQL Shack

OCTOBER 29, 2020

In this article, we will uncover some secrets about the SQL Server tempdb database. Tempdb is a system database and it is used for various internal and user operations. Besides this, the tempdb has many unique characteristics, unlike the other databases.

Database 63

Database Servers Systems Design 63

Scalegrid

MARCH 22, 2024

Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions? Register now for free and experience the seamless operation of your databases across multi-cloud and hybrid-cloud systems. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions?

Strategy 130

Strategy Cloud Government Innovation 130

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

Dynatrace

MARCH 22, 2023

Insecure design This broad category refers to fundamental design flaws in the application caused by a failure to implement necessary security controls during the design stage. Use a safe development life cycle with secure design patterns and components. Apply threat modeling and plausibility checks.

Open Source 203

Open Source Artificial Intelligence Internet Internet 203

Percona

JUNE 23, 2023

Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system. It does not follow the SQL Standard as closely as other databases, and some useful functions such as MERGE() are missing.

Database 118

Database Transportation Servers Cloud 118