Database Virtualization

3 virtual databases · query matching through JDBC proxy

Database	Engine	JDBC URL	Routing	query/min	Latency
Core Banking (Oracle)	Oracle	jdbc:oracle:thin:@vs-qa.sv.io:1521/COREQA	Virtual	2140	11 ms
CRM (PostgreSQL)	PostgreSQL	jdbc:postgresql://vs-qa.sv.io:5432/crmqa	Hybrid	680	8 ms
Reporting (MSSQL)	MSSQL	jdbc:sqlserver://vs-qa.sv.io:1433;database=RPTQA	Virtual	90	320 ms

Core Banking (Oracle)

SELECT * FROM ACCOUNTS WHERE CUST_ID = ?

120 satır · Key Based

SELECT BALANCE FROM LEDGER WHERE ACC_NO = ?

500 satır · Dataset

UPDATE LEDGER SET BALANCE = ? WHERE ACC_NO = ?

1 satır · Affected Rows

CRM (PostgreSQL)

SELECT * FROM customers WHERE email = $1

300 satır · Dataset

SELECT count(*) FROM tickets WHERE status = $1

1 satır · Weighted Random

Reporting (MSSQL)

EXEC sp_DailySummary ?

45 satır · Sequential