[Data-modeling] Proposed cleanup of hidden properties in the /tv domain

Bryan Cheung bryan.cheung at metaweb.com
Thu Mar 6 18:33:05 UTC 2008


The /tv domain has some hidden properties from some decision changes  
made a while back on how to model the relationships between tv actors/ 
personalities and their appearances in tv episodes.  The detailed  
explanation is below, but in a nutshell, I'd like to migrate any data  
in these hidden properties and subsequently delete the hidden  
properties.

/tv/tv_character/status
This property wasn't very useful in conveying the infinite number of  
possibilities for a tv character's status and should be deleted.

/tv/tv_guest_role/non_character_role_e_g_contestant & /tv/ 
non_character_role/appeared_on_tv_episode
This property was used to define the role an actor had in an episode  
as a personal appearance, such as a contestant.  A different type was  
created to represent this - /tv/tv_episode_personal_appearance .  Any / 
tv/tv_guest_role instances that have data in the property  
non_character_role_e_g_contestant should be migrated to /tv/ 
tv_episode_personal_appearance and then the instance of /tv/ 
tv_guest_role should be deleted.  The reciprocal property /tv/ 
non_character_role/appeared_on_tv_episode should also be deleted.

/tv/tv_guest_role/series
Entering the series information the type /tv/tv_guest_role would not  
link the series with the tv episode, and would require double data  
entry.  The type /tv/tv_series_episode already has a property series  
to represent this, and it's also a disambiguator for the type.  Any  
data here should be migrated to the tv episode instance that is linked  
to the /tv/tv_guest_role instance.

/tv/regular_tv_appearance/seasons & /tv/tv_season/regular_cast
A regular tv appearance is not necessarily tied to the season  
(characters can die mid-season); therefore, the property seasons was  
hidden in favor of the properties from and to.  The reciprocal  
property /tv/tv_season/regular_cast should also be deleted.

/tv/regular_tv_appearance/non_character_role & /tv/non_character_role/ 
appeared_on_tv_program
Similar to /tv/tv_guest_role/non_character_role_e_g_contestant, a  
different type was created to represent this - /tv/ 
tv_regular_personal_appearance.  Any instances that have data in the  
property non_character_role should be migrated to /tv/ 
tv_regular_personal_appearance and then the instance of /tv/ 
regular_tv_appearance should be deleted.  The reciprocal property /tv/ 
non_character_role/appeared_on_tv_program should also be deleted.

As always, are there applications that use any of these hidden  
properties?

Thanks,
Bryan



More information about the Data-modeling mailing list