Conception of Information Systems - Summer Semester 2005
For part 1, the exercises are of practical nature and serve to experience some of the technologies directly. They will be posed in a way that they can be solved in principle on paper, but we will offer the opportunity to gather practical experiences. Exercises are not marked.
There will be five exercises:
You can use the computers in IN1/3. Questions can be posed in the newsgroup epfl.ic.cours.CIS or personally to the responsible assistants during the specified office hours. Solutions for the exercises and introduction to the new exercises will be presented during the exercise hours.
You will work in the room IN3, which is reserved for this course every Wednesday 16-18h. Every second week, starting from Wednesday March 17, we will have an exercise session in this room.
For the exercises 2-5 you will be working in
groups of two. Each group will use username user0Y and
machine lsir-cis-pcX.epfl.ch, where X and Y are different for each
group. To obtain X, Y and password for your group
you will have to
register here. You must change the passwords
after the first login. In case of problems please communicate with Martin
Rubli (martin.rubli at epfl.ch).
Thus, the working environment for any group is completely determined by these two numbers, X and Y. So if you have for instance, X=9 and Y=1 you will use the command ssh -Y firstname.lastname@example.org to log in (of course, 'Y' in the above command is a flag of the command, it should not be replaced with 1). When you log in you will be paced in your home directories. Of course, you can create new subdirectories in your home directory and organize them as you wish.
You are expected to read the documentation and get familiar with the basics of the environment (starting and stopping the servers, their organization, etc.). Please use /opt/j2ee0Y/docs/QuickStart.html (and the links you find in this document) to learn the basics about the server and http://java.sun.com/j2ee/1.4/docs/tutorial/doc/index.html to learn more about the J2EE architecture.
Please keep in mind that the port numbers on your system are different from the default ones. The following three numbers are of interest to you:
(Needles to say, Y is here the user number that you have.)
As you could already figure out, there is a DBMS bundled with J2EE server. The name of the product is PointBase. Please use pdf
system guide) to learn more about this database system. In particular, the SQL reference is in
the developer's guide.