Reply to thread

Message

<blockquote data-quote="mbuzina" data-source="post: 66063" data-attributes="member: 12382">This is a sample datamodel I designed which might fit the space between good enough and clean enough.<a href="http://img105.imageshack.us/my.php?image=newdatamodelmpyb9.png" target="_blank"><img src="http://img105.imageshack.us/img105/2759/newdatamodelmpyb9.th.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></a>I would represent:an artist (e.g. Music or Movie) asLabelType = &quot;Artist&quot;Label = &quot;R.E.M.&quot;additional info might be in the Artist Table (Biography etc.)a genre asLabelType = &quot;Genre&quot;Label = &quot;Grunge&quot;ParentLabel = &quot;Rock&quot; (sample!)an album asLabelType = &quot;Album&quot;Label = &quot;Automatic for the people&quot;ParentLabel = &quot;R.E.M.&quot; (The Album Artist)a directory asLabelType = &quot;Directory&quot;Label = &quot;d:\Music\R.E.M.\Automatic for the people&quot;Directory.strPath = &quot;d:\Music\R.E.M.\Automatic for the people&quot;a playlist asLabelType = &quot;Play List&quot;Label = &quot;My Summer&quot;&nbsp;--&gt; Might need a reference to a file as well for storage or also be an itemLabelMap contains:&nbsp;map to song &quot;Drive&quot;&nbsp;map to picture &quot;SomePicture_002&quot; --&gt; Can mix media in playlists!a song asItem.strName = &quot;Drive&quot;File.strFileName = &quot;01 Drive.mp3&quot;File.idPath.strPath = &quot;d:\Music\R.E.M.\Automatic for the people&quot;LabelMap contains:&nbsp;map to Album &quot;Automatic for the people&quot; (Role Empty)&nbsp;map to Genre &quot;Rock&quot; (Role Empty)&nbsp;map to Directory &quot;d:\Music\R.E.M.\Automatic for the people&quot; (Role Empty)&nbsp;map to Artist R.E.M (Role Artist)&nbsp;map to Artist &quot;Bill Berny&quot; (Role Composer)&nbsp;map to Artist &quot;Peter Buck&quot; (Role Composer)&nbsp;map to Playlist &quot;My Summer&quot; (Role 00001), forgot to add iPosition to LabelMapa movie asItem.strName = &quot;The Rock&quot;file.strFileName = &quot;the_rock_cd1.iso&quot; (File 1)file.strFileName = &quot;the rock_cd2.iso&quot; (File 2)LabelMap contains:&nbsp;map to Genre &quot;Whatever&quot;&nbsp;map to Artist &quot;Michael Bay&quot; (Role Director)&nbsp;map to Artist &quot;Sean Connery&quot; (Role Actor)... a TV Channel asItem.strName = &quot;CNN International&quot;Label.strLabel = &quot;CNN International&quot;LabelType = &quot;TV Channel&quot;Channel.iChannelNr = 123...a program series (epg) asLabel.strLabel = &quot;The Simpsons&quot;LabelType = &quot;Series&quot;a TV Program (epg) asItem.strName = &quot;The Simpsons - Homer in Space&quot;Item.ParentItem = &quot;Pro 7&quot; (The Channel, maybe)LabelMap contains&nbsp; map to Channel &quot;Pro 7&quot;&nbsp; map to Series &quot;The Simpsons&quot;&nbsp; map to Artist &quot;Matt Groening&quot; (Role Author)&nbsp; map to Artist &quot;Bart Simpson&quot; (Role Actor)&nbsp; map to Directory &quot;d:\My Recordings&quot;File.strFileName = &quot;Pro7_TheSimpsons_HomerInSpace_2006010122222.dvr-ms&quot;File. (Either allready there or scheduled for recording)an Internet TV Stream asItem.strName = &quot;BBC World Stream&quot;Stream.strURL = &quot;http://bbc.co.uk/123456.123.asx&quot;LabelMap contains&nbsp; map to Country &quot;UK&quot; (Sample)a Picture Item.strName = &quot;SomePicture_002&quot;file.strFileName = &quot;SomePicture_002.jpg&quot;Directoy.str_Path = &quot;d:\My Pics\Summer of 2006&quot;LabelMap contains&nbsp; map to Directory &quot;d:\My Pics\Summer of 2006&quot;&nbsp; map to CustomLabel &quot;Holiday 2006&quot;&nbsp; map to Playlist &quot;My Summer&quot; (Role 000002)&nbsp; map to PrintedLabel &quot;Printed on 15th July 2006&quot;I guess I added most of the important types. I am willing (but time limited) to help out on this further.</blockquote>

