Department of Informatics – Database Technology

News
People
Research
Publications
Teaching
Software
Contact  
The Swiss National Science FoundationUniversity of ZurichAgroscope Liebefeld-Posieux

Development

We are continuously developing the Swiss Feed Database to support storage, querying and analyses of temporal, spatial and categorical properties of the feed data.
Accessing the database. The Swiss Feed Database is run under PostgreSQL open source database management system. The parameters to access the database are the following:
host name:talis.ifi.uzh.ch
port:5432
database name:tfdb
The login name and password are assigned by the request to Andrej Taliun or Francesco Cafagna. The database can be accessed from multiple environments. The easiest approach is to use pgAdmin that provides a highly developed graphical user interface and is run on the most of the operating systems. One can also connect to the database from a command line with 'psql -d tfdb -h talis.ifi.uzh.ch -p 5432 -U your_login_name -W', using PhP as described in the example or with Java using the JDBC driver. All connection to the database are via ssl protocol. The following example illustrates how it can be achieved in Java:
...
Class.forName("org.postgresql.Driver");
Properties prop = new Properties();
prop.put("user",your_login);
prop.put("password", your_password);
prop.put("ssl", "true");
prop.put("sslfactory", "org.postgresql.ssl.NonValidatingFactory");
Connection conn = DriverManager.getConnection("jdbc:postgresql://" + "talis.ifi.uzh.ch:5432/" +"tfdb", prop);
...
Extending the web interface. The first step is to install Apache2 web server with support of PostgreSQL via php5. On Ubuntu this is done with the following five commands:
sudo apt-get install apache2
sudo apt-get install php5
sudo apt-get install libapache2-mod-php5
sudo apt-get install sudo apt-get install php5-pgsql
sudo /etc/init.d/apache2 restart
and, then, all your future web files are found in /var/www/. The last step is to download and extract the latest source files of the application.
Non-Disclosure Agreement. Each contributing student must sign the non-disclosure agreement before he/she is granted the access to the database.
Documentation: