'Ecommerce database design: Adjacency list / Nested set / Closure / Materialized path

I am looking into various solutions to design an ecommerce database. I have common across a few approaches

  • Adjacency list
  • Nested set model
  • Closure path
  • Materialized path

Is one option more scalable / better for ecommerce websites? Any suggestion / link to a document would be highly appreciated



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source