What a Data Warehouse Can Never Do

In one form, the question is "How do we handle the [X] transaction in the warehouse?" Another form of the question is "What do we do when [Y] changes?" The third form is less clear, but essentially the same: "How do we maintain [Z] in the warehouse?"

All of these …

more ...

Python OODB (Revised)

Simple object persistence (i.e., serialization to a file system) is what pickle, marshal and shelve do.

However, here's the next thing of some interest OODB's.

Zope's ZODB . The original OODB for Python, the backbone of Zope.

buzhug : "a fast, pure-Python database engine, using a syntax that Python programmers should …

more ...

Python Object-Relational Mapping (Revised)

Ian Bicking: A Blog http://blog.ianbicking.org/, provided some info on Py3K and Python Introspection http://blog.ianbicking.org/introspecting-expressions-in-py3k.html.

For me, the interesting part was his summary of Object-Relational Mapping. Mr. Bicking identifies two broad approaches: lambda introspection and operator overloading.

Lambda Introspection

Dejavu It primarily uses …

more ...

Ouch, this is going to hurt

While some spread-sheet use is civilized numerical stuff, and other spread-sheet use is merely personal organization, too much spread-sheet use is the poor-person's database management system. I call it the Spreadsheet Schema (SSS), different from normalized relational schema and star schema.

There is a serious problems with people using spreadsheets …

more ...