O'Reilly Open Source Convention
oreilly.comO'Reilly Network

Arrow Home
Arrow Registration
Arrow Hotel/Travel
Arrow See & Do
Arrow Tutorials
Arrow Sessions
Arrow Evening Events
Arrow BOFs
Arrow Speakers
Arrow Press
Arrow Mail List
Arrow Exhibitors
Arrow Sponsors
O'Reilly Open Source Convention
Sheraton San Diego Hotel, San Diego, CA
July 23-27, 2001

News Coverage


Alzabo: A Data Modeller and RDBMS-OO Mapper

David Rolsky, House Absolute Consulting

Track: Perl Conference 5
Date: Wednesday, July 25
Time: 11:30am - 12:15pm
Location: Grande Ballroom C

Alzabo is a tool designed to ease the pains of dealing with a database. It serves several functions. First, it is a data-modeling tool. You describe your schema (tables, columns, indexes, relations, etc.) via a data modeling interface and then Alzabo can generate the SQL necessary to instantiate your schema. It can also reverse engineer an existing schema from a database. Finally, it is capable of generating the SQL necessary to transform an existing schema based on changes made in the data modeler (a SQL diff, if you will).

As an RDBMS-OO mapper, Alzabo is capable of abstracting most types of SQL queries. It has several efficiency features such as lazy column loading, cursors, and row caching. It is also capable of auto-generating various convenience methods to simplify programming.

The presentation will cover:

  • Alzabo's web-based schema creation interface.
  • How to perform basic data fetching/alteration (insert/select/update/delete). How to construct joins and conditionals.
  • The row caching system and how it can be used to keep objects in sync across multiple processes (particularly applicable under mod_perl).
  • Lazy column loading.
  • Method auto-generation.

oreilly.com Home | Conferences Home | Open Source Convention Home
Registration | Hotels/Travel | Tutorials | Sessions | Speakers
Press | Mail List | Exhibitors | Sponsors

© 2001, O'Reilly Media, Inc.