When you say “tag search system”, I’m going to suggest that you mean the ability on a social network to allow your users to lose content, thereby raising what’s most popular on your site using a tag cloud. It also allows users to navigate by tagged content, etc.
I like to create a SystemObjects table that stores various tables in my system, to which tags (or comments, ratings, etc.) can be applied, which allows me to have a common tag system that can cover my entire database, Then I will also have a SystemObjectTags table in which there will be a link to SystemObjectID (telling me which table has the record of interest), as well as SystemObjectRecordID (which tells me which particular record I am interested in). From there I have all my details regarding tags and tags. Then I would like to save in the list of tags a list of current tags that store a unique tag (string value of the tag) TagID (to which the SystemObjectTags table belongs), counting the use of these tags in the system (a total value of all uses), etc.If you have a site with high traffic, this data should be stored in your cache so that you do not get into the data too often.
. , , , .. , , , , . Lucene.NET , . Lucene.NET , freerext SQL Server.
, , .. Lucene.net - ! , .