Friday, August 1, 2014

Our summer visit to Plattsburgh


Few days ago, we were at a friends place. The discussion turned to summer plans. Someone turned to us and asked what our plan was. Then another friend said "I know you will be going to Plattsburgh. What is your summer plan in addition to going to Plattsburgh?". Our annual visit to Plattsburgh is emblematic of our summer plan. Everybody that knows us  knows about our annual pilgrimage to Plattsburgh in summer. 

Plattsburgh is a quiet town of about 20,000 residents by lake Champlain. Named after the great explorer Samuel de Champlain, this lake was supposedly included in the list of great lakes. But then just as Pluto was kicked out of the list of planets and made into a dwarf planet, Lake Champlain also lost the designation of "Great lake". Plattsburgh is only 30 miles from Canadian border. Once I took a wrong turn and ended in Canada. It is obvious that the region has a french connection. It used to be a part of French colony in colonial era before changing hands to British. The region became a part of America in 1783 through the treaty of Paris. But it would be another century before Mr. Platt would found the city of Plattsburgh.

We wanted to beat the Friday traffic but we did not have much luck. However, the crowded road became more deserted as we drove through New Hampshire. The journey took us through the picturesque mountains of Vermont. The road, with pine tree on both side, curls up around the mountains and vanishes somewhere in the horizon. Driving in this hilly terrain brought memories of driving in Swiss Alps and Scottish highlands.  When we started, the bright sun was over our heads. As we drove through Vermont, it turned to a bright red ball and started playing pick a boo with us as it would intermittently hide behind the mountains and then would suddenly show up. 

When it finally took refuge behind the mountains, thick black darkness descended over the landscape. We could tell that we are close to French speaking Canadian province of Quebec as bilingual signs in the interstate highway becomes more frequent and the unit in mile stone changed from Miles to Kilometers. The final phase of the trip is crossing lake Champlain by ferry from Grand Isle Vermont to Plattsburgh NY. My kids eagerly wait for this part.  Ankita kept looking for the state line, which is in the middle of late Champlain, in the GPS. She always gets very excited by the number of states we have crossed in a road trip. The above video was taken during our return trip.

Thursday, July 31, 2014

These totals are from the official measurements at Logan Airport for the top ten storms on record (dating back to 1892) here in Boston. Where will winter storm Nemo end up in this list?

Wednesday, December 5, 2012

Windows 8


I decided to upgrade my desktop to 64 bit version of Windows 8. It was running 32bit Windows XP. I rarely use my desktop. But the other day I poked around and broke something. So, I though I would just upgrade the OS. I walked in to the local Staples from work and picked $69 Windows 8 Pro. It comes with two CDs. One for 32 bit version and another one for 64 bit version. I think this was the smoothest installation ever.

First I upgraded from XP 32bit to Windows 8 32bit. I entered the product key and the installer took care of the rest. The whole thing took about 90 minutes. Next, I booted from 64bit CD and changed OS from 32 bit to 64 bit. Again, all I did was keying in the product key. The installer ran for about 60 minutes. Next thing was setting up my WiFi connection. That's it! I was ready for driving Windows 8!!

I saw some negative comment on the look and feel of Windows 8. But, I am liking Windows 8. I don't have a touch screen. I think the experience will great with the touch screen.

Only one complication I have noticed so far is that I am unable to use Office Outlook web. I can login but I am unable to click on the mails. Well, I shall work on it another day.

Wednesday, November 28, 2012

Comparison of Netezza, Vertica and Greenplum

.

Netezza(IBM)Green Plum (EMC)Vertica(HP)

.

URLwww.netezza.comwww.greenplum.comwww.vertica.com

.

ArchitectureMPPMPPMPP

.

Data StorageRowColumnColumn

.

supports SQLYesYesYes

.

Supports Postgrace SQLYesYes

.

supports JDBCYesYesYes

.

supports ODBCYesYesYes

.

Supports Map Reduce Yes

.

OSRed Hat LinuxSolarisLinux

.

ProcessorNetezza ProprietaryAMD Opteron(Sun Fire X4500)Intel

.

Memory HP Blade

.

Disk SATAProliant

.

Network Gigabit Switches

.

Hardware HP BladeSystem

Saturday, November 24, 2012

Inmon vs. Kimball




Inmon and Kimball are two influential data warehousing experts who have shaped the design philosophies of current data warehouses. Though there are similarities, there some fundamental differences. I have tried to document the differences here.

.

Inmon Kimball

.

Bus ArchitectureHub and Spoke Architecture

.

.

Top down approachBottom up approach

.

.

Design ApproachLarge centralized enterprise-wide data warehouse, followed by several satellite databases Several data marts that serve the analytical needs of departments, followed by “virtually” integrating these data marts for consistency.

.

.

Data StructureRelational-model (third normal form: 3NF) Multi-dimension model (star-schema and snowflakes).

.

.

Granularity of dataMost granular level possible and must include all the possible historical data within an enterprise.

Monday, July 23, 2012

The three Vs of Big Data.


While talking about Big Data, we always thing about the “Big”(Volume) part. But we should also think about velocity and variety of data to get the complete picture of data.

Volume
  Size of dataset (Terabytes/Petabytes)
   Number of counting records, transactions, tables, or files.


Variety
  Structured
  Unstructured
  Semi Structured
  All of the above.

Velocity
  Batch
  Real Time
  Near Time
  Streams

Tuesday, April 3, 2012

Hype Cycle of Emerging Technologies

I came across this very interesting chart on hype cycle on a paper from Gartner.