Improving join-performance of SQL databases

Cheatsheet on Relational Database Design A relational database is a type of database that organizes data into structured tables, also known as relations. These tables consist of rows (records) and columns (fields). Some key points to know about Relational Database Design 1 - SQL SQL is the standard programming language used to interact with rela... See more

Alex Xu

x.com

Strategic Database Marketing 4e: The Masterplan for Starting and Managing a Profitable, Customer-Based Marketing Program

Arthur Middleton Hughes

amazon.com

Cover of Strategic Database Marketing 4e: The Masterplan for Starting and Managing a Profitable, Customer-Based Marketing Program

For example, some of the platforms are better suited for large number-crunching BI applications than are competing products.

Steve Williams • The Profit Impact of Business Intelligence

Improving query performance in ElasticSearch at scale

blogs.halodoc.io

The logic required for most data preparation tasks is actually relatively simple. It is exactly the kind of thing that a relational database and its native language, called structured query language (SQL), are meant to do.

Bill Franks • Taming The Big Data Tidal Wave: Finding Opportunities in Huge Data Streams with Advanced Analytics (Wiley and SAS Business Series)

An imperative language tells the computer to perform certain operations in a certain order. You can imagine stepping through the code line by line, evaluating conditions, updating variables, and deciding whether to go around the loop one more time. In a declarative query language, like SQL or relational algebra, you just specify the pattern of the

Martin Kleppmann • Designing Data-Intensive Applications