RDBMS – MongoDB ETL Demo http://jsonstudio.com/rdbms-mongodb-etl-demo/ SQL access to MongoDB using SonarSQL Demo http://jsonstudio.com/sql-access-mongodb/
This discussion is a starting point for providing the inital platform for knowledge sharing & discussion of various aspects regarding newly introduced MS SQL Server 2012/2014 Columnstore Indexes . Overview: A Columnstore index can be defined as a technology for…
Considering Oracle’s increase in their Li sense cost – the Open source databases like PostgreSQL & MariaDB can be partially replace Oracle in your some of your Applications/Projects. Please check the below comparison in their features. We observed they both are good…
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…
# mysql -u root -h 127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.5.8 MemSQL source distribution (compatible; MySQL Enterprise & MySQL Commercial) Copyright (c) 2000, 2011, Oracle…
The following table presents the various SQL terminology and concepts and the corresponding MongoDB terminology and concepts. SQL Terms/Concepts MongoDB Terms/Concepts database database table collection row document or BSON document column field index index table joins embedded documents and linking…
Imagine, you have java package not available in your SERVER#1 and you know it is available with SERVER#2. Then you can copy the require yum repositories configs from SERVER#2 to SERVER#1 as below and do a yum install. 1) Check…
Step 1: Install the below required packages on all the servers which you want to make MemSQL Cluster. Required Packages for MemSQL Installation :- —————————————— [root@hostname rpms]# ls -lhtr total 118M -rw-r–r– 1 mongod games 2.8M May 14 06:43 binutils-2.20.51.0.2-5.36.el6.x86_64.rpm…
< Hadoop – Single node set-up document > 1) Create hadoop group & user [root@myhostname hpadmin]# groupadd hadoop [root@myhostname hpadmin]# [root@myhostname hpadmin]# adduser -g hadoop hadoop OR [root@myhostname hpadmin]# adduser -g hadoop hduser [root@myhostname hpadmin]# 2) Download & Install the…
http://www.apache.org/dyn/closer.cgi/hbase/ [root@my-master-host 2]# tar -zxvf hbase-0.98.3-hadoop1-bin.tar.gz [root@my-master-host 2]# ll -lhtr -rw-rw-r– 1 hpadmin hpadmin 64M Jul 14 05:44 hbase-0.98.3-hadoop1-bin.tar.gz drwxr-xr-x 7 root root 4.0K Jul 14 05:48 hbase-0.98.3-hadoop1 [root@my-master-host 2]# [root@my-master-host 2]# [root@my-master-host 2]# [root@my-master-host 2]# cd hbase-0.98.3-hadoop1 [root@my-master-host hbase-0.98.3-hadoop1]#…