Free University of Bozen - Bolzano - Distributed Databases Lab Page 2008/2009

Lab 1 - Thu 2009-03-05

What we've seen:

• intro to the final project (see article on Prof Gampers course page)
• brush up what you know about aggregation in SQL (see terminal session)
• intro and hands-on to HSQLDB (see HSQLDB home page and first example)

• bring your note book
• get HSQLDB up and running on your notebook
• start reading the article mentioned

Lab 2 - Wed 2009-03-11

What we've seen:

• discuss architecture
• refresh basic concepts about JDBC
• start writing program to generate example data (see dumper.java)

• try to be present so we can aggregate students into groups
• finish dumper.java so it generates proper random data (see note TODO)

Lab 3 - Thu 2009-03-19

What we've seen:

• form groups
• getting help solving individual problems with HSQLDB or otherwise related to your setups

• try to perform an aggregation using SQL (group by, see example queries in Lab1)
• read and understand about at least 1 algorithm from the paper: start thinking about how to populate the data structures you need by using selects from your sample data

Lab 4 - Thu 2009-03-26

What we've seen:

• clarified various questions about implementing the algorithms

Lab 5 - Thu 2009-04-02

What we've seen:

• one group discussed their implementation of the single merge algorithm with me

Lab 6 - Thu 2009-04-09

What we've seen:

• two groups discussed their implementations with me

• I'm currently aware of 3 groups out of 6 that have a working implementation of the aggregation tree with at least one of the algorithms working for count() - which is good.
  Someone from the other 3 groups (V.T.,A.P; S.B.,B.L.; I.K.,M.C.) should please show up at the next lab so we can assess how their project is doing.

Lab 7 - Thu 2009-04-16

What we've seen:

• discussed various problems

Lab 8 - Thu 2009-04-23

What we've seen:

• discussed various problems
• there is a final project FAQ

Lab 9 - Thu 2009-04-30

What we've seen:

• discussed various problems

Lab 10 - Thu 2009-05-07

What we've seen:

• discussed various problems

Lab 11 - Cancelled

Lab 12 - Thu 2009-05-21

What we've seen:

• one group presented their final project

Extra appointment for presentations - Thu 2009-05-28

What we've seen:

• two groups presented their final project