Techniques And Architecture

Pages

• Full Text Search
  Summary of how full-text search works (inverted index, stop words, stemming, relevance ranking) and its support in MySQL.
• Hierarchical Data
  Compares three relational models for storing tree data (adjacency list, closure table, nested set) and their query and update trade-offs.
• Sharding Partitioning
  Explains database sharding across servers versus table partitioning within one database, including goals, drawbacks, and partition types.