Data type handling for semi-structured data in a hybrid relational and schema-flexible database

Abstract

Disclosed herein are a system, method, and computer program product embodiments for enabling document collection creation in accordance with a semi-structured data type, retrieving and filtering data from both relational databases and a document collection, and determining a data type in which the data is retrieved. For example, a statement configured to generate a collection of semi-structured documents in a document store based on a schema is processed. The statement specifies a semi-structured data type in which a plurality of entities from the collection are to be returned from the document store. A determination is made that an entity of the plurality of entities is defined by the schema as being a particular data type different from the semi-structured data type. A query for the entity is provided to the document store. The entity is received, based on the query, in accordance with the particular data type.