Top Up Home HTML2PDF Posts

begriffs on database

  • User-defined Order in SQL (link)
  • SQL Keys in Depth (link)
  • PostgreSQL Domain Integrity In Depth (link)
  • Deferrable SQL Constraints in Depth (link)
  • Practical Guide to SQL Transaction Isolation (link)
  • Faster PostgreSQL Counting (link)
  • A Tour of PostgREST (link)
  • PostgREST (link)

Daniel Abadi DBMS Musings

  • A tour through hybrid column/row-oriented DBMS schemes (link)
  • Distinguishing Two Major Types of Column-Stores (link)
  • The problems with ACID, and how to fix them without going NoSQL (link)
  • Replication and the latency-consistency tradeoff (link)
  • If all these new DBMS technologies are so scalable, why are Oracle and DB2 still on top of TPC-C? A roadmap to end their dominance. (link)
  • Why MongoDB, Cassandra, HBase, DynamoDB, and Riak will only let you perform transactions on a single data item (link)
  • Distributed consistency at scale: Spanner vs. Calvin (link)
  • NewSQL database systems are failing to guarantee consistency, and I blame Spanner (link)
  • Partitioned consensus and its impact on Spanner’s latency (link)
  • It’s Time to Move on from Two Phase Commit (link)
  • Introduction to Transaction Isolation Levels (link)
  • Correctness Anomalies Under Serializable Isolation (link)
  • The dangers of conditional consistency guarantees (link)
  • Overview of Consistency Levels in Database Systems (link)
  • An explanation of the difference between Isolation levels vs. Consistency levels (link)
  • Introducing SLOG: Cheating the low-latency vs. strict serializability tradeoff (link)

Timilearning

  • Timilearning - Spanner (link)
  • Cloud Replicated DB, Aurora (link)
  • Causal Consistency, COPS (link)
  • Optimistic Concurrency Control (link)
  • Distributed Transactions (link)
  • Consistency Models (link)
  • Timilearning - Consistency and Consensus (link) (link)
  • Fault Tolerance - Raft (link)