CS 549 Special Topics: Information-Based Systems

Spring 2008

MWF 17:00-1750 KEC 1003

Instructor: Toshimi Minoura (minoura@cs.orst.edu)

We envision that an application that integrates content management (CM), social networking (SN), and Web-mapping features will become important. In particular, we will study the following techniques and implement some of them.

  1. Current CMS and SNS frameworks support only the database tables predefined by them. We want to allow any tables required by applications so that application-specific information can be shared and maintained.

  2. For an application we envision, systematic access-control is a key feature. Insert, search, edit, delete operations need be restrictable to owners, groups, friends, and/or friend of friends. The unit of protection need be a table, a record, or a field. Each group thus can maintain information accessible only to its members.

  3. We want to allow the users to insert/query/update/delete geographical data as well as ordinary data.

  4. We want to construct Web pages with hierarchically organized modular components, each of which is dynamically updatable with an AJAX mechanism.

  5. We want an application to be generated almost automatically from a database schema.
We will study implementations of such CMSs and SNS as Drupal, Joomla, Elgg, OpenPNE, and Usagi and learn how to use Google Map Service and the WebGD framework. The software tools and programming languages used in this course include the following: PostgreSQL (object-relational database management system), PHP (Web scripting language), JavaScript, Prototype, PostGIS (geospatial data server), Minnesota MapServer (Internet Map Server), Google Map Service, WebGD-Gen (PHP script generator developed at OSU), and WebGD framework (software framework for Web-based GIS/database applications).