I guess you have missed out the latest reports in Indian newspapers regarding the corruption scandal that has broken out of the CommonWealth Games Organizing committee. They are renting stuff for 45 days by paying more money than is required to buy that item in first place. Contracts have been given to the relatives of the OC members, and stadium rooftops are falling down hours after inauguration.
All this results in more money being spent, in addition to the insult that the nation carries because of this bunch of "organizers". And who pays the money, the poor taxpayer like me and you (assuming you are a salaried indian). The fact that the budget of the event has come to about 10 times the original estimates is an alarm bell nobody is ready to listen to. At this moment, everybody is in a mood, "ok, so what if some corruption happened, some planning glitches, they happen everywhere. Lets spend some more of tax payer money, and try to fix it."
I read a statement by Mr Aiyyar, where he was wishing for the games to fail. Perhaps its a cost that other nations need not pay (by appearing in a failed games event), but may be thats what this corrupt govt system needs to wake up, and change a few things for good...
I dont even want to start about the level of preparations for the event, and the mismanagement that is rampant in there... Let me just say this much, I've never felt worse on being part of what its they call "India". Its genuinely a shame to be called from the same country as these corrupt organizers and their bosses are...
Just one example to point to the corruption level, they are renting, mark my word, renting, not buying a chair for the event (i.e. about 6 weeks) for about 8000 INR, which would be used by spectators, whereas you can buy a decent chair for a few hundred rupees... Thats the worth of taxpayer's money in this country... and this report was filed by Vigilence committee a while back, nobody took note of it, until someone filed a RTI request...
Shame organizers.. shame..
what are we ? we are what we experience. And some more. I bring together here, collective experiences from different parts of life..
Thursday, August 5, 2010
Corruption @ Common Wealth Games in Delhi
Monday, August 2, 2010
Country General Mood using Tweets
http://www.iq.harvard.edu/
I quote - (with all credits where its due, none to me...)
A group of researchers from Northeastern and Harvard universities have gathered enough data from Twitter to give us all a snapshot of how U.S. residents feel throughout a typical day or week.
Not only did they analyze the sentiments we collectively expressed in 300 million tweets over three years against a scholarly word list, these researchers also mashed up that data with information from the U.S. Census Bureau, the Google Maps API and more. What they ended up with was a fascinating visualization showing the pulse of our nation, our very moods as they fluctuate over time.
The researchers have put this information into density-preserving cartograms, maps that take the volume of tweets into account when representing land area. In other words, in areas where there are more tweets, those spots on the map will appear larger than they do in real life.
A apparantly public domain result of the analysis is available here -
http://cdn.mashable.com/wp-
Tuesday, July 27, 2010
Oracle Count(1) vs Count(*)
Well, it might have been an everlasting discussion about which one of these to use, count(1) or count(*).
I guess, this article of Thomas Kyte already clarified the situation long long ago (well, for IT industry 2005 is long ago anyway, especially given the speed at which we are moving.)
Essentially, what askTom says that, count(*) is better than count(1) since count(1) translates to count(*) internally anyway. I wonder then, why would someone want to use count(1) anyway.
There is at least one more step involved in getting to the actual result. And there is another possible tweak, count(1) has to evaluate an expression as well, "count(1) where 1 is not null". Though its a tautology equivalent, it has to be evaluated nonetheless.
Further, there was some misconception about how the result is returned, whether its read from the data dictionary, this view or table or something like that. I dont think so. The result is calculated at the exact run time,when the query is run, and it actually goes ahead and counts the records in the table.
Should set the record straight...
Friday, July 23, 2010
Developing a Rails application using an existing database
Initially we needed the basic CRUD screens for some tables. Being lazy (i m really proud of that), I set out finding if there a solution that generates the forms (read views) for the existing tables/models.
I have already managed to generate models/schema.rb using another gem. This is called magic_model. Read more about that here
Then google helped me find this another gem called scaffold_form_generator which generates the necessary views/forms for a given model. However, there need to be some improvements required on that (I think). perhaps I would contribute something (if I find out enough on how to do that)
Well, for the moment, I am struggling with handling of the missing special meaning column from the legacy tables. Will continue writing on this...
Wednesday, July 21, 2010
Making rails talk to SQL Server Express Edition
Make an odbc connection - pointing to the db server, preferably make a sql server authentication user
Install the following gems
- activerecord-odbc-adapter (2.0)
- activerecord-sqlserver-adapter (2.3.8)
- dbd-odbc (0.2.5)
- dbi (0.4.5)
- deprecated (2.0.1)
Further, I copied odbc.so and odbc_utf8.so files from http://www.ch-werner.de/
My database.yml file looks like this -
development:
adapter: sqlserver
mode: ODBC
dsn:
username: myUserName
password: myPassword
Thursday, July 15, 2010
winscp vs cuteftp
I recently had an experience of transferring relatively larger files from a windows box to linux one.
I had some files which were ranging from 2.1 GB to 4.x GB. The company traditionally uses cuteftp to transfer (read ftp) files across servers. So I started with that anyway.
However, all my transfer attempts were failing. After transferring 2 GB of data, cuteftp would end the transfer and give away some or other error message. I figured that this was happening only to files which were larger in size. And this transfer consumed more than hour or so before it failed.
Google couldnt help a lot, so, finally i got down to winscp. And, it worked out so well. Not only the transfers didnt fail, but they finished within minutes, instead of the hours and hours spent by cuteftp.
Perhaps its some setting somewhere in cuteftp that I couldnt find, but the whole experience has left me more inclined towards the open source community.
Thanks a ton guys .. :)
Wednesday, July 14, 2010
Trying to become a Data warehousing architect... !!!
- Describe advantages of the CIF architecture versus the bus architecture with conformed dimensions. Which would fit best in our environment given [some parameters they give you] and why
- Describe snow-flaking
- Describe fact-less fact tables.
- Draw a star schema of our business
- Describe common optimization techniques applied at the data model level
- How do you handle data rejects in a warehouse architecture?
- Describe common techniques for loading from the staging area to the warehouse when you only have a small window.
- How do you load type 1 dimensions
- How do you load type 2 dimensions, and how would you load it given our [insert business particularity]
- How would you model unbalanced hierarchies
- How would you model cyclic relations
- What major elements would you include in an audit model?
- How would you implement trace-ability ?