[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