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


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
Innovate--Collaborate--Discover
O'Reilly Open Source Convention
Sheraton San Diego Hotel, San Diego, CA
July 23-27, 2001

News Coverage

Session

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.
conftech@oreilly.com