Find Jobs
Hire Freelancers

Highlight search phrase in search result using Oracle Database 12c and Java

$30-250 USD

Chiuso
Pubblicato più di 8 anni fa

$30-250 USD

Pagato al completamento
There is an easy way, and a hard way for solving this. First I'll talk about the hard way. I have an existing web service which has a search feature. The search feature works fine in Oracle 12c as long as I escape all of the necessary special/reserved characters that a user may enter in. The problem is in highlighting the search results in Java. The two different searches don't match up. For example, Oracle database 12c will find 100 records, but the highlight function, doesn't always find the same number of words or phrases because it uses a different REGEX search system. The highlight function's purpose is to take the results from the database search, and find the start and stop index, so that each word or phrase can be highlighted on the front end. In summary, the user should be able to type _any_ random characters in the search field and the highlight function should find the same number of occurrences as the Oracle Database search. If the search function finds 63 records, which contain a total of 78 occurrences of the search word or phrase, then the highlight function should find all 78 of them also, no matter what the user searches for. example inputs and outputs: Input: #%@//(*$HF\#E<)@R}#>R""2^r4' _#$RFDdfs"{ Record: fwed#%@//(*$HF\#E<)@R}#>R""2^r4' _#$RFDdfs"{f4 f 33 fwef <> fewf#%@//(*$HF\#E<)@R}#>R""2^r4' _#$RFDdfs"{ 86 45%$ 4%^&^&fdd !* Result: (4, 44), (71, 115) (The result is saying it found two occurrences. One from index 4 to 44, and another at index 71 to 115.) Again, this needs to work no matter what the user enters in the search box. This is easy to do for normal letters, not not so easy for any random character. There may be an easier way of doing this if you can get Oracle Database to tell you the indexes of exactly where it found the search string within the CLOB field, (at each occurrence). I have not been able to find a function for that though. After all special characters in searchString have been escaped, the database search is performed like this: String query = "select * from sys.my_table WHERE CONTAINS(my_clob_field, '" + searchString + "', 1) > 0"; The results are a list of strings, which are then searched to find the start and stop indexes so that the words can be highlighted. You do not need any code from me. You can just create a command line program in Java that generates some number of records with random characters in a CLOB field. Then your program would just run the search to test the accuracy of the results. If you solved it the easy way, then there isn't much testing to do. If you had to do it the hard way, then you will need to test that the highlight function correctly finds the search phrase that the initial database search found.
Rif. progetto: 9002657

Info sul progetto

8 proposte
Progetto a distanza
Attivo 8 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
8 freelance hanno fatto un'offerta media di $191 USD
Avatar dell'utente
Hello, We will be happy to help you solve the issue. We have 80+ software engineers in our company. You will be able to communicate directly with the expert working on your project. We have a team of Skilled Java-J2EE professionals with experience up to 8 years. ===== Our Expertise in Java / J2EE : * Desktop Applications : Swing, Eclipse Rich Client Platform, AWT, SWT, RMI * Frameworks: Spring, Spring Security, Spring Social, Struts, Hibernate ,JPA, Lucerne, Quartz, Ant, jUnit, DbUnit, Mybatis * Web Technology : JSP, JSTL, JSF, JQuery, Ajax, Java Script, DWR, FCK Editor, Extjs * Application Servers : JBoss, Web logic, Web Sphere, Apache Tomcat, Glassfish * Databases : MySQL 4.x/5.x, Oracle 8i/9i/10g/11g, Postgre SQL * Web Services : SOAP, WSDL, RESTFUL Web Services, Apache Axis * IDE : Eclipse, Net Beans, Web Ratio (Model Based Application Development IDE) , Spring IDE * Payment Gateway : PayPal Integration [ Experienced in integrating other payment gateways too ] * SDLC : AGILE ===== We are available from Monday To Friday, 9 hours a day. Our timezone is GMT+5.30. Please initiate chat to check our understandings and queries. We look forward to have long term engagement on the basis of quality of our work evinced in this project. Thanks.
$157 USD in 3 giorni
4,9 (36 valutazioni)
7,2
7,2
Avatar dell'utente
Hi! I am professional C/C++/C#/Java/Python programmer. I can do this project with highest quality! Best Regards, Szymszteinsl
$300 USD in 4 giorni
4,6 (40 valutazioni)
5,5
5,5
Avatar dell'utente
I am an IITK graduate, 9 year experienced software professional and I have got top notch developers in my team, who have got experience across a span of technologies. The members in my team have worked with top notch tech organization such as Amazon, Cisco, Oracle etc. We have been involved in similar projects in the past and our track record has been excellent.
$155 USD in 3 giorni
5,0 (8 valutazioni)
4,1
4,1
Avatar dell'utente
We have a team of expert JAVA developers with more than 10 years of rich industry experience & would be more than happy to work on the project. We have 100% completion rate,please check our reviews to have an idea about the quality of work we have delivered in the past. If given a chance I assure you of the best quality work within time and budget. Regards NK
$210 USD in 7 giorni
5,0 (7 valutazioni)
4,0
4,0
Avatar dell'utente
I created script by procedure Oracle
$244 USD in 2 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Don't know where your problem is - either some unmatched coding, either wrong regex'es used. Though even usage of regexes seem not necessary here because exact character string and not pattern needs to be matched. Another source of errors could be if database counts total occurence and highlighting counts only not overlaping occurence
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
Hi, could provide you with proper SQL for your problem. --------------------------------------------------------------------------- Thanks, Yegor.
$155 USD in 3 giorni
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: UNITED STATES
United States
5,0
2
Metodo di pagamento verificato
Membro dal gen 20, 2008

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.