M.Isabel Pedraza Mayer, Núria Grau Pratginestós, Carles Estevez Company & Josep Castells Boliart*
Institut Universitari de Ciència i Tecnoligia
Álvarez de Castro, 63 · 08100 Mollet (Barcelona), Spain
Carles Pi Tolrà & Carles Acero Pérez*
Quimifarma Network - Cat World Network (CISP)
Sabino de Arana, 38 Baixos b · 08028 Barcelona, Spain
The HPLC DB developed at the IUCT and CISP include a complete information about chromatograms obtained from different scientific fields (pharmaceutical, biological,...).
The interface of this DB is very user friendly:
- It is possible to obtain parameters and data information with a simple mouse movement.
- Scientists can update the HPLC DB with their chromatograms by filling an easy form.
The DB is made in 3 phases:
- Recopilation and selection of the chromatographyc data
- The DB organisation:
- Compounds from the most interesting fields or applications have been selected
- A complet information of the chromatographyc conditions is provided
- Data introduction capability
- The developed MS Acces DB can be transfered to a compatible Internet system
The calls to www. Chromatography-db.com or www. Quimifarma.net/crom are answered by the server (1).
If the user asks for a static page, (1) return the page immediately, in the case that user ask for a consult / add of information (dynamic page).
- (1) interrogate (2)
- (2) executes the suitable SQL sentences
- (2) answers (1)
- (1) makes a page with the information given by (2)
- (1) sends the answer page to the user
- Administration system:
The system has a subsystem capable to do maintenance tasks:
- add / delete / modify chromatograms
The operation procedures are similar to web browsers.
- acces to chromatograms
- web acces control (visits / statistics)
1) Web server: SUN Solaris station
2) DB server: INTEL + UNIX (Linux Red Hat 5.1) work station
- Apache web server compiled to work with Solaris station servlets
- Jserv to run the Solaris station servlets
- JDK 1.1.5 java compiler for Solaris station
- Postgresql i mySQL DB for Linux
Both stations are hosted in the LAN of an Internet supplier (Catalonia ISP, Cat World), sharing a 2 Mb channel.
- Cat World’s Firewall registers all the accesses to their LAN, denying non authorized accesses
- Cat World has a Backup system that get an auxiliary server up in 2 minutes when the web server is down
- Telnet acces is not authorized
- The apache server and the servlets run as a low level user, so no vital proccess of (1) can be interfered
- The servlets are Java applications; implementing the Java security when applications are compiled
- The acces to (2) is only allowed from the consol or from the server (1) IP
- The servlets attack the secondary (PostgresSQL) when the main DB (mySQL) is down
- The administration system is protected with a passwork and IP authentification