Technologies for system design interviews
When you put a technology on the whiteboard, the next question is how it works. Each page explains the important internals, the limits and the questions that interviewers ask.
- BigQueryBigQuery is Google Cloud's managed analytical data warehouse for SQL queries over large datasets.
- Google BigtableGoogle Bigtable is a managed wide-column database for large, sparse datasets that applications access by row key or row-key range.
- Apache CassandraApache Cassandra is a distributed wide-column database for partitioned, replicated data and high write volume.
- ClickHouseClickHouse is a column-oriented SQL database for analytical queries over large datasets.
- CockroachDBCockroachDB is a distributed SQL database that distributes relational data across nodes and supports ACID transactions.
- Amazon DynamoDBAmazon DynamoDB is a managed key-value and document database that uses partition-key lookups and predefined query patterns.
- ElasticsearchElasticsearch is a distributed search and analytics engine that uses Apache Lucene.
- etcdetcd is a distributed key-value store for small, critical coordination data, such as configuration, service registrations, and leader ownership.
- Apache FlinkApache Flink is a distributed engine for stateful stream processing and bounded-data processing.
- Apache HBaseApache HBase is a distributed wide-column database for large datasets with frequent writes, key-based reads, and ordered range scans.
- HDFSHDFS, the Hadoop Distributed File System, stores large files across a machine cluster and supports batch work with high throughput.
- Apache KafkaApache Kafka is a distributed, durable event log.
- Amazon KinesisAmazon Kinesis Data Streams is a managed, partitioned event log.
- KubernetesKubernetes runs containerized workloads across a cluster and continually matches them to their declared configuration.
- MapReduceMapReduce is a distributed batch model that converts input records into key-value pairs, then groups and processes values by key.
- MemcachedMemcached is an in-memory key-value cache for small, serialized values, such as database rows, rendered fragments, and computed results.
- MongoDBMongoDB is a document database that stores BSON documents in collections and supports indexes, aggregation, and transactions.
- Graph databases (Neo4j)Neo4j is a property graph database that stores entities as nodes and connections as relationships.
- NginxNginx is a web server, reverse proxy, and load balancer that commonly sits between clients and application servers.
- PostgreSQLPostgreSQL is a relational database with SQL, transactions, constraints, and flexible indexes.
- PrometheusPrometheus collects numeric metrics, stores them as time series, and evaluates queries and alert rules against them.
- RabbitMQRabbitMQ is a message broker that routes messages from producers into queues and delivers them to consumers.
- RedisRedis stores data structures in memory for caches, counters, sessions, rankings, and short-lived coordination state.
- Amazon S3Amazon S3 is managed object storage.
- Google SpannerGoogle Spanner is a managed relational database that distributes data across servers.
- Apache SparkApache Spark is a distributed compute engine that processes large datasets with SQL, DataFrames, and lower-level APIs.
- Amazon SQSAmazon SQS is a managed message queue that stores work until a consumer processes and deletes it.
- Apache ZooKeeperApache ZooKeeper is a replicated coordination service for small amounts of shared metadata, such as leader ownership, service membership, and configuration.