Fix duplicate entries!

danielwang · Post by **danielwang** » Sun Dec 14, 2003 11:47 pm

There's too many to mention. But to name the BIGGEST ONE:

Merge "Dragon ball Z" & "Dragonball Z"

Does MySQL even provide for such a thing as merging database records?

Some notes:
Since each video has a unique ID that's used as the primary handle there would be no duplication conflicts (e.g. two identical records except for "DBZ"/"DB Z").
The index dimensionis always supposed to be the handle anyways, if you ordered them by name it's be a mess: Each video would have to have a unique database name (Common name, CN attribute) and other problems!

J-0080 · Post by **J-0080** » Sun Dec 14, 2003 11:49 pm

This has already been mentioned fool.

As far as I know, Phade is working on a system that would count all the duplicate entries as one. So 500 DBZ and 500 Dragon Ball Z would =1000 total.

Org Profile · Post by **Phade** » Mon Dec 15, 2003 12:40 am

Hey,

Demands, demands, demands. Like nobody has ever pointed out or I haven't noticed that there are multiple titles that are actually the same anime. MySQL merge database records? I don't think any database has such a feature since none would actually know what the data in tables actually means. Databases only care about data types and relationships and such. The meaning of content is impossible. Artificial intellegence has not nearly come that far. I mean, how is the database software supposed to know that "Dragonball Z" and "Dragonball GT" are actually seperate anime. Heck, the database doesn't even know what anime _IS_ besides varchar(255).

I have written a merge tool. It will be implemented before the end of the year, just in time for the VCA.

Phade.

Flint the Dwarf · Post by **Flint the Dwarf** » Mon Dec 15, 2003 1:11 am

I would think danielwang was referring, in this case, to the titles that have all the same letters in them (where the only differences are spacing, such as his examples: "Dragonball Z" and "Dragon Ball Z"). I don't know how that affects merging, however, because I'm no designer. I don't think he was implying that the data tables could really distinguish between anime.

dokidoki · Post by **dokidoki** » Mon Dec 15, 2003 2:37 am

flint_the_dwarf wrote:I don't think he was implying that the data tables could really distinguish between anime.

OMG OMG Windows .NET Gundam can do it with its 1337 Windows Media Detect0r 9.186261beta4 .hack//PIRATED version! Phade just install that d00d and yer rockin'!