What is Digg?Sponsored by Dragon Age: Origins
Can't get enough Dragon Age: Origins? Play the flash game. view!
DragonAgeJourneys.com - Play the free companion flash game to Dragon Age: Origins.
43 Comments
- PAJK, on 10/12/2007, -3/+18"Lol PAJK, if that's the most annoying thing in your day I envy you!"
A gem of a comment. :) - webhead74, on 10/12/2007, -1/+10They've even got one for a clown registry (http://www.databaseanswers.org/data%5Fmodels/clown_registry/index.htm)... that's what Digg is built around, right?? :-)
- duncane, on 10/12/2007, -0/+8While this is a fantastic idea these are really only basic models. In the real world you will need much more detail, for example you will need to keep a history of a customers names and addresses rather than have just one of each for each customer - none of the various models include things like this.
I think something like this has huge potential. I'm sure most developers spend most of their time re-making the wheel in financial or CRM or product systems. Having a standard model for for customers/ accounts/ transactions/ products etc would revolutionize our industry. We could even have standard front ends for these models that would automatically take in a particular databases customization's. Think Access, but on at enterprise level.
Ideally we could have a site or repository where open source ERP systems could work together to choose the best data models. Now that would really start to scare oracle and SAP ;-) - boycy, on 10/12/2007, -3/+11Lol PAJK, if that's the most annoying thing in your day I envy you!
- lasean, on 10/12/2007, -1/+9Come on folks, menneke is right. Please read the page before commenting.
The guys page says, "It is not my intention to provide Models that can be used off-the-shelf to meet the requirements of a large commercial organisation." - blong, on 10/12/2007, -7/+13A gem of a resource.
- feefs, on 10/12/2007, -1/+5some of these models are a bit ropey. And maybe a few more intersection tables rather than many to many would work better!
- TrickyMick, on 10/12/2007, -0/+3I think this is a great resource. Obviously, you cant just pick one of these up and use it as is, but sometimes your head is in meltdown and you just need to look at some stuff to get your brain going. I have always wanted to find something similar for GUI designs, there are a couple of sites but none have this volume of ideas. great work
- KicktheDonkey, on 10/12/2007, -0/+3What? Like on a motorcycle?
- phogasmic, on 10/12/2007, -0/+2I think this is a great resource for beginners,such as myself. I am trying my hand at developing web aps and one of the things that bugged me was building database schemas. This is defiently a good bookmark, I`d like to give a great thanks to the person who put it up.
- brd6644, on 09/01/2009, -0/+2Very interesting to read and ponder. Dugg.
- thund3rstruck, on 10/12/2007, -0/+2You guess he's a VB programmer huh? Guess what, I am too (.NET) and I earn $85K a year. You can have your elitism, I'll keep my salary and extravagant quality of life.
- smellinator, on 10/12/2007, -1/+3There are a few books of generic data models.
Volume 1 is:
http://www.amazon.com/gp/product/0471380237/002-7830513-6869645?n=283155
Do a search for Data model resource books, and you'll see a whole bunch of Len Silverson books. None are perfect, but they definitely give you things to think about when you are designing your data models. - KicktheDonkey, on 10/12/2007, -1/+3What might also be handy is some generic SQL statements to create these data models.
- Foxman2000, on 10/12/2007, -0/+2My personal favorite is the Shrek 2 data model.
http://www.databaseanswers.org/data_models/shrek_2_movie/index.htm
I just need to figure out a way to use this one at work. - pennyfx, on 10/12/2007, -0/+2Awesome.. I finally found the Clown Registry Schema i've always wanted.... .. ha..
http://www.databaseanswers.org/data%5Fmodels/clown_registry/index.htm - duncane, on 10/12/2007, -0/+2Another great digg article goes flying by on the front page... This article could benefit from longer discussion, but the digg engine seems to move too fast for quality comments and articles that require more than a few minutes thought.
- drybij, on 10/12/2007, -0/+2I dunno - the ones I've looked at don't seem to reveal anything earth-shattering. They seem more common-sensical to me. If I had to model one of these things, this resource would save me no more than a couple minutes of pondering.
- dieseltravis, on 10/12/2007, -1/+2I agree with uptown.
A gem is truly, truly, truly outrageous. - uptown, on 10/12/2007, -1/+2Gem is truly outrageous!
- lukes, on 10/12/2007, -1/+2A good starting point maybe, but individual applications for each job will usually require quite different database models. more a curiosity than a resource.
- anon52, on 10/12/2007, -0/+1@Duncane -
I wholeheartedly agree.
I've designed many DB models for various customers that are 40-80% the same (primarily online product catalogs and normal CRM stuff) with modifications and additions for the different needs and environments. What may work best is some form of basic templating and OO inheritence.
For example, I design a base DB structure for products with templated productID, productName, prices, etc. and an easy way to change the attributes for the fields and tables. You may have a implementation-specific requirement that can either substitute or override the base definitions.
Make this usable across the 90%+ of coimmercial DB servers and it could be a fantastic aid. - drowe, on 10/12/2007, -0/+1There are more than enough tools to generate SQL from a model. What people need is the design skill to make a good database model.
Check out DB Designer 4, very good (free / open-source) tool. Has support for several databases. Then of course theres scripts for translating Dia models to DDL. Plenty of stuff. - neurokaotix, on 10/12/2007, -0/+1BRILLIANT!
- neurokaotix, on 10/12/2007, -0/+1I program in a few languages on a daily basis, VB6 being one of them. Here's what I discovered since I started using VB in 1998: VB6 appears to be a "noob language" until you do some serious ***** in it. I've seen some VB code that my hair stand on end ;)
- coding, on 10/12/2007, -0/+1I fear for the project that needs this.
- KicktheDonkey, on 10/12/2007, -1/+2Strange that you're getting dugg down by pointing out something obvious from TFA.
- antny, on 10/12/2007, -0/+1Why does it matter if he's a VB programmer? If he's been in the industry for 15 years he must be doing something right.
I think its a great resource that i'll probably go back to again and again. - seneca, on 10/12/2007, -3/+3I don't understand. What's wrong with the word gem? I think it's a nice descriptive word.
- mealies, on 10/12/2007, -0/+0While some of the designs are not the best, they are at least a good starting point, especially as most people would have to do extensive mods to them anyway
- raccettura, on 10/12/2007, -1/+1I think in the last 2 semesters of college I normalized and made ERD's for 1k problems... where the heck was that site?
On the other hand... I can do it in my sleep. - hifi78, on 10/12/2007, -0/+0Very interesting way to get the juices flowing when starting a project.
- avinsquirtler, on 08/04/2009, -0/+0I love free database models. I need to find more. Anyone have any links? I get my free samples from http://yofreesamples.com
- jerrykew, on 10/12/2007, -0/+0I have been a db designer for 28 years, and I am sorry, but this is not very good really. The models are primitive, and the whole exercise reminds me of the time ten plus years ago I bought a PC magazine with a CD on the cover offering 100,000 clip art files, upon opening I found that, for example, one arrow shape was available in 8 different directions, times 30 different sizes, times 10 different colours. The BEST place to start when building a data model is to immerse yourself in the issues of the business to be modelled, starting in a place like this will NOT help you become a good modeller.
- jeffreyrobbins, on 10/12/2007, -0/+0Good reference, its always nice seeing how others put things together.
- cosmo7, on 10/12/2007, -0/+0I like the use of lookup tables for gender. After all, you never know when a new gender is going to be invented.
- xorian, on 10/12/2007, -0/+0Ooh, if I had only known about that site a year ago, when we had to make very complex database models at school.
Great site though, I better bookmark it if I ever need it :) - menneke, on 10/12/2007, -3/+2does the term 'Kick-Start' mean anything to anybody?
- TechCoder, on 10/12/2007, -2/+1pretty lame, seems like this dude has waaay too much time on his hands. If your a pro, your not going to be rushing to this site to download a db schema. I bet this guy is a VB programmer :)
- drowe, on 10/12/2007, -2/+1Whoops...TrickyMick said it all. Go ahead and bury this...
- sentai, on 09/08/2008, -1/+0http://www.je6.info nice work man
- inactive, on 10/12/2007, -6/+2Gud for KIDS learning data normalization.
- PAJK, on 10/12/2007, -23/+3"A gem"? Is anyone else sick of that term? How annoying.
Browsing Digg on your phone just got easier with our enhancements to the 
© Digg Inc. 2009
— Content created and posted by Digg users is