Content-type: text/html Downes.ca ~ Stephen's Web ~ Relational Database Normalisation Process

Stephen Downes

Knowledge, Learning, Community
In some senses, the Semantic Web is like a big distributed database. This applies equally well to less formal instances, such as the RSS network. As such, there are basic, well-known, principles for its design. One set of these falls under the heading of 'normalization'. The idea of normalization is that you don't needlessly duplicate data entries. That's why I wince every time I see an author name entered into an element as a string instead of as a reference (or link) to an author record. This article explains database normalization and offers some examples. It's a bit of work to get through, but if you design metadata schemas or systems, please have a look.

Today: 5 Total: 97 [Direct link] [Share]

Image from the website


Stephen Downes Stephen Downes, Casselman, Canada
stephen@downes.ca

Copyright 2024
Last Updated: Nov 23, 2024 3:47 p.m.

Canadian Flag Creative Commons License.

Force:yes