MonetDB hands-on Workshop

MonetDB hands-on workshop for TELEIOS - Virtual Observatory Infrastructure for Earth Observation Data (EU-FP7-ICT)
  • When 07-03-2011 08:00 to 11-03-2011 17:00 (Europe/Amsterdam / UTC100)
  • Where L302, L120
  • Add event to calendar iCal

MonetDB hands-on workshop for TELEIOS - Virtual Observatory Infrastructure for Earth Observation Data (EU-FP7-ICT)

1. Meeting venue

 

2. Meeting logistics & agenda

2.1 Logistics

Unfortunately, we cannot provide machines and logins for short-term visitors. Hence, we ask all attendees to bring their own laptops. Since we agreed that Linux is the operation system of choice for the TELEIOS system, we recommend that the laptops run Linux (possibly in virtual machine). In case that is not possible, MacOS X or Windows would also be fine. We will provide 4 desktops as shared “servers” such that attendees with non-Linux laptops can login to these desktops, using their laptops merely as consoles/terminals.

2.2 Monday March 7 2011

Attendees
9:00 - 12:00 Welcome & Introduction
- Welcome
- Logistics
- Introduction to MonetDB (brief recap)
- Web Site & Documentation
- Support:
    - Mailing lists
    - Bug tracker system
all
12:00 - 13:00 Lunch all
13:00 - 18:00 Getting Started
- Download and install binary installers of MonetDB
- Build MonetDB from sources (tarball or Mercurial (HG))
- Location of database directory (dbfarm) and configuration options
- Configure and start MonetDB server:
    - Interactively by hand
    - As daemon (merovingian / monetdbd)
- Connect with MonetDB SQL client
- “hello world” example:
    - Create database
    - Insert data
    - Run queries
all

2.3 Tuesday March 8 2011

Attendees
9:00 - 13:00 MonetDB SQL
- General functionality
- Commonalities and differences with other DBMSs
- Migration pitfalls
- Advanced features
    - History
    - Performance profiling
    - Execution plan inspection
(All hands-on with running example(s))
all
13:00 - 14:00 Lunch all
14:00 - 18:00 Connectivity & Distribution
- Connect to server with standard tools & applications
    - ODBC
    - JDBC
- Write your own (mini) application
    - JAVA (JDBC)
    - C (MAPI)
    - Python (MAPI)
- Distributed MonetDB
    - Merovingian
all

2.4 Wednesday March 9 2011

Attendees
9:00 - 13:00 MAL (+ GDK)
- Language structure
- Writing & debugging MAL programs
- Data structures: BATs
    - “secrets” of accessing and manipulating BATs
- Creating your own functions & extension modules (in C)
- Using own MAL functions as SQL UDFs
- MAL optimizers (?)
developers
13:00 - 14:00 Lunch all
14:00 - 18:00 Break-out Groups
- Individual attention to
    - use cases
    - user questions & requirements
    - developer questions & requirements
    - etc.
all

 

2.5 Thursday March 10 2011

Attendees
9:00 - 13:00 Break-out Groups  (cont.)
all
13:00 - 14:00 Lunch all
14:00 - 18:00 Break-out Groups  (cont.)
all

2.6 Friday March 11 2011



Attendees
9:00 - 13:00 Break-out Groups  (cont.)
all
13:00 - 14:00 Lunch all
14:00 - 18:00

 Break-out Groups  (cont.)

Wrapping-up

all