A way to support unified sql query for nested documents
A document and nesting technology, applied in the field of adaptive storage and unified query, can solve the problems of difficult database system, complex structure of distributed database, integration, etc., and achieve the effect of improving usability
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0040] In order to make the present invention more comprehensible, preferred embodiments are described in detail as follows.
[0041]The invention provides a method for supporting uniform SQL query for nested documents, and the invention can address the situation that the nested documents cannot be correctly SQL-queried when multiple databases coexist under distributed middleware. By rewriting the original SQL parsing and SQL push modules of the middleware, and adding the SQL interception module, the purpose of using SQL to perform unified query on nested documents is achieved, which improves the flexibility of the distributed database middleware and provides common users with It provides a good platform for manipulating non-relational data in a relational manner. The specific operation steps are:
[0042] Step 1. Build the database environment (only MongoDB is considered here) and the distributed middleware Mycat environment, and add the underlying database nodes to the midd...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com