[QUOTE="mbuzina, post: 66063, member: 12382"] This is a sample datamodel I designed which might fit the space between good enough and clean enough. [URL=http://img105.imageshack.us/my.php?image=newdatamodelmpyb9.png][img]http://img105.imageshack.us/img105/2759/newdatamodelmpyb9.th.png[/img][/URL] I would represent: an [b]artist [/b](e.g. Music or Movie) as LabelType = "Artist" Label = "R.E.M." additional info might be in the Artist Table (Biography etc.) a [b]genre [/b]as LabelType = "Genre" Label = "Grunge" ParentLabel = "Rock" (sample!) an [b]album [/b]as LabelType = "Album" Label = "Automatic for the people" ParentLabel = "R.E.M." (The Album Artist) a [b]directory [/b]as LabelType = "Directory" Label = "d:\Music\R.E.M.\Automatic for the people" Directory.strPath = "d:\Music\R.E.M.\Automatic for the people" a [b]playlist [/b]as LabelType = "Play List" Label = "My Summer" --> Might need a reference to a file as well for storage or also be an item LabelMap contains: map to song "Drive" map to picture "SomePicture_002" --> Can mix media in playlists! a [b]song [/b]as Item.strName = "Drive" File.strFileName = "01 Drive.mp3" File.idPath.strPath = "d:\Music\R.E.M.\Automatic for the people" LabelMap contains: map to Album "Automatic for the people" (Role Empty) map to Genre "Rock" (Role Empty) map to Directory "d:\Music\R.E.M.\Automatic for the people" (Role Empty) map to Artist R.E.M (Role Artist) map to Artist "Bill Berny" (Role Composer) map to Artist "Peter Buck" (Role Composer) map to Playlist "My Summer" (Role 00001), forgot to add iPosition to LabelMap a [b]movie [/b]as Item.strName = "The Rock" file.strFileName = "the_rock_cd1.iso" (File 1) file.strFileName = "the rock_cd2.iso" (File 2) LabelMap contains: map to Genre "Whatever" map to Artist "Michael Bay" (Role Director) map to Artist "Sean Connery" (Role Actor) ... a [b]TV Channel [/b]as Item.strName = "CNN International" Label.strLabel = "CNN International" LabelType = "TV Channel" Channel.iChannelNr = 123 ... a [b]program series [/b](epg) as Label.strLabel = "The Simpsons" LabelType = "Series" a [b]TV Program [/b](epg) as Item.strName = "The Simpsons - Homer in Space" Item.ParentItem = "Pro 7" (The Channel, maybe) LabelMap contains map to Channel "Pro 7" map to Series "The Simpsons" map to Artist "Matt Groening" (Role Author) map to Artist "Bart Simpson" (Role Actor) map to Directory "d:\My Recordings" File.strFileName = "Pro7_TheSimpsons_HomerInSpace_2006010122222.dvr-ms" File. (Either allready there or scheduled for recording) an [b]Internet TV [/b]Stream as Item.strName = "BBC World Stream" Stream.strURL = "http://bbc.co.uk/123456.123.asx" LabelMap contains map to Country "UK" (Sample) a [b]Picture [/b] Item.strName = "SomePicture_002" file.strFileName = "SomePicture_002.jpg" Directoy.str_Path = "d:\My Pics\Summer of 2006" LabelMap contains map to Directory "d:\My Pics\Summer of 2006" map to CustomLabel "Holiday 2006" map to Playlist "My Summer" (Role 000002) map to PrintedLabel "Printed on 15th July 2006" I guess I added most of the important types. I am willing (but time limited) to help out on this further. [/QUOTE]

Verification