MySQL Forums
Forum List  »  Full-Text Search

Full text searching
Posted by: Greg Perry
Date: January 21, 2006 07:21PM


I am working on a project to put an entire Bible into a MySQL database, and would like to get some advise from the list members here on architecture and plan of attack.

I am going to transcribe EW Bullinger's Companion Bible into electronic format, then I want to stuff it into a MySQL 5.0 database. The type of information I need to store with each chapter and verse is formatting information (italics bold etc), as well as the side notes. The side notes sometimes contain another chapter/verse reference which I want to include for each verse (the idea of the Companion Bible was that Bullinger made detailed notes on each verse, including cross references and the Massorah).

Futher, the reason why I want to use MySQL is for the full-text search capability. For specific keywords, or combinations of words, I would like to be able to extract every verse that contains the keywords, as well as fuzzy searching (partial words etc).

So, with that being said - what type of database to start off with, what type of data types, how should each verse be broken down etc...?

Thanks in advance


Options: ReplyQuote

Written By
Full text searching
January 21, 2006 07:21PM
February 08, 2006 10:29AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.