Seperate Parts of English Sentence [message #362287] |
Mon, 01 December 2008 12:47  |
danish_fsd@yahoo.com
Messages: 38 Registered: February 2008 Location: Pakistan
|
Member |
|
|
Hi All.
I want to seperate VERBS, SUBJECT, OBJECT(part of English sentence). English sentences are stored in a column of type varchar2. Is it possible to make a query or stored procedure so that it first find only VERBS, SUBJECT, OBJECT etc and then split them. example is as follows
Sentences
How to write a query?
I am like to drink water.
.....
....
I want to seperate VERBS i.e.,("write", "drink")
or to seperate OBJECTS i.e., ("query", "water")
Can any one help me.
Regards
Danish
|
|
|
|
Re: Seperate Parts of English Sentence [message #362337 is a reply to message #362294] |
Mon, 01 December 2008 21:40   |
danish_fsd@yahoo.com
Messages: 38 Registered: February 2008 Location: Pakistan
|
Member |
|
|
"Time flies like an arrow"
Hello Michel
Thanks for reply. In my thinking, I understand "flies" as an verb and "Time" as an subject (may be I am wrong). I have no hard and fast rule to distinguish these. It should be done as it happen in English dictionary. If in any sentence some criteria not fulfill, then it may return null. Some solutions may be not exact but approximately near to solution.
Regards
Danish
|
|
|
|
|
Re: Seperate Parts of English Sentence [message #362534 is a reply to message #362339] |
Tue, 02 December 2008 21:51   |
danish_fsd@yahoo.com
Messages: 38 Registered: February 2008 Location: Pakistan
|
Member |
|
|
Hello Barbara Boehmer
Thanks for your detail reply. I know this is very difficult to distinguish these. Actually I want to rank sentences (or part of sentences) which have same meanings, and then find out sentences which occur most frequently. For example, In a web database application, where people post their questions. I want to sort out questions which is mostly asked. and all questions are stored in a single column. I want to get some idea or to make some algorithm in PL/SQL Procedure which is approximately near to this solution.
Regards
Danish
|
|
|
|
|
|
|
|