[ZODB-Dev] ZODB Compared to Commercial RDBMS

[Chris McDonough]

Kip,

ZODB is essentially an object persistence system.  As such it does not offer
some of the features you specify.  It does not itself have a query language.
Applications built on top of ZODB (such as Zope) provide most of the
functionality that you require.  For instance, ZCatalog is a part of Zope
that serves the purpose of providing an indexing and query engine.

Most of the features you require are available in some fashion using ZODB +
Zope.  Record-level locking is not supported because ZODB uses an optimistic
concurrency strategy for handling simultaneous writes to the same object.
Backup and restore differs depending on the ZODB storage implementation you
use, but for FileStorage, you just copy a file.  Data partitioning is as far
as I know not available unless you count storing data to a RAID array.
Multiphase commits are supported.  Query optimization is supported in a
crude way though ZCatalog's TopicIndexes.  Scalability and replication is
provided via ZEO.  Fault tolerance is provided via ReplicatedStorage, a Zope
Corp. "for fee" product that allows you to set up a "warm standby" ZEO
storage server.

HTH,

- C


----- Original Message -----
From: "Kip Cartwright" <kip@finfonet.com>
To: <zodb-dev@zope.org>
Cc: "Christopher Lozinski" <lozinski@jobmart.com>
Sent: Thursday, April 25, 2002 1:38 AM
Subject: [ZODB-Dev] ZODB Compared to Commercial RDBMS


> I'm new to Zope and I am trying to determine if the platform is a good fit
> for my project.  My main concern is whether ZODB has all the functionality
> of a commercial RDBMS (at least where it applies to an OODB). FYI, I have
no
> experience with ZODB or any other OODB.  Forgive me if any of my questions
> are not valid in an OO environment.
>
> Basic concerns are:
>    Record level locking (or equiv OODB functionality)
>    Backup & restore including applying log to last backup
>    Data partitioning (spreading database across multiple
volumes/partitions)
>    Multi-phase commits
>    Query optimization
>
> General concerns are:
>    High availability & clustering
>    Disaster recovery
>    DB management (runaway queries alerts, query throttling)
>    DB tuning
>    Performance
>    Scalability
>    DB Replication
>
> And some non database concerns:
>    Ease of formatting data in ready to print format (e.g., pdf or flash)
>
> I looked through the archives for this type of info but couldn't find
> anything.  My apologies if this is a redundant post.
>
> Thanks,
> Kip Cartwright
>
>
>
>
> _______________________________________________
> For more information about ZODB, see the ZODB Wiki:
> http://www.zope.org/Wikis/ZODB/
>
> ZODB-Dev mailing list  -  ZODB-Dev@zope.org
> http://lists.zope.org/mailman/listinfo/zodb-dev
>