Monday, October 19, 2009

Distributed and Scalable Non-Relational Database Systems

Fascinating read on non RDBMS distributed scalable databases.

http://www.linux-mag.com/cache/7579/1.html

Friday, October 9, 2009

Forecast: First freeze and flakes for Twin Cities | Updraft | Minnesota Public Radio

Forecast: First freeze and flakes for Twin Cities Updraft Minnesota Public Radio

No doubt the weather is one of those things that cycle through each year. In this installment of 365 and again, I present the annual question of when is the first flake going to fall on the Minnesota soil.

Wednesday, October 7, 2009

Genealogy Logical Data Model (LDS)

This is a simple genealogy logical data model that I developed in 10 minutes. Excuse my ascii art.

I hope to build an application on top of it.


+---------------+
| FATHER |
+--------------------+---------------+
| fathered | |
-+- +---------------+
^ v
+---------------------+ -+-
|PERSON | | father to
+---------------------+ |
|person_id |---------------+
|~~~~~~~~~ |
|person_date_of_birth |
|person_place_of_birth|
|person_name |---------------+
|person_details | | mother to
+---------------------+ -+-
v ^
-+- +---------------+
| mothered | MOTHER |
+--------------------+---------------+
| |
+---------------+




This is how it reads
  • About each person we can remember their person_id, person_date_of_birth, person_place_of_birth, person_name, person_details, person's father, person's mother, person mother to and person father to.
  • About each mother we can remember the person, and people mothered.
  • About each father we can remember the person, and people fathered.
One interesting this about this model is that a person can father and mother themselves. I hope this is not how life begun.