Master thesis in Computing Science By: Ronny Andersson 710716-6717 CTH

Abstract :

This report describes a SQL-compiler. The compiler translates the query language SQL to the Erlang programming language and the query language Mnemosyne. Two options are provided for the programmer using the SQL-compiler. SQL statements can either

be embedded in Erlang code and compiled together with the Erlang program or compiled at run time when the query is evaluated.

The report explains how and why the compiler was developed. There are also some examples and a tutorial showing how the compiler is used. The compiler is a prototype. Hence, there are some recommendations on how to make a product of it.

The compiler was developed for the database manager Mnesia. Mnesia’s query language, Mnemosyne, is embedded in the Erlang programming language. The development of the compiler was done in an UNIX environment using Erlang and some tools supplied by OTP.