Thanks @osgav
Question about PARA. Imagine you have different legal entities. This might be YOU, YOURWIFE, YOURCOMPANY. So PARA would just say create those 4 categories for each entity, right? So now imagine you always filed taxes for just YOU. Then, you decided to jointly file for you and your wife. Should the joint taxes be duplicated under the YOU entity and the YOURWIFE entity? Or maybe you create a joint entity: YOU&YOURWIFE and create PARA categories under that. This YOU&YOURWIFE would be a bit like the junction table approach first mentioned.
I’m still noodling about this but it seems the obsidian and zettel crowd are not the only communities to tackle the issue of organizational schemes.
Here are other topic areas that seem to have some relevance.
In game design, there is an idea called Data Oriented Design. Describes a process for managing all your data and the methods on that data.
Generally, the literature on “namespaces” tackles organizational issues and methods.
In relational database management, model schemas are often premised on an organizational principal. Specifically, as previously mentioned, Junction or Bridge Tables deal with many to many relationships without hierarchy.
One of the unspoken issues here is computer based search v. human based search. The power most people get from the linking system and graph in Obsidian is it aids human based search. UUIDs are great for computer based search but often bad for human based search. Links help with human based search and perhaps computer based search in something like a graph database (for example NEO4J). Tags help with human based search. Folders help with human based search. MOCs are for human based search. Dewey decimal is for human based search. If you look at database design literature, the various organization schemes are ment for optimizing computer based search (e.g. decreasing the latencies of queries). There is a certain rhyming to the human based methods and the computer based methods. For example, in human based search, Folgzettel or other numbering schemes and alphabetizing schemes seem to play a role that indexing does for a database in computer based search.
Collectively, it might be interesting to draw on the wisdom of crowds in this forum and think about the search optimizations used by computer based systems and their analogues in human based search. There might even be new ideas for human analogues waiting to be discovered…