Home > Innovation
> Technology Alliances
Oracle Technology Stack : Database
Sonata's capabilities in the Oracle Technology Stack : Database
Sonata’s association with Oracle has enabled it to deliver premier services to the Oracle user fraternity. Sonata offers wide-ranging services to Oracle database servers and application servers.
Services for Oracle Database Servers
Sonata’s services for Oracle database servers include architecture and designing of database implementation, implementation of high-availability solutions and other services like performance tuning backup, recovery planning, designing and maintenance.
Architecture and Design
For architecture and designing of Oracle database servers, Sonata offers implementation, consulting and re-organization services, such as :
 |
Database configuration
|
 |
Data replication (bi-directional)
|
 |
Multi-master replication
|
 |
Development and testing support
|
 |
Sizing and implementation, considering the network topology, hardware, software and storage, including options such as Database Vault, TimesTen, Secure Backup and Real Application Test.
|
High-Availability Solutions
Sonata implements high-availability solutions based on its experience, knowledge and the best practices laid down by Oracle for high availability. ‘High availability’ is to provide appropriate redundancy and adequate protection from planned as well as unplanned database outages, and to ensure consistent high performance and enhanced security. By reducing the complexity of the design and maximizing the availability through load balancing and reduced resource utilization, maintenance costs can be driven down.
Sonata’s services in the area of Oracle high-availability solutions include consulting, designing and implementation of the following Oracle products :
 |
Real Application Cluster
|
 |
Data Guard (Active-Active / Active-Passive)
|
 |
Streams (a critical data replication and integration feature)
|
 |
Grid computing
|
Upgrade Services
Sonata also addresses the upgradation requirements of Oracle customers. Sonata’s services include upgradation of binaries and data migration from lower versions to the latest versions of the products across all the platforms. Sonata services these requirements using tools and customized execution method. While executing these services, Sonata’s objective is to reduce the required time as well as the downtime of the production upgrade.
Migration Services
Sonata provides consulting, implementation and maintenance services to competitive database users to migrate them to Oracle products and vice-versa.
Other Database Service
 |
Performance Tuning : Performance tuning of databases using Oracle tools such as Statspack, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), TKPROF, IOSTAT and VMSTAT,
and the best practices
|
 |
Backup & Recovery : Advice on backup and recovery strategies and methodologies for the usage of storage such as Flashback, Automatic Storage Management (ASM) and Cluster File System, and integration of the backup policy with the organization’s risk management strategy
|
 |
Maintenance of Application Server : Sonata provides maintenance services for database servers. These services include monitoring of servers and log files, storage, patching and regular housekeeping of servers.
|
|