Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How do I use DTD's with XML DB ?

mdrake-OracleAug 24 2006 — edited Aug 24 2006
Assume I have an XML document containing a DOCTYPE that looks like this...
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> 
<plist version="1.0">
<dict>
	<key>Major Version</key><integer>1</integer>
	<key>Minor Version</key><integer>1</integer>
	<key>Application Version</key><string>6.0.5</string>
	<key>Features</key><integer>1</integer>
	<key>Music Folder</key><string>file://localhost/C:/My%20Documents/My%20Music/iTunes/iTunes%20Music/</string>
	<key>Library Persistent ID</key><string>08072423C5C39B39</string>
	<key>Tracks</key>
	<dict>
		<key>113</key>
		<dict>
			<key>Track ID</key><integer>113</integer>
			<key>Name</key><string>Speak to Me/Breathe in the Air</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Nick Mason/Richard Wright/Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>9500202</integer>
			<key>Total Time</key><integer>237479</integer>
			<key>Track Number</key><integer>1</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:06:59Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B48</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/01%20Speak%20to%20Me-Breathe%20in%20the%20Air.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>115</key>
		<dict>
			<key>Track ID</key><integer>115</integer>
			<key>Name</key><string>On the Run</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>8480282</integer>
			<key>Total Time</key><integer>211983</integer>
			<key>Track Number</key><integer>2</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:06:59Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B49</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/02%20On%20the%20Run.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>117</key>
		<dict>
			<key>Track ID</key><integer>117</integer>
			<key>Name</key><string>Time</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Nick Mason/Richard Wright/Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>17007482</integer>
			<key>Total Time</key><integer>425168</integer>
			<key>Track Number</key><integer>3</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:06:59Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4A</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/03%20Time.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>119</key>
		<dict>
			<key>Track ID</key><integer>119</integer>
			<key>Name</key><string>The Great Gig in the Sky</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Richard Wright</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>11484657</integer>
			<key>Total Time</key><integer>287085</integer>
			<key>Track Number</key><integer>4</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:06:59Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4B</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/04%20The%20Great%20Gig%20in%20the%20Sky.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>121</key>
		<dict>
			<key>Track ID</key><integer>121</integer>
			<key>Name</key><string>Money</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>15343842</integer>
			<key>Total Time</key><integer>383582</integer>
			<key>Track Number</key><integer>5</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4C</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/05%20Money.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>123</key>
		<dict>
			<key>Track ID</key><integer>123</integer>
			<key>Name</key><string>Us and Them</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Richard Wright/Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>18756812</integer>
			<key>Total Time</key><integer>468897</integer>
			<key>Track Number</key><integer>6</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4D</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/06%20Us%20and%20Them.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>125</key>
		<dict>
			<key>Track ID</key><integer>125</integer>
			<key>Name</key><string>Any Colour You Like</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Nick Mason/Richard Wright</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>8225302</integer>
			<key>Total Time</key><integer>205609</integer>
			<key>Track Number</key><integer>7</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4E</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/07%20Any%20Colour%20You%20Like.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>127</key>
		<dict>
			<key>Track ID</key><integer>127</integer>
			<key>Name</key><string>Brain Damage</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>9219097</integer>
			<key>Total Time</key><integer>230452</integer>
			<key>Track Number</key><integer>8</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B4F</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/08%20Brain%20Damage.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>129</key>
		<dict>
			<key>Track ID</key><integer>129</integer>
			<key>Name</key><string>Eclipse</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Dark Side of the Moon</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>5067312</integer>
			<key>Total Time</key><integer>126667</integer>
			<key>Track Number</key><integer>9</integer>
			<key>Year</key><integer>1973</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:00Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:26Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B50</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Dark%20Side%20of%20the%20Moon/09%20Eclipse.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>157</key>
		<dict>
			<key>Track ID</key><integer>157</integer>
			<key>Name</key><string>Shine on You Crazy Diamond, Pts. 1-5</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Richard Wright/Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>32523642</integer>
			<key>Total Time</key><integer>813061</integer>
			<key>Track Number</key><integer>1</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B51</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/01%20Shine%20on%20You%20Crazy%20Diamond,%20Pts.%201-5.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>159</key>
		<dict>
			<key>Track ID</key><integer>159</integer>
			<key>Name</key><string>Welcome to the Machine</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>17855766</integer>
			<key>Total Time</key><integer>446380</integer>
			<key>Track Number</key><integer>2</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B52</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/02%20Welcome%20to%20the%20Machine.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>161</key>
		<dict>
			<key>Track ID</key><integer>161</integer>
			<key>Name</key><string>Have a Cigar</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>12320401</integer>
			<key>Total Time</key><integer>307983</integer>
			<key>Track Number</key><integer>3</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B53</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/03%20Have%20a%20Cigar.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>163</key>
		<dict>
			<key>Track ID</key><integer>163</integer>
			<key>Name</key><string>Wish You Were Here</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>13609931</integer>
			<key>Total Time</key><integer>340218</integer>
			<key>Track Number</key><integer>4</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B54</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/04%20Wish%20You%20Were%20Here.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
		<key>165</key>
		<dict>
			<key>Track ID</key><integer>165</integer>
			<key>Name</key><string>Shine on You Crazy Diamond, Pts. 6-9</string>
			<key>Artist</key><string>Pink Floyd</string>
			<key>Composer</key><string>David Gilmour/Richard Wright/Roger Waters</string>
			<key>Album</key><string>Wish You Were Here</string>
			<key>Genre</key><string>Rock</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>29708412</integer>
			<key>Total Time</key><integer>742687</integer>
			<key>Track Number</key><integer>5</integer>
			<key>Year</key><integer>1975</integer>
			<key>Date Modified</key><date>2006-03-09T22:07:14Z</date>
			<key>Date Added</key><date>2006-08-24T05:24:33Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Persistent ID</key><string>08072423C5C39B55</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file://localhost/C:/My%20Documents/My%20Music/Pink%20Floyd/Wish%20You%20Were%20Here/05%20Shine%20on%20You%20Crazy%20Diamond,%20Pts.%206-9.mp3</string>
			<key>File Folder Count</key><integer>-1</integer>
			<key>Library Folder Count</key><integer>-1</integer>
		</dict>
	</dict>
	<key>Playlists</key>
	<array>
		<dict>
			<key>Name</key><string>Library</string>
			<key>Master</key><true/>
			<key>Playlist ID</key><integer>37</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3A</string>
			<key>All Items</key><true/>
			<key>Playlist Items</key>
			<array>
				<dict>
					<key>Track ID</key><integer>113</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>115</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>117</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>119</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>121</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>123</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>125</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>127</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>129</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>157</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>159</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>161</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>163</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>165</integer>
				</dict>
			</array>
		</dict>
		<dict>
			<key>Name</key><string>90’s Music</string>
			<key>Playlist ID</key><integer>40</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3B</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQEAAwAAAAIAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAcAAAEAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABEAAAAAAAAB8YAAAAAAAAAAAAAAAAAAAAB
			AAAAAAAAB88AAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAA=
			</data>
		</dict>
		<dict>
			<key>Name</key><string>My Top Rated</string>
			<key>Playlist ID</key><integer>43</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3C</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQEAAwAAAAIAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABkAAAAQAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABEAAAAAAAAADwAAAAAAAAAAAAAAAAAAAAB
			AAAAAAAAADwAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAA=
			</data>
		</dict>
		<dict>
			<key>Name</key><string>Party Shuffle</string>
			<key>Playlist ID</key><integer>61</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B40</string>
			<key>Party Shuffle</key><true/>
			<key>All Items</key><true/>
			<key>Playlist Items</key>
			<array>
				<dict>
					<key>Track ID</key><integer>115</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>125</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>129</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>123</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>127</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>117</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>113</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>119</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>121</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>123</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>125</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>113</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>127</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>115</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>119</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>129</integer>
				</dict>
			</array>
		</dict>
		<dict>
			<key>Name</key><string>Podcasts</string>
			<key>Playlist ID</key><integer>64</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B41</string>
			<key>Podcasts</key><true/>
			<key>All Items</key><true/>
		</dict>
		<dict>
			<key>Name</key><string>Recently Added</string>
			<key>Playlist ID</key><integer>52</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3F</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQEAAwAAAAIAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAIAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABELa4tri2uLa7//////////gAAAAAACTqA
			La4tri2uLa4AAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAA=
			</data>
			<key>Playlist Items</key>
			<array>
				<dict>
					<key>Track ID</key><integer>113</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>115</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>117</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>119</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>121</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>123</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>125</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>127</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>129</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>157</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>159</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>161</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>163</integer>
				</dict>
				<dict>
					<key>Track ID</key><integer>165</integer>
				</dict>
			</array>
		</dict>
		<dict>
			<key>Name</key><string>Recently Played</string>
			<key>Playlist ID</key><integer>49</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3E</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQEAAwAAAAIAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABcAAAIAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABELa4tri2uLa7//////////gAAAAAACTqA
			La4tri2uLa4AAAAAAAAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAA=
			</data>
		</dict>
		<dict>
			<key>Name</key><string>Top 25 Most Played</string>
			<key>Playlist ID</key><integer>46</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B3D</string>
			<key>All Items</key><true/>
			<key>Smart Info</key>
			<data>
			AQABAwAAABkAAAAZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAA==
			</data>
			<key>Smart Criteria</key>
			<data>
			U0xzdAABAAEAAAABAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQBAAACAAAAAAAAAAAAAAAAAAAAAAAA
			AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
			</data>
		</dict>
		<dict>
			<key>Name</key><string>Videos</string>
			<key>Playlist ID</key><integer>67</integer>
			<key>Playlist Persistent ID</key><string>08072423C5C39B42</string>
			<key>All Items</key><true/>
			<key>Videos</key><true/>
		</dict>
	</array>
</dict>
</plist>
For those who are interested it's a Libary.xml generated when you export your library from Apple's iTunes

Comments

Mannamal-Oracle
We are planning direct SPARQL support, but for now the options are exactly what you say - use products from partners like Metatomix or TopQuadrant who support a SPARQL interface to a backend Oracle RDF data store.

We also have an integration with the open source Jena, through which SPARQL queries can be issued against an Oracle RDF store. The integration for Jena requires the Oracle Jena Adaptor (see 586398 for downloading and using the adaptor).

Melli
222378
Thank you for the reponse.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 21 2006
Added on Aug 24 2006
#performance-availability, #xml-db
4 comments
12,232 views