Re: Views for denomalizing

> If a UDF named "Email" has a value that is the list of e-mail
addresses for a person and another one named Phone had a list of phones, then a view could have tuples such as: (PersonID, LastName, FirstName, Phone, CompanyName, Email) would lend itself to a SQL select * having output such as:

1    Harley  George   555-6762      CoA        ghar_at_aol.com
_                     555-1123                 g_har_at_CoA.com
_                                              geo_at_harfam.org
2    Vander K Mary    555-8785      CoB        mvk_at_yahoo.com
_                     555-1191

The desire to have RM create the above view is morally wrong (in the context of RM) because among other reasons tuples have no direct relationship to each other than they belong to the same relation (table), thus your desired view arranged differently is garbage.

_                     555-1123                 g_har_at_CoA.com
_                                              geo_at_harfam.org
_                     555-1191
1    Harley  George   555-6762      CoA        ghar_at_aol.com
2    Vander K Mary    555-8785      CoB        mvk_at_yahoo.com

Each tuple is a separate entity. Dicing a single entity across multiple tuples is modelling with a blender. Buy hey, I am probably wrong. Go ahead and push the puree button :) Received on Thu Feb 03 2005 - 23:48:49 CET