Re: Is it possible to have an array in a table?
From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Sun, 23 Aug 2009 09:05:38 -0400
Message-ID: <7fct53F2k35shU1_at_mid.individual.net>
Ramon,
Date: Sun, 23 Aug 2009 09:05:38 -0400
Message-ID: <7fct53F2k35shU1_at_mid.individual.net>
Ramon,
Generally you should use side tables with referential integrity to store
such data.
Let's use your phone number example.
It is trivial for the DBMS to reverse lookup a name from a phone number
if the data is stored in relational format: (empid, number)
If you store your phone-numbers in an array there will be no indexing,
no statistics, no detection of duplicate numbers.
ARRAYs belong into the world of procedural logic, not relational, IMHO
Cheers
Serge
-- Serge Rielau SQL Architect DB2 for LUW IBM Toronto LabReceived on Sun Aug 23 2009 - 08:05:38 CDT