O'Reilly Open Source Convention
oreilly.comO'Reilly Network
Conferences International Safari: Books Online

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

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



From Oracle to ZODB: A Case Study
Luciano Ramalho, Hiperlogica
Leonardo Rochael Almeida, Hiperlocgica

Track: Python
Date: Wednesday, July 24
Time: 2:30pm - 3:15pm
Location: Marina IV

In this case study we will describe the evolution of the CanalDVD project which started as a Zope and Oracle isolated web site but bacame a distributed Zope application using the ZODB as the main data storage.

CanalDVD.COM.BR is a Brazilian online catalog of DVDs which syndicates its content to other web sites. It was developed in the year 2000 as a Zope 2.2 application connected to an Oracle database. The catalog itself was stored in about 30 Oracle tables, representing entities such as Film, Genre, Actor, Languages, Special features etc. Application logic, templates, news articles and some images were stored in the ZODB.

In 2001 CanalDVD decided to license its content to multiple client web sites. However, the cost and complexity of deploying and synchronizing Oracle servers at each client site prompted Hiperlógica to rewrite the entire application as a Zope-only solution. That was the motivation for converting CanalDVD from a relational schema into a an object-oriented database implemented in ZODB.

Download presentation file

oreilly.com Home | O'Reilly Bookstores | How to Order | O'Reilly Contacts
International | About O'Reilly | Affiliated Companies | Privacy Policy

© 2001, O'Reilly Media, Inc.