Fog Creek Software
Discussion Board




Where can I find just data models

You can always find plenty of source code.  Books come with CD's (or only a picture of one  if you are a Greenspun) with source code.

I once bought a book on data modelling. I could get the data models in the book on CD if I paid something like US$400.00 or more.

Every now and then I look but  I never see examples of data models.

Have I missed the websites with the models and explanations of why and how and the variations etc.?  i.e., here is how we model our user ... note we have no field for middle name, who needs stinkin middle names ... or ... yes, we limit first names to 10 characters, we  want to irritate people who have first names exceeding 10 characters ...

As an aside, not related necesarily to the data model, someone recently told me a customer was pissed because someone had put "Von" as his middle name because the form validation would not allow for a space in a last name ... too funny.

I really see, imho, a lot of bad forms which indicate to me that people aren't giving enough thought to the data models.

Is there some odd reason such sites don't exist?

seekingDataModels
Friday, June 11, 2004

Here's a source I found out about when, I think, Albert Kallal posted it on JoS in reponse to a similar question last year:

"Library of Free Data Models": http://www.databaseanswers.com/data_models/index.htm

Herbert Sitz
Friday, June 11, 2004

Great site . . . interesting to note in his models you can see him "evolve" . . . for example, from storing Address as attributes on addressable entities (People, Places, etc.) to storing address as its own entity and relating accordingly. This is just a lil' "quirk" I notice when evaluating someone who claims themselves to be a data modeler . . .

Another quick is storing a "Balance" field in any entity . . . computed fields will ALWAYS be your bane if you fall into that trap!

Matt
Saturday, June 12, 2004

Handy info - thanks.

  --Josh

JWA
Saturday, June 12, 2004

http://www.universaldatamodels.com/

Is this the site that wanted you to pay $400 or whatever? What a nerve! Asking to be paid for giving away years of hard-won experience! What next, software you actually have to pay for?

Data Miner
Saturday, June 12, 2004

I think he might have been talking about this companion CD:

http://www.wiley.com/WileyCDA/WileyTitle/productCd-0471388289.html

to these books:

The Data Model Resource Book: A Library of Universal Data Models for All Enterprises, Revised Edition, Volume 1
Len Silverston

http://www.wiley.com/WileyCDA/WileyTitle/productCd-0471380237.html

The Data Model Resource Book: A Library of Universal Data Models by Industry Types, Revised Edition, Volume 2
Len Silverston

http://www.wiley.com/WileyCDA/WileyTitle/productCd-0471353485.html

GuyIncognito
Saturday, June 12, 2004

Data structures for $400! Heck, I'll sell you a linked list for $200, and throw in a stack to go with it.

Anony Coward
Saturday, June 12, 2004

Throw in a queue and you've got a deal...

GuyIncognito
Sunday, June 13, 2004

Can it be a LIFO queue?  ;^)

Anony Coward
Sunday, June 13, 2004

Where can I just find models to date?

T. Norman
Sunday, June 13, 2004

Yeah, that was the book. I thought I was getting the datamodels with the book. Oh well.  See, the analgoy was with open source. All of you here, even Microsofties, are benefiting from good, open source software that also happens to be free. People have actually given away years of hard work. The concept is not too unusual on the internet ... at least the one that was.  Granted, most people I know who are from the Microsoft culture are in fact from a different culture.

However, I'm not against anyone selling something. I bought programs all the time. In fact I like to pay for software so the creator will keep creating.  When I use free software or when I've read the source code from others then that makes me honor bound to do the same ... not with all that I create but just as someone else provided to the community, so should I if I partake. But then that's just me.

The interesting thing that I noted is that there are so few places where one can get free data models AS OPPOSED to the plethora of free source code available.

So far only one website has been mentioned and you must ask for any model you want. I do, however, appreciate that I can browse the models.  But so far only one.

Imagine all the free, opensource projects ... nearly all of them have data models but I have not see anyone separate that.  I wonder if a lot of peole simply give little value to data models. I consider them paramount when starting an application.  I think I'll start a project to pull out all the data models from open source projects, that will be interesting.

seekingDataModels
Monday, June 14, 2004

*  Recent Topics

*  Fog Creek Home