Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. This information can be a mix of analytical (OLAP) queries (i.e. Inserts are efficient for bulk inserts only.

Database 40

Database Analytics Blockchain Healthcare 40

Scalegrid

JULY 17, 2020

Why should a relational database even care about unstructured data? If you store each of the keys as columns, it will result in frequent DML operations – this can be difficult when your data set is large - for example, event tracking, analytics, tags, etc. JSON database in 9.2 2014) added support for JSONB data type.

Storage 321

Storage Database Efficiency Processing 321

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

Alex Russell

MARCH 6, 2021

Devices and networks have evolved too: Alex Russell @slightlylate An update on mobile CPUs and the Performance Inequality Gap: Mid-tier Android devices (~$300) now get the single-core performance of a 2014 iPhone and the multi-core perf of a 2015 iPhone. mid-priced Androids were slightly faster than 2014's iPhone 6.

Performance 124

Performance Network Cache Metrics 124

The Netflix TechBlog

JANUARY 10, 2024

From Reloaded to Cosmos Reloaded Starting in 2014, we developed and operated the video processing pipeline on our third-generation platform Reloaded. The results are saved to a database so they can be reused. Reloaded was well-architected, providing good stability, scalability, and a reasonable level of flexibility. 264, AV1, etc.).

Processing 229

Processing Media Latency Innovation 229

Highly Scalable

MARCH 10, 2015

most of them are structured as data scientist manuals focusing on algorithms and methodologies and assume that human decisions play a central role in transforming analytical findings into business actions. This framework will later be used to describe analytical problems in a more uniform way. Simchi-Levi, 2014. Fano, 2002.

Retail 152

Retail C++ Analytics Metrics 152

SQL Performance

APRIL 23, 2019

SQL Server 2014 added the ability to perform parallel batch-mode grouped aggregation within a single Hash Match Aggregate operator. The scripts that follow assume there is a table called dbo.Numbers in the current database that contains integers from 1 to at least 16,384.

Servers 67

Servers Testing Metrics Storage 67