BACKGROUND
Due to recent advances in technology, computer users are now able to enjoy many features that provide an improved user experience. For example, users can play media and multimedia content on various computing devices, such as personal, laptop, or handheld computers, as well as mobile phones and other portable media devices. In some media environments, a computing device has access to a computer-readable medium storing media files such as Moving Picture Experts Group audio layer-3 (MP3) files and Windows® Media technologies audio (WMA) and video (WMV) files. Many computers today are also able to play compact discs (CDs) and digital versatile discs (DVDs) and have an Internet connection capable of streaming and downloading audio and video.
In the realm of personal digital media, there may be several interesting “scopes” of media. For example, at one end of the spectrum, a user may store a personal media collection locally on one or more machines or devices. A typical user's local or personal media collection includes perhaps a few thousand media items. At the other end of the spectrum, online retailers (e.g., FYE.com), online media sources (e.g., Microsoft Corporation's MSN® Music service), and online subscription services (e.g., Napster® and RealNetwork's Rhapsody® digital music services) often have libraries of more than a million media items available to the user remotely (e.g., via the internet). A general interaction between these two scopes is to extract media from one and insert the items into the other by purchasing and/or downloading media content. But the size of the service library clearly eclipses that of the local library and the rate at which a user consumes media is relatively low when compared to the amount of media released during the same time period. In other words, far more media items are released on any given day than a single user would purchase. As such, the integration of the two scopes has been left undone. Moreover, conventional user interfaces, implementation models, and the like are also very different, which complicates the integration of local and remote media libraries.
SUMMARY
Embodiments of the invention overcome one or more deficiencies in known systems by providing a seamless user experience by which users can manage local and remote media. In this regard, users may consider both local and remote media libraries as part their own collections while retaining a clear understanding of what is local versus what is remote. Aspects of the invention provide user-friendly, content-driven access to complex remote data sources with the benefits of a local user experience. Moreover, aspects of the invention may be applied to various forms of digital media, including songs, movies, television shows, and audio books as well as physical libraries of traditional, non-digital media items such as books, physical DVD collections, and the like.
Computer-readable media having computer-executable instructions for performing methods of managing media collections embody further aspects of the invention. Alternatively, embodiments of the invention may comprise various other methods and apparatuses.
Other features will be in part apparent and in part pointed out hereinafter.
This Summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used as an aid in determining the scope of the claimed subject matter.
BRIEF DESCRIPTION OF THE DRAWINGS
FIG. 1 is a block diagram illustrating components of an exemplary computer system implementing an embodiment of the invention.
FIG. 2 is an exemplary flow diagram illustrating a catalog update process according to an embodiment of the invention.
FIG. 3A to FIG. 3F are exemplary screen shot illustrating aspects of a media player user interface according to embodiments of the invention.
FIG. 4 is an exemplary screen shot illustrating further aspects of a media player user interface according to an embodiment of the invention.
FIG. 5 is a graphical representation of an exemplary album stack according to an embodiment of the invention.
FIG. 6 is a block diagram of an exemplary data structure for use in creating intelligent playlists according to an embodiment of the invention.
Corresponding reference characters indicate corresponding parts throughout the drawings.
DETAILED DESCRIPTION
Referring now to the drawings, FIG. 1 illustrates an exemplary computing environment in which the present invention may be implemented for enhancing user media playing experience. A media player system 100 includes one or more client computers 102 coupled to a data communication network 104. One or more server computers 108 may also be coupled to the network 104. As shown in FIG. 1, the system 100 also includes one or more databases 110 associated with server 108.
In one embodiment, the computer 102 accesses the server 108 (and the information in the database 110) via network 104. As an example, network 104 is the Internet (or the World Wide Web) but the teachings of the present invention may be applied to any data communication network. Server 108 and computer 102 communicate in the illustrated embodiment using, for example, the hypertext transfer protocol (HTTP).
Aspects of the invention provide software routines that, when executed by a computer, render media content and retrieve, store, and display contextual information. Referring further to FIG. 1, the user's computer 102 accesses one or more digital media files stored in the form of a local media library 112. The local media library 112 may reside on the computer's hard drive, a removable computer-readable storage medium, or the like. In the illustrated embodiment, computer 102 executes a media player application 116 for rendering selected media files. The media player application 116 may be any suitable media player that is configured to play digital media so that a user can experience the content that is embodied on the media. For example, a media player application embodying aspects of the invention may be built on Microsoft Corporation's Windows Media™ Player program.
The media player application 116 may be configured to communicate with server 108 and its associated database 110 via network 104 to access data stored in database 110. In this instance, server 108 and database 110 constitute a media internet services site 120 that enables the user to access, retrieve, and display so-called metadata. In particular, this aspect of the invention enables media player application 116 to access, retrieve, and display metadata in conjunction with rendering media content. Those skilled in the art are familiar with metadata, which is simply information about data. In the context of the present invention, metadata includes information related to specific content of a digital media file being rendered by the media player application 116. Basic metadata includes title, composer, performer, genre, description of content, and the like. Extended metadata includes cover art, performer biographies, reviews, related performers, where to buy similar items, upcoming concerts, ticket sales, URLs to other related experiences including purchase opportunities, and the like.
In the embodiment of FIG. 1, server 108 matches the metadata stored in database 110 to the specific media content that is being experienced by the user. Server 108 then returns the metadata to the user's computer 102. In many of the examples herein, media content is described in the context of music content stored in the client computer's memory for convenience. It is to be appreciated and understood that the media content may be embodied on any suitable media, including digital files downloaded to the local memory of client computer 102 or accessible by computer 102 via network 104. The media content may include, without limitation, specially encoded media content in the form of, for example, an encoded media file such as media content encoded in Microsoft® Windows Media ™ format using the Microsoft® Windows Media™ Player program.
The system 100 of FIG. 1 permits the user to render a media file on an enabled media playing device (e.g., computer 102 running Microsoft® Windows® operating system and Windows Media™ Player program) and expect not only to experience the media content but also have access to all manner of related metadata. In addition, the user community has the ability to contribute key information such as community ratings to the process to improve the experience for other users.
Aspects of the invention also include communication between the media player application 116 executed on computer 102 with one or more remote media services 122. The remote media service 122 may be, for example, an online retailer (e.g., FYE.com), an online media source (e.g., Microsoft Corporation's MSN® Music service), or an online subscription service (e.g., Napster®) and RealNetwork's Rhapsody® digital music services). In one embodiment, remote media service 122 utilizes one or more servers for maintaining a catalog of available media files, that is, a remote library 126. Those skilled in the art are familiar with such services from which a user may download music files and/or listen to songs directly via the Internet, usually for a monthly subscription price or on a per-song basis. For example, the remote library 126 contains the inventory of an online media provider.
The exemplary operating environment illustrated in FIG. 1 includes a general purpose computing device (e.g., computing device 102) such as a computer executing computer-executable instructions. The computing device typically has at least some form of computer readable media. Computer readable media, which include both volatile and nonvolatile media, removable and non-removable media, may be any available medium that may be accessed by the general purpose computing device. By way of example and not limitation, computer readable media comprise computer storage media and communication media. Computer storage media include volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data. Communication media typically embody computer readable instructions, data structures, program modules, or other data in a modulated data signal such as a carrier wave or other transport mechanism and include any information delivery media. Those skilled in the art are familiar with the modulated data signal, which has one or more of its characteristics set or changed in such a manner as to encode information in the signal. Wired media, such as a wired network or direct-wired connection, and wireless media, such as acoustic, RF, infrared, and other wireless media, are examples of communication media. Combinations of any of the above are also included within the scope of computer readable media. The computing device includes or has access to computer storage media in the form of removable and/or non-removable, volatile and/or nonvolatile memory. A user may enter commands and information into the computing device through input devices or user interface selection devices such as a keyboard and a pointing device (e.g., a mouse, trackball, pen, or touch pad). Other input devices (not shown) may be connected to the computing device. A monitor or other type of display device (not shown) is also connected to the computing device. In addition to the monitor, computers often include other peripheral output devices (not shown) such as a printer and speakers, which may be connected through an output peripheral interface (not shown).
The computer 102 may operate in a networked environment using logical connections to one or more remote computers. The remote computer may be a personal computer, a server (e.g., servers 108, 124), a router, a network PC, a peer device or other common network node, and typically includes many or all of the elements described above relative to computer 102. Such networking environments are commonplace in offices, enterprise-wide computer networks, intranets, and global computer networks (e.g., the Internet).
Although described in connection with an exemplary computing system environment, aspects of the invention are operational with numerous other general purpose or special purpose computing system environments or configurations. The computing system environment is not intended to suggest any limitation as to the scope of use or functionality of aspects of the invention. Moreover, the computing system environment should not be interpreted as having any dependency or requirement relating to any one or combination of components illustrated in the exemplary operating environment. Examples of well known computing systems, environments, and/or configurations that may be suitable for use in embodiments of the invention include, but are not limited to, personal computers, server computers, hand-held or laptop devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics, mobile telephones, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or devices, and the like.
Embodiments of the invention may be described in the general context of computer-executable instructions, such as program modules, executed by one or more computers or other devices. Generally, program modules include, but are not limited to, routines, programs, objects, components, and data structures that perform particular tasks or implement particular abstract data types. Aspects of the invention may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
Referring further to FIG. 1, embodiments of the invention provide a relatively seamless user experience by which a user of computer 102 can manage local media (i.e., local library 112) and remotely accessible media (i.e., remote library 126). In one aspect, the user may consider both local and remote media libraries as part a personal collection while retaining a clear understanding of what is local versus what is remote. Embodiments of the invention provide user-friendly, content-driven access to complex remote data sources such as remote library 126 with the benefits of a local user experience (e.g., responsive behaviors such as searching and sorting; rich user experience constructs such as “word wheeling”, searching, sorting, large list scrolling, alternate views, and context menus; and local storage for offline use). Moreover, aspects of the invention may be applied to various forms of digital media, including audio files (e.g., music tracks, news reports, audio web logs, audio books, speeches, comedy routines, etc.), video and multimedia files (e.g., movies, movie trailers, television shows, etc.), and images. In addition, aspects of the invention may also be applied to physical libraries of traditional, non-digital media items such as books, physical DVD collections, and the like.
In one embodiment, media player system 100 implements an integrated media library system. As described above, computer 102 executes media player application 116 for rendering one or more media files. In this instance, local library 112, which may be stored on the hard drive of computer 102 or a removable storage device associated with the computer, contains one or more media files. In addition, remote library 126 contains one or more media files. Although library 126 is remote from computer 102, its media files are accessible by media player application 116 via network 104. A user interface (e.g., see FIGS. 3A-3F) displays information representative of both local library 112 and remote library 126. The media player application 116 is responsive to user input via the user interface for performing one or more media player operations on either local library 112 or remote library 126 or both.
Typical media player operations include, for example: displaying metadata associated with the media files; rendering, copying, or downloading selected media files; rendering samples of selected media files; assigning media files to one or more playlists; searching or sorting the media files according to their metadata or content; displaying media library contents; scrolling through the media library contents; and displaying contextual menus of available media player operations.
One aspect of the invention relates to a local copy 130 of the remote library 126 maintained by computer 102. In one embodiment, the local copy 130 is a compressed database or catalog representative of the remote media files accessible by computer 102 from the remote media service 122. The exemplary schema described in APPENDIX A permits relatively heavy compression of the typically large remote library 126 to permit local storage. For example, compression according to the file structure of this exemplary schema allows 1.2 million tracks of metadata to be fit into about 20 Mbytes of storage. In one embodiment, remote media service 122 generates the copy 130 of remote library 126. In the alternative, media internet service 120 may communicate with remote media service 122 to generate the copy 130 of remote library 126. APPENDIX B provides an exemplary import schema.
FIG. 2 illustrates a catalog update process according to one embodiment of the invention. As shown, media player application 116 begins by requesting a media player “Live in the Service Library” (LISL) plug-in application 132 for the current catalog 126. In turn, the plug-in 132 communicates with the back end, that is, remote media service 122 (or service 120), to obtain either a full catalog or an update. In one embodiment, the catalog server 124 maintains not only remote library 126 in its current state but also a number of previous versions. By taking N previous catalogs and applying a difference function 136, server 124 generates N difference files 138 that describe the differences between each previous catalog and the current one. The remote service 122 (or service 120) then permits the LISL plug-in 132 to download either the full catalog or difference files as appropriate. If plug-in 132 downloads the full catalog (i.e., a compressed database representative of remote library 126), plug-in 132 stores it on computer 102 and returns its location to media player application 116. On the other hand, if plug-in 132 downloads catalog updates, plug-in 132 initiates a client-side update process. In FIG. 2, the LISL plug-in 132 performs a merge function 140 on an old, out-of-date catalog 140 stored on computer 102 to add the difference files 138 and generate a new catalog 146. Following the merge, plug-in 132 updates the local catalog, shown at reference character 130, and returns its location to media player application 116.
Several beneficial aspects of the invention are described below in the context of a series of exemplary user interfaces illustrated in FIG. 3A to FIG. 3F. Generally, the user interfaces depicted in FIGS. 3A-3F are exemplary only and details of their appearance should not be construed as critical. The computer 102 is adapted for performing the media player operations and actions described herein with respect to these user interfaces, which embody aspects of the invention. The media player application 116 executed by computer 102 receives instructions and selections from the user and provided information to the user through the user interfaces.
With respect to FIG. 3A, media player application 116 displays at least one hierarchical structure representative of both local library 112 and remote library 126. For example, the hierarchical structure is an expandable and collapsible tree structure 302 that shows the files stored on the hard drive of computer 102 and another expandable and collapsible tree structure 304 showing the remote media files to which the user has access. According to aspects of the invention, the use of a compressed, locally stored database such as local copy 130 permits media player application 116 to very quickly display a listing 306 of thousands or even millions of tracks contained in remote library 126 in an integrated user interface. Instead of or in addition to the tree structures, the user interface also provides a “bread crumb” navigation bar 308 for informing the user about the location and nature of the displayed media item listing 306.
Advantageously, the user interface of FIG. 3A includes a “more info” region 310 displaying metadata, editorially-based recommendations, and the like. These editorially-based recommendations, sometimes referred to as specialty pivots, are “fresh” because they are web sourced and very fast because they are locally referenced. A middle pane 310 of the user interface displays the media item listings 306. In this embodiment, both the bread crumb bar 308 and the tree structure 304 indicate that the media files listed in the middle pane 312 are songs accessible from remote media service 122 via network 104. In addition, middle pane 312 may also display metadata such as album art, track number and name, duration, community or user ratings, artist, etc. The media file listing 306 in the middle pane 312 is consistent in user experience for both the remote media library 126 and the local library 112.
As described in greater detail below, one embodiment of the invention also includes a persistent search field 316 (see FIG. 3B) in the user interface of media player application 116 for receiving a user-entered search term for querying the compressed catalog. An aspect of this embodiment allows “word wheeling,” that is, rapidly updating search results as the user enters additional characters of the search term. With respect to “word wheeling,” a UI element such as the search field 316 or or other form of query box provides the user with instant search access to information on his or her computer as well as the Internet. In one embodiment, search field 316 uses “word wheeling” to dynamically display results in the middle pane as the user begins typing a search term. For example, as a user types “n-o-r-a-h” into the search 316 (see FIG. 3C), he or she quickly sees a list of any media files that contain the letter “n” and the search results automatically, and quickly, update as the user types additional characters; first “n”, then “no”, etc.
FIG. 3B further illustrates a basket or bin for displaying a playlist 318 of media items. Those skilled in the art are familiar with the use of playlists for ordering media files for rendering by media application 116. Advantageously, media player application 116 is responsive to user input via the user interface for performing various media player operations on one or more of the media files from either local library 112 or remote library 126 or both.
Referring to FIG. 3C, the exemplary user interface indicates by way of, for example, the tree structure 304 and the bread crumb bar 308, remote media files grouped by artist. In one embodiment, stacked album art images 320 (see also FIG. 5) in the middle pane 312 enhance the user experience. In this instance, the “more info” region 310 provides contextual information (e.g., relating to artists) such as the most downloaded artists or featured artists.
In FIG. 3C, the user in this example searched for a particular artist by typing her name into search field 316. In this instance, middle pane 312 displays the album stack 320 to corresponding to the particular artist. Clicking on album stack 320 in FIG. 3C yields a user interface such as the example shown in FIG. 3D. The search field 316 is cleared, indicating that the results are unfiltered. Here, the “more info” region 310 provides artist-specific metadata to the user and drives the local player user interface. The middle pane 312 displays all of the selected artist's albums available from remote library 126. The exemplary user interface of FIG. 3E may be reached by clicking on one of the “similar artists” from the “more info” region 310 of FIG. 3D. The bread crumb navigation bar 308 shows the user's selected similar artist. Clicking on one of the most downloaded albums for this similar artist, as shown in the “more info” region 310 of FIG. 3E, takes the user to exemplary user interface of FIG. 3F. The bread crumb bar 308 now shows the context as “album” because the user selected an album from FIG. 3E.
As shown in the exemplary user interface of FIG. 4, graphical representations or icons 326 sometimes referred to as “chicklets” may be used in the service library (i.e., remote library 126) listing 306 local ownership or other status information about the media files. In the illustrated embodiment, an action column in the library view assists the user in behaviors such as Buy, Add to library, Download, Restart download, etc. This is particularly beneficial in integrating the local and remote environments. TABLE I provides a listing of exemplary status information that may be shown in an action column.
TABLE I
|
|
StateBrowseBurnSync
|
Media in catalogDownloadBuy $xx.xxDownload
only (not local)
Media available✓ In LIbraryIf burn rights exist,If sync rights exist,
locallyitem appearsitem appears
(purchased ornormally with no icon.normally with no icon.
downloadedIf no burn right,If no sync right,
already)users get smartusers get smart
tag allowing themtag allowing them
to get more rights.to get more rights.
Currently beingIcon showsIcon showsIcon shows
downloadeddownloading.downloading.downloading.
Failed downloadRestart DownloadRestart DownloadRestart Download
IconIconIcon
Stream only, notItem appearsEntire row for theEntire row for the
purchasablenormal, no icons.item is grayed out.item is grayed out.
30 second clip onlyItem has specialEntire row for theEntire row for the
(file can't be bought,“30 second clipitem is grayed out.item is grayed out.
streamed, oronly” icon
subscribed to)
Purchase onlyBuy $xx.xxBuy $xx.xxBuy $xx.xx
|
Other user interfaces different from those described above are contemplated as within the scope of the claimed invention.
Further aspects of the invention relate to presenting specialty lists in the middle pane, “more info” region, or elsewhere in the media player UI. Instead of only showing tracks and album under an artist view, one embodiment of the invention shows the following exemplary layout. In this instance, each of these is a “container” of media (a list of sorts) and can be opened to view the contents. In other words, a particular artist may be represented in several other lists besides simply “artist” (e.g., albums, charts, Grammy award winners, featured lists, etc.).
An important mechanism to creating intelligent LISL-aware playlists is a novel naming convention employed by embodiments of the invention. For example, a playlist created from service library content has a streaming uniform resource locator (URL), a service identifier (SID), and a service name (SNAME). Playlists created by a user using local content may also be created with a local path as well as with a SID/SNAME when a match for it exists. The playlist file in one embodiment has the path used to author the playlist but the playlist resolver code may use all available IDs to resolve the media to the most suitable content (generally local media is gathered first for rendering even if it is not at the same path followed by remote media).
Yet another aspect of the invention relates to a playlist resolution algorithm for LISL playlists with streaming URLs and SID/SNAME behaviors. For example, when a playlist is created of LISL content, the playlist cannot be persisted until all of the tracks have been downloaded. If the user happens to logout (or close his or her laptop), the user would be in a position where a playlist was not created. This may not be what the user wishes to happen. Rather, the user would like for the playlist to be immediately useable for any purpose (e.g., play, burn, sync, etc.) and for this playlist to favor using media that is local over streaming media. In one embodiment, when a new playlist is created of LISL content, media player application 116 saves the playlist with the streaming URL as well as the SID and SNAME parameters. These three fields may be saved into the playlist. Download of the media in this example happens latently, on its own timeline. Due to errors, slow links, and the like, it may well be that it takes hours or days for the media to appear locally. It may even be possible (due to an excess of retry errors, user aborted downloads, etc.) that the media never downloads to the local computer 102. Upon playback of a playlist, media player application 116 is aware of the SID and SNAME fields according to an embodiment of the invention. Thus, when the SID and SNAME parameters are found, and the path component of the playlist is a web streaming URL (versus a local URL), the media player will first attempt to locate a URL that is local to the computer instead. In this way, local playback is favored over remote playback. Advantageously, the local path may be found by querying the local media player database for records that match the SID and SNAME fields in the playlist. When found, the media player will play the local media file instead of the remote media file.
In one embodiment, the integrated LISL environment permits local filtering of a similar artist list using a local LISL database (i.e., local copy 130) and a local user database (i.e., local library 112). In this regard, aspects of the invention provide highly personalized “Similar Artists” behavior without the need to expose a user's personal play or ownership information to the music service 122. For example, the “more info” region (e.g., region 310 of FIGS. 3A-3F) may show “Similar Artists” to assist the user in music discovery. All by itself, this allows a user to discover music but it does not assist the user in quickly determining which of these similar artists are already represented in the local library 112. One embodiment of the invention breaks this information into different groups, such as “Related Artists (in your library)” and “Artists to Discover (in LISL)”. In this instance, the “related artists” view shows artists that the user already has in local library 112 while the “artists to discover” view shows artists not found locally. For example, the LISL catalog represented by local copy 130 may be aware of N artists (for 1 million tracks, this is approximately 90,000 artists). For each artist, the LISL catalog would have N (e.g.: twenty to thirty artists) suggested artists, in order of similarity ranking (the first being the most similar). On the client, there may be two user experience regions for displaying the artist fields. For the “Related Artists” region, the local player code would look to the above N artists and pick those that do exist in the user's local library 112 to display. For the “Artists to Discover” region, the local player code would look to the above N artists and pick those that do not exist in the user's local library 112 to display. The net result of this is that the user can quickly hyperlink to artist they have, and artists they don't have.
FIG. 5 is a graphical representation of an exemplary album stack (e.g., album stack 320) according to an embodiment of the invention. In one embodiment, the stack 320 provides an album art for each of the albums available for a particular artist. The graphical representations uses accurate album art for each and the album art images are offset from each other to indicate the actual number of albums in the stack. In the illustrated embodiment, the album art images are slightly rotated relative to each other and aspects of the invention alpha blend the images to make them more visually appealing to the user.
Referring to FIG. 6, aspects of the invention relate to a data structure enabling intelligent playlists as described above. The data structure in one embodiment includes a playlist of media files adapted for rendering by media player application 116. In this instance, each of the media files in the playlist is located in either local library 112 or remote library 126. The data structure also includes a pair of identifiers, namely, a first identifier SID for identifying each of the media files in the playlist and a second identifier SNAME representative of a source of each of the media files in the playlist. In addition, the data structure includes a streaming locator, such as a streaming URL, for each of the media files in the playlist. The streaming locator is defined by the first and second identifiers and may be used to first locate each of the playlist media files in local library 112 for rendering before locating each of the playlist media files in remote library 126.
The order of execution or performance of the methods illustrated and described herein is not essential, unless otherwise specified. That is, it is contemplated by the inventors that elements of the methods may be performed in any order, unless otherwise specified, and that the methods may include more or less elements than those disclosed herein. For example, it is contemplated that executing or performing a particular element before, contemporaneously with, or after another element is within the scope of the invention.
When introducing elements of the present invention or the embodiments thereof, the articles “a,” “an,” “the,” and “said” are intended to mean that there are one or more of the elements. The terms “comprising,” “including,” and “having” are intended to be inclusive and mean that there may be additional elements other than the listed elements.
In view of the above, it will be seen that the several objects of the invention are achieved and other advantageous results attained.
As various changes could be made in the above constructions and methods without departing from the scope of embodiments of the invention, it is intended that all matter contained in the above description and shown in the accompanying drawings shall be interpreted as illustrative and not in a limiting sense.
|
|
TRACK
Track_ServiceIDYesIntegern
Track_AMGIDNoStrings
TrackTitleYesStrings
DurationYesInteger (inn
seconds)
TrackNumberYesInteger; 0 = undefined[0 | n]
DiscNumberYesInteger; 0 = undefined[0 | n]
TrackPriceYesString; ‘0’ = Free;[0 | $cc.cc]
NULL = Unknown
CanBuyYesBoolean[0|1]
CanStreamYesBoolean[0|1]
CanDownloadYesBoolean[0|1]
HasPreviewClipYesBoolean[0|1]
ParentalRatingYesNormal | Explicit |[N | E | C]
CleanVersion
LinkedTrackArtist_ArtistIDsYesList ofn;n;n;
Artist_ServiceID(trailing ;)
ComposerYesString“ABBA; Bono;
etc”
PopularityYesFloatn.nn
StarRatingNoFloatn.nn
Track_ServiceIDService provided ID3242424bits
namespace
Track_AMGIDAMG ID of currentT---1221Null permitted
item
TrackTitleTrack titleShe Drives Me—
Crazy
DurationTrack duration5:21—
TrackNumberTrack number3127 max track
number
DiscNumberDisc number (box0None
set) or 0 if not a
multi-disc set
TrackPriceTrack Price0.9929 possible
different
values in table
Can BuyTrack can be1—
purchased
CanStreamTrack can be0—
streamed
CanDownloadTrack can be1—
downloaded
HasPreviewClipTrack can be1—
previewed (30 s clip)
ParentalRatingParental AdvisoryE—
Rating
LinkedTrackArtiTrack or51322; 12321;—
st_ArtistIDscontributing artists2444; 55563
ComposerComposers for424; 52223Jazz/Classical
classical contentcomposers
only
PopularityPosition in list when125256Ranking;
sorted by popularityideally unique
StarRatingOptional star rating;4.21 (WMPWill be
show in UXwill round uprounded as
to 4.25)needed
ARTIST
Artist_ServiceIDYesIntegern
Artist_AMGIDNoStrings
ArtistNameYesStrings
LinkedGenreIDYesSingle GenreIDn
LinkedSimilarArtistIDsYesList ofn;n;n; (trailing
Artist_ServiceID;)
PopularityYesFloatn.nn
StarRatingNoFloatn.nn
Artist_ServiceIDService78978924bits
provided ID
namespace
Artist_AMGIDAMG IDP---23423Null permitted
of current
item
ArtistNameArtistDidoNo inline tab
displaycharacters;
nameunicode
LinkedGenreIDArtist's313Main Genre
primaryonly; not a
genresubgenre
LinkedSimilarArtistIDsOrdered31; 32; 5435; 32131; 21312Max 40 artists;
list of3; 123; 3424; 454; 534535; 3less may be
similar223423; 1232;used
artists
PopularityPosition432Ranking; ideally
in listunique
when
sorted by
popularity
StarRatingOptional4.5Will be rounded
staras needed
rating;
show in
Ux
ALBUM
Album_ServiceIDYesInteger
Album_AMGIDNoStrings
AlbumNameYesStrings
AlbumArtistYesSingleIntegerArtistServiceID
Artist_ServiceIDreference
ReleaseDateYesDateYYYY-MM-DD
AlbumPriceYesString; ‘0’ = Free;[0 | $cc.cc]
NULL = Unknown
LinkedGenreIDYesSingle—
Genre_ServiceID
LinkedSubGenreIDsYesList ofn;n;n; (trailing ;)
Subgenre_ServiceIDs
PopularityYesFloatn.nn
StarRatingNoFloatn.nn
IsRecentlyAddedYesBoolean[0|1]
IsFeaturedYesBoolean[0|1]
EditorialGlyphYesinteger = gylphID; 0 = no[0|1..7]
glyph
Album_ServiceIDService provided78945624bits
ID namespace
Album_AMGIDAMG ID of currentR---321211Null
itempermitted
AlbumNameAlbum TitleLost on my
hard drive
AlbumArtistAlbum Artist (or34332
“Various artist”,
etc)
ReleaseDateRelease Date2005-0-00 is a valid
day or
month
AlbumPriceAlbum Price12.49510
possible
different
values in
table
LinkedGenreIDPrimary Genre for12—
album
LinkedSubGenreIDsList of associtated32; 44; 663No limit; we
sub genresmay only
pick first N
PopularityPosition in list125256Ranking;
when sorted byideally
popularityunique
StarRatingOptional star3.25Will be
rating; show inrounded as
UXneeded
IsRecentlyAddedFlag to add1—
recently added
(whatever that
means to you)
IsFeaturedFlag to indicate0—
this is a featured
track (sort bias,
etc)
EditorialGlyphDisplay one of 731-7 will
possiblehave us ask
decorativeplugin for
images in UXimage
LISTS
List_ServiceIDYesIntegerInteger
ListTitleYesString // try for lesss
than 64
ListSubtitleNoString // try for lesss
than 64 —omit if
same!
ListDescriptionNoString // try for lesss
than 256
Linked_ItemTypeYesString[T | P | A | L | G|
S]
Linked_ListItemsYesList ofn;n;n; (trailing ;)
NNNNNN_ServiceID
PopularityYesFloatn.nn
StarRatingNoFloatn.nn
IsRecentlyAddedYesBoolean[0|1]
IsFeaturedYesBoolean[0|1]
EditorialGlyphYesinteger = gylphID; 0 = no[0|1..7]
glyph
List_ServiceIDService provided24bits
ID namespace
ListTitleList TitleOne Hit—
Wonders
ListSubtitleList alternate titlePeople who—
once were . . .
who are no
longer
ListDescriptionList FriendlyAll your favorite—
display textone hit wonders
of the 50's, 60's,
70's, 80's, and
90's.
Linked_ItemTypeTells us what thePTrack,
linked items arePerformer,
Album, List,
Genre,
Subgenre
Linked_ListItems12; 34; 653; 112—
PopularityPosition in list125256Ranking;
when sorted byideally
popularityunique
StarRatingOptional star3.75Will be
rating; show inrounded as
UXneeded
IsRecentlyAddedFlag to add0—
recently added
(whatever that
means to you)
IsFeaturedFlag to indicate1—
this is a featured
track (sort bias,
etc)
EditorialGlyphDisplay one of 741-7 will have
possibleus ask
decorativeplugin for
images in UXimage
GENRE
Genre_ServiceIDYesIntegern
GenreNameYesStrings
Genre_ServiceIDService provided ID1264 different
namespacegenres
GenreNameGenre displayRock—
name
SUBGENRE
SubGenre_ServiceIDYesIntegern
SubGenreNameYesStrings
SubGenreTooltipNoString // try fors
less than 64
Linked_Genre_ServiceIDYesList ofn;n;n; (trailing
Artist_ServiceID;)
SortOrderRankYesIntegern
SUBGENRE
SubGenre_ServiceIDService221024
provided IDdifferent
namespacesubgenres
SubGenreNameSubgenreBollywood—
display nameBrooklyn
SubGenreTooltipDescribe theWe have no—
meaning ofidea; let us
“Bollywoodknow if you
Brooklyn”like it
Linked_Genre_ServiceIDParent12; 32—
SortOrderRankAids is sorting2Ranking;
subgenres inideally
the UXunique
|