Database Taxonomy

September 30th, 2009 admin
Share/Save/Bookmark

Add To Delicious Digg This post Stumble this post
Topics:

In my domain modeling/alternative database talk , I usually spend some time talking about taxonomy in biology. It’s a fascinating field, with a lot of interesting tangents (ligers and tigons and pluots, oh my!), but in the presentation I focus on how difficult it can be to model in a standard relational schema. I think there’s another set of lessons that people interested in databases can draw from taxonomy, however, and that’s a way of looking at how databases are related. Similarity There are two main techniques in taxonomy for classifying things. Numerical taxonomy is the practice of grouping by similarity – dogs are more similar to bears than they are to cats, so dogs and bears fall into the same suborder (Carniformia, versus Feliformia for cats). As it…


Originally posted on Viget

 
  Related Posts
Top Five Best Database Management Tools
Top Five Best Database Management Tools
For a database administrator, DBM (database management) tools make tasks related to maintaining relational databases efficient and fast. Prior to the popularity of these tools, most DBA’s had to use the command line to create, edit, and delete databases. In this article, we present to you the top five most popular/most voted for database... 
Why you Should be using PHP’s PDO for Database Access
Why you Should be using PHP’s PDO for Database Access
Many PHP programmers learned how to access databases by using either the mysql or mysqli extensions. Since PHP 5.1, there’s been a better way. PHP Data Objects (PDO) provide methods for prepared statements and working with objects that will make you far more productive! PDO Introduction “PDO – PHP Data Objects – is a database... 
Visual Database Creation with MySQL Workbench
Visual Database Creation with MySQL Workbench
In today’s tutorial, you’ll learn how to use a visual database modeling utility to draw a database diagram and automatically generate SQL. Specifically, we’ll review how to use MySQL Workbench , a cross-platform, visual database design tool. What is MySQL Workbench? MySQL Workbench is a powerful tool developed by MySQL with three... 
Django 1.2 Alpha Offers Multiple Database Support, Improved Security Features
Django 1.2 Alpha Offers Multiple Database Support, Improved Security Features
Django , the popular web development framework written in Python, has released the first alpha for its much-anticipated new version, Django 1.2. Among the new features coming in Django 1.2 are support for multiple databases — a key feature for larger websites running Django — improved security features and a messaging framework that... 
Rack Support in Rails: Why It Matters
As I’ve mentioned elsewhere , my RailsConf session on Rack support in Rails went very well. I’m not planning on giving this talk again, however, so I thought I’d write a quick summary of it for people who are interested in a little more detail than the slides can provide. My main motivation in giving this talk was to call attention... 
Coming Soon: The NoSQL Series
We’re always excited about new trends here at Viget, and the most recent phenomenon that’s caught our attention is NoSQL – the reaction against traditional relational databases like MySQL . The movement has been characterized by an explosion of interest in key-value stores, document-oriented databases, and other (mostly non-relational)... 
50 Examples of Drop-Down Navigation Menus in Web Designs
50 Examples of Drop-Down Navigation Menus in Web Designs
Having a clean and well-structured website navigation is key in designing an effective user interface. Drop-down menus are great for sites that have multiple levels of content hierarchy. The typical design pattern of a drop-down menu is that when a user hovers over the parent navigation item, a submenu of navigation items appears. In this collection... 
Simple Process To Develop WordPress Themes
A frequently asked question I often receive – mainly from people who start having a hand in developing WordPress themes for the first time – is: what’s the right way to proceed for implementing a custom theme? What’s the order with which modifying all various files which compose the default theme? As I already said in other posts... 
Backup your Database in Git
Short version : dump your production database into a git repository for an instant backup solution. Long version : keeping backups of production data is fundamental for a well-run web application, but it’s tricky to maintain history while keeping disk usage at a reasonable level. You could continually overwrite the backup with the latest data,... 
Supercharge Website Performance With AWS S3 and CloudFront
Supercharge Website Performance With AWS S3 and CloudFront
We live in a world where people are increasingly expecting more and faster speeds. In fractions of a second, your website can lose valuable visitors and in turn, money. Although most people think CDNs are for the “big dogs”, they’re actually super cheap and incredibly easy to use these days. In this tutorial I’ll show you... 
  Related Tweets from Twitter
tonyvia (Tony)  : Does anyone have a good wireframe template they can share? cc/ @viget I'm looking in your direction #lazyweb..
Updated : 2010-09-08T19:34:39Z   |  Reply  |  View Tweet
themosse (Simon Mosse)  : An interesting take on Creativity + "Inspiration" - 'the chase and risk of failure is worth the extra sweat and toil' - http://bit.ly/9rtL2Z..
Updated : 2010-09-08T10:07:48Z   |  Reply  |  View Tweet
ruisopdelijn (Ruben)  : doet infographics inspiratie op: http://www.viget.com/inspire/infographics-galore/..
Updated : 2010-09-08T10:04:31Z   |  Reply  |  View Tweet
codaset (Codaset.com)  : Getting to grips with Git http://www.viget.com/extend/getting-to-grips-with-git..
Updated : 2010-09-08T08:46:44Z   |  Reply  |  View Tweet
train_boy (train_boy)  : http://tinyurl.com/2fw7uwo Getting to Grips with Git | Viget Extend..
Updated : 2010-09-08T07:16:23Z   |  Reply  |  View Tweet
  Related News from Digg
No comments yet.

Spam Protection by WP-SpamFree

TOP