Building Business Rules Engines with Drools – Power to the SMEople
One of the most amazing things about working in software development is the ability to work in many different industries – especially if you’re a consultant. Most software development skills you learn while working within one industry are directly transferable to any…
Create dblink from oracle to memsql
Install required RPM packages Configure ODBC gateway Setup environment variable Configure listener.ora and tnsnames.ora Configure ODBC listener Create database link and test2 Environment: Database DB Name DB Version Host Name OS Version Oracle PCRADMN…
YCSB Benchmarks on Amazon RDS Oracle
[root@ip-10-0-0-67 ycsb-0.1.4]# ll -lhtr total 16M -rw-r–r–. 1 501 games 479 Feb 18 2012 NOTICE.txt -rw-r–r–. 1 501 games 7.9K Feb 18 2012 LICENSE.txt drwxrwxrwx. 2 501 games 102 Feb 22 2012 workloads -rw-r–r–. 1 501 games 2.3K Feb 23…
[Oracle]: SQL*Plus Client installation (sqlplus)
[root@ip-10-0-0-67 ~]# cd /home/ec2-user/ [root@ip-10-0-0-67 ec2-user]# ll -lhtr total 100M -rw-r–r–. 1 root root 95M Feb 24 2012 ycsb-0.1.4.tar.gz -rw-rw-r–. 1 ec2-user ec2-user 809K Jul 7 03:57 oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]# [root@ip-10-0-0-67 ec2-user]#…
[ RDBMS to MongoDB ] Best practices for Migration
Relational databases are being pushed beyond their limits because of the way we build and run applications today, coupled with growth in data sources and user loads. To address these challenges, many companies, such as MTV and Cisco have migrated…
SQL Converter
Database and SQL Migration Tools : ========================= This site really worked for me and it can convert a bunch of different DDL commands from Oracle, MySql, MS-SQL Server, Sybase and others. http://www.sqlines.com/online SQLines provides database migration tools: Database Schema (DDL) Conversion…
Intro to Spring Data
The spring-data project offer abstraction and unified data access for variety of data sources. Category Sub-project Relational Databases JPA Spring Data JPA – Simplifies the development of creating a JPA-based data access layer JDBC Extensions Support for Oracle RAC, Advanced Queuing,…
How to do Yahoo! Cloud System Benchmark (YCSB) for Oracle DB
Yahoo! Cloud System Benchmark (YCSB) for Oracle DB :- Sample Reports Description W/T – secs Threads# 10 Threads# 25 Threads# 30 Threads# 50 Update heavy workload (50%R : 50% W) Workload# a 1777…