Database management and design

Although OSSAC focuses primarily on Oracle Rdb and MySQL relational database management systems, the database services offered by OSSAC are not limited to these. In particular we also support solutions based on RMS, ORACLE DBMS, SQLServer, MUMPS (Cache) and others as well.

Oracle Rdb is a full-featured, relational database management system for mission-critical applications on OpenVMS platforms.

Rdb’s technical strengths include:

• Very high performance to deliver extraordinary real-world throughput
• Extremely high reliability, providing both data security and database uptime
• Extremely high availability—requirements for scheduled maintenance downtime are minimal
• Easy maintainability
• Low cost per transaction

Capabilities

Design of relational and non relational DBMS

• Design and redesign of database solutions using state of the art E/R tools
• Implementation of medium to large RDB installations
• Implementation of MySQL based solutions on OpenVMS systems

Design of Backup and data integrity concepts

• OSSAC uses different technologies based on hardware, software and clustering techniques to achieve the best possible data integrity
• Developing backup and, even more important, restore concepts to protect valuable and mission critical data from being lost due to hardware failure and/or human error

Monitoring and performance tuning

• As database systems grow, monitoring and performance tuning becomes more and more important
• OSSAC focuses on a demand driven strategy in monitoring and tuning of large database installations
• We regard databases as very dynamic systems, which need constant monitoring and adaptations to changed customer needs

.

Reference Accounts

Deutsche Telekom (German Telecom)
Maintenance, 1st, 2nd and 3rd line support for one of the biggest RDB installations in Europe at the Münster data center

Österreichische Lotterien (Austrian Lotteries)
Performance analysis of the online and the hot standby database systems based on Oracle RDB and OpenVMS clusters

PKE
Enhancement and implementation of Security Management Systems based on Oracle RDB and MySQL

UPC Telekabel
Consulting and second line support for the billing system based on OpenVMS cluster and Oracle RDB