O'Reilly Open Source Software Convention 2002

	Home
	Registration
	Speakers
	Keynotes
	Tutorials
	Sessions
	At-a-Glance
	BOFs
	Events
	Exhibitors
	Sponsors
	Hotel/Travel
	Venue Map
	See & Do
	Press
	Mail List

From the Frontiers of Research to the Heart of the Enterprise
O'Reilly Open Source Convention
Sheraton San Diego Hotel and Marina
July 22-26, 2002 -- San Diego, CA

Apache
Tutorial
Integrating Databases with Zope
Kent Hoxsey, www.smoking-gnomes.org
Carl Rendell

Track: Python
Date: Monday, July 22
Time: 1:45pm - 5:15pm
Location: Marina IV
The purpose of this tutorial is to explore some of the challenges of integrating databases into the web space, without imposing restrictions based on toolset. We will integrate data from a couple different databases into a demonstration intranet, and show how that integration provides additional flexibility and insight to web users.
The demonstrations will show how the technique applies to data in several different database systems, as well as how to integrate disparate systems seamlessly.
Outline:

Basic Terminology and Techniques

Data as Content
Metadata, and Indexing
Cataloging 101

A Simple Example

Publishing a work queue (MySQL)

Building a simple dashboard

Creating measurements against db objects
Publishing Customer Service metrics
(Oracle)

Hard Stuff- Complex Composites

Integrating Customer data
Build a complete view of a Customer
(Oracle, MySQL, SQL Server)