The Morning Paper

AUGUST 29, 2019

We group the DBMS design choices and tradeoffs into three broad categories, which result from the need for dealing with (A) external storage; (B) query executors that are spun on demand; and (C) DBMS-as-a-service offerings. Another interesting experiment here compared the effects on performance of different storage types.

Architecture 76

Architecture Cloud Storage Serverless 76

ACM Sigarch

OCTOBER 4, 2018

For example, consider a database system that is distributed across a data center, or even across data centers. On the other hand, one can implement this system with encryption/decryption units between the compute and the storage. Second, as the trust boundary grows, the classes of adversary that can permeate that boundary increases.

Systems 47

Systems Hardware Storage Healthcare 47

SQL Performance

MAY 8, 2019

GetNums ( 1 , 100 ) AS C WHERE C. Fellow SQL Server MVP Paul White theorizes that it could be related to using information from the outer input’s leaf to hint the storage engine to avoid duplicated effort by the read-ahead mechanisms. GetNums ( 1 , 100 ) AS C WHERE C. CREATE TABLE dbo. Customers. (

Best Practices 68

Best Practices C++ Code Servers 68

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. SELECT DISTINCT c from sbtest where id between ?

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. Remove the background task and aggressively reclaim database space during query execution. C++ template usage is an example of where COMDAT folding can shine.

IoT 61

IoT Servers Development Cache 61

Percona

JANUARY 17, 2019

now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). For my test, I need to choose: Aurora instance type and comparison. Aurora instance type and comparison. SSD) we can’t utilize the full potential of IOPS with just one thread.

Cache 48

Cache C++ AWS Airlines 48

SQL Server According to Bob

JANUARY 11, 2020

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? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40

Highly Scalable

MAY 1, 2012

The straightforward approaches for implementation of this system are: Log all events in a large storage like Hadoop and compute unique visitor periodically using heavy MapReduce jobs or whatever. A Liner-Time Probabilistic Counting Algorithm for Database Applications. Counters on each position are incremented. References. Durand and P.

Analytics 191

Analytics Traffic Big Data Efficiency 191

The Netflix TechBlog

FEBRUARY 13, 2020

By Aditya Mavlankar, Jan De C**k¹, Cyril Concolato, Kyle Swanson, Anush Moorthy and Anne Aaron TL; DR We need an alternative to JPEG that a) is widely supported, b) has better compression efficiency and c) has a wider feature set. We believe AV1 Image File Format (AVIF) has the potential.

Code 212

Code Metrics Efficiency Open Source 212

Smashing Magazine

JANUARY 7, 2019

To get a good first impression of how your competitors perform, you can use Chrome UX Report ( CrUX , a ready-made RUM data set, video introduction by Ilya Grigorik), Speed Scorecard (also provides a revenue impact estimator), Real User Experience Test Comparison or SiteSpeed CI (based on synthetic testing).

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

JANUARY 6, 2020

Alternatively, you can also use Speed Scorecard (also provides a revenue impact estimator), Real User Experience Test Comparison or SiteSpeed CI (based on synthetic testing). Paddy Ganti’s script constructs two URLs (one normal and one blocking the ads), prompts the generation of a video comparison via WebPageTest and reports a delta.

Performance 145

Performance Cache Network Metrics 145