OLTP Solution in Financial Industry

High Availability Disaster Recovery Performance Optimized Productivity Cost and ROI

OLTP in Financial Sector

HA+DR (Option1)

HA+DR (Option 2)

HA+DR (Option 3)

Leading TPC-E Benchmark Accelerate the performance of I/O using data

compression capabilities Scale to 250 Million Subscribers 25 million capitalizations and account accruals in

less than 42 minutes 1TB of data in less than 30 minutes using ETL

tools

Performance in SQL Server 2012

SQL Server Data Tools T-SQL Enhancements SQL Server Management Studio Efficiently Manage Data Integration Services Data Protection Control Access Policy-Based Management Compression of database and backup Most Secure of any of the major database

platform by NIST

Optimized Productivity in SQL Server 2012

SQL Server Migration Assistant (SSMA) tool for Database Transition

Power Builder Migration Tool for Application Migration

Sybase DBA skill sets can transfer to SQL Server with minimum risk

The risk of migrating from Sybase ASE to SQL Server is low because both Technologies are using T-SQL Language

Migration Flexibility ( Sybase ASE to SQL Server 2008 /2012)

Features SQL Server T-SQL Sybase T-SQL

Indexes B-tree indexes B-Tree indexes

Tables Relational tablesTemporary tables

Relational tablesTemporary tables

Triggers AFTER triggers,INSTEAD OF triggers

Login triggers,AFTER triggers

Procedures T-SQL statements T-SQL statements,SQLJ stored procedures

User-defined functions Scalar functions, inline table-valued functions, multistatement table-valued

functions

SQLJ functions

Indexed views Supported Not supported

Alter procedures, triggers, views Supported Not supported

Partitioned views Supported Not supported

Multiple triggers Supported Not supported

Aggregate functions Supported Not supported

Global cursors Supported Not supported

Global temporary tables Supported Not supported

T-SQL features in SQL Server and Sybase

Feature SQL Server 2012 Enterprise

Sybase ASE EE Oracle 11G R2

Base $27,496 $88,540 $95,000

Disaster recovery Included $50,590 $11,500

High availability Included $10,110 $23,000

Encrypted columns Included $20,230

$11,500 Data compression Included Not available

Table partitioning Included $20,230 $11,500

Security Included $10,110 $11,500

Transparent Data Encryption Included Not available $11,500

Full text search Included $9,990 Not available

Policy-Based Management Included Not available Not available

OLAP Included Not available $23,000

BI Included Not available $23,000

Total $27,496 $209,800 $221,500

Cost

ROI

3 years Risk-Adjusted and Non Risk-Adjusted ROI Benefits

Risk-Adjusted Non Risk-Adjusted0%

20%

40%

60%

80%

100%

120%

140%

160%

180%

200%

149%

189%Greater productivity Of IT Staff

Incremental Productivity of Application Developers

Avoiding Potential service level Agreement penalties

Greater Productivity and Delivered Business value for Information Workers

Total cost of ownership

SQL Server 2012 OLTP Solution

High Availability

Cost ROI

SQL Server

2012 OLTP Solution