Lengkap

Solr Schema Design & Optimization

The schema for the core needs to be properly designed and optimized based on the following specifications.

The dataConfig

<dataConfig>

<dataSource type="JdbcDataSource"

driver="[url removed, login to view]"

url="jdbc:jtds:sqlserver:////………….." />

<document>

<entity name="parcels"

pk="PIN_18"

query="select PIN_18,[url removed, login to view](PIN_18, '[-.]', '') as StrippedPIN, [Owner] as OwnerName, RTRIM(ISNULL(Owner_Street, '') + ' ' + ISNULL(Owner_City_ST_ZIP, '')) as OwnerAddress, RTRIM(ISNULL(Property_Street, '') + ' ' + ISNULL(Property_City_ST_ZIP, '')) as PropertyAddress from [url removed, login to view]"

deltaImportQuery="select PIN_18, [url removed, login to view](PIN_18, '[-.]', '') as StrippedPIN, [Owner] as OwnerName, RTRIM(ISNULL(Owner_Street, '') + ' ' + ISNULL(Owner_City_ST_ZIP, '')) as OwnerAddress, RTRIM(ISNULL(Property_Street, '') + ' ' + ISNULL(Property_City_ST_ZIP, '')) as PropertyAddress from [url removed, login to view] WHERE id='${[url removed, login to view]}'"

deltaQuery="SELECT PIN_18 FROM [url removed, login to view] WHERE changed = 1"

>

</entity>

</document>

</dataConfig>

Current Schema File: Attached

Requirements :

A single search term is passed to the Solr Core like below

https://[[url removed, login to view]]/solr/parcelsmonroein/select?q=radhakrish*&wt=json&rows=10&indent=true&hl=true&hl.fl=*&hl.simple.pre=%3Cem%3E&hl.simple.post=%3C%2Fem%3E

In this case the search term is radhakrish*

The search is performed across all fields and returns results with highlights. This works well for wildcard searches even though the schema is not optimized.

We would like to

a. optimize the schema

b. improve the search for "phonetic" matches such as

Angela - Angie

Mike - Michael

Toni or Tony - Anthony

and if possible

7th - seventh

The name phonetic matches will apply for Owner names and the numerical for addresses.

Sample dataset is attached

Kemahiran: Apache Solr

Lihat lagi: solr query optimization, solr optimization, single-case design, single case design, schema design, michael query, delta design, delta com, solr schema api, solr php client solr, design solr schema, mysql design schema, nutch solr drupal schema, solr schema, solr mysql schema, optimization design analysis flywheel, project optimization design analysis flywheel, solr schema mysql, solr schema xml mysql, schema solr creator

Tentang Majikan:
( 5 ulasan ) Bloomington, United States

ID Projek: #10096196

Dianugerahkan kepada:

OkkeKlein

As a Solr expert of many years I am confident I can help you with your project. Does search have to be wildcard? Or is there room for other options? Other then that it looks pretty straightforward. You can f Lagi

$222 USD dalam 2 hari
(11 Ulasan)
5.0

4 pekerja bebas membida secara purata $236 untuk pekerjaan ini

pmpmuthukumar

Hi I am good expert in Solr and currently I developed a project for a [login to view URL] company using solr you can see this [login to view URL] which uses solr for searching. I can do this and make a successfull one. Lagi

$222 USD dalam 3 hari
(0 Ulasan)
0.0
$288 USD dalam 15 hari
(0 Ulasan)
0.0
cupertinovw

Hello, We have customized the Solr core and the search index by developing a custom Admin dashboard using Solarium. - this was to customize the search criteria and the crawler Optimizing existing data will be Lagi

$211 USD dalam 4 hari
(0 Ulasan)
0.0