Abstract: Many types of data files can only be stored in SQL databases as Blobs—Binary Large Objects, that the database can only handle as a whole. This limits searches within the Blob. Here improved methods are taught for automatically analyzing potential Blob files, and assigning at least certain classes of potential Blob files to General Data Type documents. In some cases, the potential Blob may be automatically analyzed and mapped to a JSON document type, and this JSON document type then automatically mapped into appropriate lists of JSON-document-nodes and tables that can be stored in the SQL database, and subsequently queried. This enables much data within the (to prior art) Blob to be queried at more detailed granularity. This data can then be retrieved and used to reconstruct some or all of the original General Data Type document, which would otherwise be a Blob to prior art methods.

Abstract: Embodiments for storing a JSON document tree in a single SQL database table by defining a schema to store JSON nodes in the table and converting each JSON document into a corresponding set of rows in the table using the schema to encode a hierarchical relationship of nodes and sub-nodes into a path that specifies a node path to a root node for each node. Embodiments further receiving a SQL query to retrieve a specific sub-document, responding to the query by returning all rows of the table belonging to the sub-document, and inflating the returned rows back into a JSON expression using the path to guide reconstruction of the original JSON document tree.

Abstract: Embodiments for storing a JSON document tree in a single SQL database table by defining a schema to store JSON nodes in the table and converting each JSON document into a corresponding set of rows in the table using the schema to encode a hierarchical relationship of nodes and sub-nodes into a path that specifies a node path to a root node for each node. Embodiments further receiving a SQL query to retrieve a specific sub-document, responding to the query by returning all rows of the table belonging to the sub-document, and inflating the returned rows back into a JSON expression using the path to guide reconstruction of the original JSON document tree.

Abstract: A repository portal includes a repository database, file repository and repository APIs handled by a stream as metadata catalog which lists file and database data in the repository. Access to database and file data is possible via the stream. From a user's point of view, the stream provides a common point from which to access and manage both database data and file data, the distinction being limited to differing storage class keywords in the xMIME typing system. The xMIME typing system “extends” the MIME typing system to add the storage class to the general and specific types. A general class keyword is also preferably added to the xMIME expression for distinctly typing different kinds of content.