MonetDB hands-on workshop for TELEIOS - Virtual Observatory Infrastructure for Earth Observation Data (EU-FP7-ICT)
Table of Contents
- 1. Meeting venue
- 2. Meeting logistics & agenda
- 2.1 Logistics
- 2.2 Monday March 7 2011
- 2.3 Tuesday March 8 2011
- 2.4 Wednesday March 9 2011
- 2.5 Thursday March 10 2011
- 2.6 Friday March 10 2011
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 |
