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

• 2019-深度揭秘腾讯云数据库技术的 7 年变迁史: 腾讯分布式数据库 TDSQL& 企业级云原生数据库 CynosDB 具有重要的历史节点。接下来，我们将从架构等细节着手，为大家详细介绍这两款数据库背后的技术进阶和研发历程。

Comparison

• 2016-一篇文章，掌握所有开源数据库的现状

• 2017-Millions of Queries per Second: PostgreSQL and MySQL’s Peaceful Battle at Today’s Demanding Workloads

• 2019-Top 11 Open Source Database for Your Next Project: Data is everything. And by extension, so are databases. Here are some fantastic open source options for your next kick-ass project.

• 2020-Recent database technology that should be on your radar : In this post I’d like to talk about three recently minted database technologies that I find intriguing.

Resource

• digoal/blog #Series#: Everything about database,bussiness.(Most for PostgreSQL).

• 数据库内核 #Series#: 解码数据库实现

• 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.

• 2010-Database System Concepts-6th #Book#:

• 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.

• 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.

• 2016-Relational Database Design and Implementation-4th #Book#: The book begins by reviewing basic concepts of databases and database design, then turns to creating, populating, and retrieving data using SQL.

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

• 2019-Cloud Data Management #Book#: Learn how to manage your data stack and set up processes to get the most out of your data in your organization.

Collection

• 2016-Readings in Databases #Collection#: A list of papers essential to understanding databases and building new data systems.

Course

• TP 301: TinySQL, a distributed relational database in Go #Project#: TinySQL is a course designed to teach you how to implement a distributed relational database in Go. TinySQL is also the name of the simplifed version of TiDB.

• TP 302: TinyKV, a distributed key value database in Go #Project#: This is a series of projects on a key-value storage system built with the Raft consensus algorithm. These projects are inspired by the famous MIT 6.824 course, but aim to be closer to industry implementations.

• 2019-W3Resource SQL Tutorial #Course#: SQL Tutorial of w3resource aims to meet the need of a beginner to learn SQL without any prior experience.

• SQL in a Nutshell #Course#: This series focuses on the most frequent data science and analytical problems in the real-world, and aims at solving them with SQL.

• W3School SQL 教程 #Course#

• SQL Teaching #Course#

• Intro to SQL: Querying and managing data #Course#: Learn how to use SQL to store, query, and manipulate data. SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations.

• 2019-Select Star SQL #Course#: This is an interactive book which aims to be the best place on the internet for learning SQL.

Paper

• 2013-F1: A Distributed SQL Database That Scales #Paper#: F1 is a distributed relational database system built at Google to support the AdWords business.

Tutorials

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

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

Scratch

• Database basics: writing a SQL database from scratch in Go #Series#: In this series we'll write a rudimentary database from scratch in Go.