Sandbox‎ > ‎Archive‎ > ‎IPT 2008-09‎ > ‎Blair's page‎ > ‎Major Project Register‎ > ‎

2009-02-12 Relations to course - databases

posted Feb 11, 2009, 8:44 PM by Unknown user   [ updated Jun 27, 2009, 11:13 PM by Eddie Woo ]
Databases are fundamental to the Apocaliptic Design intranet.

The intranet itself can been seen as a gignatic relational database, with individual components, such page contents, "recent site activity", and the user list, all flat-file databases within the relational database, relating to each other in a complex but necessary manner.

A relational database is merely a collection of flat file databases that share relations between each other. An example of how flat file databases on the intranet relate to each other is the relation between pages and the user list. To determine whether the current user is allowed to edit a page, the relational database must cross-reference with the user list, checking which permission level (Viewer, Collaborator, or Owner) the current user has, and then checking with yet another flat file database what this permission level is allowed to do.

Incidentally, the idea of "permission levels" comes from the concept of protecting a database - in this case, from unauthorised change.