Designing Data Intensive Application

3. Storage and retrieval B-trees Log-structured index Clustered index: storing all row data within the index Non-clustered index: storing only references to the data within the index Multi-column indexes

Database from scratch

Persistence: como não perder dados Indexing: como consultar dados Concurrency: como lidar com multiplos clientes Persistence Indexing Existem dois tipos de queries: Analytical (OLAP): Geralmente envolvem um grande numéro de dados, com agregação, agrupamento, or joins. Transactional (OLTP): consultas que envolvem apenas uma pequena parte dos dados. Transactional (OLTP)

Database design

(https://cs-people.bu.edu/mathan/publications/fnt23-athanassoulis.pdf?utm_source=hackernewsletter&utm_medium=email&utm_term=books)[https://cs-people.bu.edu/mathan/publications/fnt23-athanassoulis.pdf?utm_source=hackernewsletter&utm_medium=email&utm_term=books] (https://www.postgresql.org/docs/current/query-path.html)[https://www.postgresql.org/docs/current/query-path.html] (https://ocw.mit.edu/courses/6-830-database-systems-fall-2010/)[https://ocw.mit.edu/courses/6-830-database-systems-fall-2010/] (https://blog.marcua.net/2009/06/03/mit-database-systems-6830-ta-course-notes.html)[https://blog.marcua.net/2009/06/03/mit-database-systems-6830-ta-course-notes.html]