Database compiler for Microsoft SQL Server - SQL, T-SQL Dual function as project manager

Company: UBS AG, Zurich

Technology: MS SQL Server, SQL, T SQ, .NET, C#.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Jan 2003 – Dec 2006

Cost: no details

Creating a prototype of a database compiler that is able to convert process-oriented flow structures and flow diagrams into stored functions. The application is used to register the signatures of employees with regard to the legal templates in the commercial register. In doing so, a rule management of more than 2000 active rules is taken into account when registering employees. Not only the database compiler is ordered, but also various auxiliary programmes, which are necessary for the automated process from the mail to the published signature on the Internet. The application is realised using Microsoft SQL Server, SQL, T SQ, .NET and C#.

• Management of physical signatures of employees authorised to sign, taking into account internal and legal requirements.
• Technology: Multi-layer technology.
• Database Microsoft SQL Server.
• Logic implemented using T-SQL (graphical generation of stored procedures - worldwide patents).
• Integrated security layer implemented using Microsoft SQL Server, T-SQL and
• A compiler is developed based on the Microsoft Access prototype.
• Recursive generation of Transact SQL stored procedures.
• At a later stage, the application will be migrated from Microsoft VB to Java and from Microsoft SQL Server to Oracle.
• Automated entry of signatures in the public registers
• Responsible for data modelling, database development (SQL Server) and implementation of logic in Transact SQL.
• Image processing tools in the .NET area (C#, EPF, WCF etc)
• Interface between compiler and database.