| |
anonym
Registered: Jan 2002
Posts: 250 |
Merging duplicate entries
Hi guys,
there's some duplicate entries in the database. For example Offence has got an ex-member called Pal and an active member called Rooster, but both are the same person.
Could we maybe merge those two somehow so no information would be lost (as opposed to deleting one of them)? And then again, this is just an example, I am pretty sure that there are more of those.
/Frank
PS: Keep the great work up! |
|
... 18 posts hidden. Click here to view all posts....
|
| |
Jayce
Account closed
Registered: Dec 2001
Posts: 39 |
With the risc of sounding like a mr knowitall, but is the HANDLE of a person the primary key in your scener database?
Because if so, i think that's not a good idea. Handles can change, multiple handles do occur, if you took for example a combination of both (handle and realname) as a primary key you'll have a pretty unique combination. And a much easier starting point.
But to prevent further polution of the database, maybe it's an idea to temporarily de-activate the adding of new sceners while cleaning the current database. I know it's a lot of work, but as i can see it, it's currently the only way to get the consistanticy of the database back in order.
(and while your at it, maybe you can delete the 'gamecompany' records aswell :) )
I realise myself, that this project isn't your dayjob and me idea are a bit radical. But to me nothing is more irritating then a inconsistant database.
|
| |
Perff
Administrator
Posts: 1666 |
Quote: With the risc of sounding like a mr knowitall, but is the HANDLE of a person the primary key in your scener database?
Because if so, i think that's not a good idea. Handles can change, multiple handles do occur, if you took for example a combination of both (handle and realname) as a primary key you'll have a pretty unique combination. And a much easier starting point.
But to prevent further polution of the database, maybe it's an idea to temporarily de-activate the adding of new sceners while cleaning the current database. I know it's a lot of work, but as i can see it, it's currently the only way to get the consistanticy of the database back in order.
(and while your at it, maybe you can delete the 'gamecompany' records aswell :) )
I realise myself, that this project isn't your dayjob and me idea are a bit radical. But to me nothing is more irritating then a inconsistant database.
A little technical information about how sceners are represented in CSDb.
We have two tables. One for the sceners personal data (real name, address, phone, email etc.) This table can be viewed as the main table of the sceners.
The other table contains the sceners handles, handlestory, aka etc. and it's from this table relations to group, releases etc are made about memberships and credits etc.
And from the handles table there are a pointer to the scener table so more handles can point to the same scener.
I think this is the way to do it. :)
/Perff
|
| |
TDJ
Registered: Dec 2001
Posts: 1879 |
Set up seems okay, so why not use the real name on top of the scener page, maybe with the 'primary' handle attached to it?
We're real people, please treat us as such :) |
| |
CyberBrain
Administrator
Posts: 392 |
Please, don't use the real name on top of the sceners pages!! :) We're sceners please treat us as such. (and who cares about the real names of sceners anyway?) (don't hope this will start one of those xtream discussions :) ) |
| |
TDJ
Registered: Dec 2001
Posts: 1879 |
If the scener (whose name is his key) is the root record, it would be sensible to have at least a page with his/her name on top. On that page could be links to other pages dealing with his handles.
You could also use a 'main' handle, but that's very hard, because different people may know a certain scener under a different 'main' handle.
As for your remark about "who cares about real names": I guess that's the difference between us, to me the most interesting thing of our scene was that it consisted of people.
|
| |
Perff
Administrator
Posts: 1666 |
I see the point in using the real name when the same person (scener) can have multiple handles BUT the only thing that is required to create a scener in CSDb is a handle! So you might find sceners with no real name (or at least no real name entered in CSDb. :) )
I'm still working on (re)coding CSDb to cope with the new feature of multiple handles and will do what I think is best. heh. ;)
When I'm done we can discuss if there are a better solution. |
| |
TDJ
Registered: Dec 2001
Posts: 1879 |
So create a super-user (heh) called 'anonymous' (sorry Frank) and connect all the handles without users to that one, use that as the mainpage. Ofcourse it would have to be possible to 'transfer' handles from one person to another, just in case somebody would find out that Jeroen's Tel real name is .. well .. |
| |
Rough
Account closed
Registered: Feb 2002
Posts: 1829 |
you're so close to the light, TDJ, I let it out: I am Jeroen Tel! |
| |
Steppe
Registered: Jan 2002
Posts: 1510 |
Let us all bow before the Lord! ;-)
(Damn, I knew it....) |
| |
Commander
Account closed
Registered: Jan 2002
Posts: 106 |
I think that it is good that it starts with the handle and not with the real name! It's still a scene database, why making thibngs so difficult...? It's our own kind of world (a hobby for most of us), let's kep it like that. And my opinion : the guys of No Name did very good work with this Database, I don't agree with TDJ. If some people like it in their own way of taste, then start your own and see which database is the most popular... People should be happy that someone started this great project!!! Some of the people here don't have real critics anymore but simply look down to other people (even if they say it's not). Let us try to do our best, I think that the database is already a very nice thing for the moment and the webmaster improves it from time to time when he has time for it. I am greatfull for that.
|
| Previous - 1 | 2 | 3 - Next |
