Saltar al contenido ForoHackers

NoSQL: start here

NoSQL
#2905 · · Citar · Denunciar

NoSQL is a loose name for databases that depart from the relational table model: key-value stores, document stores, wide-column stores and graph databases. Each trades some of the relational toolbox, such as joins or strict schemas, for an advantage in scale, flexibility or a particular access pattern.

Key concepts

  • Data models: key-value for fast lookups, documents for nested records, wide-column for huge sparse tables, graphs for relationships.
  • Design from queries: you often shape the data around the questions you will ask, duplicating it if needed.
  • Partitioning: splitting data across machines by a key, so a poor key creates hot spots.
  • Replication and consistency: copies on several nodes raise availability but may briefly disagree.
  • Schema flexibility: records need not share a shape, so the application must handle old and new versions.

Vocabulary

  • CAP theorem: during a network partition a system must choose between consistency and availability.
  • Eventual consistency: replicas converge to the same value if updates stop.
  • Denormalisation: storing the same fact in several places to avoid joins.
  • TTL: time to live, the age after which a record expires on its own.

What to study, in order

  1. Relational basics first, so you know what you are giving up.
  2. Use a key-value store as a cache and observe expiry and eviction.
  3. Model a small application, such as a blog, in a document store and list the queries it supports well.
  4. Try a graph database on a social network and write a friends-of-friends query.
  5. Read about partitioning and replication, and simulate a node failure.
  6. Take a relational schema and redesign it for a wide-column store, noting every compromise.

Related tags

#databases #sql #distributed-systems #big-data

No has iniciado sesión, así que esto se publica como anónimo: no se guarda con ello ninguna cuenta, nombre ni dirección, y no puede llevar enlaces ni imágenes. Inicia sesión o únete para publicar con tu nombre. Los registros de nuestro servidor web guardan la dirección y la hora de cada petición hasta 14 días; para que la tuya no quede en ellos, usa Tor. Para escribir al equipo de forma confidencial, usa el buzón. Firmar como fuente habitual (una clave guardada solo en este navegador)

Enviar tarda unos segundos aquí: tu navegador resuelve antes una prueba de trabajo contra el spam.

Responder