improving query performance

List overview All Threads
Download

newer

older

BaseX GUI: XPath suggestions /...

Re: [basex-talk] documentation flaw

Bill Osmond

21 Aug 2020 21 Aug '20

3:51 p.m.

Hi all, I'm attempting to query a fairly large database, with 136,938 resources and a size of 12,257,686,099. The basex server itself is an AWS EC2 instance with 4 cores & 16 gigs of ram, using -Xmx12g. The database contains audio DDEX information which (to me at least) is fairly complicated XML. The query I'm running against the database works and gives me the result I want, but takes upwards of 15 minutes to execute. I've taken a look at the wiki documentation regarding indexes, but it's not clear to me that any of the non-default indexes would help for the query I'm running. That query is:

declare namespace ernm="http://ddex.net/xml/ern/411";

for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording for $release in $r/ReleaseList/Release where $track_release/ReleaseLabelReference = $party/PartyReference and $track_release/ReleaseResourceReference = $sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference return <identity> <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc> <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist> <title>{ $sound_recording/DisplayTitleText/text() }</title> <album>{ $release/DisplayTitleText/text() }</album> <icpn>{ $release/ReleaseId/ICPN/text() }</icpn> <sublabel>{ $party/PartyName/FullName/text() }</sublabel> </identity>

Am I wrong, and would an additional value index help here? Or is my query just bad?

Thanks, Bill

p.s. The BaseX GUI client is awesome - especially the treemap view. Really helps with wrangling these XML files!

Attachments:

attachment.html (text/html — 2.2 KB)

Show replies by date

Bridger Dyson-Smith

21 Aug 21 Aug

4:03 p.m.

Hi Bill,

I won't claim to be any kind of query expert, but there are some things you can try to experiment with query speeds:

On Fri, Aug 21, 2020 at 3:52 PM Bill Osmond bill@with.in wrote:

...

Hi all, I'm attempting to query a fairly large database, with 136,938 resources and a size of 12,257,686,099. The basex server itself is an AWS EC2 instance with 4 cores & 16 gigs of ram, using -Xmx12g. The database contains audio DDEX information which (to me at least) is fairly complicated XML. The query I'm running against the database works and gives me the result I want, but takes upwards of 15 minutes to execute. I've taken a look at the wiki documentation regarding indexes, but it's not clear to me that any of the non-default indexes would help for the query I'm running. That query is:
declare namespace ernm="http://ddex.net/xml/ern/411";

for $r in /ernm:NewReleaseMessage
for $track_release in $r/ReleaseList/TrackRelease
for $party in $r/PartyList/Party
for $sound_recording in $r/ResourceList/SoundRecording
for $release in $r/ReleaseList/Release
where
  $track_release/ReleaseLabelReference = $party/PartyReference
  and $track_release/ReleaseResourceReference =
$sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference return <identity> <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc> <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist> <title>{ $sound_recording/DisplayTitleText/text() }</title> <album>{ $release/DisplayTitleText/text() }</album> <icpn>{ $release/ReleaseId/ICPN/text() }</icpn> <sublabel>{ $party/PartyName/FullName/text() }</sublabel> </identity>

Am I wrong, and would an additional value index help here? Or is my query just bad?

It looks like you're trying to use text values -- do you have a full range

of indexes in your database? (text, attribute, token, and maybe full text)

Also, have you tried running this query against a local instance of the database? The GUI can help steer you towards query optimizations in the Info window.

...

Thanks, Bill

p.s. The BaseX GUI client is awesome - especially the treemap view. Really helps with wrangling these XML files!

I'm crunched for time at the moment so please excuse the hasty response.

Best, Bridger

Liam R. E. Quin

4:48 p.m.

On Fri, 2020-08-21 at 12:51 -0700, Bill Osmond wrote:

...

declare namespace ernm="http://ddex.net/xml/ern/411";

for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording for $release in $r/ReleaseList/Release where $track_release/ReleaseLabelReference = $party/PartyReference and $track_release/ReleaseResourceReference = $sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/Release ResourceReference

BaseX is probably smart enough to rewrite this, but check -

for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease where $track_release/ReleaseLabelReference = $party/PartyReference

return for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording where $track_release/ReleaseResourceReference = $sound_recording/ResourceReference return for $release in $r/ReleaseList/Release where $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseRe sourceReference return <identity>...

...

Am I wrong, and would an additional value index help here? Or is my query just bad?

You're computing every possible combiation of 5 items and then filtering out the ones you want.

Filtering out earlier would probably help. Also, moving the tests least lilely to match to the outside would reduce the number of tests sooner.

A value index might well help, but as Bridger wrote, check in the gUI to see the query plan. BaseX might already be doing the sort of rewrite i suggested.

Liam

-- Liam Quin, https://www.delightfulcomputing.com/ Available for XML/Document/Information Architecture/XSLT/ XSL/XQuery/Web/Text Processing/A11Y training, work & consulting. Barefoot Web-slave, antique illustrations: http://www.fromoldbooks.org

Bill Osmond

4:52 p.m.

Thank you both! I was in the middle of typing a response to Bridger when this came through, so while I digest both of your messages & test index addition/moving things around, I'll leave the output from the GUI info panel here - if I knew how to read it, it would no doubt point straight at the issue! I'll note that it runs much quicker locally as opposed to on server+via the python BaseXClient, but I don't know if that's because the GUI is stopping at 500k results, or what.

