Friday, July 28, 2017

Working With Hierarchies in a NoSQL Database

DZone Database Zone
Working With Hierarchies in a NoSQL Database

Organizing information in hierarchies is something programmers have to deal with from time to time. Examples are:

Threaded discussions/comments. Addresses on a map. Folders and documents. Organizational structures. Storage/shelf locations in a warehouse. Pages on a web site. Link referrals.

Using a NoSQL document database (or SQL, for that matter), it is quite easy to create a structure to organize this type of information. For each record/document/node, you simply need a reference to the parent (except for the top node).

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...