The Monash Manga Library is part of the Japanese Studies Centre at Monash University in Clayton. I first started visiting the library in 2004 and became a volunteer staff member soon after that.

It’s run almost entirely by volunteers who have a lot of love for that place. We’ve all become friends and keep in touch long after we’ve graduated.

Image from the Monash Manga Library website

The database that the library runs on was also made by a volunteer…and while I know the best intentions were there, it really isn’t a great database. It is definitely not normalised and is missing some basic code – for example, code that could determine whether a library member can actually borrow any books, or when the books would be due.

Considering that the volunteer who designed it wasn’t an ICT student, they did a pretty good job of building that Access database. But at the moment, it can take up to 10 minutes to enter loans or returns. The database has corrupted over time and there are concerns that the library’s revenues and expenses aren’t being tracked properly.

I offered to build a new database for the library. We decided we would still use Microsoft Access because it was an interface all of the staff were already familiar with and because Monash University already holds software licenses for it. But beyond that, this database is set for a complete redesign.

I’m going to introduce barcodes into the library. Handheld USB scanners are cheap and easy to source. There’s also a wonderful barcoding program by IDAutomation that is free for educational or non-profit organisations. Introducing barcodes has meant that we’ve had to do a massive stocktake in the library. There are over 8000 items! They were all taken off the shelves, barcoded, their details recorded into the new, clean repository and then reshelved. That was a task-and-a-half but I remember when we added coloured ratings and author surnames to the book’s spines a few years ago. Similar situation! I think that the library just needs to fall into complete chaos like that every few years. Being surrounded by piles of books, paper and dust is good for the soul, hehehe!

Anyway, the database has taken a massive leap forward in recent weeks. There has been a little scope creep and my design has changed a little from the original plan. But since there’s only a year or so left before I have to say goodbye to the library and get stuck into a full-time career, I’m happy to change this database until it’s perfect and I can leave the manga library ticking over nicely to the next generation of volunteers.

Hopefully once I’ve finished the database and fully implemented it, I can post some screenshots and documentation here to show how the new system works. Monash University have shared some exciting news: the future database could be used as a reserch tool, which means that the Manga Library could receive more funding! That would be fantastic, since it’s such a great little library.

I love music. It takes up a large portion of my life and I don’t exaggerate when I say that I couldn’t cope without it. And since I also love technology and have been an avid Internet user for about 13 years now – it makes sense that I have a LOT of digital music :)

The problem is that I never really kept it under control. There are MP3 files, OGG files, WAV files, WMA files and AAC files all spread out over 5 computers, hundreds of CD and DVD backups, my external hard drives and two iPods. Most of the files don’t have proper tags. There are plenty of “Unknown Title by Unknown Artist” songs or something equally vague.The files that do have some correct title and artist information often don’t have the album cover images embedded – which doesn’t fully utilise the beautiful interface on my iPod or other music programs.

Now, on top of this, I also own plenty of CDs that (believe it or not) haven’t yet been converted to digital format. I also have a small collection of vinyls and cassete tapes that I’d like to convert so I can enjoy them more often. Finally, since starting RADIO TOKYO, I really need to make my music collection as searchable, accessible and fully annotated as possible, so Ican prepare for the show quickly.

My music collection needs help! I’m not entirely sure how to go about cleaning it up, though. There are plenty of tagging programs out there, but not many of them are entirely accurate (especially with my Japanese CDs). There are others that can only tag newly-ripped music, not files that were already created. I’m fairly particular and will put a huge amount of attention to getting the details correct (heh, so why did I let my music collection get so unruly? I’ll put it down to sheer size and momentum of growth), so I don’t think I can accept the standard tagging programs.

MusicBrainz logoI’m a member of the MusicBrainz community (username MagdaStremeski) which is an open source database of music metadata. It relies on community members to create and update the records of music releases. Anyone can change the data but every change requires some ‘cool-down’ time, where other community members can query or vote for the changes. This means that changes made are -for the most part- very accurate. It’s an excellent open source project and it’s free.

So I’m sure that part of my solution will be the MusicBrainz tagging program, because I can always change the tags if I find a mistake, or create the release in MB if it isn’t already there. For the most part though, i think that even my Japanese music collection will be serviced quite well.

But I’m not sure that MusicBrainz will be enough. There are many ‘Unknown Title” tracks in my collection – aMusicIP logond quite often they’ve stayed that way because I really don’t know what the title is! There are a few music fingerprinting services out there – MusicIP is one that has partnered with MusicBrainz, so hopefully the services I can get will be integrated. Hopefully MusicIP can scan my collection and fill in the blanks.

I also need something that will rip the CDs I have and covert them. Yet another set of programs to investigate! But what format should I rip them to? iTunes uses AAC, which probably is a better quality format than MP3 but is really only useful in Apple products. OGG and FLAC compressions are higher quality still AND they’re open source.

But…hard drive space is growing bigger and cheaper every day. And I’ve done a little research on the various MP3 codecs – it doesn’t have to be a poorer quality sound. MP3 files are also accepted by my home and car stereo systems.

So perhaps I’ll re-rip all my CDs into high-quality Mp3s with a WAV backup, in case FLAC becomes more widespread. I’ll have to see what can be done about the AAC or originally low-quality MP3 files and what I can do with them.

I feel like I have all the pieces available to me for cleaning up and organising my music collection. I just have to have a closer look at processes and make sure that whatever method I use will give me my end goals without too much rework (especially manual rework).

If you have any suggestions for music ripping/identification/tagging programs, then please comment below!

© 2012 Magda Stremeski Suffusion theme by Sayontan Sinha