Re: Full-search index for the database

2011-09-11 Thread Erick Erickson
How much search-specific stuff are we talking here? Do you want to do stemming? Plurals? Or are you talking exact match? Phrases? multi-word queries? If exact match on individual terms is all you want, you could hack something together like this: index each term into a catch-all field with the fie

Re: Full-search index for the database

2011-09-11 Thread Eugeny Balakhonov
My task is very simple: I have a big database with a lot tables and fields. This database has dynamic structure and can be extended or changed in any time. I need a tool for full-search possibility via all fields in all tables of my database. On the input of this tool - some text for search. On th

Re: Full-search index for the database

2011-09-11 Thread Eugeny Balakhonov
Hello, Thanks for answer! I have created separate fields in mysolr schema for each field in database (more than 500!). How to ask parser for search via all these fields? By default Solr schema should contain explicit declaration of default search field like following: TEXT I tried to use follow

Re: Full-search index for the database

2011-09-11 Thread Jamie Johnson
You should create separate fields in your solr schema for each field in your database that you want recognized separately. You can use a query parser like edismax to do a weighted query across all of your fields and then provide highlighting on the specific field which matched. 2011/9/10 Eugeny B

Full-search index for the database

2011-09-10 Thread Eugeny Balakhonov
I want to create full-text search for my database. It means that search engine should look up some string for all fields of my database. I have created Solr configuration for extracting and indexing data from a database. According documentation in the file schema.xml I have created field f