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. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. 2006-01-01

Database 40

Database Analytics Blockchain Healthcare 40

SQL Performance

SEPTEMBER 25, 2020

Back in 2006, I complained via multiple Connect items about the lack of visibility of the default values for parameters in the catalog views. Here’s the only item I’ve found that made it to the new feedback system.). I recently answered a question on Stack Overflow about this problem, and it took me down memory lane. Really hard.

Code 42

Code C++ Database Servers 42

SQL Server According to Bob

JANUARY 11, 2020

© ​​ 2006 ​​ Microsoft Corporation. KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? ​​ All rights reserved.

Servers 40

Servers Cache Database Media 40

Highly Scalable

MARCH 10, 2015

Most of this article represents an overview of the results published by retailers and researchers who built practical decision making and optimization systems combining abstract economic models with data mining methods. The most typical use cases for this problem are recommender systems, personalized search results ranking, and targeted ads.

Retail 152

Retail C++ Analytics Metrics 152