ANASOFT

Home > Segments > Telco & Media

Alles klar.com

The Challenge allesklar.com AG

On allesklar.com approximately 45,000 vacancy descriptions must be checked against an amount of descriptors of a so called prof ID, either in bulk mode or at the push of a button (more important). Out of this one or more prof IDs matching the job tree’s position of the “Bundesagentur für Arbeit” can be determined.

With bulk import ca 45,000 positions are tested against ca 10,000 ID descriptors (operating time 3 to 5 min), with the manual allocation 45,000 positions are tested against one until max. 25 descriptors. The response time here must be located in the span of a few seconds (several allocations per minute by a crew of editors). A descriptor is a term composed of “and”, “or” and “and not” parts; the performance bottleneck is located at the request for enabling double-sided truncation of literals.

Our Solution

Entire redesign of existing application for meeting the performance demands:

- Design of back-end structures

- Analysis of quantity structure and performance conditions

- Process modelling

- Implementation of the application logic and bulk load interface for data import (cron, ETL)

- Tuning and installation of parallel processing on database side

The application’s redesign was profitable: the resulting performance could be improved considerably. The systematic use of Oracle text for indexing of input data was significant for this enhancement. The access of editors can now be afforded, as far as possible, without any holding time. The total time for data preparation is 5 to 20 minutes, depending on data volume.

Applied Technology

- Modelling with MagicDraw and Oracle Designer

- Implementation of system on Oracle using SQL Loader

- Use of Oracle text

- PL/SQL client interface with bash (server) and bask script with download/update logic

- Import with SQL Loader from bash script

- Processing and allocation algorithms in PL/SQL in packages and views

- Supply of interface for in-house forms application