text records and cross referencing

Hi

i am very new to mysql. I am playing around with it to test it as a
personal vocabulary and language expression manager.
Main field would be a passage from a text work, where each word is
searchable.
Any experience and reports about such use?

A further questions is about the possibility to make cross references, that
is
1) highlighting all records that have been connected (by the user) to the
displayed record
2) switching from a record to another one, within the same database.

Thank you

---Pol


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: text records and cross referencing

Hi Pol,

MySQL support FULLTEXT indexes, and natural language searches, including Bo=
olean conditions. This may help you; however, you will have to adjust the =
default behavior of the index, but changing server settings. By default th=
ere is a minimum word length which you will have to adjust, and a list of s=
topwords (words to ignore.) Both of these will prevent you from indexing e=
ach and every word, and even still words that show up in most or all record=
s will be ignored (and I don't know if you can change that behavior.) The=
alternative, is using unindexed lookups, which would be very slow for any =
non-trivial application.

See:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

The highlighting and switching behavior is up to your application. MySQL j=
ust stores data, it's up to you to write programs that manipulate it.

In all honesty, if this really is a "personal" application, you may be bett=
er off using another, simpler method.

Regards,
Gavin Towey

-----Original Message-----
From: news [mailto:news@ger.gmane.org] On Behalf Of Pol
Sent: Wednesday, August 19, 2009 2:38 AM
To: mysql@lists.mysql.com
Subject: text records and cross referencing

Hi

i am very new to mysql. I am playing around with it to test it as a
personal vocabulary and language expression manager.
Main field would be a passage from a text work, where each word is
searchable.
Any experience and reports about such use?

A further questions is about the possibility to make cross references, that
is
1) highlighting all records that have been connected (by the user) to the
displayed record
2) switching from a record to another one, within the same database.

Thank you

---Pol


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgtowey@ffn.com


The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: text records and cross referencing

Gavin Towey wrote:

> Hi Pol,
>
> MySQL support FULLTEXT indexes, and natural language searches, including
> Boolean conditions. This may help you; however, you will have to adjust
> the default behavior of the index, but changing server settings. By
> default there is a minimum word length which you will have to adjust, and
> a list of stopwords (words to ignore.) Both of these will prevent you
> from indexing each and every word, and even still words that show up in
> most or all records will be ignored (and I don't know if you can change
> that behavior.) The alternative, is using unindexed lookups, which would
> be very slow for any non-trivial application.
>

Thank you for you references.
I am not an expert, so i hope to find a smart interface to mysql to set up
the server.

>
> In all honesty, if this really is a "personal" application, you may be
> better off using another, simpler method.

What are your suggestions?

Thank you

--Pol



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org