Benchmarking Queries and System Design

Flashcards covering key concepts in query benchmarking, distributed architecture, CDN limitations, AI in program management, geospatial indexing, and related system design topics.

Query Performance Benchmarking

Begin by benchmarking query performance and assess if feature development has influenced schema or APIs.

JSON Data Size Impact

A case where the database slowed because JSON fields stored increasingly larger data, causing deserialization and parsing delays.

Distributed Architecture Considerations

Consider the impact of node locations in distributed architectures on query time.

Redis Cache

A cache that can help with retrieving frequently used data from the database.

CDN

Can help retrieve blob elements if they are already part of the database.

Different Availability Zones

A way to spread your application across different geographic locations for better availability.

Edge Nodes Limitations

These can affect CDN's ability to bring data to the cache near a geographic location.

MapReduce framework

Framework discussed in foundation material.

TPM Role Depth

In TPM roles, expect a touch base of breadth, but deep dives are less extensive than in technical roles.

AI meeting tools

The tool that helps to retrospect meeting and make notes of meeting through the AI.

AI Agents

AI can be used for this, to automate repetitive task

AI Model Knowledge

Important to know when discussing AI during interviews, including differences between LLMs and SLMs and local implementations.

Notification of monitoring

Automating this can help track system status and reduce downtime.

Geospatial Indexing

A type of indexing that can be used to find nearby places, often involving geohashing for efficient storage and retrieval.

Geohashing

A technique where latlongs are translated to, to manage precision and group locations.