Find Jobs
Hire Freelancers

MS Search Server and/or SQL Server Freetext expert required

$30-5000 USD

Cancelado
Publicado hace alrededor de 12 años

$30-5000 USD

Pagado a la entrega
I'm looking for someone with working experience in either or both Microsoft Search Server and SQL Server features. If you are not familiar with both, let me know which are you are very familiar with and I will consider it. IMPORTANT NOTES: * DO NOT APPLY UNLESS YOU HAVE WORKED WITH IT OR ARE VERY FAMILIAR WITH IT. I CANNOT AFFORD TO WASTE TIME ON THIS PROJECT. * This is not an immediate development requirement, well at least not fully. I'm more interested right now in information rather than actual development, so if you feel confident that you can still provide the information I require, that's fine, but again I would prefer if you were a developer who has dealt with both product preferably but if you only know just the one, let me know which and I will make a decision. * I don't just need someone who can pleasurize work from books or the internet. I need someone smart for this job and can judge what is worth mentioning or not, what is important or not, what should be confident to hightlight points that haven't been mentioned, and can provide intelligent suggestions. * Do not apply for this project unless you are fluent in english at least . Again due to past experience, I need someone that can express themselves clearly at the very least in writting, but preferly oraly as well if skype call or other is required. ## Deliverables I'm looking for someone with working experience in either or both Microsoft Search Server and SQL Server features. If you are not familiar with both, let me know which are you are very familiar with and I will consider it. This project is made of 2 parts and I only want to deal with the first part right now. Do not quote for the second part. * Comparative Analysis of the 2 products mentioned above. * Development IMPORTANT NOTES: 1. DO NOT APPLY UNLESS YOU HAVE WORKED WITH IT OR ARE VERY FAMILIAR WITH IT. I CANNOT AFFORD TO WASTE TIME ON THIS PROJECT. 2. PROJECT: The first part of this project is the only part I'm interested in right now i.e. "COMPARATIVE ANALYSIS" and contrairly as some of you may have misread, the development part is second part of this project. I cannot emphasize strongly enough on that. I'm not interested in development at this stage as I first want to know everything there is to know about SQL Server Freetext and MS Search Server. Read my (brief) spec again. There is enough in there as to what I want in regards to the analysis. 3. FOCUS: Please stay focus. I'm only interested in the experience you've had with SQL Server and it's freetext feature and/or with MS Search Server. I don't need to know about all your experience in regards to SQL, Website design, etc... - This is of no use to me. I need to know if you know either specifically SQL Server and its freetext feature or MS Search Server. 4. DETAILS Telling me you have experience in SQL and/or MS Search server is not enough and is just too vague. Tell me about what you've done with either productS, again staying of the focus on the freetext, and how you've used it or how you've used MS Search Server. Don't just tell me you know it. 5. SPEC: A few of you have asked me for a chat, but honestly right now, it is too early. I feel that you can either provide me with this comparative analysis or not, but if you have the right knowledge you should be able to understand what I require without having the need to discuss it further with me. 6. QUOTE: Please provided me with a fix price. I do not want this to be done by the hour nor do I want it leave it vague an assign a project without knowing how much will it cost me! * IMPORTANT: This is not an immediate development requirement, well at least not fully. I'm more interested right now in information rather than actual development, so if you feel confident that you can still provide the information I require, that's fine, but again I would prefer if you were a developer who has dealt with both product preferably but if you only know just the one, let me know which and I will make a decision. * I don't just need someone who can pleasurize work from books or the internet. I need someone smart for this job and can judge what is worth mentioning or not, what is important or not, what should be confident to hightlight points that haven't been mentioned, and can provide intelligent suggestions. * Do not apply for this project unless you are fluent in english at least . Again due to past experience, I need someone that can express themselves clearly at the very least in writting, but preferly oraly as well if skype call or other is required. As mentioned, this is not development requirement, well at least not fully. I'm more interested right now in information rather than actual development, so if you feel confident that you can still provide the information I require, that's fine, but again I would prefer if you were a developer who has dealt with both product preferably but again if you only know just the one, let me know which and I will make a decision. 1. Advantages/Disadvantages of MS Search and SQL Server Freetext, more specifically what features are supported by each and not by the other, which ones are common, cost, RAM usage, storage usage, filters supported, speed, Query Search support (VERY IMPORTANT), search relevancy (if availble), etc... 2. Supported Document filters by each. Which ones are included as part of software, which one are optional, and which one have a cost associated with it. 3. Explain each of the supported search type for each, and the options applicable to each search. For example in SQL Server freetext, you can add a weight on each of the keywords, so I want this to be one of the search features and explain about the weight, but you get the idea. I want to be able to compare which options will be provided by each product, which are missing and it will allow me to decide which product to go with. 4. Minimum requirements and cost involved. If the express version are suggested, I need to know about the difference between express and full version. Again, expand on the features provided in features vs full. 5. Installation Steps - Must be very detailed i.e. From setup, filter installation if required, IIS, etc... Anything that will be required to install either app assuming you have no knowledge on how to previously do so. I know that some filters come as standards but if PDF support is required, i know you need to get a filter.. .I need to know how to install the filter. The above must provide documentation on how to deal with it with the 32-bit and 64-bit version of the products and please do not assume they are the same as this is very likely not going to be the case. 6. Provide samples to try out as many of the available search features from either products. This is very important. 7. Specific: Our product offers customers the ability to store documents in either the database or in an actual physical file repository (Not MS Filestream!), so I need to know as well which products offer the ability to search and build their search indexes with documents stored in the DB, or in an actual folder (and sub-folders) or in both. This is a very important requirement as we will need to let our customers know which way to go. For example, we obviously won't be recommending SQL Server Express if you can only use the database to stored documents in order to use free text and they have a large document requirement but we might if they only need to process a 100 docs a months for example... Again expand on this point if you can and if you have suggestions, please let me know. Note that our documents, whether stored in the database or in a physical storage such as a hard drive are all directly linked to a unique document id. Again depending on the product, the available options, etc... We hopefully will be able to returned the documentid associated with each record returned matching a specific search and ideally the actual document # on which it is on. Note that we can associate multiple document to a single document id. Note that we deal with Tiff document as well and we'll look after the 'ocr' part and we'll be able to provide a textual form of the documents, but again recommend whether or not we should store this text file along side the tiff, or store the text in the database and leave the tiff in on the hard drive (assumingwe're not storing it in the db), etc... Development: This is a very overview only, but it will give you an idea. Once we have made a decision, we will need to create a .NET wrapper that will allow us to do the following: 1. Create an interface that will provide common options as we will probably create a factory component for one product i.e. SQL, or the other MS Search or both and we have a third-party product also in mind, so an interface will be critical here. 2. Create a factory based on defined interface where there will 1 be at least 1 core function i.e. search example: [login to view URL](....) 1. Input: i.e. We will need to pass the keyword parameters and provide an any additional options i.e. weights, boolean search, or other. 2. Output: This will return the data in a dataset, or xml or other. Not fussy on this one but what is being returned will be critical i.e. relevancy weight (if possible), title(?), short description, and a document id, a document # and/or a link. Any other useful information should be returned but you'll need to let me know which one they will be.. 3. This factory assembly will eventually be called from either a .net remoting or a WCF component but this will not affect you. Remember this project is about providing me as much information as possible on either or both products so we can decide which one to go with or even pick one and start using this first but with the idea that it will be eventually expandable to support the other or even a third-party software. We will of course need to all rights to all the code written. This will be posted as a second project unless we are happy to continue dealing with the same contractor. Thanks. Thierry
ID del proyecto: 2719325

Información sobre el proyecto

Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos

Sobre este cliente

Bandera de IRELAND
Dublin, Ireland
5,0
40
Miembro desde sept 3, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.