Cddb - Database Feeder

Version 0.1

(c) Stefan Wagner, Kopfwerk Banane

An Investigation on Hashcodes of the CDDB

Written Dez. 2003, minor update Sprint 2005


Download the used java-program. It is (and will not be) waited. It's a bz2-tar: cddb.tar.bz2 and about 60 k in size.
german version

Motivation

At ripping musik-CD's , and converting into ogg or mp3 - format, we loose the almost boring information, at which frameoffset track one begins.
In about 75% of the cases, this offset is 150 which matches 2 seconds.
Since ripped music doesn't need offsets, this information is that boring.
But that's only true for the first look at these information, because the CSID is calculated with these offsets.
And the CSID is used by many Applications, to search the internet for additional infos for a CD: Artist, CD-name, name of the different songs, to mention the most prominents.
To get these details without the offset, I started writing a programm, which creates it's own ID, without offset, and looks into a table, which CSID is related to its own ID. My own ID I call LLCI : 'LeadinLess CD Identifier'.

Steps ahead

1 1 1 0 1 7 1 2

It consists of three Parts: 2 digits for the SQS, 4 for the songlength-time, and 2 for the tracks

Let's have an example:
11101712
The Merchant of Venice / Outside Looking Out
11 1017 12

The parts solitaer:


Todo


Fussnoten

Musik-CDs While more and more discs with music don't match the CD-standard, to implement a Copyprotection, which lead to the expression UNCD for these crippled stuff, I ignore this detail in this essay, and talk generously about CDs.
somehow actual From 2003-09-03 - which is - writing this - three months ago.
Honestly I don't know how I got the file.
With my friend and personal linux-guru Rico, lacks the time for programming, and feels a bit strange to databases, I discussed the question how to solve the problems of ogg-files, and it was his idea to start solving this problem at all.
He owns more CDs and listens to them from PC.
At least he infected me with the problem, and I tried to give some work to my Postgresql-Database.
And I got some weeks time, and think, he organized the September-Database (112 kb downstream).
KB, MB, GB Computerpeople use kilo not for 1000, but 1024, and Mega is 1024 kilo etc.
Therefore the values seem to misfit: here 977 MB, there 1.024.688.005, which looks like 1GB.
SQS Summe of cross sums (QuerSummen) (of trackoffsets [in seconds]).
Logar. View. The screenshot was shot with KSnapshot.
Then manipulated with Gimp.
Both is OpenSource-software.
Lineare View. The graphic was generated with OpenOfficeOrg: Calc, a priceless available Office-programm from SUN.
Because there is no export possibility for the grafics (or didn't I find it, but there is?) I made a screenshot again, and surprise: with KSnapshot.
foo bar
counter counter

Valid HTML 4.0!