Static Query Analysis for MongoDB
BA/Project
Static analysis of SQL is a common technique to identify
potentially inperformant queries, possible query
optimisations and improved data structuring and indexing.
However, it is only rarely applied for documented-oriented
databases, because of their flexible syntax. In this work,
a tool for static source code analysis for MongoDB queries
should be implemented. For normal queries, it identifies
data structures that should be indexed. In addition,
queries based on MongoDB's powerful yet often slower
aggregation pipeline are automatically transformed into
equivalent native MongoDB queries based on
.find()
.
- MongoDB
- query optimisation
- static code analysis