Archive for July, 2011

Flashback ability with HBase

Wednesday, July 27th, 2011

Oracle has a great feature called flashback query. This allows a user to (try to) query a row as it existed at some point in the past. It provides this functionality by trying to find the necessary UNDO to reconstruct the row as it existed at the time the user requested. If the necessary... »

Posted in Database, NoSQL | No Comments »

Printing all property values in an HBase configuration

Wednesday, July 13th, 2011

I’m sure there is an easier (perhaps built-in) way to do this, but for now, I wanted to document how you can print all properties for a given configuration that you load into a JVM. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19... »

Posted in Database, HBase, NoSQL | No Comments »

Loop through and print directory size

Wednesday, July 6th, 2011

1 2 3 4 5 6 7 8 9 10 11 Set objShell = CreateObject("WScript.Shell") Set objFSO = CreateObject("Scripting.FileSystemObject")   Set objFolder = objFSO.GetFolder("C:\")   Set colSubfolders = objFolder.Subfolders   For Each objSubfolder in colSubfolders on error resume next Wscript.Echo objSubfolder.Name, objSubfolder.Size Next »

Posted in Windows | No Comments »

Simple HBase stress tester

Wednesday, July 6th, 2011

What is below is a simple class to read a random set of records from a table. This should be a good start if you are looking for a simple one class test case, that may also be useful for simple stress testing. As other example regarding HBase, it assumes you have configured your... »

Posted in Database, NoSQL | No Comments »

Simple HBase class to load data

Wednesday, July 6th, 2011

What is below is a simple java class to load the customers table we created in a previous post 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 import java.util.*; import org.apache.hadoop.hbase.client.*; import org.apache.hadoop.hbase.util.*;  ... »

Posted in Database, NoSQL | No Comments »

Bridging the gap…from SQL to No SQL

Tuesday, July 5th, 2011

For any DBA’s that have had someone call them and ask “What do you know about NoSQL?”, this post is specifically intended. Before you have a conniption fit and began quoting Tom Kyte-ism’s (an exceptionally smart guy, if you do want to quote him ), realize that software is not a religion, and sometimes... »

Posted in Database, NoSQL | No Comments »