Berichte und Anträge - Front- and Backend

This projects target was the development of a front- and backend for the administration of the "Berichte und Anträge" of the government to the liechtenstein Landtag.

 

The backend can unfortunatly only be discribed in general because there only is technical documentation and no management information and descriptions for most of the server programs. This is the reason why I only give a short overview about the project.

The frontend is publicly available under the URL http://bua.gmg.biz/BuA.

 

Backend

The backend consists of multiple parts. First the files are created and then transcoded into XML. These XML data are then enriched by meta information like catchwords and links and are then imported into a database. From this point an the data can be viewed and searched in the online interface.

 

Data gathering

The data is gathered by multiple workers in the different fields as Word documents.

These are then transformed into XML documents with Word-Makros. We chose this step because all of the existing data already was in this format and we did not want to reenter the documents.

 

Dataimport

The XML files are than passed to a special java import program that maps the XML strcutrure onto a relational database structure and translates the data into SQL statements wich are then inserted into the database. This import program also generates all secondary tables like references, catchwords and so on.

During the import the program also creates index files which makes searching for articles a lot faster.

 

Frontend

You can see the frontend website at  http://bua.gmg.biz/BuA . Using this web application it is possible to print, search and show all the different articels that are available to the public.

A special feature are the standard and professional search options which make it really easy to look for a data row. The user can always select between the standard interface and the professional interface with more links and options.

This concept makes it possible for both regular power users and normal users to find their data and to work with this application.