1 NF

From: frebe <frebe73_at_gmail.com>
Date: 28 Feb 2007 11:14:32 -0800
Message-ID: <1172690072.338413.274810_at_z35g2000cwz.googlegroups.com>

Hi,
I read an interview with Chris Date (http://www.dbmsmag.com/ int9410.html) which made me a little bit confused. He claims that having an array as a column values doesn't violates 1NF. Is this the common opinion at comp.databases.theory too? If yes, how is it possible at apply 1NF at all, in that case?

Does a blob containing an image violates 1NF? Wouldn't the correct way to model images be something like this:

pixels(imageid, x, y, color)

Does it exists any attempts to implement a relational database that would be able to handle images like this, in an efficient way?

/Fredrik Received on Wed Feb 28 2007 - 20:14:32 CET