Filewatcher File Search File Search
Content Search
» » » » »


Indexing documents with MySQL as storage

DBIx::FullTextSearch is a flexible solution for indexing contents of documents. It uses the MySQL database to store the information about words and documents and provides Perl interface for indexing new documents, making changes and searching for matches. For DBIx::FullTextSearch, a document is nearly anything -- Perl scalar, file, Web document, database field.

The basic style of interface is shown above. What you need is a MySQL database and a DBI with DBD::mysql. Then you create a DBIx::FullTextSearch index -- a set of tables that maintain all necessary information. Once created it can be accessed many times, either for updating the index (adding documents) or searching.

DBIx::FullTextSearch uses one basic table to store parameters of the index. Second table is used to store the actual information about documents and words, and depending on the type of the index (specified during index creation) there may be more tables to store additional information (like conversion from external string names (eg. URL's) to internal numeric form). For a user, these internal thingies and internal behaviour of the index are not important. The important part is the API, the methods to index document and ask questions about words in documents. However, certain understanding of how it all works may be useful when you are deciding if this module is for you and what type of index will best suit your needs.

Package version:0.73-10


Current structure of the *_data tables:
1. Blob
	word  - contains word to look up
	idx - blob containing id's of all documents containg that word
		along with number of occurances
2. Column
	word_id - contains id of word to look up
	doc_id - contains id of doc
	count - contains number of occurances
3. Phrase
	word_id - contains id of word to look up
	doc_id - contains id of doc
	idx - contains loc



This is the README file for the DBIx::FullTextSearch module. Please read it
fully, especially if you install or use the module for the first time and
have some troubles with it. I probably won't be polite if you email me and I
will realize that you did not read what I've written to help you to use
the thing. That


DBIx::FullTextSeaUser3Contributed Perl DocuDBIx::FullTextSearch(3pm)

       DBIx::FullTextSearch - Indexing documents with MySQL as stor‐

       DBIx::FullTextSearch uses a MySQL database backend to index
       files, web documents and database fields.  Supports must
       include, can include, and cannot include words and phrases.
       Support for boolean (AND/O





libdbix-fulltextsearch-perl (0.73-10) unstable; urgency=low

  * Fix debian/rules rmdir bug (closes:


0.73 March 2nd 2003
	Fixed bug when searching with wildcards '*' and retrieving multiple 
	results f



	Explore use of Berkeley DB as faster alternative to MySQL.
	It is likely that Berkeley DB 


This software was Debianized by Dominic Hargreaves on
Sun, 19 Sep 2004 23:57:51 +0100.

It was downl

Browse inside libdbix-fulltextsearch-perl_0.73-10_all.deb

         [DIR]DEBIAN/ (2)  65535+ mirrors
         [DIR]usr/ (1)  65535+ mirrors

Download libdbix-fulltextsearch-perl_0.73-10_all.deb

Results 1 - 1 of 1
Help - FTP Sites List - Software Dir.
Search over 15 billion files
© 1997-2017