34 questions · 19 almanac · 0 findings

Distributed and Database Systems

Systems that coordinate computation and data across machines.

Almanac The Internet's First Word Was 'Lo'
  • What made ARPANET's packet-switching architecture conceptually different from earlier networks?
  • Which universities were connected by the original ARPANET in 1969?
Almanac The Programmer Learns to Navigate
  • What problem did Charles Bachman's Integrated Data Store (IDS) solve for storing structured data?
  • How does a network-model database let programs navigate between records compared to sequential tape access?
  • What did Bachman mean by 'The Programmer as Navigator' in his Turing Award lecture?
  • How did Bachman's navigable record structures influence the relational databases that came after IDS?
Almanac Proving a Program True
  • What problem did Hoare's Communicating Sequential Processes formalism solve for reasoning about concurrent programs?
Almanac The Tables Beneath Every Transaction
  • How does Codd's relational model differ from the navigational database systems it replaced?
  • Why were early implementations of the relational model dismissed as too slow to be useful?
  • What role did relational calculus play in giving database engineers a provably correct design target?
  • How did SQL databases end up displacing navigational systems that once seemed clearly superior?
Almanac Designing for Computers That Belong to People
  • What was the Xerox Alto and why was it significant for personal computing?
  • What areas of computing did Butler Lampson's Turing Award citation cover?
  • What ideas did Lampson's 1983 paper 'Hints on Computer System Design' put forward?
Almanac A Transaction That Cannot Half-Happen
  • What do the ACID properties (Atomicity, Consistency, Isolation, Durability) guarantee about a database transaction?
  • Why does a power failure mid-transaction risk leaving a database in a corrupt in-between state without these guarantees?
  • How did Jim Gray's work on two-phase commit protocols shape the design of modern database systems?
Almanac Getting Machines to Agree on the Truth
  • What problem do logical clocks solve when computers can't share a perfectly synchronized physical clock?
  • What is the Byzantine Generals Problem and why does it define the theoretical limits of consensus?
  • How does the Paxos algorithm let distributed systems reach consensus despite failures and delays?
Almanac One Lab, Every Database Since
  • How did Michael Stonebraker's Ingres project prove that relational databases could run efficiently in practice?
  • What did Postgres add to the relational database model that made it useful for scientific data?
  • Why is storing data by column rather than row, as C-Store did, faster for analytical queries?