our work for you

about us

our technologies

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.
TECHNOLOGIES USED:
Order a similar project
Add your project
If you want us to perform your project, upload all the necessary data and we will be happy to discuss with you all the details of our cooperation.
Name
E-mail
Want to order
Upload your brief
For message
Send Message
Order a template
To install and configure the theme, you need to specify your billing details and hosting data (FTP, PHP admin logins, passwords). After that, our specialists will install the template and you can test it.
Name
E-mail
Want to order
Hosting data and databases
For message
Send request
Add your Review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World), Youtube url, text...
Name
E-mail
Upload your review
URL video-feedback Youtube
Write a review
Post a review
Add your review
If you have worked with our company, you can add your review using the form below. Upload your review in A4 format (Microshoft World)
Name
Upload
Post a review

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.

+41 (0)56 552 01 85

+41 (0)58 590 10 04

+41 (0)44 442 01 80

+41 (0)56 552 01 86