Replica sets in MongoDB

Replica sets is a feature of MongoDB for Automatic Failover, in this setup there is a primary server and the rest are secondary servers. If the primary server goes down, the rest of the secondary servers choose a new primary via an election process, each server can also be assigned number of votes, so that you can decide the next primary based on data-center location, machine properties etc, you can also start mongo database processes that act only as election tie-breakers these are known as arbiters, these arbiters will never have data, but just act as agents that break the tie.

Read more

Share

Schema less databases and its ramifications.

Entity design in schema-less databases

Read more

Share

Effective use of data for better customer experience.

Using data over a period of time

Read more

Share

Schema design in a document database

We are using MongoDB on our project, since mongo is document store, schema design is somewhat different, when you are using traditional RDBMS data stores, one thinks about tables and rows, while using a document database you have to think about the schema in a some what different way. Lets say, we want to save a customer object, when using a RDBMS we would come up with Customer, Address, Phone, Email.

Read more

Share

My experience with MongoDB

The current project I’m on is using MongoDB. MongoDB is a document based database, it stores JSON objects as BSON (Binary JSON objects). MongoDB provides a middle ground between the traditional RDBMS and the NOSql databases out there, it provides for indexes, dynamic queries, replication, map reduce and auto sharding, its open source and can be downloaded here, starting up mongodb is pretty easy. ./mongod --dbpath=/user/data/db is all you need, where /user/data/db is the path where you want mongo to create its data files.

Read more

Share

Workshop at Enterprise Data World 2010

Doing a workshop on Agile Database Development at Enterprise Data World 2010 at SF. See you there.

Read more

Share

Testing in data conversion projects

Testing Data Conversion projects

Read more

Share

Ruby OCI 2.0 Array binding

We have been doing some data moving lately using Ruby and Ruby-OCI. We started with Ruby OCI 1.0 and did use prepared statements with bind variables (since we are using oracle database and pulling data from an oracle database and pushing data to an oracle database). Later we found this really cool feature in Ruby-OCI8 2.0 where you can bind a whole array and just make one database trip for many database operations.

Read more

Share

Create an Index for all FK Columns in the database

Index scans on FK columns

Read more

Share

Materialized views and database links in oracle.

Using materialized views as an interface oobject

Read more

Share