Brandon's Blog

11/8/2007

Strange

The evil machinations of SAP are becoming familiar to me.

I think I finally get what “metadata” is within a database.  I think they are equivalent to the MS Access concept of “Relationships” … if I’m getting the concept right.  These define many-to-one, one-to-one, and one-to-many correspondences between different tables of data.

I also now understand the whole star schema thing, and it is brilliance.  I think it is often the intuitive default, but forcing it is probably a great idea.