...
The CheatSheet Generator can also be used by lecturers to generate course specific operator documentations.
MEP Calculator
The MEP Calculator can be used to test MEP functions and complex expressions used in Select/Join predicates. Therefore, one can enter an arbitrary expression in the first line. The tool will then call the internal precessing to estimate the return type and output the optimized form of the expression, the conjunctive normal form (CNF), and the disjunctive normal form (DNF).
MEP Tests and Time/Space requirements
...
The result of the MEP function test is stored in JSON format and includes a detailed report about all tests including parameter type, value, and stacktrace in case of an error.
The second utility called "Run MEP Time/Space Estimation" estimates the average time and space requirements for all MEP functions and calculates the relative time and space complexity score which can be used for the predicate optimization in the rewrite phase during the query compilation.
...
The estimation can be restricted to a specific set of packages by defining a filter. Note: The estimated time and space score is a relative value of the estimated time and space requirements. Also the estimated scores can differ depending on the platform.
Testcase Generator
The last entry in the developer menu opens a wizard to create a "Test Case" using the Testcase Generator. The Testcase Generator provides an editor to generate operator specific integration tests by generating a operator specific query including an input stream, and a resulting output stream.
...