Timeline for What is the hierarchical DB schema for this xml?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 19, 2014 at 9:36 | comment | added | CodesInChaos | The big downside of MongoDB is that it doesn't support transactions (yet). | |
| Dec 19, 2014 at 6:57 | comment | added | overexchange | Using relational, i saw a table schema design that maintains tree hierarchy structure of nodes in a hierarchical network as a tuple (parent_node,child_node,ancestor_rank) so for multiple parents you have a single child and ancestor_rank will prefer which parent to choose. You additionally maintain indexes for faster retrievals from such tables. But this is tough design and non-intuitive in practical world. This is the crux of my query. i will check your answer further in this aspect. | |
| Dec 19, 2014 at 6:54 | comment | added | overexchange | thanks for this info, i will further look into it, because am about learn JSON now ): | |
| Dec 18, 2014 at 16:29 | history | answered | Jules | CC BY-SA 3.0 |