Client: a leading worldwide provider of payment technology services.
Task: It was required of us to migrate a database from Oracle 11g to DB2 10.5. We migrated four Oracle databases to a single one on DB2. The requirements included migration of data loading scripts and modification of a custom framework with facilities of both database creation from scratch and performing incremental updates.
We migrated DDLs, stored procedures/packages, data loading scripts, and developed several modules in Java/C whose purpose is to provide missing/insufficient DB2 functionality. We also migrated a set of Perl scripts (main script size ~11K lines).
Technologies: Java, Perl, C, Oracle, DB2
Customer: world’s leading anti-spam service provider.
Task: The Customer requested our team to enhance and support its product
Solution: The RELEX team designed and developed the low level (kernel) of the incoming e-mail analysis system. Based on the kernel was created a new email scanner. To improve the filtering quality, the following functions were implemented in the system:
- Message language auto-detection (without impairing the performance),
- Natural language parsing
- Collecting statistics based on the parser results.
These functional modules became the basis for an artificial intelligence system and containers for storing and accessing the accumulated statistics. Our team successfully resolved the task of filtering messages in Eastern languages (Chinese, Korean, Japanese etc.). The final application, besides the high email filtering quality and additional services, can process over 500 messages per second with full content analysis in the integrated target system.It also uses traditional methods of spam traffic limitation, like filtering the incoming TCP/IP traffic by the incoming IP address, which helps narrowing down the channel for unknown or suspicious traffic sources.Along with spam filtering, the system can identify messages of some specific categories, such as phishing, mail/safe-list and bounce/backscatter auto-generated.