#musicbrainz

the hard thing is figuring out what really needs to be done.

people will scream for everything all the time.

I've personally never seen a box set of a sets that is identifiable on it's own (e.g. by EAN or catalog number)

I meant to type 'creams' there

nikki: And yeah, I think that's ugly as hell, isn't really logical, and now we have multiple copies of AC/DC albums where the only difference is that one's named after a box set and the other one's not.

luks: now the question is this: Can we come up with some sort of schema that uses our current schema and adds the BBC's CI while taking us a step towards NGS>

ruaok: if I understand what they mean by CI, then yes

luks: would you do me a favor and sketch out how you see that could be done?

hmm... guess it depends exactly what you mean by it, I guess the box would have a barcode, the discs within the box set have catalogue numbers

then we could take that fluff it up and toss it over to the BBC as a first stab at defining it and seeing if it fits their needs....

nikki: yes, but you said you have a box set that includes box sets

srotta: i think that's part of a larger problem, there are many other reasons to duplicate a release with the current schema. and _that_ is the problem.

nikki: does the top level box set have a catalog number?

nikki: in my experience is just a package to sell more items at once

ruaok: I'd simply take the part of http://users.musicbrainz.org/~luks/ngs3.png from medium to right bottom

ruaok: ignoring artist changes, ignoring track changes

luks: i think the brilliant classics Bach Edition qualifies.

including the label changes?

technically there are no label changes

well technically I do, I just don't have the key to open the box handy

except for separating the label and labelname tables?

yep

which isn't really that useful for labels

so then medium would connect to our current album?

The whole box set thing is sort of a mystery to me, particularly the way it's documented and how it's implemented in edits, in practice. For example, me and inhouseuk have some differing views about an Elton John album (http://musicbrainz.org/show/edit/?editid=9432442)

luks: the whole thing is one box with 155 cds in it, barcode and catalog. but the box has also been released in seperate volumes. Same music content, but the package uses a different volume/disc numbering scheme.

ruaok: I'd like album AND tracklist to be the current album. album would take the meta data, tracklist would take the list of tracks and discids

ruaok: er, sorry, I meant from tracklist to right buttom

ah.

and that would then essentially replace the album and release tables?

albumjoin would be where tracklisttrack is now?

yes

I think that is imminenty doable.

and I think the BBC will likely be ok with that.

release technically stays untouched, except it has a title and multiple catalog numbers instead of one

would it make sense to do albumtitle in this round or wait til next?

and the release.gid == summit8.PackageId ?

every release needs a title, so either we have heavily duplicated data or we separate albumtitle from album

one go sounds smarter

ok, I think I grok.

thats a perfect sized chunk for an intermediary step.

and from the looks of it artistcredit might make another one.'

I had one idea about how the *title/name tables are handled, but I want to benchmark it before

in my current schema they are bound to artist/album, the idea was to move the link to artist/album to artistcreditname and release

that would mean less text duplication in albumtitle, but a little more data in release

it would also mean a direct link from release to album

currently it can save ~100k album titles

thats a significant change on the CI proposal, no?

how much effort to benchmark that?

not really, I'd say it's just a technical detail

the core schema is still the same

granted, but its a decision we need to make before we start on CI

yes

how will you benchmark that?

implementing both in postgres

but I think for album/release it's quite easy decision

for artists it's harder

since we can't quantify the data in the new structure.

well, since the core schema doesn't change, I don't really have to address this issue *now*.

I'll try to draw some diagram how I'd integrate into the current schema

and some SQL how to convert the data

awesome.

I'll start the conversation with the BBC to see if we can get this on the road.

"321,271,968 4.74M/s eta 2m 45s" speedy pipe you got :>

ruaok: still awake?

barely.

ok, let's talk tommorow :)

Wizzcat: downloads off that machine are throttled.

I hope to fix that before too long, now that we have a better switch.

luks: will you be around in 8 hours or so?

yes

cool.

then again, I'm curious. again. :)

I can always re-read the logs in the morning, so hit me. :-)

well, why is dateadded in table album? :)

it obviously should be in albummeta

urm. ya.

my GF will be out of town this weekend and there is rain forecast.

:D

natta everyone...

so I managed to close my eyes...

and I figured out why dateadded is in album, not albummeta

why?

dateadded is not derivable from other datat. the moderation tables may not be present. or they may be pruned.

albummeta can be easily regenerated.

hmm

if you have any ideas, I'll read the chatlog in the am.

bad time.

natta

aCiD2: Back at uni? \o/

His hostmask says yes :P

Lucky you.

Or not

my train was JUST cancelled :/

Time to take the long route, sigh

Ow.

Leaves on the line!

heh

I asusme you noticed, they have a pair of dates within which they expect leaves on the line.

Iirc it's after 2:30pm on 4th Dec that no more leaves are allowed on the line.

I've seen sheep on the line before

Welcome to wales.

Only in Wales

Girlfriend

I wouldn't bother otherwise , it's shit there

FauxFaux: yessir

ah, so that's how you met her.. the sheep on the line you mentioned before ;)

"Oh, so you're into that TOO!"

Heh, I met her in London not knowing she'd feck off to uni in Wales :|

I feel conned etc

You feel her pain when she sees your face?

"face"

"pain"

Where the Reading -> London Waterloo line crosses the River Thames at Egham, there are regularly Swans on the line. As they are protected birds, the trains have to stop until they can be tempted to leave.

that's ridiculous

Muzzz: why does http://www.last.fm/music/Cycles not show my "Experiments" album?

i can't figure it out for the life of me :(

inhouseuk: Reading to waterloo as in the one that takes 1h20 and goes through hell^Wbracknell?

hmm

rah!

this Uriah heep album is pissing me off. i got release dates for july, june (propagated from a faulty amazon source, I am sure) and august

how handah

the problem is that for some unknown reason Teleguise has taken an intereest to this spesifically

so i have to find more info on it

the problem is that a lot, and I mean A LOT ofplaces takes it source from amazon

nuke them all and pick the earliest?

yea, the probløem is that tele changed it

and is pissed becasue i apperantly broke code of conduct when i changed it back