On Mon, Jun 29, 2009 at 3:43 PM, Tom Lane<t...@sss.pgh.pa.us> wrote: > David Fetter <da...@fetter.org> writes: >> On Mon, Jun 29, 2009 at 01:28:01PM -0700, Nathan Boley wrote: >>> ... They dismiss >>> singular value decomposition and the discrete wavelet transform as >>> being too parametric ( which is silly, IMHO ) > >> Should we have a separate discussion about eigenvalues? Wavelets? > > I think it'd be a short discussion: what will you do with non-numeric > datatypes? We probably don't really want to assume anything stronger > than that the datatype has a total ordering.
Well, in the general case, we could use their ranks. At the end of the day, we cant do any dimension reduction unless the ordering encodes some sort of useful information, and the data type being in R^n is certainly no guarantee. Consider, for instance, the cross correlation of zip-codes and area codes - you would really want to order those by some geographic relation. I think that is why cross-column stats is so hard in the general case. That being said, for geographic data in particular, PCA or similar could work well. -Nathan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
