Abstract
Constructing and optimizing queries for schemaless, document-oriented non-relational (NoSQL) databases can be challenging due to implicit data relationships and opaque cost mechanics. The disclosed techniques describe a system for interactive, graph-based query authoring, validation, and cost estimation. This system can utilize a bidirectional, three-way synchronization engine to link natural language input, a visual graph representation, and executable query code through a canonical intermediate data model. A change made in one modality, for example, manipulating the visual graph or entering a plain-language request, can be translated by the engine to update the other representations. The system may also include a pre-execution analysis pipeline to validate query feasibility, check for indexing requirements, and provide estimates for read costs and performance. This functionality can allow for proactive identification and correction of inefficient queries before execution, which may mitigate common operational challenges in NoSQL database development.
Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.
Recommended Citation
Nigro, Leonardo, "Graph-Based System for NoSQL Query Authoring, Validation, and Cost Estimation", Technical Disclosure Commons, ()
https://www.tdcommons.org/dpubs_series/12420