Hi Jason We use Lucene only for Razuna and do the same, thought we have a lesser requirement then you describe but we have categories for assets, like video, images and documents. Lucene has "category" and "categorytree".
For us we can, say store the category "videos" in "categeory" and in "categorytree" we store the folder ID where the video is stored in. As far as I can remember you can store multiple values in those fields as well. Furthermore you can save many indexes with the same categorytree and thus combining the index. For us, we store the content of the asset (if it is a document the fulltext) in one index and have the query of the database in another index. Obviously, cfsearch supports these "filters" and thus you can easily search. Hope this helps. Kind Regards, Nitai On Fri, Sep 25, 2009 at 7:36 PM, Jason Allen <[email protected]> wrote: > > Thanks Matthew! I knew some guys that are Lucene experts, so I will > probably contact them. > > My site is using openBD and Microsoft SQL Server. Right now we are > using SQL 2000 but will port to 2008 once everything is done. Getting > a demo online quickly is our biggest goal. > > Comparing search features available with SQL Server vs. Lucene, do you > have a preference? I'll need not only text based search, but column to > column search as well. > > What I mean is that we will have detailed forms that isolate each > column in tables as search criteria. For instance, one of our tables, > for vehicles, is just a set of columns that are 'bit' data types for > features such as air conditioning, cd player, etc. In the search form, > users could select, via check box, whether to search for records that > meet this criteria. So if you wanted to search for cars with leather > seats, you would simply check the "leather seats" option, and that > criteria would be passed along with the search. This seems like > something we could go straight to the database for. > > What do you think? I'm still reading up on Lucene and how it works so > maybe my research will answer that question. > > > -- Razuna SaaS On-Demand - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Follow us on Twitter http://twitter.com/sixsigns --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
