problems with mysql conversion?

 
Post new topic   Reply to topic    WordNet Developers Forum Forum Index -> MySQL
View previous topic :: View next topic  
Author Message
bdejong



Joined: 20 Oct 2004
Posts: 17

PostPosted: Fri Oct 22, 2004 5:04 am    Post subject: problems with mysql conversion? Reply with quote
Hiya,


a lookup for the verb "abide" gives results in the original Wordnet 2.0, but doesn't come up aith anything in the MySQL android-tech MySQL version!

I suspect there's plenty more... Confused

Any ideas?

- bram
_________________
http://www.iua.upf.es/mtg
http://www.icmc2005.org
http://www.smartelectronix.com
http://www.musicdsp.org
Back to top
View user's profile Send private message
bdejong



Joined: 20 Oct 2004
Posts: 17

PostPosted: Fri Oct 22, 2004 5:52 am    Post subject: Reply with quote
another few to look out for: infant, needy, dishonour, ...


- bram
_________________
http://www.iua.upf.es/mtg
http://www.icmc2005.org
http://www.smartelectronix.com
http://www.musicdsp.org
Back to top
View user's profile Send private message
bdejong



Joined: 20 Oct 2004
Posts: 17

PostPosted: Fri Oct 22, 2004 6:01 am    Post subject: Reply with quote
Found it.

The prolog datafiles have:

s(109201456,1,'baby',n,1,611).
s(109201456,2,'babe',n,1,6).
s(109201456,3,'infant',n,1,3).

As you can see these three have the same synset ID, however you only enter the first into the MySQL database:

INSERT INTO `wn_synset` VALUES (109201292,1,'baby','n',4,9);
=> INSERT INTO `wn_synset` VALUES (109201456,1,'baby','n',1,611);
INSERT INTO `wn_synset` VALUES (109201816,1,'baby_boomer','n',1,0);

Perhaps it would be nice to open-source your Prolog => SQL conversion utility?


- bram
_________________
http://www.iua.upf.es/mtg
http://www.icmc2005.org
http://www.smartelectronix.com
http://www.musicdsp.org
Back to top
View user's profile Send private message
roschler
Site Admin


Joined: 20 Oct 2004
Posts: 91

PostPosted: Fri Oct 22, 2004 9:16 am    Post subject: Reply with quote
Bram,

Yes we are aware of those missing words. We originally converted the Prolog files to tab-delimited files for fast loading into MySQL using the "LOAD DATA" command. However something did not go well.

Today we are modifying our conversion program to convert the Prolog data files to MySQL batch file scripts instead, and reload them. I will e-mail you when it's done today, so you can download the new files.

Thanks,
Robert
_________________
Robert
Forum Administrator
Back to top
View user's profile Send private message
bdejong



Joined: 20 Oct 2004
Posts: 17

PostPosted: Fri Oct 22, 2004 9:20 am    Post subject: Reply with quote
Thanks Robert, that's great!


And what about making the conversion open-source?

I've seen that the prolog files are very straight-forward, so the conversion isn't that difficult, but still, it might be nice to have the conversion files!



- Bram
_________________
http://www.iua.upf.es/mtg
http://www.icmc2005.org
http://www.smartelectronix.com
http://www.musicdsp.org
Back to top
View user's profile Send private message
roschler
Site Admin


Joined: 20 Oct 2004
Posts: 91

PostPosted: Fri Oct 22, 2004 9:50 am    Post subject: Reply with quote
Bram,

The conversion files are written in Delphi Object Pascal. I don't think a lot of other WordNet developers use that language, so to take the time to clean up and "disentangle" the conversion code from our other libraries would not be worth it; especially since it only has to be run when the WordNet data files are changed.

However, I do intend within the next few months to set up a searchable "repository" of code samples and snippets that we can all use and augment.

Thanks.
Back to top
View user's profile Send private message
roschler
Site Admin


Joined: 20 Oct 2004
Posts: 91

PostPosted: Fri Oct 22, 2004 5:05 pm    Post subject: Reply with quote
Bram,

The files are fixed, see the Announcements Forum using the link below. If you have any trouble, let me know.

http://www.wordnetchat.com/phpBB2/viewtopic.php?t=6

Here's a direct link to the download page:

http://www.androidtech.com/html/wordnet-mysql-20.php

Thanks.
_________________
Robert
Forum Administrator


Last edited by roschler on Sat Oct 23, 2004 8:51 am; edited 1 time in total
Back to top
View user's profile Send private message
bdejong



Joined: 20 Oct 2004
Posts: 17

PostPosted: Sat Oct 23, 2004 7:16 am    Post subject: Reply with quote
"The topic or post you requested does not exist"
I'll look at your site to see if it's there.

cheerio,

- bram
_________________
http://www.iua.upf.es/mtg
http://www.icmc2005.org
http://www.smartelectronix.com
http://www.musicdsp.org
Back to top
View user's profile Send private message
roschler
Site Admin


Joined: 20 Oct 2004
Posts: 91

PostPosted: Sat Oct 23, 2004 8:50 am    Post subject: Reply with quote
That links seems to work now, although I too tried it earlier and got that message. Great, a haunted message board! Confused
_________________
Robert
Forum Administrator
Back to top
View user's profile Send private message
bdejong



Joined: 20 Oct 2004
Posts: 17

PostPosted: Sat Oct 23, 2004 9:13 am    Post subject: Reply with quote
nope, still no go here, I don't see a "announcements" forum either, btw.

did you install the original phpBB or some kind of hacked version (I don't really recognise the style...).

Pehaps it'd be wise to redo the installation after backing up the messages and users?


- bram
_________________
http://www.iua.upf.es/mtg
http://www.icmc2005.org
http://www.smartelectronix.com
http://www.musicdsp.org
Back to top
View user's profile Send private message
roschler
Site Admin


Joined: 20 Oct 2004
Posts: 91

PostPosted: Sat Oct 23, 2004 9:31 am    Post subject: Reply with quote
Bram,

I'm not having that problem, everything is working well now. This forum is standard php BB 2.0.10 . It's only the template that is different. Did you try clearing your browser cache?

Let me know how you make out with the new "build" of data files.

Thanks.
_________________
Robert
Forum Administrator
Back to top
View user's profile Send private message
bdejong



Joined: 20 Oct 2004
Posts: 17

PostPosted: Sat Oct 23, 2004 1:59 pm    Post subject: Reply with quote
sorry man, I just tried from a totaly different computer and it doesn't work - so it's definatly not a browser problem.

This link: http://wordnetchat.com/phpBB2/viewtopic.php?t=6 just doesn't work at all. And, browsing the forum, I don't see any "announcement" part. Are you sure it's not some kind of forum part with administrative permissions only?
_________________
http://www.iua.upf.es/mtg
http://www.icmc2005.org
http://www.smartelectronix.com
http://www.musicdsp.org
Back to top
View user's profile Send private message
roschler
Site Admin


Joined: 20 Oct 2004
Posts: 91

PostPosted: Sat Oct 23, 2004 3:18 pm    Post subject: Reply with quote
Bram,

That was a good catch. Even though I had the Announcement's forum "View" permissions set to REG (Registered users), it didn't show up for non-moderators until I set it to ALL. I don't know why that is, I would think that REG would allow registered users to see the forum.

Thanks for your persistence on this. I tested it from another computer, as a Guest. It should be visible now. Hopefully you were able to get the files on the other link I gave you earlier?
_________________
Robert
Forum Administrator
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    WordNet Developers Forum Forum Index -> MySQL All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




Powered by phpBB © 2001, 2002 phpBB Group Theme Designed by Team 101 Designs