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. Processed 4.15 toDate(max(created_utc))??????count()??

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

Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. It is largely an unofficial response to published comments from the MariaDB Corporation. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

The Netflix TechBlog

JANUARY 10, 2024

Future blogs will provide deeper dives into each service, sharing insights and lessons learned from this process. The Netflix video processing pipeline went live with the launch of our streaming service in 2007. The Netflix video processing pipeline went live with the launch of our streaming service in 2007.

Processing 229

Processing Media Latency Innovation 229

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. Advances in browser content processing. Content Is Dead, Long Live Content.

Performance 124

Performance Network Cache Metrics 124

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. This eliminated unnecessary row-mode processing, and removed the need for an exchange. SQL Server 2016 introduced serial batch mode processing and aggregate pushdown.

Servers 67

Servers Testing Metrics Storage 67

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.

Retail 152

Retail C++ Analytics Metrics 152