simple mle deployerscg.unibe.ch/download/softwarecomposition/2020-06...emergenetics@i profile janet...

Simple MLE Deployer

A Tool for deploying JavaScript to Oracles Multilingual Engine

Bachelor thesis of Julian Weyermann Supervised by Boris Spasojevic

Contents

1. What is MLE?2. Original Goal & My issues3. Rescoping & Solution: Simple MLE Deployer4. Demo5. Conclusion

2

What is MLE? And what is it about?

● MLE = Multilingual Engine● Extension of the Oracle Database● Bring other languages to the Database (besides Java & C)

○ Language selection based on needs○ Libraries

● Based on GraalVM● Speed and resource benefits!

3

Original Goal

Generate reports directly on the Database

● JS libraries for generating PDFs available (for Node.js and Browser use)

4

Issues

5

● MLE behaves weird sometimes (unexpected behaviour)● Deployment Process is Heinous

Issues & Rescoping

6

● Solution: Write tooling for deployment

Create Desired JavaScript functionality

7

Store Code in Database

8

Create DB-Internal representation

9

Create Function

10

Call Function

11

Result

12

Solution: Simple MLE Deployer

13

DEMO

14

Conclusion

● Everyone with JS knowledge now can try MLE ● Wide field of future work:

○ Type conversions○ Multiple PL/SQL functions at once○ IDE integration○ ...

15

Thanks for your Attention!

Original Idea

Generate PDFs

Issues

Solution:Architecture

Simple MLE Deployer

16Go to simplemledeployer.uk.to to try it yourself!