Compiling: - rewrite context value to document-node() sequence: . -> (db:open-pre("umg-118061851424", 0), ...) - rewrite util:root(nodes) to document-node() sequence: util:root((db:open-pre("umg-118061851424", 0), ...)) -> (db:open-pre("umg-118061851424", 0), ...) - move where clause: $track_release_1/ReleaseLabelReference = $party_2/PartyReference - swap operands: PartyReference = $track_release_1/ReleaseLabelReference - rewrite to predicate: PartyReference = $track_release_1/ReleaseLabelReference - move where clause: $track_release_1/ReleaseResourceReference = $sound_recording_3/ResourceReference - swap operands: ResourceReference = $track_release_1/ReleaseResourceReference - rewrite to predicate: ResourceReference = $track_release_1/ReleaseResourceReference - swap operands: ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/Rel... - rewrite to predicate: ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/Rel... - inline for $release_4 in $r_0/ReleaseList/Release[ResourceGroup/ResourceGroup/ResourceGroupContentItem/Rele...

Optimized Query: for $r_0 in (db:open-pre("umg-118061851424", 0), ...)/ernm:NewReleaseMessage for $track_release_1 in $r_0/ReleaseList/TrackRelease for $party_2 in $r_0/PartyList/Party[PartyReference = $track_release_1/ReleaseLabelReference] for $sound_recording_3 in $r_0/ResourceList/SoundRecording[ResourceReference = $track_release_1/ReleaseResourceReference] return $r_0/ReleaseList/Release[ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/ReleaseResourceReference] ! <identity> <isrc> { $track_release_1/ReleaseId/ISRC/text() } </isrc> <artist> { string-join($sound_recording_3/DisplayArtistName, "/") } </artist> <title> { $sound_recording_3/DisplayTitleText/text() } </title> <album> { DisplayTitleText/text() } </album> <icpn> { ReleaseId/ICPN/text() } </icpn> <sublabel> { $party_2/PartyName/FullName/text() } </sublabel> </identity>

Query: declare namespace ernm="http://ddex.net/xml/ern/411"; for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording for $release in $r/ReleaseList/Release where $track_release/ReleaseLabelReference = $party/PartyReference and $track_release/ReleaseResourceReference = $sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference return <identity> <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc> <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist> <title>{ $sound_recording/DisplayTitleText/text() }</title> <album>{ $release/DisplayTitleText/text() }</album> <icpn>{ $release/ReleaseId/ICPN/text() }</icpn> <sublabel>{ $party/PartyName/FullName/text() }</sublabel> </identity>

Result: - Hit(s): 500000 Items - Updated: 0 Items - Printed: 8192 kB - Read Locking: umg-118061851424 - Write Locking: (none)

Timing: - Parsing: 2.88 ms - Compiling: 4.38 ms - Evaluating: 114935.22 ms - Printing: 114.59 ms - Total Time: 115057.07 ms

Query Plan: <QueryPlan compiled="true" updating="false"> <GFLWOR type="element()*"> <For type="element()" size="1" name="$r" id="0"> <IterPath type="element()*" database="umg-118061851424"> <DBNodeSeq type="document-node()+" size="136938" database="umg-118061851424"> <DBNode pre="0" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="59" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="118" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="177" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="236" type="document-node()" size="1" database="umg-118061851424"/> </DBNodeSeq> <IterStep axis="child" test="ernm:NewReleaseMessage" type="element()*"/> </IterPath> </For> <For type="element()" size="1" name="$track_release" id="1"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ReleaseList" type="element()*"/> <IterStep axis="child" test="TrackRelease" type="element()*"/> </IterPath> </For> <For type="element()" size="1" name="$party" id="2"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="PartyList" type="element()*"/> <IterStep axis="child" test="Party" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <SingleIterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="PartyReference" type="element()*"/> </SingleIterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseLabelReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> </For> <For type="element()" size="1" name="$sound_recording" id="3"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ResourceList" type="element()*"/> <IterStep axis="child" test="SoundRecording" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <SingleIterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="ResourceReference" type="element()*"/> </SingleIterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> </For> <DualMap type="element()*"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ReleaseList" type="element()*"/> <IterStep axis="child" test="Release" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <IterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="ResourceGroup" type="element()*"/> <IterStep axis="child" test="ResourceGroup" type="element()*"/> <IterStep axis="child" test="ResourceGroupContentItem" type="element()*"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">identity</QNm> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">isrc</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseId" type="element()*"/> <IterStep axis="child" test="ISRC" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">artist</QNm> <FnStringJoin name="string-join" type="xs:string" size="1"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$sound_recording" id="3"/> <IterStep axis="child" test="DisplayArtistName" type="element()*"/> </IterPath> <Str type="xs:string" size="1">/</Str> </FnStringJoin> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">title</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$sound_recording" id="3"/> <IterStep axis="child" test="DisplayTitleText" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">album</QNm> <IterPath type="text()*" database="umg-118061851424"> <IterStep axis="child" test="DisplayTitleText" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">icpn</QNm> <IterPath type="text()*" database="umg-118061851424"> <IterStep axis="child" test="ReleaseId" type="element()*"/> <IterStep axis="child" test="ICPN" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">sublabel</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$party" id="2"/> <IterStep axis="child" test="PartyName" type="element()*"/> <IterStep axis="child" test="FullName" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> </CElem> </DualMap> </GFLWOR> </QueryPlan>

On Fri, Aug 21, 2020 at 1:48 PM Liam R. E. Quin liam@fromoldbooks.org wrote:

...

On Fri, 2020-08-21 at 12:51 -0700, Bill Osmond wrote:

...
declare namespace ernm="http://ddex.net/xml/ern/411";

for $r in /ernm:NewReleaseMessage
for $track_release in $r/ReleaseList/TrackRelease
for $party in $r/PartyList/Party
for $sound_recording in $r/ResourceList/SoundRecording
for $release in $r/ReleaseList/Release
where
  $track_release/ReleaseLabelReference = $party/PartyReference
  and $track_release/ReleaseResourceReference =
$sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/Release ResourceReference
BaseX is probably smart enough to rewrite this, but check -

for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease where $track_release/ReleaseLabelReference = $party/PartyReference

return for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording where $track_release/ReleaseResourceReference = $sound_recording/ResourceReference return for $release in $r/ReleaseList/Release where $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseRe sourceReference return <identity>...

...
Am I wrong, and would an additional value index help here? Or is my query just bad?

You're computing every possible combiation of 5 items and then filtering out the ones you want.

Filtering out earlier would probably help. Also, moving the tests least lilely to match to the outside would reduce the number of tests sooner.

A value index might well help, but as Bridger wrote, check in the gUI to see the query plan. BaseX might already be doing the sort of rewrite i suggested.

Liam

-- Liam Quin, https://www.delightfulcomputing.com/ Available for XML/Document/Information Architecture/XSLT/ XSL/XQuery/Web/Text Processing/A11Y training, work & consulting. Barefoot Web-slave, antique illustrations: http://www.fromoldbooks.org

Bill Osmond

5:25 p.m.

The indentation levels and multiple returns in your suggested query alone has helped me in understanding what's actually going on, and I've rewritten the query mostly as you suggest:

for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease where $track_release/ReleaseLabelReference = $r/PartyList/Party/PartyReference return for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording where $track_release/ReleaseResourceReference = $sound_recording/ResourceReference return for $release in $r/ReleaseList/Release where $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference return <identity> <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc> <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist> <title>{ $sound_recording/DisplayTitleText/text() }</title> <album>{ $release/DisplayTitleText/text() }</album> <icpn>{ $release/ReleaseId/ICPN/text() }</icpn> <sublabel>{ $party/PartyName/FullName/text() }</sublabel> </identity>

I say "mostly" because at the first 'where' statement, I had to replace the $party/PartyReference on the right side of the = with an explicit reference from $r, because $party isn't defined until 2 lines further down. The query does work and appears to be giving the right results, however the performance is basically the same: 127,698.27 ms for this run vs. 114,935.22 ms for the original. I'll try shuffling things around next!

On Fri, Aug 21, 2020 at 1:52 PM Bill Osmond bill@with.in wrote:

...

Thank you both! I was in the middle of typing a response to Bridger when this came through, so while I digest both of your messages & test index addition/moving things around, I'll leave the output from the GUI info panel here - if I knew how to read it, it would no doubt point straight at the issue! I'll note that it runs much quicker locally as opposed to on server+via the python BaseXClient, but I don't know if that's because the GUI is stopping at 500k results, or what.

Compiling:

rewrite context value to document-node() sequence: . ->

(db:open-pre("umg-118061851424", 0), ...)

rewrite util:root(nodes) to document-node() sequence:

util:root((db:open-pre("umg-118061851424", 0), ...)) -> (db:open-pre("umg-118061851424", 0), ...)

move where clause: $track_release_1/ReleaseLabelReference =

$party_2/PartyReference

swap operands: PartyReference = $track_release_1/ReleaseLabelReference

rewrite to predicate: PartyReference =

$track_release_1/ReleaseLabelReference

move where clause: $track_release_1/ReleaseResourceReference =

$sound_recording_3/ResourceReference

swap operands: ResourceReference =

$track_release_1/ReleaseResourceReference

rewrite to predicate: ResourceReference =

$track_release_1/ReleaseResourceReference

swap operands:

ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/Rel...

rewrite to predicate:

ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/Rel...

inline for $release_4 in

$r_0/ReleaseList/Release[ResourceGroup/ResourceGroup/ResourceGroupContentItem/Rele...

Optimized Query: for $r_0 in (db:open-pre("umg-118061851424", 0), ...)/ernm:NewReleaseMessage for $track_release_1 in $r_0/ReleaseList/TrackRelease for $party_2 in $r_0/PartyList/Party[PartyReference = $track_release_1/ReleaseLabelReference] for $sound_recording_3 in $r_0/ResourceList/SoundRecording[ResourceReference = $track_release_1/ReleaseResourceReference] return $r_0/ReleaseList/Release[ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/ReleaseResourceReference] ! <identity> <isrc> { $track_release_1/ReleaseId/ISRC/text() } </isrc> <artist> { string-join($sound_recording_3/DisplayArtistName, "/") } </artist> <title> { $sound_recording_3/DisplayTitleText/text() } </title> <album> { DisplayTitleText/text() } </album> <icpn> { ReleaseId/ICPN/text() } </icpn> <sublabel> { $party_2/PartyName/FullName/text() } </sublabel> </identity>

Query: declare namespace ernm="http://ddex.net/xml/ern/411"; for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording for $release in $r/ReleaseList/Release where $track_release/ReleaseLabelReference = $party/PartyReference and $track_release/ReleaseResourceReference = $sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference return <identity> <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc> <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist> <title>{ $sound_recording/DisplayTitleText/text() }</title> <album>{ $release/DisplayTitleText/text() }</album> <icpn>{ $release/ReleaseId/ICPN/text() }</icpn> <sublabel>{ $party/PartyName/FullName/text() }</sublabel> </identity>

Result:

Hit(s): 500000 Items

Updated: 0 Items

Printed: 8192 kB

Read Locking: umg-118061851424

Write Locking: (none)

Timing:

Parsing: 2.88 ms

Compiling: 4.38 ms

Evaluating: 114935.22 ms

Printing: 114.59 ms

Total Time: 115057.07 ms

Query Plan:

<QueryPlan compiled="true" updating="false"> <GFLWOR type="element()*"> <For type="element()" size="1" name="$r" id="0"> <IterPath type="element()*" database="umg-118061851424"> <DBNodeSeq type="document-node()+" size="136938" database="umg-118061851424"> <DBNode pre="0" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="59" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="118" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="177" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="236" type="document-node()" size="1" database="umg-118061851424"/> </DBNodeSeq> <IterStep axis="child" test="ernm:NewReleaseMessage" type="element()*"/> </IterPath> </For> <For type="element()" size="1" name="$track_release" id="1"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ReleaseList" type="element()*"/> <IterStep axis="child" test="TrackRelease" type="element()*"/> </IterPath> </For> <For type="element()" size="1" name="$party" id="2"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="PartyList" type="element()*"/> <IterStep axis="child" test="Party" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <SingleIterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="PartyReference" type="element()*"/> </SingleIterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseLabelReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> </For> <For type="element()" size="1" name="$sound_recording" id="3"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ResourceList" type="element()*"/> <IterStep axis="child" test="SoundRecording" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <SingleIterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="ResourceReference" type="element()*"/> </SingleIterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> </For> <DualMap type="element()*"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ReleaseList" type="element()*"/> <IterStep axis="child" test="Release" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <IterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="ResourceGroup" type="element()*"/> <IterStep axis="child" test="ResourceGroup" type="element()*"/> <IterStep axis="child" test="ResourceGroupContentItem" type="element()*"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">identity</QNm> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">isrc</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseId" type="element()*"/> <IterStep axis="child" test="ISRC" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">artist</QNm> <FnStringJoin name="string-join" type="xs:string" size="1"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$sound_recording" id="3"/> <IterStep axis="child" test="DisplayArtistName" type="element()*"/> </IterPath> <Str type="xs:string" size="1">/</Str> </FnStringJoin> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">title</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$sound_recording" id="3"/> <IterStep axis="child" test="DisplayTitleText" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">album</QNm> <IterPath type="text()*" database="umg-118061851424"> <IterStep axis="child" test="DisplayTitleText" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">icpn</QNm> <IterPath type="text()*" database="umg-118061851424"> <IterStep axis="child" test="ReleaseId" type="element()*"/> <IterStep axis="child" test="ICPN" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">sublabel</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$party" id="2"/> <IterStep axis="child" test="PartyName" type="element()*"/> <IterStep axis="child" test="FullName" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> </CElem> </DualMap> </GFLWOR> </QueryPlan>

On Fri, Aug 21, 2020 at 1:48 PM Liam R. E. Quin liam@fromoldbooks.org wrote:

...
On Fri, 2020-08-21 at 12:51 -0700, Bill Osmond wrote:

...
declare namespace ernm="http://ddex.net/xml/ern/411";

for $r in /ernm:NewReleaseMessage
for $track_release in $r/ReleaseList/TrackRelease
for $party in $r/PartyList/Party
for $sound_recording in $r/ResourceList/SoundRecording
for $release in $r/ReleaseList/Release
where
  $track_release/ReleaseLabelReference = $party/PartyReference
  and $track_release/ReleaseResourceReference =
$sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/Release ResourceReference
BaseX is probably smart enough to rewrite this, but check -

for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease where $track_release/ReleaseLabelReference = $party/PartyReference

return for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording where $track_release/ReleaseResourceReference = $sound_recording/ResourceReference return for $release in $r/ReleaseList/Release where $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseRe sourceReference return <identity>...

...
Am I wrong, and would an additional value index help here? Or is my query just bad?

You're computing every possible combiation of 5 items and then filtering out the ones you want.

Filtering out earlier would probably help. Also, moving the tests least lilely to match to the outside would reduce the number of tests sooner.

A value index might well help, but as Bridger wrote, check in the gUI to see the query plan. BaseX might already be doing the sort of rewrite i suggested.

Liam

-- Liam Quin, https://www.delightfulcomputing.com/ Available for XML/Document/Information Architecture/XSLT/ XSL/XQuery/Web/Text Processing/A11Y training, work & consulting. Barefoot Web-slave, antique illustrations: http://www.fromoldbooks.org

Christian Grün

5:38 p.m.

Just a quick hint: As the query info output indicates that no text index is used (see [1]), you could try to attach explicit text() steps in your comparisons:

where $track_release/ReleaseLabelReference/text() = $r/PartyList/Party/PartyReference/text() ... where $track_release/ReleaseResourceReference/text() = $sound_recording/ResourceReference/text() ...

Feel free to provide us with a minimized XML document that allows us to run your query.

[1] https://docs.basex.org/wiki/Indexes

On Fri, Aug 21, 2020 at 11:26 PM Bill Osmond bill@with.in wrote:

...

The indentation levels and multiple returns in your suggested query alone has helped me in understanding what's actually going on, and I've rewritten the query mostly as you suggest:

for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease where $track_release/ReleaseLabelReference = $r/PartyList/Party/PartyReference return for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording where $track_release/ReleaseResourceReference = $sound_recording/ResourceReference return for $release in $r/ReleaseList/Release where $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference return

<identity> <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc> <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist> <title>{ $sound_recording/DisplayTitleText/text() }</title> <album>{ $release/DisplayTitleText/text() }</album> <icpn>{ $release/ReleaseId/ICPN/text() }</icpn> <sublabel>{ $party/PartyName/FullName/text() }</sublabel> </identity>

I say "mostly" because at the first 'where' statement, I had to replace the $party/PartyReference on the right side of the = with an explicit reference from $r, because $party isn't defined until 2 lines further down. The query does work and appears to be giving the right results, however the performance is basically the same: 127,698.27 ms for this run vs. 114,935.22 ms for the original. I'll try shuffling things around next!

On Fri, Aug 21, 2020 at 1:52 PM Bill Osmond bill@with.in wrote:

...
Thank you both! I was in the middle of typing a response to Bridger when this came through, so while I digest both of your messages & test index addition/moving things around, I'll leave the output from the GUI info panel here - if I knew how to read it, it would no doubt point straight at the issue! I'll note that it runs much quicker locally as opposed to on server+via the python BaseXClient, but I don't know if that's because the GUI is stopping at 500k results, or what.

Compiling:

rewrite context value to document-node() sequence: . -> (db:open-pre("umg-118061851424", 0), ...)

rewrite util:root(nodes) to document-node() sequence: util:root((db:open-pre("umg-118061851424", 0), ...)) -> (db:open-pre("umg-118061851424", 0), ...)

move where clause: $track_release_1/ReleaseLabelReference = $party_2/PartyReference

swap operands: PartyReference = $track_release_1/ReleaseLabelReference

rewrite to predicate: PartyReference = $track_release_1/ReleaseLabelReference

move where clause: $track_release_1/ReleaseResourceReference = $sound_recording_3/ResourceReference

swap operands: ResourceReference = $track_release_1/ReleaseResourceReference

rewrite to predicate: ResourceReference = $track_release_1/ReleaseResourceReference

swap operands: ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/Rel...

rewrite to predicate: ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/Rel...

inline for $release_4 in $r_0/ReleaseList/Release[ResourceGroup/ResourceGroup/ResourceGroupContentItem/Rele...

Optimized Query: for $r_0 in (db:open-pre("umg-118061851424", 0), ...)/ernm:NewReleaseMessage for $track_release_1 in $r_0/ReleaseList/TrackRelease for $party_2 in $r_0/PartyList/Party[PartyReference = $track_release_1/ReleaseLabelReference] for $sound_recording_3 in $r_0/ResourceList/SoundRecording[ResourceReference = $track_release_1/ReleaseResourceReference] return $r_0/ReleaseList/Release[ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference = $track_release_1/ReleaseResourceReference] ! <identity> <isrc> { $track_release_1/ReleaseId/ISRC/text() } </isrc> <artist> { string-join($sound_recording_3/DisplayArtistName, "/") } </artist> <title> { $sound_recording_3/DisplayTitleText/text() } </title> <album> { DisplayTitleText/text() } </album> <icpn> { ReleaseId/ICPN/text() } </icpn> <sublabel> { $party_2/PartyName/FullName/text() } </sublabel> </identity>

Query: declare namespace ernm="http://ddex.net/xml/ern/411"; for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording for $release in $r/ReleaseList/Release where $track_release/ReleaseLabelReference = $party/PartyReference and $track_release/ReleaseResourceReference = $sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseResourceReference return <identity> <isrc>{ $track_release/ReleaseId/ISRC/text() }</isrc> <artist>{ fn:string-join($sound_recording/DisplayArtistName, '/') }</artist> <title>{ $sound_recording/DisplayTitleText/text() }</title> <album>{ $release/DisplayTitleText/text() }</album> <icpn>{ $release/ReleaseId/ICPN/text() }</icpn> <sublabel>{ $party/PartyName/FullName/text() }</sublabel> </identity>

Result:

Hit(s): 500000 Items

Updated: 0 Items

Printed: 8192 kB

Read Locking: umg-118061851424

Write Locking: (none)

Timing:

Parsing: 2.88 ms

Compiling: 4.38 ms

Evaluating: 114935.22 ms

Printing: 114.59 ms

Total Time: 115057.07 ms

Query Plan:

<QueryPlan compiled="true" updating="false"> <GFLWOR type="element()*"> <For type="element()" size="1" name="$r" id="0"> <IterPath type="element()*" database="umg-118061851424"> <DBNodeSeq type="document-node()+" size="136938" database="umg-118061851424"> <DBNode pre="0" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="59" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="118" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="177" type="document-node()" size="1" database="umg-118061851424"/> <DBNode pre="236" type="document-node()" size="1" database="umg-118061851424"/> </DBNodeSeq> <IterStep axis="child" test="ernm:NewReleaseMessage" type="element()*"/> </IterPath> </For> <For type="element()" size="1" name="$track_release" id="1"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ReleaseList" type="element()*"/> <IterStep axis="child" test="TrackRelease" type="element()*"/> </IterPath> </For> <For type="element()" size="1" name="$party" id="2"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="PartyList" type="element()*"/> <IterStep axis="child" test="Party" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <SingleIterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="PartyReference" type="element()*"/> </SingleIterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseLabelReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> </For> <For type="element()" size="1" name="$sound_recording" id="3"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ResourceList" type="element()*"/> <IterStep axis="child" test="SoundRecording" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <SingleIterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="ResourceReference" type="element()*"/> </SingleIterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> </For> <DualMap type="element()*"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$r" id="0"/> <IterStep axis="child" test="ReleaseList" type="element()*"/> <IterStep axis="child" test="Release" type="element()*"> <CmpHashG op="=" type="xs:boolean" size="1"> <IterPath type="element()*" database="umg-118061851424"> <IterStep axis="child" test="ResourceGroup" type="element()*"/> <IterStep axis="child" test="ResourceGroup" type="element()*"/> <IterStep axis="child" test="ResourceGroupContentItem" type="element()*"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseResourceReference" type="element()*"/> </IterPath> </CmpHashG> </IterStep> </IterPath> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">identity</QNm> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">isrc</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$track_release" id="1"/> <IterStep axis="child" test="ReleaseId" type="element()*"/> <IterStep axis="child" test="ISRC" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">artist</QNm> <FnStringJoin name="string-join" type="xs:string" size="1"> <IterPath type="element()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$sound_recording" id="3"/> <IterStep axis="child" test="DisplayArtistName" type="element()*"/> </IterPath> <Str type="xs:string" size="1">/</Str> </FnStringJoin> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">title</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$sound_recording" id="3"/> <IterStep axis="child" test="DisplayTitleText" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">album</QNm> <IterPath type="text()*" database="umg-118061851424"> <IterStep axis="child" test="DisplayTitleText" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">icpn</QNm> <IterPath type="text()*" database="umg-118061851424"> <IterStep axis="child" test="ReleaseId" type="element()*"/> <IterStep axis="child" test="ICPN" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> <CElem type="element()" size="1"> <QNm type="xs:QName" size="1">sublabel</QNm> <IterPath type="text()*" database="umg-118061851424"> <VarRef type="element()" size="1" database="umg-118061851424" name="$party" id="2"/> <IterStep axis="child" test="PartyName" type="element()*"/> <IterStep axis="child" test="FullName" type="element()*"/> <IterStep axis="child" test="text()" type="text()*"/> </IterPath> </CElem> </CElem> </DualMap> </GFLWOR> </QueryPlan>

On Fri, Aug 21, 2020 at 1:48 PM Liam R. E. Quin liam@fromoldbooks.org wrote:

...
On Fri, 2020-08-21 at 12:51 -0700, Bill Osmond wrote:

...
declare namespace ernm="http://ddex.net/xml/ern/411";

for $r in /ernm:NewReleaseMessage
for $track_release in $r/ReleaseList/TrackRelease
for $party in $r/PartyList/Party
for $sound_recording in $r/ResourceList/SoundRecording
for $release in $r/ReleaseList/Release
where
  $track_release/ReleaseLabelReference = $party/PartyReference
  and $track_release/ReleaseResourceReference =
$sound_recording/ResourceReference and $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/Release ResourceReference
BaseX is probably smart enough to rewrite this, but check -

for $r in /ernm:NewReleaseMessage for $track_release in $r/ReleaseList/TrackRelease where $track_release/ReleaseLabelReference = $party/PartyReference

return for $party in $r/PartyList/Party for $sound_recording in $r/ResourceList/SoundRecording where $track_release/ReleaseResourceReference = $sound_recording/ResourceReference return for $release in $r/ReleaseList/Release where $track_release/ReleaseResourceReference = $release/ResourceGroup/ResourceGroup/ResourceGroupContentItem/ReleaseRe sourceReference return <identity>...

...
Am I wrong, and would an additional value index help here? Or is my query just bad?

You're computing every possible combiation of 5 items and then filtering out the ones you want.

Filtering out earlier would probably help. Also, moving the tests least lilely to match to the outside would reduce the number of tests sooner.

A value index might well help, but as Bridger wrote, check in the gUI to see the query plan. BaseX might already be doing the sort of rewrite i suggested.

Liam

-- Liam Quin, https://www.delightfulcomputing.com/ Available for XML/Document/Information Architecture/XSLT/ XSL/XQuery/Web/Text Processing/A11Y training, work & consulting. Barefoot Web-slave, antique illustrations: http://www.fromoldbooks.org

Bill Osmond

5:47 p.m.

Thank you for the suggestion Christian, and thank you for starting this project, which saves us from pains that we no doubt would have suffered were we to use Oracle XML DB! I'll throw explicit text() steps in, and try to reduce the number of loops I'm doing. Conceptually there are really only two loops:

"for each document, iterate over each track, and pull out all of the other information referenced by that track"

Below is a single sample document. I wish I could make it smaller, but such is the problem I'm dealing with :)

<?xml version="1.0" encoding="UTF-8"?> <ernm:NewReleaseMessage xmlns:ernm="http://ddex.net/xml/ern/411" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance" LanguageAndScriptCode="en" ReleaseProfileVersionId="Audio" xsi:schemaLocation="http://ddex.net/xml/ern/411 http://ddex.net/xml/ern/411/release-notification.xsd%22%3E <MessageHeader> <MessageThreadId>xxx</MessageThreadId> <MessageId>xxx</MessageId> <MessageSender> <PartyId>xxx</PartyId> <PartyName> <FullName>xxx</FullName> </PartyName> </MessageSender> <MessageRecipient> <PartyId>xxx</PartyId> <PartyName> <FullName>xxx</FullName> </PartyName> </MessageRecipient> <MessageCreatedDateTime>xxx</MessageCreatedDateTime> <MessageControlType>TestMessage</MessageControlType> </MessageHeader> <PartyList> <Party> <PartyReference>P1</PartyReference> <PartyName> <FullName>Sandy & Junior</FullName> <KeyName>Sandy & Junior</KeyName> </PartyName> </Party> <Party> <PartyReference>P2</PartyReference> <PartyName> <FullName>Moogie Canazio</FullName> <NamesBeforeKeyName>Moogie</NamesBeforeKeyName> <KeyName>Canazio</KeyName> </PartyName> </Party> <Party> <PartyReference>P3</PartyReference> <PartyName> <FullName>Sandy</FullName> <KeyName>Sandy</KeyName> </PartyName> </Party> <Party> <PartyReference>P4</PartyReference> <PartyName> <FullName>Junior</FullName> <KeyName>Junior</KeyName> </PartyName> </Party> <Party> <PartyReference>P5</PartyReference> <PartyName> <FullName>Liah Soares</FullName> <NamesBeforeKeyName>Liah</NamesBeforeKeyName> <KeyName>Soares</KeyName> </PartyName> </Party> <Party> <PartyReference>P6</PartyReference> <PartyName> <FullName>Márcio Cruz</FullName> <NamesBeforeKeyName>Márcio</NamesBeforeKeyName> <KeyName>Cruz</KeyName> </PartyName> </Party> <Party> <PartyReference>P7</PartyReference> <PartyName> <FullName>Pedro Barezzi</FullName> <NamesBeforeKeyName>Pedro</NamesBeforeKeyName> <KeyName>Barezzi</KeyName> </PartyName> </Party> <Party> <PartyReference>P8</PartyReference> <PartyName> <FullName>Danimar</FullName> <KeyName>Danimar</KeyName> </PartyName> </Party> <Party> <PartyReference>P9</PartyReference> <PartyName> <FullName>Junior</FullName> <KeyName>Junior</KeyName> </PartyName> </Party> <Party> <PartyReference>P10</PartyReference> <PartyName> <FullName>John Ondrasik</FullName> <NamesBeforeKeyName>John</NamesBeforeKeyName> <KeyName>Ondrasik</KeyName> </PartyName> </Party> <Party> <PartyReference>P11</PartyReference> <PartyName> <FullName>Mauricio Gaetani</FullName> <NamesBeforeKeyName>Mauricio</NamesBeforeKeyName> <KeyName>Gaetani</KeyName> </PartyName> </Party> <Party> <PartyReference>P12</PartyReference> <PartyName> <FullName>Otavio De Moraes</FullName> <NamesBeforeKeyName>Otavio De</NamesBeforeKeyName> <KeyName>Moraes</KeyName> </PartyName> </Party> <Party> <PartyReference>P13</PartyReference> <PartyName> <FullName>Francesco Boccia</FullName> <NamesBeforeKeyName>Francesco</NamesBeforeKeyName> <KeyName>Boccia</KeyName> </PartyName> </Party> <Party> <PartyReference>P14</PartyReference> <PartyName> <FullName>Gianfranco Calliendo</FullName> <NamesBeforeKeyName>Gianfranco</NamesBeforeKeyName> <KeyName>Calliendo</KeyName> </PartyName> </Party> <Party> <PartyReference>P15</PartyReference> <PartyName> <FullName>Ciro Esposito</FullName> <NamesBeforeKeyName>Ciro</NamesBeforeKeyName> <KeyName>Esposito</KeyName> </PartyName> </Party> <Party> <PartyReference>P16</PartyReference> <PartyName> <FullName>Ricardo Moreira</FullName> <NamesBeforeKeyName>Ricardo</NamesBeforeKeyName> <KeyName>Moreira</KeyName> </PartyName> </Party> <Party> <PartyReference>P17</PartyReference> <PartyName> <FullName>Alanis Morissette</FullName> <NamesBeforeKeyName>Alanis</NamesBeforeKeyName> <KeyName>Morissette</KeyName> </PartyName> </Party> <Party> <PartyReference>P18</PartyReference> <PartyName> <FullName>Roberto Carlos</FullName> <NamesBeforeKeyName>Roberto</NamesBeforeKeyName> <KeyName>Carlos</KeyName> </PartyName> </Party> <Party> <PartyReference>P19</PartyReference> <PartyName> <FullName>Sandy</FullName> <KeyName>Sandy</KeyName> </PartyName> </Party> <Party> <PartyReference>P20</PartyReference> <PartyName> <FullName>Guilherme Lamounier</FullName> <NamesBeforeKeyName>Guilherme</NamesBeforeKeyName> <KeyName>Lamounier</KeyName> </PartyName> </Party> <Party> <PartyReference>P21</PartyReference> <PartyName> <FullName>Nando</FullName> <KeyName>Nando</KeyName> </PartyName> </Party> <Party> <PartyReference>P22</PartyReference> <PartyName> <FullName>Kiko</FullName> <KeyName>Kiko</KeyName> </PartyName> </Party> <Party> <PartyReference>P23</PartyReference> <PartyName> <FullName>Ricardo Feghali</FullName> <NamesBeforeKeyName>Ricardo</NamesBeforeKeyName> <KeyName>Feghali</KeyName> </PartyName> </Party> <Party> <PartyReference>P24</PartyReference> <PartyName> <FullName>Per Nylen</FullName> <NamesBeforeKeyName>Per</NamesBeforeKeyName> <KeyName>Nylen</KeyName> </PartyName> </Party> <Party> <PartyReference>P25</PartyReference> <PartyName> <FullName>Andreas Carlsson</FullName> <NamesBeforeKeyName>Andreas</NamesBeforeKeyName> <KeyName>Carlsson</KeyName> </PartyName> </Party> <Party> <PartyReference>P26</PartyReference> <PartyName> <FullName>Julie Morrison</FullName> <NamesBeforeKeyName>Julie</NamesBeforeKeyName> <KeyName>Morrison</KeyName> </PartyName> </Party> <Party> <PartyReference>P27</PartyReference> <PartyName> <FullName>Jane Vaughn</FullName> <KeyName>Jane Vaughn</KeyName> </PartyName> </Party> <Party> <PartyReference>P28</PartyReference> <PartyName> <FullName>Karsten Dahlgaard</FullName> <NamesBeforeKeyName>Karsten</NamesBeforeKeyName> <KeyName>Dahlgaard</KeyName> </PartyName> </Party> <Party> <PartyReference>P29</PartyReference> <PartyName> <FullName>Johnny Pedersen</FullName> <NamesBeforeKeyName>Johnny</NamesBeforeKeyName> <KeyName>Pedersen</KeyName> </PartyName> </Party> <Party> <PartyReference>P30</PartyReference> <PartyName> <FullName>Milton Guedes</FullName> <NamesBeforeKeyName>Milton</NamesBeforeKeyName> <KeyName>Guedes</KeyName> </PartyName> </Party> <Party> <PartyReference>P31</PartyReference> <PartyName> <FullName>Paulinho Galvão</FullName> <NamesBeforeKeyName>Paulinho</NamesBeforeKeyName> <KeyName>Galvão</KeyName> </PartyName> </Party> <Party> <PartyReference>P32</PartyReference> <PartyName> <FullName>Lloyd "Gitsy" Oliver Willis</FullName> <NamesBeforeKeyName>Lloyd "Gitsy" Oliver</NamesBeforeKeyName> <KeyName>Willis</KeyName> </PartyName> </Party> <Party> <PartyReference>P33</PartyReference> <PartyName> <FullName>Robbie Shakespeare</FullName> <NamesBeforeKeyName>Robbie</NamesBeforeKeyName> <KeyName>Shakespeare</KeyName> </PartyName> </Party> <Party> <PartyReference>P34</PartyReference> <PartyName> <FullName>Everton Bonner</FullName> <NamesBeforeKeyName>Everton</NamesBeforeKeyName> <KeyName>Bonner</KeyName> </PartyName> </Party> <Party> <PartyReference>P35</PartyReference> <PartyName> <FullName>Joseph Bonner</FullName> <NamesBeforeKeyName>Joseph</NamesBeforeKeyName> <KeyName>Bonner</KeyName> </PartyName> </Party> <Party> <PartyReference>P36</PartyReference> <PartyName> <FullName>John Taylor</FullName> <NamesBeforeKeyName>John</NamesBeforeKeyName> <KeyName>Taylor</KeyName> </PartyName> </Party> <Party> <PartyReference>P37</PartyReference> <PartyName> <FullName>Sly Dunbar</FullName> <NamesBeforeKeyName>Sly</NamesBeforeKeyName> <KeyName>Dunbar</KeyName> </PartyName> </Party> <Party> <PartyReference>P38</PartyReference> <PartyName> <FullName>Pedro Abrunhosa</FullName> <NamesBeforeKeyName>Pedro</NamesBeforeKeyName> <KeyName>Abrunhosa</KeyName> </PartyName> </Party> <Party> <PartyReference>P39</PartyReference> <PartyName> <FullName>Universal Music International Ltda.</FullName> </PartyName> </Party> </PartyList> <ResourceList> <SoundRecording> <ResourceReference>A1</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200733</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Não Dá Pra Não Pensar</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Não Dá Pra Não Pensar</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Não Dá Pra Não Pensar</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M50S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T15</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M50.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T15_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>D0DA7A0C4FBB86CFF71FE185E7D04EDB</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A2</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200734</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Nada É Por Acaso</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Nada É Por Acaso</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Nada É Por Acaso</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P5</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="5"> <ContributorPartyReference>P6</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="6"> <ContributorPartyReference>P7</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="7"> <ContributorPartyReference>P8</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M21S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T14</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M21.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T14_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>0D7EE7708A5CE62C75CBB9B5754C1B4D</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A3</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200724</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Super-Herói (Não É Fácil)</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Super-Herói (Não É Fácil)</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Super-Herói (Não É Fácil)</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P9</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P10</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="5"> <ContributorPartyReference>P11</ContributorPartyReference> <Role>Translator</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M14S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T13</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M13.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T13_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>E3EAC70ED4B59307191AE87D80084548</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A4</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200744</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Deixa Eu Tentar</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Deixa Eu Tentar</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Deixa Eu Tentar</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P12</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M53S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T12</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M53.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T12_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>764951DA059C70123A726D329FF5462A</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A5</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200735</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Quando Você Passa (Turu Turu)</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Quando Você Passa (Turu Turu)</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Quando Você Passa (Turu Turu)</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P13</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="5"> <ContributorPartyReference>P14</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="6"> <ContributorPartyReference>P15</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="7"> <ContributorPartyReference>P16</ContributorPartyReference> <Role>Translator</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT3M52S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T11</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H3M51.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T11_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>C037C6F6579786DA17817D2CA43975E5</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A6</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200743</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Uninvited</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Uninvited</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Uninvited</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P17</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M47S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>en</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T10</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M46.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T10_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>D6B0CC56A1FE3B1953C78786D933058B</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A7</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200725</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Como É Grande O Meu Amor Por Você</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Como É Grande O Meu Amor Por Você</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Como É Grande O Meu Amor Por Você</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P18</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT2M50S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T9</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H2M49.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T9_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>7E752408F66B43CBE9EBA14B59A52BF8</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A8</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200736</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Enrosca</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Enrosca</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Enrosca</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P19</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P20</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT3M32S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T8</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H3M31.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T8_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>C0657E94D28F126B6A8796425B2CFC5B</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A9</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200737</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">A Lenda</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>A Lenda</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>A Lenda</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P21</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="5"> <ContributorPartyReference>P22</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="6"> <ContributorPartyReference>P23</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M38S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T7</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M37.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T7_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>BE335EAE070F07470B785ABA05451BE6</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A10</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200738</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Words Are Not Enough</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Words Are Not Enough</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Words Are Not Enough</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P24</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="5"> <ContributorPartyReference>P25</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT3M34S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>en</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T6</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H3M34.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T6_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>4EDBF599C3C2876D83B0AF877AF7577D</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A11</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200739</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Love Never Fails</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Love Never Fails</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Love Never Fails</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P26</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="5"> <ContributorPartyReference>P27</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="6"> <ContributorPartyReference>P28</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="7"> <ContributorPartyReference>P29</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M10S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>en</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T5</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M10.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T5_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>23A44A17289D6CC6796998DE5081E465</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A12</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200740</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">O Amor Faz</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>O Amor Faz</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>O Amor Faz</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P11</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M36S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T4</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M35.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T4_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>DFF2D6AEC7D87F8D4D317B1372D4CC97</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A13</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200741</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">A Gente Dá Certo</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>A Gente Dá Certo</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>A Gente Dá Certo</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P30</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT4M17S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T3</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H4M17.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T3_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>C83A3CE4AAD1F3E4407E6CEA7C892B12</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <SoundRecording> <ResourceReference>A14</ResourceReference> <Type>MusicalWorkSoundRecording</Type> <ResourceId> <ISRC>BRMCA0200742</ISRC> </ResourceId> <DisplayTitleText IsDefault="true">Cai A Chuva / Me Diz / Citação: Não Posso Mais</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Cai A Chuva / Me Diz / Citação: Não Posso Mais</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Cai A Chuva / Me Diz / Citação: Não Posso Mais</TitleText> <SubTitle>Ao Vivo No Rio De Janeiro / 2002</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <Contributor SequenceNumber="1"> <ContributorPartyReference>P2</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Producer">UserDefined</Role> </Contributor> <Contributor SequenceNumber="2"> <ContributorPartyReference>P3</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="3"> <ContributorPartyReference>P4</ContributorPartyReference> <Role>AssociatedPerformer</Role> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="Vocalist">UserDefined</Role> </Contributor> <Contributor SequenceNumber="4"> <ContributorPartyReference>P30</ContributorPartyReference> <Role>ComposerLyricist</Role> <Role>Translator</Role> </Contributor> <Contributor SequenceNumber="5"> <ContributorPartyReference>P31</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="6"> <ContributorPartyReference>P32</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="7"> <ContributorPartyReference>P33</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="8"> <ContributorPartyReference>P34</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="9"> <ContributorPartyReference>P35</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="10"> <ContributorPartyReference>P36</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="11"> <ContributorPartyReference>P37</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <Contributor SequenceNumber="12"> <ContributorPartyReference>P38</ContributorPartyReference> <Role>ComposerLyricist</Role> </Contributor> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music International</PLineCompany> <PLineText>℗ 2002 Universal Music International</PLineText> </PLine> <Duration>PT5M14S</Duration> <CreationDate ApplicableTerritoryCode="BR" LocationDescription="Maracanã, Rio de Janeiro (RJ)">2002-10-12 </CreationDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <LanguageOfPerformance>pt</LanguageOfPerformance> <TechnicalDetails>

<TechnicalResourceDetailsReference>T2</TechnicalResourceDetailsReference> <AudioCodecType>FLAC</AudioCodecType> <NumberOfChannels>2</NumberOfChannels> <SamplingRate UnitOfMeasure="kHz">44.1</SamplingRate> <BitsPerSample>16</BitsPerSample> <Duration>PT0H5M13.000S</Duration> <IsPreview>false</IsPreview> <File> <URI>00044006704722_T2_audtrk.flac</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>5DC6BD4B66CE9AC8376210A3D497605A</HashSumValue> </HashSum> </File> </TechnicalDetails> </SoundRecording> <Image> <ResourceReference>A15</ResourceReference> <Type>FrontCoverImage</Type> <ResourceId> <ProprietaryId Namespace="DPID:PADPIDA2013042401U">06UMGIM33173</ProprietaryId> </ResourceId> <DisplayTitleText IsDefault="true">Sandy & Júnior Ao Vivo No Maracanã</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Sandy & Júnior Ao Vivo No Maracanã</TitleText> <SubTitle>Ao Vivo</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Sandy & Júnior Ao Vivo No Maracanã</TitleText> <SubTitle>Ao Vivo</SubTitle> </AdditionalTitle> <Contributor SequenceNumber="1"> <ContributorPartyReference>P1</ContributorPartyReference> <Role Namespace="DPID:PADPIDA2013042401U" UserDefinedValue="MainArtist">UserDefined</Role> </Contributor> <CLine IsDefault="true"> <Year>2002</Year> <CLineCompany>Universal Music International</CLineCompany> <CLineText>© 2002 Universal Music International</CLineText> </CLine> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <TechnicalDetails>

<TechnicalResourceDetailsReference>T1</TechnicalResourceDetailsReference> <ImageCodecType>JPEG</ImageCodecType> <ImageHeight UnitOfMeasure="Pixel">1408</ImageHeight> <ImageWidth UnitOfMeasure="Pixel">1422</ImageWidth> <File> <URI>06UMGIM33173_T1_cvrart.jpg</URI> <HashSum> <Algorithm>MD5</Algorithm>

<HashSumValue>f6b0cdeaff97c8c438f940a12f3060c3</HashSumValue> </HashSum> </File> </TechnicalDetails> </Image> </ResourceList> <ReleaseList> <Release> <ReleaseReference>R0</ReleaseReference> <ReleaseType>Album</ReleaseType> <ReleaseId> <ICPN>00044006704722</ICPN> </ReleaseId> <DisplayTitleText IsDefault="true">Ao Vivo No Maracanã</DisplayTitleText> <DisplayTitle IsDefault="true"> <TitleText>Ao Vivo No Maracanã</TitleText> <SubTitle>Ao Vivo</SubTitle> </DisplayTitle> <AdditionalTitle IsDefault="true" TitleType="FormalTitle"> <TitleText>Ao Vivo No Maracanã</TitleText> <SubTitle>Ao Vivo</SubTitle> </AdditionalTitle> <DisplayArtistName IsDefault="true">Sandy & Junior</DisplayArtistName> <DisplayArtist SequenceNumber="1"> <ArtistPartyReference>P1</ArtistPartyReference> <DisplayArtistRole>MainArtist</DisplayArtistRole> </DisplayArtist> <ReleaseLabelReference IsDefault="true">P39</ReleaseLabelReference> <PLine IsDefault="true"> <Year>2002</Year> <PLineCompany>Universal Music Ltda</PLineCompany> <PLineText>℗ 2002 Universal Music Ltda</PLineText> </PLine> <CLine IsDefault="true"> <Year>2002</Year> <CLineCompany>Universal Music Ltda</CLineCompany> <CLineText>© 2002 Universal Music Ltda</CLineText> </CLine> <Duration>PT59M47S</Duration> <Genre IsDefault="true"> <GenreText>Pop</GenreText> </Genre> <ReleaseDate IsDefault="true">2006-03-07</ReleaseDate> <OriginalReleaseDate IsDefault="true">2002-01-01</OriginalReleaseDate> <ParentalWarningType IsDefault="true">NotExplicit</ParentalWarningType> <IsMultiArtistCompilation>false</IsMultiArtistCompilation> <ResourceGroup> <ResourceGroup ResourceGroupType="Component"> <SequenceNumber>1</SequenceNumber> <ResourceGroupContentItem> <SequenceNumber>1</SequenceNumber>