On Sun, Aug 18, 2013 at 12:17 PM, Christian Tismer <tis...@stackless.com> wrote:
...
> We get a medication prescription database in a certain serialized format
> which is standard in Germany for all pharmacy support companies.
>
> This database comes in ~25 files == tables in a zip file every two weeks.
> The DB is actually a structured set of SQL tables with references et al.

So you get an entire database snapshot every 2 weeks?

> I actually did not want to change the design and simply created the table
> structure that they have, using ZODB, with tables as btrees that contain
> tuples for the records, so this is basically the SQL model, mimicked in
> Zodb.

OK.  I don't see what advantage you hope to get from ZODB.

> What is boring is the fact, that the database gets incremental updates all
> the time,
> changed prices, packing info, etc.

Are these just data updates? Or schema updates too?

> We need to cope with millions of recipes that come from certain dates
> and therefore need to inquire different versions of the database.

I don't understand this. What's a "recipe"?  Why do you need to
consider old versions of the database?

Jim

-- 
Jim Fulton
http://www.linkedin.com/in/jimfulton
_______________________________________________
For more information about ZODB, see http://zodb.org/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zodb-dev

Reply via email to