12 ms·
Interesting observation, @gibsonf1. What kind of hierarchical queries do you have in mind that would be challenging to write in SQL? Would you mind sharing them
by jarulraj 3y ago
Interesting observation, @gibsonf1. What kind of hierarchical queries do you have in mind that would be challenging to write in SQL? Would you mind sharing them in natural language?
- miohtama 3y agoDocumentation databases operate in tree structures - MongoDB - ZODB - Others - This is also how disk file systems operate You access items by their path, instead of id. Also path is relevant how the data is physically stored, fetching nearby data being cheaper. To work with this kind of data in SQL you need to construct recursive CTE queries. While it’s possible, it is a bit akward sometimes.
- johnthescott 3y agojsonb queries in postgres have been very performant for us over +tb data sets. however, we often materialize views of large json blobs, just cause we can.
- gibsonf1 3y agoOur conceptual awareness AI uses recursive conceptual inference where given some entity, looking at its states, the system determines which concepts can be inferred directly from those states, then precedes to then also infer that that entity inherits all the properties of the genera concepts of those starting conceptual types. If you follow the recursion, it can be quite a large number of jumps, but incredibly fast. For our data, we use Apache Solr, but a schema modeled on how we think the human schema works - its quite simple actually.