Database-List

Database List | 数据库资料索引

Overview

  • 2015-The Next 50 Years of Databases: I know that it's been a year since my last post and that I still need to write part 3 in my series on the open research problems for transaction processing database systems.

  • 2016-Evolutionary Database Design: Over the last decade we've developed and refined a number of techniques that allow a database design to evolve as an application develops.

  • 2017-The Rise of GPU Databases: The recent but noticeable shift from CPUs to GPUs is mainly due to the unique benefits they bring to sectors like AdTech, finance, telco, retail, or security/IT . We examine where GPU databases shine.

  • 2017-2017 年数据库技术盘点: 我们将从学术界、工程界的角度,从国外到国内,从数据库内核技术到数据库运维等多种角度,一起来回顾精彩的 2017。

  • 2019-国产数据库激荡 40 年: 在被 Oracle、MySQL、DB2 等产品蚕食的中国数据库市场,国产自研数据库如何才能真正崛起?

Case Study

Comparison

Resource

Blog

Book

  • 2007-Architecture of a Database System #Paper#: This paper presents an architectural discussion of DBMS design principles, including process models, parallel architecture, storage system design, transaction system implementation, query processor and optimizer architectures, and typical shared components and utilities.

  • 2012-The Internals of PostgreSQL #Book#: The main purposes of this document are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

  • 2012-High Performance MySQL #Book#: With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

  • 2014-SQL for MySQL: A Beginner's Tutorial #Book#: This introduction to SQL for MySQL begins by discussing exactly how data is stored and maintained in a relational database, familiarizing readers with SQL INSERT, UPDATE, and DELETE statements.

  • 2015-Readings in Database Systems-5th #Book#: Readings in Database Systems (commonly known as the "Red Book") has offered readers an opinionated take on both classic and cutting-edge research in the field of data management since 1988.

  • 2017-Designing Data Intensive Applications #Book#: This book will help you navigate the diverse and fast-changing landscape of technologies for storing and processing data. We compare a broad variety of tools and approaches, so that you can see the strengths and weaknesses of each, and decide what’s best for your application.

  • 2019-Database Internal #Book#: The book consists of two parts: Storage Engines and Distributed Systems since that’s where most of the differences between the vast majority of databases is coming from.

SQL

  • 2018-SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL-4th Edition #Book#: SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques.

  • 2019-How to Teach People SQL #Book#: This book will help you empathize with people learning SQL for the first time.

  • 2019-Learn SQL #Book#: Welcome to our PostgreSQL interactive SQL Tutorial! We’ve designed this specifically for tech-savvy folks to learn enough SQL to be able to do their own analysis and data fetching.

  • 2019-SQL Optimization #Book#: Get exposed to the most common techniques for improving query speed and database performance. Learn how to optimize queries by modifying SQL. Understand how indexes work and when to apply them.

RDB

MySQL

  • 2017-MySQL 学习笔记 #Book#: 本文档可以看作是 D 瓜哥 学习《高性能 MySQL》时做的读书笔记。为了让内容更丰富易懂,还参考了《MySQL 技术内幕》和《数据库索引设计与优化》。

  • 2017-The Unofficial MySQL 8.0 Optimizer Guide #Book#: Morgan Tocker is the Product Manager for the MySQL Server at Oracle. He has previously worked in a variety of roles including Support, Training and Community. Morgan is based out of Toronto, Canada.

Datawarehouse

Collection

Course

SQL

Paper

Tutorials

  • 2019-几万年前,有一只猴子大闹地府后删库跑路...: 生死薄技术上如何实现?广大生灵在生死薄中的唯一标记是什么?阴间数据库是什么样一个数据库?于是脑洞大开的程序员开始了他们的表演.....

  • 2018-数据库内核杂谈 #Series#: 我希望能够深入浅出地去讲解数据库是一个什么样的系统,以及为什么它最后会演化成这样一个系统,为什么我们都用 SQL 来操作数据,而不是 AQL 或 BQL. 希望读者阅读后,对数据库的理解不再单单只是知道简单的 table, row 等的基本概念或者单单会写些 join, select 的 SQL 语句。而是能从源头真正做到知其所以然。

Scratch