A document-relation associated query system based on distributed middleware

For the widely existing document and relation mixed-type data, this paper proposes a system of storage and query for associated mixed-type data based on the distributed middleware. It adopts distributed middleware as technological tools to integrate databases of different types, which achieves adaptive and efficient data storage performance for document and relation type data. Furthermore, the hybrid data query mechanism is provided to extend the query object of SQL statement. In addition, the extended SQL operators such as a fuzzy join are implemented to realize the associated query between document data and relation data. In the proposed system, the upper layer uses SQL as query language, while the function can be extended to realize the associated matching query between document and relation data. The concrete execution plan is pushed to each node, so the proposed system could execute the query plan adaptively, which is an effective attempt for multisource and heterogeneous data management.