Financial Sector

Reorganization / optimization of IBM Informix databases to accelerate ETL processes in the financial industry.

Healthcare Service

Consulting, planning and implementation of IBM Informix healthcare database solutions with high availability (HDR).

Retailing Industry

Analyze and optimize existing IBM Informix database applications and optimize IBM Informix database queries and processing in the retail industry.

Public sector

Database support in different fields of credit rating, the maintenance and administration of the scoring platform and the corresponding reporting tools.

Mobility

Administration of Informix environment, preparation, installation and performing of Database Monitoring tools according to the valid SLAs of the end customer.

Retailing Industry

 

Year:

2016

 

Duration:

4 months

 

System environment:

IBM Power/AIX, Informix 11.70, Informix HDR, Data Warehouse/Informix Warehouse Accelerator (IWA)

 

Task:

The company is nationwide active retailer and was supported in analyzing and changing of the database configuration (Caching, Fragmentation, PDQ) and the programming/optimization of statements of the batch applications. The focus was on Analysis and Removal of performance bottlenecks.

 

Actions:

  • Analysis & Adjustments in server configuration
    • Caching
    • Fragmentation
    • PDQ
  • Analysis of queries & batch applications
    • Performance tuning
    • PDQ
  • Optimization database design

 

 

  • hamburg data GbR
  • Jörg Kleinitzke & Oliver Hesse
  • Oehleckerring 4
  • 22419 Hamburg

loation and how to find us  How to find us

  • Tel.:+49 (0)40 875 00 589
  • Fax.:+49 (0)40 875 01 968
  • eMail: This email address is being protected from spambots. You need JavaScript enabled to view it.
  • VAT.-Id.-No.: DE277820876
  • Taxl office: Hamburg Nord