T
Thomas Mercer-Hursh
Guest
Let me play product manager here. What I am getting here are descriptions of capabilities, not business use cases. I understand the business use case for stuffing some JSON in the database temporarily as a cache and in that usage I am likely to provide, via another field(s), indexes to locate the desired piece of JSON easily, e.g., something like a session ID. I get that one might want to have longer term store of documents in various formats, like an audit trail, but again one would expect primary access to be on some key fields. If one wanted to search the documents, one could certainly make a case for word index on a CLOB, but I don't see how JSON would stand out here as being a particularly preferred document format. For history on something that is not inherently a document, I am not sure why one wouldn't parse to ordinary fields so that one had access through all the usual mechanisms, including SQL-based reporting tools which would be unlikely to support a JSON datatype as anything other than a string. I understand that if one had a JSON datatype and this implied being able to index key-value pairs, that one could do fast searches on message content. But, there are two things I don't understand about that. One is how this capability would be any different than word index on a CLOB with the right word-break tools, a capability which would have a much, much broader utility than a JSON specific one. Note in particular, that generalized search on key value pairs implies full inversion, like word index. If there is only a limited number of keys on which one would ever search, then throwing the values into regular fields and indexing those is an immediately available capability supported by reporting tools. I.e., by asking for full inversion on a JSON datatype, you are asking for something harder than word index on a CLOB. The other is what is the actual business use case that would cause you to store a large volume of JSON strings and indicate generalized searching on key value pairs (recognizing that this kind of search is generally *not* available with audit trails)? How am I doing as a Product Manager, Rob?
Continue reading...
Continue reading...