UCOSP

Undergraduate Capstone Open Source Projects

Technology Explorer Introduction

Posted by Diane Tam on 2010/01/28

Technology Explorer for IBM DB2 “Flight simulator” Project

Team:

Brian Olynyk, team lead of Technology Explorer

Peter Kohlmann, original creator of Technology Explorer

Matthew Vandenbussche, core developer and architect of Technology Explorer

UCOSP Students:

Michael Man SFU <mantong01@gmail.com>

Godfrey Chan SFU <godfreykfc@gmail.com>

Lenny Han Toronto <fallingangeles@gmail.com>

Diane Tam Toronto <diane.tam@gmail.com>

Jean Lalande Laval <jeanlalande@gmail.com>

Sylvain Petitclerc Laval <sylvain.petitclerc@gmail.com>

UCOSP FlightSim Team Blog:

http://ucosp.wordpress.com/category/flightsim/

Weekly Team Meetings:

Tues and/or Thurs 1-2pm (EST)

Code Sprint Jan 15-17 Overview:

http://ucosp.wordpress.com/2010/01/17/code-sprint-day-1-2-data-server-flight-simulator4/

http://ucosp.wordpress.com/2010/01/17/day-3-database-flight-simulator/

Overview:

One of the major long term goals for the Technology Explorer for IBM DB2 has been to provide an environment similar to a flight simulator for Database Administrators.  Pilots used to learn to deal with potentially dangerous and stressful situations in a real place.  This was risky and expensive.  Pilots today learn to deal with system failures and extreme conditions on flight simulators.  DBAs still develop their experience on live multi-million dollar production systems.  They could develop skills and confidence faster and more safely on a simulator.

Over the past few years the Technology Explorer for IBM DB2 team has built all the base components to create this simulator as part of our open source project.  The next step is to pull the pieces together into a viable simulation.  The team will use the existing open source building blocks to simulate a stable production system and then disrupt it with a number of planned or unplanned problems.  The system will then walk the DBA through problem recognition and resolution.

Goals for the project would:

  • Extend the existing framework to simulate database management problems
    • Simulate DB2 in production
    • Create a disruption of the system, for example a hard drive failure, lock contention, or excessive workload
    • Guide a DBA to identification and resolution of the disruption
  • Develop at least one example of a problem simulation

Languages:

PHP, JavaScript, Prototype js library, AJAX, dynamic web pages, HTTP protocol (the impact of it being a stateless system and what has been done to keep memory between requests on both the client and server sides)

Project managed through SourceForge.net:

Wiki: http://db2mc.sf.net

Development:  https://sourceforge.net/projects/db2mc/develop

Forum: https://sourceforge.net/projects/db2mc/forums/forum/761211

Issue Tracker: https://sourceforge.net/tracker/?group_id=211760

Additonal Links:

Steps for adding files(e.g. screencast): https://sourceforge.net/apps/trac/sourceforge/wiki/Release%20files%20for%20download

Express-C:  http://www-01.ibm.com/software/data/db2/express/

Source code for ibm_db2:  http://pecl.php.net/package/ibm_db2

Debugging PHP:  PDT2 (Eclipse for PHP) http://www.eclipse.org/pdt/downloads/ and install either XDebug or ZendDebug and configure in Apache and Eclipse.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: