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:
  1. Recopilation and selection of the chromatographyc data
  2. The DB organisation:
    1. Compounds from the most interesting fields or applications have been selected
    2. A complet information of the chromatographyc conditions is provided
    3. Data introduction capability
  3. The developed MS Acces DB can be transfered to a compatible Internet system




OPERATION
  1. Web:
    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
  2. Administration system:
    The system has a subsystem capable to do maintenance tasks:
    - add / delete / modify chromatograms
    - acces to chromatograms
    - web acces control (visits / statistics)
    The operation procedures are similar to web browsers.

HARDWARE
1) Web server: SUN Solaris station
2) DB server: INTEL + UNIX (Linux Red Hat 5.1) work station
SOFTWARE
- 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
- HTML and JavaScript web pages are written with HTML 3.0 to be compatible with any standard browser
Connectivity:
Both stations are hosted in the LAN of an Internet supplier (Catalonia ISP, Cat World), sharing a 2 Mb channel.
SECURITY
- 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