Обсуждение: array character types
Can anyone offer some insight or link to documentation on the use of integer and/or string array data types? We are thinking of using them in our database but there is some concern about breaking normalization standards and opening ourselves up to more issues later.
We are storing data about various analyses that are being run - i.e user and system parameter values. It would be nice not to have to create a separate table for each of these fields.
Any thoughts would be greatly appreciated.
Thank you,
Jodi Kanter
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
Jodi,
In my experience:
It is better to normalize these arrays into separate tables - even if it isn't "nice" to do so :-p
Array types can't be indexed, can't be foreign keys, and aren't compatible with other systems.
Normalization is always the most efficient way of handling multiple values under one category for a table.
Sometimes you may file the need to hit the C and write a procedure or two that can handle creation, deletion and retrieval from these quickly.
A lot of the time though, this isn't necessary.
Regards
Gareth Kirwan
Thermeon Europe Ltd
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Jodi Kanter
Sent: 31 October 2002 15:06
To: Postgres Admin List
Subject: [ADMIN] array character typesCan anyone offer some insight or link to documentation on the use of integer and/or string array data types? We are thinking of using them in our database but there is some concern about breaking normalization standards and opening ourselves up to more issues later.We are storing data about various analyses that are being run - i.e user and system parameter values. It would be nice not to have to create a separate table for each of these fields.Any thoughts would be greatly appreciated.Thank you,Jodi Kanter_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
Jodi, check contrib/intarray for arrays of integers. Олег On Thu, 31 Oct 2002, Jodi Kanter wrote: > Can anyone offer some insight or link to documentation on the use of integer and/or string array data types? We are thinkingof using them in our database but there is some concern about breaking normalization standards and opening ourselvesup to more issues later. > We are storing data about various analyses that are being run - i.e user and system parameter values. It would be nicenot to have to create a separate table for each of these fields. > Any thoughts would be greatly appreciated. > Thank you, > Jodi Kanter > > _______________________________ > Jodi L Kanter > BioInformatics Database Administrator > University of Virginia > (434) 924-2846 > jkanter@virginia.edu > > > > > > > > > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83