September 30th, 2009 admin
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
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...
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...
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 , 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...
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...
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)...
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...
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...
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,...
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 |
Related News from Digg