referenzen1_1920x800.jpg
Financial Sector

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

referenzen2_1920x800.jpg
Healthcare Service

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

referenzen3_1920x800.jpg
Retailing Industry

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

referenzen4_1920x800.jpg
Mobility

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

referenzen5_1920x800.jpg
Public sector

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

  2. Home
  3. References
  4. Retail Industry
Financial Sector
Retailing Industry
Healthcare Service
Public sector
Mobility

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