Laboratory data acquisition - Oracle, Microsoft SQL Server, T-SQL
Company: Philip Morris, Lausanne
Technology: MS SQL, Oracle, PL/SQL .
Link: Not available
People in the project: Stefan Tröhler
Implementation period: Sep 2001 – Jul 2002
Cost: no details
Documenting all Microsoft SQL, Oracle and Microsoft VBA applications for the Philip Morris laboratories. The inventories of the applications were taken and both technical documentation and a user manual were created for each application. Both documents were produced in English.
- Documenting the quality monitoring applications in the laboratories.
- Applications created using Microsoft Visual Basic 6.0.
- Backend Oracle and PL/SQL.
- Backend Microsoft SQL Server and Transact SQL.
- Analysing the applications to be documented.
- Discussions with the development teams, with the responsible project managers.
- Recording the original requirements for the applications.
- Some applications had to be analysed from scratch (data model, database logic, user interfaces and user interface logic).
- Based on the analyses, documents and discussions with the responsible parties, a technical documentation could be created.
- The technical documentation was created using Microsoft Word in German and English.