Karthi's Blog

காலபேதம்

2011-03-01T14:37:00.003-05:00

நாளும் நீளும் பகல்

இளவெப்பம் ஏற்றி வரும் காற்று

பருவத்திரிவின் அறிகுறியான கனமழை

கடந்தகாலத்தில் இழந்த ஆடையை

விரும்பி அணியும் மரங்கள்

மரங்களின் முரணாய் கல்லூரிப் பெண்கள்

மறித்திருந்த மாக்கள் யாவும் உயிர்த்தெழ

மறைந்திருந்த மக்கள் யாவரும் வெளிவர

இப்படியாக .. நான்,

இப்பிரபஞ்சத்தின் தகவல் கட்டமைப்பை வியந்து,

வசந்தத்தின் வருகையை நோக்கி !!

புலம்பெயர்ந்த சிந்தனை !!

2011-01-16T23:16:00.001-05:00

நளவெண்பா பயிலவேண்டாம்

நன்னூல் நவிலவேண்டாம்

குறளேதும் அறியவேண்டாம்

பகுத்தறிவு பகலவேண்டாம்

அறிவியல் அறிய வேண்டாம்

ஒழுக்கமேதும் இருக்கவேண்டாம்

சமுதாய சிந்தனை வேண்டாம்

மனிதமென்று ஒன்றும் வேண்டாம்

ஆனால் ...

கடல்தாண்டிய பணி வேண்டும்

கைநிறைய பணம் வேண்டும்

தமிழறிந்த மடந்தை வேண்டும்

நம்வழி மறக்க வேண்டும்

பிறர்வழி நடக்க வேண்டும்

வந்தேரியாய் வாழவேண்டும்

வளர்த்த மண்ணை வசைபாடவேண்டும்

இருந்தும் …

தம்மக்கள் தமிழ்பேச வேண்டும்

உடன்படா இவ்வாழ்க்கை விட்டு

என்றேனும் திருநாடு திரும்பவேண்டும் !!

காலாவதிக்க !!

2010-11-29T21:04:00.001-05:00

காதல் தவிர பிற

பாடுபொருள் அறியா

தற்க்கால தமிழ் கவிஞர்களே ,

"காலாவதி" தவறியதா உம் அகராதி ?

இஃதிலா கடவுளர்களும் இல்லை

காதலென்ன , வெறும் கருமம் தானே !

காலாவதியின் கரு அறிவான் ஞாணி

அதனின் காலாவதி பகர்பவன்

கற்பனை புனையும் கவிஞனே!!

ராவணன் !!

2010-05-10T00:47:00.003-04:00

மணி, ரத்தினம், வைரம், முத்து....
மேற்கண்ட இந்நான்கும்
இரநிரண்டே தனி சேர்ந்து
பின் அவை இரண்டும் ஒரு சேர்ந்த
பல படைப்பில் வியப்படைந்து,
புது பரிமாணம் அளிக்குமோ ?? இவர்களின் தற்கால படைப்பு
என்கிற எதிர்பார்ப்பின் விளிம்பில் !!

A Cliché !!

2010-01-07T20:58:00.001-05:00

“It’s been long since I have written a post”

this has almost become a preface for all my recent posts. Blogging is the best way to organize the data you have in mind. We know, Learning is the process of reading/hearing/visualizing and understanding information. The common misconception is, the process of learning does not end with simply knowing facts and statistics. The real understating begins, as we start organizing the data we have learned. It could be either in our mind or in an external medium. Blogging does this exact transition of teaching our consciousness about our subconscious learning.

I think, blogging should be done as and when you feel like expressing something. Failing to do so might dilute the crux of the information you would like to convey. I have a number of scenarios, experiences, and mullings, which flashes in my mind and inspired me to write, but failed miserably to get converted in to post, because of my immature time management and my nomadic interests.

“Time and Space”, “Science behind booking tickets in IRCTC” ,” Abstraction is amazing” are some of the posts which blossomed and vanished out of my mind before I could find some time to write.

Instantaneous and micro-blogging tools like Twitter has made blogger’s life easy, obviously by making them lazy. Eventually, It has made some occasional and emerging bloggers impotent. Twitter is good in the way of communicating your thoughts short and quick though its dirty. At the same time, it grabs once opportunity to write a well thought and planned posts by serving a perky way to share your thoughts in Mobile phones.

I know, humans always wanted a scapegoat to blame for their failure. Analyzing my situations make one thing clear for me

The need of the hour is “discipline”.

Google’s Milestones in 2 Minutes

2009-10-27T18:06:00.001-04:00

Time constraints made me to blog less and tweet more. But I am still consciously trying to pen-down my thoughts. I believe that “ Google is the best thing that has happened to us in this 21st Century”. I would say, it is analogous to “Inventing Wheel” or “Understanding structure of human DNA”. We can talk about the array of services provided by Google, but we couldn’t find our time enough for doing so.

This video enumerates the milestones of Google in 2 minutes.

Source: youtube

Gmail - Dockable Labels

2009-07-02T02:38:00.001-04:00

Google came up with new docking features in Labels of Gmail. Inspite of clear and lite interface, Gmail users were complaining the difficulty involved in archiving or grouping related mails using folders. It was partly due to the fact that most user were novice in using labels or more accustomed to folders provided by yahoo. To elucidate this, Gmail introduces “move to” option in Gmail. This feature allowed us to simply select mails and choose the labels under which we need to group or archive it. Yesterday moving one step ahead in imparting simplicity in Gmail interface, it has introduced a dockablity of mails into labels. In other words, simply you can drag and drop mails into labels, virtually folders. Dockability has eventually turned this labels in to folders.

Additionally, we have options to set the visibility of each labels under “manage labels” settings. It provisions us to disable infrequently used labels and default options like All Mails and Sent Mails which make the interface hassle free and simple. We can drag any label and drop in to different part of the browsers which levitate your label fly back into its position. Web User Interface is evolving right?

Dockable Label

Users, who are getting screwed with heavy mail clients like Lotus Notes are happy to use MS Outlook and open sources like thunderbird. Google is a phase of introducing all adorable features of latest email client in its interface. I guess it may gradually get in to the race of developing a new mail client as they have developed arguably the fastest browser chrome.

Google is the best thing that has happened for us in this information era.

முரட்டுகவி முரளி !!

2009-06-19T13:33:00.001-04:00

மும்பை மாநகரம் எனக்கு தந்த முத்தான நண்பர்களில் குறிப்பிடத்தக்கவர் முரளிதரன். தமிழ் ஆர்வமும், சமுதாய சிந்தனையும் மிக்க முரளி பழகுவதற்கு இனியவர். எங்களது உரையாடல் சினிமா , அரசியல், ஆன்மிகம் என்று தினசரி போல பல பரிமானம் கொண்டிருக்கும்.

ஒரு சமயம் "திருமணம் செய்ய சரியான வயது" என்பதை பற்றி விவாதிக்கும் போது, வது ஏற ஏற பக்குவம் வரும் .. ஆனா..ரெம்ப வயசான எதுவுமே வராதுன்னு சொல்லி முடித்த பிறகு, இரண்டு நிமிடம் ஆனது எனது சிரிப்பை அடக்க. இயற்கையாகவே தனக்குள்ள மொழி ஆர்வத்தை கவிதை எழுதி தீர்ப்பது இவரின் சிறப்பு. இதோ உங்கள் பார்வைக்கு ஒரு மாதிரி, இதன் உட்கரு காதல் எனினும் இவர் பயன்படுத்தும் தமிழ் சிறப்பு!!

/*****************************************/

காளை நான்

காதலை கூறிய போது

கருத்தில் கொள்ளாது

கருப்பாய் இருக்கிறேன் என்றாய்

கேவலமாய் …

பைத்தியகாரி !!

புரிந்துகொள்வாய்

புறக்கணித்து தவரென்று

உன்னிடம் வெறுப்பாய்

நடபோரிடம் நான்

நெருப்பாய் கொதிக்கும் போது

மட்டுமல்ல

நீ தவறாய் முள்ளைக்

கடக்கும் போது நான்

செருப்பாய் வரும்போது கூட ...

-- முரட்டுகவி முரளி

/*****************************************/

எங்களது மற்றொரு நண்பர் முஹமது , இவர் கவிதை யதார்த்தத்தை எடுத்து உரைப்பவை. முகமதின் "மொக்கை கவி" என்ற புனைபெயருடன் தனது படைப்புகளை எழுதி வருகிறார். இவ்வாறன வித்தியாசமான கவிதைகளை தங்கள் சிந்தனையில் மட்டுமே இயற்றி, வெளிஉலகிற்கு தர தயங்கும் தமிழர்களுக்கு இவர்கள் விதிவிலக்கல. இதனை வெளியட தயங்கும் காரணமும் விளங்கவில்லை. இவர்கள் இயற்றும் பண்ணும், பாடலும் இனி இங்கே இடம்பெறும். முரட்டுகவியும், மொக்கை கவியும் சிறந்த தமிழ் படைப்புகளை நமக்கு அளிப்பார்கள்.

குத்திக் காட்டியது - என் தமிழ்

2009-04-23T01:20:00.007-04:00

நிழலின் அருமை வெயிலில் தெரியும் ! இதை நம்மில் பலர் அறிவோம் ஆனால் உணர்ந்தோமா என்பது தனி மனிதரை பொருத்தது. சில நேரங்களில் நாம் படித்து அறிந்த பொருளை பகுத்து உணரும் சூழ்நிலை அமையும். அது

பிறர் எடுத்து உரைக்கும் போதோ
தீவிர சிந்தனையின் போதோ
ஏதேனும் படிக்கும் போதோ

இவ்வாறாக பல சமயங்களின் போது நிகழலாம். அண்மையில் வாசித்து உணர்ந்தது ....இதோ உங்கள் பார்வைக்கு

/************************************************/

தாத்தாவின் மூக்குக் கண்ணாடி
கை தவறி விழும் முன் சொன்னேன்
'Sorry ' தாத்தா என்று …!

தூங்கும் போது கழுத்து வரை
போர்த்தி விடும் கருணை - தூக்கத்திலும் சொல்வேன்
'Thanks ' ம்மா என்று …!

நாளை நண்பனின் பிறந்த நாள் - இன்றே
வாழ்த்து அட்டையில் எழுதினேன்
'Happy Birthday da' என்று …!

காலையில் நாளிதழ் படிக்கும் பொழுது எதிர் வீட்டுக்காரர்
அவர் சொல்லும் முன் முந்திக் கொள்வேன்
'Good Morning Uncle' என்று …!

கோயிலில் பத்தாம் வகுப்பு சிநேகிதி கணவனுடன்
அவள் பேசும் முன் முடித்துக் கொள்வேன்
'Hai' என்று …!

மாலையில் கடற்கரையில் என்னவள் - மணலில்
அவள் விரல் பிடித்தே எழுதுவேன்
'I Love You' என்று …!

இரவில் …
வீட்டிற்கு செல்லும் வழியில் - காலை
குத்தியது முள் …
'அம்மா' என்று அலறினேன்

குத்தியது முள்ளில்லை - என்னை
குத்திக் காட்டியது - என் தமிழ்

/************************************************/

Distant Measurement Tool from Google

2009-03-10T03:01:00.001-04:00

Today, I was checking for some new features from Google Services. Own map creation tool embedded with Google Maps allowed me to add my home from Madurai in My map. While searching for options on the left pane, I found an interesting link named Distant Measurement Tool. I clicked over it. It has equipped me with location balloons for measuring distance. I have placed two location balloons in the map and it has printed the distance between the points and a drop down with different units of measurement. I was amused to to see this feature. Also I have tested the tool by measuring distance between my home and nearest ATM centre.

On changing the displayed units, the measured distance will be converted to the new unit selected. I think, considering the variety and range of people, who are accessing the map, they have listed all possible units to measure length. During my college days, I use to jog around Teppakulam couple of times daily. I thought it was awesome, considering the stamina and energy required. Gradually it had extended to long conversation, sometime debate, with my bro regarding Teppakulam’s perimeter. I guessed it was 1.5 Km, he use to deny it irrespective of whatever I said. So It had become a long term ambition to measure the perimeter of Teppakualm. Though we had an option of doing it with odometer of our motorcycle, I was not convinced with its accuracy. Today Google makes it possible with its immaculate image processing algorithm. Finally Google has measured it as 1181.94 m.

Measuring Teppakulam’s Perimeter

I left you guys to explore the other features available in Google Map.

Oracle Trace Files

2009-03-06T02:39:00.001-05:00

Guys ! as a software engineer you need to know how to work round the clock and also to be idle for weeks, even months. Though I have experienced the former for most part of my career, last couple of months I was bound to undergo the second and most boring phase. Fortunately, I have identified this within a couple of days and also figured out a possible remedy for this monotonous phase I was heading towards. That is my friends… “Installation and configuration of Metasolv” . I have to agree that it was really challenging to install M6 from scratch. Amid my new learning, the notable one is Trace files in Oracle. Despite the trace option in Metasolv, I had to avail Oracle trace option to troubleshoot some privilege issue.

Trace is a feature in oracle which enables you to log minute details of a session. Enabling trace for a session will make oracle to log the session details in a file called trace file with extension “.trc”. A proper naming convention has been followed by oracle for these trace files.

“DB_NAME”_ORA_”SID”.trc

DB_NAME – Global database name

SID- Session id

Example: mssdev_ora_2308.trc

Enabling trace

Trace can be enabled session wise. We can enable session using a simple alter statement from a particular session or using DBMS_SUPPORT package provided by oracle.

ALTER SYSTEM SET trace_enabled = TRUE; for enabling trace.
ALTER SYSTEM SET trace_enabled = FALSE;for disabling trace.

If you would like to enable trace for another session apart from your current session, you can use DBMS_SUPPORT package.

SQL> desc dbms_support
Element         Type
---------------------- ---------
PACKAGE_VERSION               FUNCTION
MYSID                                FUNCTION
START_TRACE                     PROCEDURE
STOP_TRACE                      PROCEDURE
START_TRACE_IN_SESSION   PROCEDURE
STOP_TRACE_IN_SESSION     ROCEDURE

Last two procedures described above are used for starting and stopping tracing for any session that currently exists in the database. Lets see a method for enabling trace for all active sessions for a particular user using a simple BEGIN-END block.

BEGIN
for c in (select s.sid     sid,
                   s.serial# serial
            from   v$session s
            where s.USERNAME = 'ASAP' and
                   s.status = ’ACTIVE’)
loop
    dbms_support.start_trace_in_session(c.sid, c.serial);
end loop;
END;

Use dbms_support.stop_trace_in_session (c.sid,c.serial); for stopping the tracing. Trace file provides each and every details of the session. A sample trace file will be like this.

=====================================================================

Dump file c:\oracle\admin\mssdev\udump\mssdev_ora_2308.trc
Wed Feb 18 13:01:42 2009
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Instance name: mssdev

Redo thread mounted by this instance: 1

Oracle process number: 15

Windows thread id: 2308, image: ORACLE.EXE

*** 2009-02-18 13:01:42.000
*** SESSION ID:(9.23) 2009-02-18 13:01:42.000

PARSING IN CURSOR #2 len=79 dep=0 uid=73 oct=3 lid=73 tim=259898785365 hv=4060294543 ad='1cd62f00'

SELECT global_name FROM global_name
END OF STMT
PARSE #8:c=15625,e=17422,p=0,cr=2,cu=0,mis=1,r=0,dep=0,og=4,tim=2592960232
BINDS #8:
EXEC #8:c=0,e=1358,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=2592968343
WAIT #8: nam='SQL*Net message to client' ela= 3 p1=1952673792 p2=1 p3=0
WAIT #8: nam='SQL*Net message from client' ela= 3338 p1=1952673792 p2=1 p3=0
WAIT #8: nam='SQL*Net message to client' ela= 1 p1=1952673792 p2=1 p3=0
FETCH #8:c=0,e=1422,p=0,cr=3,cu=0,mis=0,r=1,dep=0,og=4,tim=2592977265
WAIT #8: nam='SQL*Net message from client' ela= 36895 p1=1952673792 p2=1 p3=0

=====================================================================

Every line in the trace file has statistics embedded in it, we have to decipher the trace file to understand the details of the session. For example PARSE line shows, the length of the cursor (len=79), the user id of the person parsing the cursor (uid=73), the time the parse began (tim=) and the SQL address of the cursor (ad=). As you will see shortly, we can reference the ad= line to v$sqlarea and get the text of this cursor.

Some commonly used variable in the trace file are

C= cpu time, e=elapsed time, p=number of database blocks read, cr=number of consistent mode blocks read. cu=number of current mode blocks read, mis=number of library cache misses, r=number of rows, og=optimizer goal (1=all_rows, 2=first_rows, 3=rule and 4=choose)

It shows values of these variables for each each section like parsing, binding with variable values, executing, waiting and fetching the records. Reading this file would gives us the understanding of

Client used for execution
Time and resource involved in executing the query
Number of rows fetched along with optimizer goal

You can read more on Output format of Trace file.

Daddy Is Back!!

2009-02-27T08:50:00.001-05:00

Title is an inspiration from Mr. Barney, man of catchy phrases who has inspired me with his grandiloquent speech even though often it has lame adjectives.

It’s been couple of months now, after I have written a post on Fundamentalism. Time is an amazing entity in this existence which takes us through its manifestations, unconditionally. Lot has happened in these two months which were conglomeration of good and bad, but by the end of the day all are mere perceptions. I came across thoughts and incidents which provoked me to pen down some as posts but I was struggling to conceive all my thoughts as a post of high standards with meticulous flow. It is really motivating to read posts and articles from The Economist, Times of India, but it has created an internal urge for writing new posts with better standards.

Recently added book in my shelf has been a real source of wisdom, English vocabulary and also it explains the physics behind the fabrication of existence and questions one’s understanding of life. Hopefully my next posts will be of real and exciting thoughts which I have perceived in the recent past. With the six senses, our life is stumbling of feeling, varying from agony to ecstasy. It’s really nice to mull over its intricacies.

Let this post be my starter for this season of blogging :)

Fundamentalism is Lethal !!

2008-12-24T05:37:00.001-05:00

This post could be an extension of my previous post and eventually I could have titled it as Rusticating Part II, but intensity of my musings on unpalatable happenings around our world has made me to change the post’s heading.

Today, terrorism and its inhumane atrocities occupy most part of our dailies and weeklies. You could give an endless list starting from Kashmir issue & Tamil Elam Issue in Indian sub-continent to Israel-Palestine issue in middle east. Irrespective of geography, ethnicity and culture, the root case for these outrage is fundamentalism. Let me explain my understating of “ How fundamentalism leads to ruthless outrage?”

“Comparison” is a very basic quality, which human beings possess and uses it in all aspects of life. It gets surfaced in our minds when parents compare us with our counterparts in neighborhood. It is an undeniable fact that “comparison” is a primary dimension of sixth sense, which helps us in analyzing scenarios and making decisions. But, we humans use “comparison” the other way around. World clouded with insecurities, instigates people to compare them with others in terms of language, race, color complexion, geography (lets call these as attributes) etc to identify the aspects in which they are better than others to feel a sense of security. Its very human… right? This process has been fueled by hard core belief on one’s culture that we call as fundamentalism. Evilness of “comparison” comes out in the process of glorifying ones attributes people are naturally inclined to show disdain to others. People do this unintentionally as they get involved in the act. Sub-conscious mind of human beings executes the comparison process with “disrespect” as a weapon. Consequently, mutual disdain and disrespect between groups of people hampers the harmony in social living and ultimately make their co-existence impossible.

It is evident that these kind of thoughts are predominant with narrow-minded people. But the prevailing situation across the world concludes that more communities and its leaders are vulnerable for this “comparison”. It gives them a sense of pride, security, holiness or whatever terminologies which give them a belief that they are superior (indirectly secure). This happens at every level; between two villages in a district, between two states of a country and eventually between two countries and religion. In recent times, India is witnessing results of these fundamentalism in forms communal riots and cross border terrorism. So border issues, communal problems and terrorism are derivatives of fundamentalist thoughts endorsed by extremist act.

If you take any issue as an example, both sides (involved) can list innumerable points to justify or rationalize their stand, supported by historical data and sentiments of people. In fighting for the cause of unreal attributes, people forget the basics of life i.e LIVING. Yes, solution should be derived, but, by considering the fact that people in the concerned region are born to live.

“Comparison” is natural and a quintessential part of life. It separates us from animals. The good or evil depends on how we decipher the result of comparison; either with narrow-mind to cause social disintegration or with open-mind to cause social harmony. Life with no disdain for anyone, open minded thinking, social tolerance, non-fundamentalist leadership would improve the social harmony and make this world a place to live.

சிந்தனையை தூண்டிய கவிதை !

2008-12-09T11:58:00.000-05:00

நேற்று, பொழுதுபோக்குவதற்கு கூகுளின் உதவியை நாடினேன். எங்கிருந்தோ வந்த தமிழ் கவிதை ஆர்வமும், கூகிளின் நேர்த்தியும் கீழே இடம்பெற்றுள்ள கவிதைபக்கத்துக்கு எடுத்து சென்றது. பல ஆண்டுகளுக்கு பிறகு சிந்தனை மிகுந்த ஒரு கவிதை படிக்கும் வாய்ப்பு கிட்டியது. இதோ உங்கள் பார்வைக்கு அந்தக்கவிதை …

நன்றி கூடல் தளம்

Diagnosing Oracle Database Performance

2008-12-05T03:36:00.001-05:00

RDBMS has been my area of interest for the last couple of years and mainly I have been working on improving performance of oracle database by tuning queries, writing sql scripts for load monitoring and killing blocking locks. I joined my project as a novice in database before two years and faced lot of challenges in maintaining a database centric application called Metasolv. I have compiled the steps involved in troubleshooting and diagnosing performance of an oracle database (DB).

Identify Users With Maximum Active Sessions

Applications use to create sessions with database using drivers like JDBC/ODBC for executing the statements( queries, DDLs, DMLs etc). “Users” are DB objects used for creating sessions. We can identify the number of active sessions for every users connected to the DB using the following query.

select substr(s.username, 1, 18) username,
       substr(s.program, 1, 15) program,
       count(1) session_count
from v$session     s,
       v$process     p,
       v$sql         q
where s.paddr = p.addr and
          s.status = 'ACTIVE' and
       s.sql_address = q.address
       and p.BACKGROUND is null -- exclude oracle process
group by substr(s.username, 1, 18) ,substr(s.program, 1, 15)

USERNAME             PROGRAM           SESSION_COUNT
------------------    ---------------         ----------------
KARTHI                sqlplusw.exe                1
MSLV                  DbUser                       8
REPORTS             busobj.exe                  2

“PROGRAM” column gives us the client used by users for connection.”DbUser “ indicates session created within the db itself. Pick the user with erratically high session count and drill down into minute details by following these steps.

Identifying Time Consuming Queries

This step involves measurement of time taken by queries, which are executed by user we identified in the previous step. From result-set identify the maximum time consuming queries.

For example, lets take the “REPORTS” user for proceeding further.

select distinct v.sid,
                v.serial#,
                s.sql_text,
                trunc(v.last_call_et / 60, 2) minutes,
                trunc(v.last_call_et / 3600, 2) || 'Hr' Hours,
                v.logon_time
from   v$session v,
       v$sql     s
where v.username = 'REPORTS' and
       v.status = 'ACTIVE' and
       v.sql_address = s.address
order by 4 desc;

SID    SERIAL# SQL_TEXT   MINUTES        HOURS          LOGON_TIME

----    -------      ---------      -------          -------       ---------------

940    19336        VIEW_SQL    0.15            0Hr     12/5/2008 12:01:27 PM

The output shows the list of SQLs and the time, i.e how long the SQL is executing and the logon time. Please note the time in minutes and hour are same time but displayed in different units. I replaced the actual SQL by VIEW_SQL text to make the output legible. Pick the query with maximum minutes and tune it using different optimization techniques.

Performance from Lock Perspective

Performance of databases can also be affected due to unavailability of resources. Exclusive lock is the primary reason for unavailability of resources. You can see a descriptive view on oracle locks, an older post from my blog. Still I would like to write down the method of finding waiting locks and its associated details like SQL, users involved, time taken, client details etc.

Identify the waiting locks using this query.

select s.osuser, s.machine, s.sid,s.serial#, s.username, s.LOCKWAIT,
       trunc(s.last_call_et / 60, 3) minutes
from   (SELECT /*DECODE(request,0,'Holder: ','Waiter:') ||*/
         sid sess,id1,id2,lmode,request, type
        FROM   gv$lock
        WHERE (id1, id2, type) IN (SELECT id1,
                                           id2,
                                           type
                                    FROM   gv$lock
                                    WHERE request > 0)
        ORDER BY id1,
                  request) inn,
       v$session s
where inn.sess = s.sid;

OSUSER MACHINE SID SERIAL# USERNAME LOCKWAIT MINUTES

-----------    ----------     ---    ------      ---------      --------------                   -------
    KARTHI   01HW165315     15     6463      MSLV                                         0.183
    KARTHI    01HW165315    471    19501    MSLV    7000001788E9010            0.133

The result set shows that the session with sid 15 is locking an object which cause the session with sid 471 to wait for the same object. The session (15) is holding the object for 0.183 minutes and the session (471) is waiting for 0.133 minutes.

You can get more details of the session (SID) using the following query.

select do.object_name,
       dbms_rowid.rowid_create(1,
                               ROW_WAIT_OBJ#,
                               ROW_WAIT_FILE#,
                               ROW_WAIT_BLOCK#,
                               ROW_WAIT_ROW#) "rowid"
from   v$session   s,
       dba_objects do
where s.sid in (15) and
       s.ROW_WAIT_OBJ# = do.object_id;

OBJECT_NAME                       rowid

-------------------         ------------------
ONE_STATUS_SERV    AAARRlAATAAAAAAAAA

Using the object name and the rowid you can find out the row which has been locked. Reasoning the locks and its types will give us insight of the application’s architecture. After understanding the root cause of the lock you can make the necessary code or architecture changes to avoid locks and there by giving assured performance.

Note: I recon readers to refer oracle documentation for description of all data dictionary views. Also I request the readers to leave their comments on my post which would be a feedback (positive or negative) for me.

Rusticating Part I

2008-12-01T02:16:00.001-05:00

As I mentioned earlier, my desire to decipher the experience on vacation to Madurai made to write this post. Since I am from a domestic project, I was fortunate enough to get a long vacation of two weeks. As I landed, I felt the conducive vicinity around me in forms of language spoken and people’s faces which I am missing for the last couple of years. Simply you could describe it as the summit of nostalgia. Life in Mumbai gave me the opportunity to witness the mammoth infrastructure in terms of roads, apartments, railways, water supply etc. I wondered "We were staying in such a small city !!" as I headed toward my home at Annanagar. Roads were pretty narrow with negligible traffic, which obviates the need for its wideness. From the station, I travelled to home by the so called "City bus", which I would never like to miss whenever I go to my home town. Mumbai-life at the back of my mind and Madurai-life in front of my eyes drag my mind to a comparison between the city I love and the city I live now.

Though detailed plan of rustication had not been made, I had a rough to-do list like meeting friends; discussing with professors ; meeting relatives and of course to eat the delicious meal prepared by mom at home.

Metro-cities like Mumbai have strong affinity towards the western life, where things like personal life, opinion & desire, financial security, job satisfaction are having ultra high priority. For getting these, people are ready to compromise anything and they rationalize their act in the name of “growth”. Recently I read, in In Spite of Gods , that only the society, which urbanize rapidly will be able to grow constantly by providing jobs to all common people. But the recent economic melt down defy this. Even a small crisis on any one of the industry or business sector in the global village creates its amplified repercussion on all possible business and industry there by affecting all class of people. Though we cannot deny the fact that urbanization fueled to exponential growth, equally we should accept that urbanization has increased the vulnerability of our economy for external factors( i.e a business carried out across the boundaries). I am going off the topic.. right?. So the point is, urbanization is good for an extent, but madly following the same would jeopardize our financial stability at times of economic crisis like “Credit Crunch”. Personally I feel, we need to encourage more variety of industry or business as we have to achieve heterogeneity in our business. Amuck westernization would be a barrier for creating a heterogeneity in our business.

After spending couple of days in home I had visited our college for meeting the professors. I was able to visualize some changes in the college, which was on its way to lose the reputation it had. The “university issue” had already segregated the stake holders of the college into group of islands. I felt a sense of insecurity prevailing among the college staffs when I had interacted with them. Our college needs better infrastructure, high profile professors, better course work and all these could be possibly achieved through funds. Perhaps this could be the reason why the agenda of “ The university creation” has been put forth by the management. But you know, there are always two sides for a coin. As an alumni I want a fair decision to be taken by considering all the possible inputs and analyzing all possible pros and cons.

As a part of the vacation I had travelled towns, villages and cities to meet uncles, aunts cousin brothers, cousin sisters, nephews etc. Really nice to be a part of a big family, huh ! I had wonderful time meeting school and college friends especially Vignesh, Reuben, Sathya and Arun (Muthu and Pras were missing). I still remember those penultimate days of our semester exams, when we (me Pras and Reuben) mock at each other in the name of “Preparing for exams”. Amid the vacation, a new fragrance of thoughts on society, culture, economy and politics blossom in my mind. It was quite peculiar compared to thought history dominated by electronics and computers. With all these memories I was getting ready to catch the train towards Mumbai.

On My Way To Rusticate

2008-11-13T01:13:00.001-05:00

Everything was set for my trip to Madurai after a long gap of six months. As planned Gary and I went half hour early to catch Madurai Express, which was about to depart from Lokmanya Tilak Terminus(LTT). My past experience with second class sleeper has provoked me to go for three tire AC car. As we were trying to settle by finding place for our luggage and in search of some amicable co-travelers, we met Maheshwaran, a voluble, outspoken and a typical tamilian. Knowing the fact that a ticket cancelled by us in penultimate day of our journey enabled him to get his ticket confirmed had made us good friends. Mahesh introduced him as a Deputy Engineer from Essar, a premier oil refinery in India. I thought his fluency in Hindi might be a reward for his outspoken nature and amount of time he might have spent in north India. We were accompanied by a Marathi family, who were embarking a tour to south Indian cities like Kodaikanal, Madurai and Kanyakumari.

I was amazed by Mahesh’s ability to gel easily with strangers. But his wit fullness in cracking joke might made it possible. Eventually he had made the long journey easy by giving us a good company and explaining the concepts involved in process of oil formation from fossils. He went on explaining structure of tectonic plates and how it helps in trapping oil in between the layers of earth. We exchanged common problems, prides and gossips that all south Indians come across after being migrated to northern part of our country. It gave me a sense of relief after sharing my thoughts in my mother tongue on topics varying from Raj Thackeray to world Economic crisis. Our discussion was intensively thoughtful when we talked about different cultures prevailing in Mumbai and different languages we learned in our journey from home and interesting similarities among them. Our synchronized frequency of thoughts had created a good chemistry between us, which made our journey an enjoyable one. Mahesh’s desperation to help the Marathi family in making them understand the fact that Dindigul is near to Kodaikanal than Madurai and arranging a cab for travelling from Dindigul to Kodaikanal was really remarkable. He finally signed-off with a smile at Trichy station, where he was picked by his brother.

Our compartment was almost empty after Dindigul, after which we met a person who was in his early 50’s. He introduced himself as a railway employee from Andhra Pradesh and he was going to meet his son, who was working in Honeywell Madurai located at the campus of our college. Within a couple of minutes after our introduction he enquired about my package and started comparing his son’s package. Somehow I had managed not to show my embarrassment. But his knowledge on current affairs has amused me to continue our conversation. He was worried about Biharis dominance in Southern Railways and concerned about people who are getting railway jobs with mere political support and less technical knowledge or merit. We discussed about steps Mr.Lalu had taken to improve Indian railway as a profit yielding organization and in the conversation I understood the fact that 70% of revenue for Indian railways comes from goods train. Besides he expressed his dream of making his son an IAS officer. Especially People from Andhra have lot of passion for civil service; without which guys like Charan won’t quit a high-paying job for preparing for Indian civil service entrance exam.

I reached Madurai exactly after 36 hours of boarding from Mumbai. It was exciting to see my people and city again. This time my stay in Madurai provoked thoughts on my society, economy and culture. Hopefully I will pen those thoughts in near future.

Sourav – A Determined Leader !!

2008-10-08T03:30:00.001-04:00

After twelve years of international cricket, Sourav Ganguly, a flamboyant left handed opener from Kolkata has called “Its day”, before the hyped four-match test series against the Oz. Sourav, who has been known for his ability to pierce the offside field and timing the ball with perfection will be playing his last four match against Australia in the next 30 days. As a captain he has taken the Indian team from “bunch of lazy batsmen” to a “rich blend of talented youths”. As a rhetoric leader he has been respected in the team as a captain and a senior player. By taking India to the 2003 World cup final and remarkable Test Series victories outside sub-continent, arguably he is the best captain India has ever produced. Yesterday once again he set standard by announcing his retirement from cricket for giving way to the young talents in the country.

Sourav was predominantly a batman in earlier stages of his carrier. His ability to score runs consistently at the top of the order gave balance in batting order for the Indian team, which was suffering from lack of skilled openers in 1996 world cup in the sub-continent. Rahul once complimented Sourav as “next to God on the offside”. Geoffrey Boycott, the notorious English commentator, praised him as a “gifted timer” of the cricket ball. Sourav’s name has been appended in the list of Indian star batsmen, which was having only the name of Sachin for almost a decade. His cricketing skills enthralled crowds across the country and earned him respect and love among the sentimental Indian fans.

He got the opportunity to lead the Indian side when Sachin stepped-down as captain after the 2000 Australian tour debacle. He had transformed himself from a player to a great leader. Sourav’s decision making; team selection and field setup were widely appreciated by commentators and cricket lovers. He has backed youngsters like Yuvraj, Kaif, Zaheer, Harbhajan and given freedom for them to perform and establish themselves as players. He lead a team with rich blend of experience and youth, which had won the historic Final in Lords against England; victories outside subcontinent; famous test victory at Leeds and first Test series win in England. He is great communicator and extracted the best out of all individuals and created history by beating Australia in their home after 35 years. He was involved in couple of controversies on and off the field, But I personally feel that he is one of the few Indian players, who responded properly to happenings on the field like sledging.

As unanimously happening to all players of the game, Sourav also had been dropped from the team following series of poor show with the bat. In the midst of these humiliations, he had been criticized by Indian media and column writers for his incapability to play bouncers and the deliveries moving away from his bat. He responded to all the criticism by scoring consecutive hundreds in domestic tournaments and county matches, which earned him a place in the national Team when India toured South Africa by 2007. He emerged as a player of the series and sent a strong message to the world that, he was still determined to play cricket with passion. I was really impressed by the comeback from the “prince of Kolkata”. In a post match presentation he said “ It’s all about guts and determination, ” when someone asked about his comeback.

Sourav has been a role model for lot of young emerging players from India. His knowledge and passion for the game is still a valuable resource that BCCI can exploit for betterment of cricket in India. With hefty experience of international cricket, Sourav still has a lot with him to deliver to Indian cricket.

Quick Fix in a Blog

2008-09-29T09:29:00.002-04:00

While writing a blog on Flash tennis, I have embedded the flash tennis game in my blog. I was happy to present this to my readers, but I forgot the fact that this flash file was having an audio playing in the background. So, whenever someone open the site, flash will be loaded and and eventually they will get the sound produced by the flash file. Reader opening my blog from a silent place may get annoyed by the unexpected loud noise. Shankar, one of my friend had experienced this, when he casually opened my pages when he was in a library. I understood the problem when he conveyed the message to me, and the same instigate me to provide an immediate fix for this bug in my writing. Here is the fix,

Download the html code from this Link.
Open a notepad.
Paste this code and save the file with HTML extension
Open the file with a browser you will get the flash tennis.

I have removed the attached flash from my old blog. Shankar’s advice at right time will help me to avoid my readers getting annoyed.

An Adorable Essay !!

2008-09-26T09:58:00.001-04:00

Forwarding mails has become a hobby for some of my friends. Forwarded mail contents are like scintillating series of picture; creating awareness about health; urgent requirement of help; mockery which could be analogous to any recent movie; a wired picture; some time puzzles. Recently I got an interesting mail having an essay written by an IAS exam candidate, It was really a scintillating and gibberish transliteration from his mother-tongue to English. I took sometime for me and Sunil to control our laughing. I am presenting the same to you guys.

Even I am taking efforts to improve my vocabulary for giving my GRE. Who knows ? my analytical writing may be as gibberish as this one to my GRE readers.

Jubilant Federer !!

2008-09-24T02:02:00.001-04:00

“I am jubilant, because Federer is jubilant”, these were the words I was murmuring when Federer made a remarkable come back by winning the US open 2008. He has taken his game to a new level of perfection and controlled aggression. After failed to prove his class in the Australian open; out lashed by Nadal in the French Open and unlucky in the epic final at the Wimbledon, Federer also lost his regime of number one spot in ATP tennis ranking after almost four and half years. Because of shear excellence and class he has dominated world tennis for consecutive four years which made media to bestow him the best player ever to play the game.The same media started speculating about the thirteen-time grand slam champion’s down fall so early. Once his unusual calm and uncommon lack of visible frustration has been praised by media and same set of crazy people in the recent past remarked his game as “lack of self-confidence”. But he has given answer to all the question in an unanimous way by winning the US open for the fifth time at Flushing Meadows.

Federer with fifth (consecutive) US Open Trophy

Andy Murray one of strong forehanded emerging player from Scotland was finding difficult to match the 16 time grand slam finalist from Switzerland. Federer started this US Open with average wins, as he progressed further he got his serves stronger and returns accurate. I was able to feel difference in his performance in semifinal against Djokovic. Federer was able to convert all his breakpoint successfully into winners. In the post semifinal press meeting he was asked on, whom would he prefer in the final among Nadal and Murray. He said “I would prefer the trophy”, which showed his desperation to win a grand slam this year. Being a top player for consecutive 230 odd weeks you can't think of an year without any Grand title.

Nadal was lacking his usual agility and endurance in hard court this year. Even though, he won French and Wimbledon he lost in all hard-court tournaments this year. He failed to produce his trademark cross-court return, which earned him vital points in crucial stages of games he played in the past. Murray was too good to beat Nadal in the semis and ready to face Federer in the Final of US open 2008.

Rejuvenated Roger was completely back at his best in final against Murray. He swept opening set by 6 games to 2. Federer game used to be dominated by aces, but contrastingly in the finals he produced only 3 aces but he displayed all-round game by converting 70% of his break point to winners; 70% success by volleying at the nets. He thrust to a 5-0 lead in the final set by breaking the Scot thrice. He was at the peak of his form in the final set producing some unbelievable baseline shots. Finally he won convincingly 6-2, 7-5, 6-2 to become the first man to win US open five times in a row. "It definitely feels great," said Federer afterwards. "This is a very special moment in my career,” he added.

He is one title away from Pete Sampras record of 14 grand slam title. "I'm not going to stop at 13 - that would be terrible!” he said in the after match presentation. Murray said "I had a great tournament but I came up against, in my opinion, the best player ever to play the game today".

Federer would have felt lot better after winning US Open. "I think the French Open loss was brutal, but I got over that one pretty easily, played great on the grass and had a really tough loss at Wimbledon which - you know, I was proud to be part of such a great match, but at the same time it just sort of made me sad not having won that great epic match,” he shared.

Finally he revealed the fact that he was annoyed by media’s comment on his form and performance over the last year. "I mean, I'm a bit disappointed. Sometimes to a point a bit annoyed, because all sorts of crazy people started writing me and trying to reach me, telling me I need some help either mentally or physically. "You're laughing but it's the way it goes. People come out of the closet and think they can start helping me now. It's just a pain.

"For me, this sort of puts them to rest a little bit, and calms down the phones at my parents' a little bit, which I'm happy about”. Federer shines away from the press meet.

Google Chrome is Phenomenal

2008-09-04T02:03:00.006-04:00

One more milestone in Google's history when they have launched the impeccable browser Chrome. I read about Chrome in Times of India yesterday, and I was furious to see how it looks and works. Today as I walked into the office, the first thing I did was download and install the browser Chrome. I feel Chrome resembles Picasa (web album by Google) in look and feel. It opens as fast as a notepad and the interface is also as simple as notepad. Apparently it seems it will beat Opera in speed and response. Importantly it does not have any array of menus or heavy tool bars.
It looks very gentle and light with a simple address bar and tab bar. Controls which are currently active in the browser are automatically highlighted with saffron color, which helps people who predominantly use keyboard rather than mouse. All the menu and options are embedded on the right side of your browser as a drop down menu. It makes your browser spacious to display content of the site your are surfing. Menus are grouped in to two main categories like Control menus and Customize menus.

Snap of Google Chrome

Control menu & Customize Menu

Its left to you to exercise the functions of each menu shown above. Chrome is using the Internet setting of MSIE. Options menu will take you to the proxy setting of IE browser.

Incognito Window

Google does not fail to enthrall people with unique features. It has an option called "incognito window", which will not store the browsing history and they won't leave other traces, like cookies

For Developers
The highlight of the browser for web developers is the developer menu, which allows us to debug the java script of the site we are browsing. Chrome has also provided a console for Javascript and it will help us in checking the Javascript and the Stylesheet (CSS) used in the page. Google has incorporated all the functionality of web-developer plugins provided by firefox inside its browser itself.
Task manager

Chrome handles every tab as a different operating system process, which helps in handling the unresponsive windows separately. It also encapsulate the functionality of one tab from other. So if any tab hangs because of some issue, it won't affect the other tabs performance and evidently allow us to kill it by leaving the others untouched. Chrome also provides a separate task manager for the browser for killing the "not responding" tabs. Task Manager provides you same valuable details like memory consumption and CPU. One step further we can drill memory statistics of the tabs in your browser up to its process nerds.

If you click the stats for nerds in your task manager, it will show you the panoramic details of each process like

Process id
Virtual Memory
Physical Memory
Private and shared split up of each memory.

Stats For Nerds

Chrome is simply a heap of ingenious functionality with unbelievable speed. Its awesome, isn't it?

Addicted to Flash Tennis!!

2008-09-01T04:18:00.012-04:00

Online Flash are really perky.Isn't it ? Especially, if you love a game and failed in finding time to play and enjoy it.You can feed your hunger in playing the flash version of the game. As I was fascinated by Cricket and Tennis, I spent most of my leisure time in either reading about the game or playing it with my friends.Once you become a pro you are subjected to relinquish some of your habits (As I left my habit of "obsession to cricket"). For guys who sacrificed playing games these Flash games are real treat.

There are innumerable sites for online Flash games with attractive graphics and challenging rounds. Best of the pack is Tennis. As Sunil listed we use to play Flash Tennis a lot. It is a game which challenges your speed, accuracy, tactics and knowledge of the game. It provides option for you to set your skill level and your opponents' in terms of Forehand ,Backhand, Serve and Footwork in scale of zero to ten.You can choose an exhibition match for practice and tournament for testing your skills.

This game is reachable with simple Google search for "Flash tennis", but obviously you need to have Internet connection. As most of the employers are blocking URLs like flash and games; you could not enjoy tennis in office leisure hours. This provoked me and Sunil to explore the option of downloading the Flash (SWF) and embed it in an excel sheet.We have succeed in doing this. Hopefully we will explain you elaborately on, how to download and embed flash in an excel in near future. But as of now I am attaching the most amazing Flash tennis game here.Enjoy!!

Embeded Flash has been moved to new location for better User Interface.

Challenge

I would reckon you guys to follow these steps to make it more exciting.

Set 10 for you and 8 for you opponent and try to win 3-0.
Set 10 for both of you and try to win 3-0.
Set 10 to your opponent and 8 to you and try to win 3-0.
Set 10 to your opponent and reduce your rating gradually from 8 to 1 and try to win 3-0 in all possible combinations.

We are now trying to post a 3-0 win with a combination of 10 to opponent and 1 to us.Its really an adorable game to play.

Oracle Performance Tuning and Optimization Part II

2008-08-25T03:59:00.001-04:00

As I mentioned in my last blog on oracle performance, we will see some more better ways of writing SQL queries in oracle.

While Joining multiple tables specify smallest table at last.

As we saw, using joins produce better results than inner query, we have to order the table in such a way that the small table will be specified at last in SQL, so that the number of times oracle compare the records will be reduce.

Before Optimization	After Optimization
select so.documnet_number count(1) from activation a, serv_ord so, task t where t.documnet_number=so.document_number and so.serv_item_id=a.serv_item_id group by so.document_number	select so.documnet_number count(1) from task t, serv_ord so, activation a, where t.documnet_number=so.document_number and so.serv_item_id=a.serv_item_id group by so.document_number
Time Taken : 10 Sec	Time Taken : 2.1 Sec

Replace NOT IN with NOT EXISTS

This is very similar to avoiding sub query

Before Optimization	After Optimization
Select count(1) from task t where t.document_number not in ( select tt.document_number from task_bkp)	select count(1) from task t where not exists (select tt.document_number from task_bkp)
Time Taken : 500 Sec	Time Taken : 6 Sec

Use FORALL instead of FOR

This is a handy option available in oracle for inserting bulk records. I have already given more details about this in my blog on Best practices in PL/SQL.Think about FORALL whenever you write a cursor.It will reduce the loop execution time.

Before Optimization

After Optimization

DECLARE

TYPE NumTab IS TABLE OF NUMBER(5) INDEX BY BINARY_INTEGER;

TYPE NameTab IS TABLE OF CHAR(15) INDEX BY BINARY_INTEGER;

pnums NumTab;

pnames NameTab;

BEGIN

FOR j IN 1..20000 LOOP -- load index-by tables

pnums(j) := j;

pnames(j) := 'Part No. ' || TO_CHAR(j);

END LOOP;

FOR i IN 1..20000 LOOP -- use FOR loop

INSERT INTO parts VALUES (pnums(i), pnames(i));

END LOOP;

END;

DECLARE

TYPE NumTab IS TABLE OF NUMBER(5) INDEX BY BINARY_INTEGER;

TYPE NameTab IS TABLE OF CHAR(15) INDEX BY BINARY_INTEGER;

pnums NumTab;

pnames NameTab;

BEGIN

FOR j IN 1..20000 LOOP -- load index-by tables

pnums(j) := j;

pnames(j) := 'Part No. ' || TO_CHAR(j);

END LOOP;

FORALL I in 1 .. 20000 -- use FORALL

INSERT INTO parts VALUES (pnums(i), pnames(i));

END;

Time taken in sec: 11.0 Sec

Time Taken in Secs: 0.5 sec

FORALL will reduce the loop-back time between PL/SQL and SQL engine.You can download my presentation on best practices of PL/SQL from my site.

use BULK COLLECT

BULK COLLECT is an option provided by Oracle for avoiding the use of loops in collecting data from table.For any heavy data processing application BULK COLLECT will be useful.For example we need to select 1000 records from a table and process the records and insert it into another table, then we can either bulk collect.

Before Optimization

After Optimization

declare

Type bcode is table of products.barcode%TYPE;

i int;

barc bcode;

cursor cur_seq is

select barcode from products where rownum<100001;

begin

i:=0;

for cur_dta in cur_seq loop

i:=i+1;

barc:=cur_dta.barcode;

end loop;

end;

declare

Type bcode is table of products.barcode%TYPE;

i int;

barc bcode;

begin

select barcode BULK COLLECT into barc from products where rownum<100001;

end;

Time taken : 17sec

Time taken : 1.41 sec

Summary of Optimization

Use uniform coding standards across the application
Avoid data type mismatch for index columns
Avoid functions on index columns
Move conditions from having clause to where clause
Use joins instead of nested selects, whenever possible
Replace Not IN by Not EXISTS or OUTER JOIN (but not in distributed environment)
Use bulk inserts when inserting more records
Use BULK COLLECT clause when fetching records

As a fan of Mr.Barney.

I demand, you fellow programmers to follow some best practices while writing PL/SQL code.

Oracle Performance Tuning and Optimization

2008-08-21T01:08:00.001-04:00

With the overwhelming hits from allover the world for my blog on oracle locks, I thought of sharing some performance tuning methods with all.Performance is a parameter, which is critical for any application. Since no users will be willing to compromise on performance of his system, we are subjected to develop a system with less response time and greater throughput.As all distributed systems use database for implementing the business logic, its performance is directly proportional to number of tuned queries and optimized PL/SQL objects in the database.Tuning is not a separate process as such. It should be carried out parallel to the SDLC.

Oracle is one of the widely use database in the world. We will go through some optimization technique that can be implemented to develop better systems.

Avoid data type mismatch for index columns

Most people, who are novice in database use single quote (in the filter condition) irrespective of the data-type they are querying.This makes oracle to do an internal typecast to the required data-type.

Before Optimization

After Optimization

select name,age,city,state

from employee

where employee_id='1000';

select name,age,city,state

from employee

where employee_id=1000;

Time taken : 2.3 sec

Time taken : 0.3 sec

Avoid functions on indexed columns

Normally, we identify the most frequently queried column from table and create an index on it.But while querying we use functions on the indexed column. This will ultimately annul the purpose of creating an index on the column.

Before Optimization	After Optimization
select name,age,city from employee where substr(employee_name,1,3)='kar';	select name,age,city from employee where employee_name like 'kar%';
Time Taken : 2.8 sec	Time Taken : 0.3 sec

If we cannot avoid using a function in the query. we can create functional index on the specific column

Specify the condition in WHERE instead of HAVING

Before Optimization	After Optimization
select name, count(1) from employee group by name having name='karthi';	select name, count(1) from employee where name='karthi' group by name;
Time Taken = 2.2 sec	Time Taken = 0.3 sec

This is an obvious error.If you are not filtering before grouping, then all unnecessary data will be grouped and finally the required data will be filtered. Applying filter before grouping will avoid unnecessary sorting and grouping.

Use Joins instead of inner query

Before Optimization	After Optimization
select employee_name from employee where employee_id in ( select employee_id from defaulters)	select employee_name from employee e, defaulters d where e.employee_id=d.employee_id
Time Taken : 14.1 sec	Time Taken : 5.5 sec

This is actually considered as a bad practice in writing SQL, writing inner query results in querying the outer table for each output of the inner query.I would consider this as potential area where we can improve the system performance.

I feel that, I am overloading every blog with more data.So I will try to present rest of the optimization techniques in next blog.

Quality Vs Indian IT

2008-08-11T06:37:00.004-04:00

This title may be awkward for those who literally portray IT as a boom in Indian economy for the last two decades, in which GDP of India increased from 4 to around 8% per year. This is more than four times when compared to our GDP in first thirty years after independence. Its is evident that it has improved our standard of living, and it rejuvenated the beliefs of middle class people to pursue their goal of owning a house or a secure job. Dramatic change is the last generation's jobs in government offices, running small business in a town, agriculture and their sibling are working in computers in centralized air conditioned room. IT industry is certainly a boom for a developing country like India, which needs to provide jobs to million of its young generation to keep its rate of growth in a constant level. But I feel this view of IT Industry as a boom is just abstract and without deep insight. We need to have a deep insight of anatomy of the change this IT is making in India. It would provide the panoramic view of India's standard in delivering a product or service.

I was unfortunate to not to read a mail sent by my friend before being part of this industry.It vividly explained my future, what I am witnessing now. It would be highly pessimistic to just hate anything without any substantial reason.So let me put my view delicately in Barney's style.

Indian service industries are recruiting students from best engineering colleges from India by showing attractive packages and tempting perks. As most of the students are from middle class background they are naturally attracted towards these high paying jobs and landed in one of the metros polis in India. Colleges are also keen in getting more companies for recruitment irrespective of its domain and background. It has become a business strategy for colleges to show its placement cout in their pamphlets and web sites.

Any fresher recruited by an IT industry usually will undergo a training program, where he/she will be inculcated with soft skills, computer basics and probably one technology in which the so called expertise is required by the company for billing the client.Indian IT giants like TCS has its in-house training center in Trivandrum and Infosys own an impeccable center in Mysore in state of Karnataka.TCS traninig center is getting the requirement from global HR and mending professional accordingly.Its counterpart in Infosys also follows almost the same logic and the latter has been perceived as a quality trainer compared to the former.

After getting trained for couple of months in a particular technology employees are assigned to totally unrelated projects.So their training is merely a paradox.Ironically the cost involved in training a resource is getting wasted because of improper training plan and execution.More than 95 percent of the projects of any major Indian IT company are Maintenance and Support.Clients from west are out-sourcing the low graded support and maintenance to India and the jobs like design,where quality matters are out-sourced to foreign consultancy.

In support most of the jobs are like running scripts once in a day;monitoring logs for exceptions or alarms;report generation sometimes it is like attending user calls and providing support on call.This is terrible.isn't it ?.Indian engineers from IIT who learned cutting edge technology in signal processing or hydrogen fuel or system on chip will be solving trouble tickets raised by clients.People are doing this because they are getting money and socially they are respected as software engineers.Calling any guy doing this work as an engineer is the peak of ignorance or stupidity.

My points are not lopsided by explaining only the adverse part of the industry.I do accept that there are some projects with high standard.Companies are working on designing enterprise application for Telecom, Health care even some mission critical applications.But overall quality of a company has been decided by majority of its work.It shows that work these companies are providing to the young engineers are not exciting.Inspite of the quality of work they offer , they are not ready to compromise on the quality they except from freshers.Everyone might aware of the conditions being imposed on the college managements by the companies before they visit for recruitment.They are desperate to be the first company to visit for recruitment.If you need cream layer of students from the universities then you should be able to provide the work the cream layer students deserve.It is quite obvious from the recruitment strategies,traninig plan and allocation plan that these companies need resources to slog for them.It hardly matters for them whether the resource is he, she or it.

I have a friend working in IT who has done his masters in Communication systems.He was very much worried about work he is doing.He was forced by his family condition to not to quit and do his Phd.He was hilarious while we discussed about the usage of the word R&D by IT guys."Even reading a pdf on java scripts become R&D here" he laughed.

Even if anyone understand the real situation after getting in to these companies he can't even think of the moving out as he has been tied with a lock called service agreement.I don't understand how it is possible in India as we have a law against bonded labors.Mostly ignorance of students along with attractive packages results in engineers doing these menial works.

My views are not against Indian IT industry.They should understand their current strategy of getting whatever project west offers to you will not work on the long run.So we should realize that its not about quantity, when we release our quarter results.Its a matter of quality, which will sustain your growth in long run. It also provides motivation and challenge to your associates and get the best out of them.So we need a commitment from our IT managers to shift their mode of business from evil support and maintenance to a more conservative job, which helps us to compete with our counterparts in other countries.

Finally.As I mentioned, It has transformed the living standard of million of Indians.But the question is should we compromise the quality of work we are doing for the money we are getting ??

Interesting Derivation !

2008-08-07T06:10:00.001-04:00

Stumble-upon is really an exciting Internet tool.It will provide you variety of sites, which would be impractical to reach through search engine.Just you need to select the topic you like most and start stumbling.Once you start stumbling through, you will reach sites of different flavor.It provide a valuable time-pass when ever you get bored with chronic work.I want to share a derivation we got,

Its nothing serious,just for fun :)

Unbelievable Match I have ever witnessed!!

2008-07-07T03:47:00.004-04:00

It was midnight quarter passed two, I was at the edge of the seat watching the Wimbledon 2008 Final between impeccable Federer and the young roaring Nadal.It is evident from my older blogs that, I am an admirer and a die hard fan of Federer, and obviously I was expecting Roger to crush Nadal to get his sixth consecutive title at England lawn tennis Club. As everyone expected it was a thrilling match both the world top rank players showed their elegance and enthralled the cloud with amazing serves, forehands, volleys and backhands.

Analogous Arch-rivalry
It was the repeat of 1980 finals between flawless Borg and the fighter McEnroe.This final was also an analogous match between a five time champion and a young emerging player. McEnroe emerged as a winner of that Final stopping Borg from taking his six consecutive Title. Nadal emerged as a winner of yesterdays final stopping the king of grass from breaking the record of his role-model. Both players were absolutely spotless in shot selection and played with great heart and temperament.

Defensive Federer
Federer was too much defensive in first two sets and payed the penalty for it. Federer was aiming to avoid the strong forehand return from Nadal by pushing the ball to the wrong hand of Nadal. I am seeing him using the same strategy from French Open final 2008.But Federer failed to execute his plan to perfection, which results in unnecessary unforced errors. For the last two weeks Federer was hardly doing more than couple of unforced errors. But to play his new strategy he played avoiding some great forehand chances and tried too much on Nadal’s serve. It ultimately cause the champion to lose two opening sets.

Great Comeback
Being two set down in final and playing third set with much calm and composure is possible only for Feddy. He started playing like a champion in the third set which went for tie break and Federer eased it through his immaculate Aces. I was able to see a Sampras inside Federer especially in his drop-shot and consistent forehands close to the baseline.
“Come on Federer!!” I shouted from my heart. I still remember a quote by Shane Warne
“I never fall out of my game. Sometimes I may, But when ever I comeback, I comeback strongly”
Federer was showing these line his as character to the crowd in the fourth set. Even he failed to break Nadal throughout fourth set; he was storming through the tie break with strong, high and accurate serves. Nadal was nervous and missed a championship point in the fourth set.“Thank God!!” I was praying for my hero.

Ultimate Match
The crowd was astonished to see a rally kind of match extending for more than four and half hours. Rain interrupted the match twice which was good for the spectators to take some breathe. When the players walked out for the second time, when matched stopped due to rain the score was :
              Sets   Game   Points
-----------------------------------------------
Nadal       2        2           40
Federer   2        2           40
shows it was nothing but an amazing tennis match in the history. The aroma of excitement was around us even at 2 ‘O clock in the midnight, when we were watching the match. The level of composure botht these guys showed was really a point we have to learn from this game.

The Decider
Again Federer was too much defensive and trying to play on wrong hand side of Nadal made several attempts to break the Spaniard bit all went in vain. Fifth set went to 6-6 as the match was reaching the pinnacle of nervous excitement. Finally too much of unforced errors from Federer and agility and endurance of Nadal helped the latter to break Federer’s serve, which ultimately provided a new player capable of winning against the five time champion at his own den. I found Nadal has improved his game a lot especially in serve and backhand. “Congrats Nadal!!”,I admired
Every true lover of the game witnessed the fantastic and unbelievable match. All the tennis greats expressed their opinions.

“Federer wouldn't be Federer if he didn't come back with something amazing”
-By Boris Becker
“It's so tough to pinpoint one area where Nadal won it. There was barely anything to separate them; it just came down to a question of the Spaniard's endurance and his sheer determination.”
- By Tim Henman

Federer was beaten in the grass after 6 years. It was an unbelievable record winning streak of 65 matches, which has given him five consecutive titles. I feel everything is perfect about Roger Federer, except his fear for Nadal. If you list out the qualities of both player definitely Roger will have an edge over Nadal in

• Strong and Accurate Serve
• Fluent Backhand
• Drop shots and Volleys

But still his fear over Nadal’s victory over him in the last few Finals has made a huge influence in Federer’s game. But still he is the master of the game. He just need to believe that he can beat Nadal, the rest will happen with the quality of the game he is playing since 2003.
We can expect even a better game if these two greats meet in the near future. But I believe in Shane’s Words.”Come on Feddy!!”

A Stress-Relief Trip To Lonavla

2008-06-27T05:07:00.002-04:00

Our team had planned for a trip to Lonavla. I had hesitated to go, as I was not feeling well.I was down with cough and cold. After Hari and Charan left, I was feeling a bit restless and alone. Since we were staying and sharing things together for last one year, It look sometime for me to overcome their separation. They played an eminent role in all my success in last couple of years. Last weekend I was suppose to be alone in home. To avoid this I said OK for Lonavla.
Amit and Anant were the tour managers. As per our plan we have started from Yantra Park by a mini bus at 7 AM. As usual we got the last seat along with Amol. It remembers me the Industrial visit we had in college days.

Oh !! Those were golden days, when we use to start the journey by shouting SALA PULA SALA PULA KUMTAHLAKA. Normally I use to avoid being in a group. My affinity towards groupisim was increased because of the unity we had in our college days. Mootai Annamalai and Maheswaran all use to get themselves involved in 'OOO Poodu'.I feel these kind of small things are playing immense role in bringing people together and creating better relationships. As I was thinning about my olden days we have reached a place in Pune-Mumbai Highway where we had the first stopping for having Vada pav to break our fast. I am planning to write a blog in Vada Pav, the quintessential food for all Mumbaikars.

Amol,Me Sendhil and Gokul

After the first stop we had an hour of journey and reached Lonavla. As I heard It was really a pleasant place with full of greeneries. The monsoon was started already and it has added a bit of lush to the greens around. Actually Lonavla is lying some 600Feet from ground. As we came out of the bus with preparation for taking bath we saw lot of families, couples and friends were already there for enjoying their weekend. We had to trek for about 500 meters in the small mountain to reach a water falls. We spent couple of hours in the water falls.

From there our tour mangers directed us Tiger point. Its a place about five to six miles from Lonavla. It was like “suicide point” in Kodaikanal. We reached there at 3 PM so it was very windy. We were taking snaps and spend the evening there.

We started our journey back to Mumbai from Tiger point. I have to talk about the immaculate highways between Mumbai and Pune. It was really well planned and constructed. Maintaining road of that much width and lanes in hilly area is really difficult. In the return journey I shared my seat with Saurabh , Mr. Billing in our project. He was discussing about his plan to name his child as "Billing”. I know he has gone crazy after doing billing for last two years.

We reached home by half past eight in the evening. I was feeling free after coming back from the trip. Really having some trips to some remote places now and then will definitely relive stress.

முதல் தமிழ் வலைபதிவு

2008-06-24T04:49:00.005-04:00

வணக்கம் நண்பர்களே !
எனது 50 ஆவது வலைப்பதிவை தமிழில் எழுழ்துவதில் பெரும் மகிழ்ச்சி அடைகிறேன்.இந்தியமொழி அனைத்தும் வழ்ங்கம்படும் இந்த மும்பை நகரம் மொழி மட்டுமல்லாது பல கலாச்சாரங்களின் தொகுப்பாக நான் கண்கிறேன்.சரியாக 2 ஆண்டுகளுக்கு முன்பு ஒரு சாமானிய தமிழனாக, மும்பை பணியை கட்டாய தாலியாக ஏற்ற எங்களுக்கு, இந்த மாநகரம் கற்றுக் கொடுத்திருபவை ஏராளம்.எலக்ட்ரானிக்ஸ் மற்றும் ப்ரோக்ரம்மிங்கில் மட்டும் இருந்த எனது ஆர்வம், மொழி, கலாச்சாரம், லெமுரியா என்று பல பரிமானம் எடுத்து இங்குதான்.
எனது தாய் மொழி அல்லாத பிற மொழியை கேட்கவும் பேசவும் இங்கே வாய்ப்பு கிடைத்தது.தமிழின் அண்டைய மொழியான தெலுங்கு,மலையாளம் போன்ற மொழிகளை கேட்கும் போது நம் மொழியின் தொன்மையும், தொடர்பும் இனிமையும் புலப்படும்.தமிழின் தோற்றத்தின் மேல் ஆர்வம்; தமிழர் கலாச்சரத்தின் மீது மரியாதையை என பல மாற்றங்களை என்னுள் விதைத்தது மும்பை வாழ்க்கை.
நான் எழதிய 49 படிமத்தின் முடிவில், எதோ எனது எண்ணங்கள் அனைத்தும் எழுத்துகளாக மாறாமல் போனதுபோல் ஓர் மாயை மட்டுமே முடிவுரையாக நிற்கும்.தமிழில் சிந்தித்தால் .... இதோ ஒரு கச்சிதமான வரிவடிவம் பெற்றுஇருகிறது என் எண்ணம்.

நன்றி : கூகிள் transliterate

Wiki Relation - Six Degrees

2008-06-07T06:31:00.001-04:00

Wikipedia has now become a standard reference for definition of any matter in this universe.You can see almost all bloggers create a back link to Wiki page for definition of any words they use.It is having analogy with magazines in late 95's referring to oxford dictionary for any peculiar word in their article.I recently read an article on new Mars rover in daily local paper, where they have used a new word related to Mars surface property and the explanation was given like... "As Per Wikipedia....."It shows the power and growth of wikipedia as a standard reference in last couple of years.

Today I heard the concept of finding the relationship between any two the articles in Wikipedia.It is not the logical relation.It is the number of links between the two articles.In simple words it the number of clicks required to reach one article from other.We can say it the distance between the two articles.So the biggest distance between any two article will define the diameter of the Wikipedia.I have read that this project was an attempt to find the diameter of Wikipedia, but it has given a handy algorithm to find out the distance between two articles.

Example( You can also have a try)

I gave vague unrelated topic,but see! Wiki is having awesome relationship between articles

Wiki relation between Y2K and Purananuru

According to Stephen Dolan,Wikipedia has 2301486 articles with 55550003 links between them.The largest "strongly-connected-component" of Wikipedia has 2111480 articles. That is, there are 2111480 articles with the property that from any of them, it is possible to get to any other one. The rest are mostly pages that no-one has linked to or disambiguation pages.

Stephen has used graph theory to convert the relation between articles as a graph.From Wikipedia's database Stephen got the XML and used scripts to parse the XML to find the graph.Finally distributed Computing algorithms has been used to identify

The diameter of Wikipedia
The distance between any two articles.

The techincal concepts like parsing, graph Theory and distributed computing has been clearly explained in Stephen's site

It is really an interesting game to play.I tried combinations of two completely different articles but I was able to get the maximum distance of 4.If any one could get more than four please comment on this blog.

A View on Oracle Locks

2008-05-08T04:48:00.003-04:00

Reliability of a database has been determined by the degree to which it strives to achieve atomicity, consistency, isolation and durability, what we can call simply as ACID properties. Oracle is a robust and highly reliable database which has these ACID properties. Locks play a vital role in achieving couple of these properties. Oracle defined lock as Mode and type. Mode defines the way in which a session locks a row or set of rows in a table. Type can be defined as the transaction type which makes this lock happened.

Modes of Lock
There are six lock modes in oracle out of which the sixth lock is NULL lock.They are

Lock Mode	Abbreviation
Row Shared	SS
Row Exclusive	RX
Share	S
Share Row Exclusive	SRX/SSX
Exclusive	X

Lock types
There are three lock types like TM .TX and UL. They are classified according to the transaction which is locking the table. TX denotes a transactional lock which occurs when any transaction changes data from a table. TM is a DML lock which occurs when ever an object is changed. UL is a user defined lock.

Locks are strong contender which affects the performance of database, which cab be diagnosed easily.

Data Dictionary Views
Oracle uses any one of the above locks modes according to the transaction type to achieve the Isolation of ACID. Oracle provides couple of data dictionary views to identify almost all details about locks like who is locking an object, which sessions are waiting for the same object and session details. File and the block where the lock has been made can also be easily identified from the data dictionary views.
• V$lock
• V$locked_object

We will take an example where we will create a lock and we will try to gather the lock details

ses1>create table test_lock(
2 id number,
3 name varchar(200));
Table created.

ses1>insert into test_lock values(1,'apple');
1 row created.
ses1>insert into test_lock values(2,'orange');
1 row created.
ses1>insert into test_lock values(3,'banana');
1 row created.
ses1>insert into test_lock values(4,'mango');
1 row created.
ses1>commit;
Commit complete.

ses1>column id format 99
ses1>column name format a10
ses1>select * from test_lock for update;

ID NAME
--- ----------
1 apple
2 orange
3 banana
4 mango

Session 2 created for updating a single row from the same table

SQL> set sqlprompt ses2>
ses2>
ses2>column id format 99
ses2>column name format a10
ses2>select * from test_lock where id=1 for update;

ID NAME
--- ----------
1 apple
Session 3 for studying the locks due to session 1 and 2

SQL> set sqlprompt ses3>
ses3>column addr format a18
ses3>column kaddr format a18
ses3>column sid format 999
ses3>column ty format a3
ses3>column id1 format 99999999
ses3>column id2 format 99999999
ses3>column lmode format 9999
ses3>column request format 999
ses3>column request format 999
ses3>column block format 9
ses3>set linesize 300
ses3>Select *from v$lock where type in ('TX','TM');

ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK------------------ ------------------ ---- -- --------- --------- ----- ------- ---------- -----070000000BBB72B0 070000000BBB7428 48 TX 393237 8560 6 0 2478 1070000000BB6C7E8 070000000BB6C810 48 TM 45405 0 3 0 2478 0070000000BB6C8A8 070000000BB6C8D0 54 TM 45405 0 3 0 2478 0070000000B3C3D90 070000000B3C3DB0 54 TX 393237 8560 0 6 2478 0070000000BBADD18 070000000BBADE90 75 TX 262182 9758 6 0 7460 0070000000BB6C728 070000000BB6C750 75 TM 45400 0 3 0 7460 0070000000BBE3FB0 070000000BBE4128 77 TX 589867 7411 6 0 5773 0070000000BB6C668 070000000BB6C690 77 TM 43850 0 3 0 5773 0

8 rows selected.

LMODE and REQUEST

The LMODE and REQUEST columns both use the same numbering for lock modes, in order of increasing exclusivity: from 0 for no lock, to 6 for exclusive lock. A session must obtain an exclusive TX lock in order to change data; LMODE will be 6. If it can't obtain an exclusive lock because some of the rows it wants to change are locked by another session, then it will request a TX in exclusive mode; LMODE will be 0 since it does not have the lock, and REQUEST will be 6.
You can see this interaction in the rows we selected earlier from v$lock:

SID
This is session id you can join with the V$session and v$sql for finding the session details and sql which is causing the lock.
ses3>

select q.SQL_TEXT
from v$session s,
v$sql q
where s.sid= 54 and
s.SQL_ADDRESS=q.ADDRESS;

SQL_TEXT
------------------------
select * from test_lock where id=1 for update

CTIME
Time since current mode was acquired
ID1 and ID2
The ID1 and ID2 columns point to the rollback segment and transaction table entries for that transaction.
For DML lock the column ID1 shows the object being modified

ses3>select object_name from dba_objects do where do.object_id=45405;

OBJECT_NAME
---------------------------
TEST_LOCK

Block
This column shows whether this lock is blocking some other session

Identifying Locked Table and its Row
We can identify the sid from v$lock table and the corresponding sid in v$session table will gives us the
• object ID,
• the relative file number,
• the block in the datafile,
• the row in the block that the session is waiting on

We can calculate the extended rowid from the above four parameters using the procedure rowid_create in DBMS_ROWID package.

ses3>column object_name format a15
ses3>column row_id format a60
ses3>column query format a 60
ses3>column query format a60
ses3>select do.object_name,
        dbms_rowid.rowid_create(1,
        ROW_WAIT_OBJ#,
        ROW_WAIT_FILE#,
        ROW_WAIT_BLOCK#,
        ROW_WAIT_ROW#) row_id,
        'select * from ' do.object_name ' where rowid = '''
        dbms_rowid.rowid_create(1,
        ROW_WAIT_OBJ#,
        ROW_WAIT_FILE#,
        ROW_WAIT_BLOCK#,
        ROW_WAIT_ROW#) '''' query
from v$session s,
       dba_objects do
where s.sid = 54 and
         s.ROW_WAIT_OBJ# = do.object_id;

OBJECT_NAME              ROW_ID                                                          QUERY
--------------- ------------------------- --------------------------------------------------------
TEST_LOCK AAALFdAALAAAlQ1AAA    select * from TEST_LOCK where rowid = 'AAALFdAALAAAlQ1AAA'

The third column of this query will give the query which will show the column which got locked by the session

ses3>select * from TEST_LOCK where rowid = 'AAALFdAALAAAlQ1AAA';
ID NAME
--- -------
1 apple

So this way we can find out the

• Lock
• Type of lock and locking user
• object which is locked
• SQL which is locking
• Row which is locked

It would be good if some one reading this blog add some points I missed out :)

I am happy to share my step by step methods in diagnosing oracle database performance.

Real Live Cricket !!

2008-05-05T06:33:00.009-04:00

I am proud to be a passionate lover and follower of the game cricket for long time.Even it has taken a lot of my time in return it has inculcated lot of qualities in me. I started understanding the English conversation after hearing cricket commentary. Even the way I am speaking the language has the influence of commentators I loved to hear. The passion for the game drives me to learn its sensible and exiting parts like pitch preparation and strategy used for controlling a batsman or the planning involved in field setting and using bowlers; testing batsmen patience; even some abusing words in English.

I haven’t got any opportunity to enjoy the game as a spectator among the crowd; I was just enjoying the matches on television. After being to Mumbai I was waiting for an opportunity to get an international match in Mumbai. Last Sunday we got the opportunity to watch a Twenty-Twenty match here in DY Patil Stadium in Nerul.
The match was between Mumbai Indians and Delhi Dare Devils. The effort taken by one of my friend Saurab in arranging tickets for the match has been exceptional. He was in a tight schedule last weekend as he travelled to Indore to attend one of his colleague’s marriage and he travelled back to Pune on Saturday night. He returned to Mumbai the next day morning to give tickets to us. We reached the cricket stadium by half past three in the evening.
There was a big crowd out side the DY Patil Stadium. I was accompanied by Saurabh, Hari, Gokulan and Amol. We were able to see the excitement spread in the ambience.

DY Patil Stadium

We went inside the stadium. It was really a well designed and constructed stadium, Galleries were remembering me the galleries of Gabba, Brisbane. It certainly looks eccentric from normal Indian grounds. The boundary size has been reduced to amplify the excitement of the game. I thought why the game has deriving its new dimensions by favoring the batsmen and curtailing the bowler’s interest in the game. Before we reached there Delhi won the toss and elected to field. There where two LCD screens for displaying the slow motions after every delivery and ads.

Five minutes before the match was scheduled one Delhi Player with red and black jersey came out. It was really difficult to identify the player in the ground from the gallery. But I identified him. He was Glen McGrath. I was excited to see him; I was shouting … Hey Mcgra… Mcgra !!.He was doing warm up and bowling with short run-up to his mates. I did not believe that I was seeing McGrath bowling. It took some time for me to bring myself back to the ground state. After that Delhi players started jogging inside the ground I was able to identify Asif ,Shewag and Ghambir.Mcgrath bowled the first over. Watching the match live on the filed is not the same as we are watching in the television. Here we are able to see the reaction of batsmen and the action of bowler and pitch of the ball direction of swing of the bat and running between wickets when ball running down the ground with the help of technology. But if you watch the match live, it is very simple. It was like a college cricket match we played. But I saw players like Sanath playing their shots fluently from middle of their bat. Sixes were hit effortlessly and elegantly by players. It is really a batsmen game.Margin of error is very less so bowlers have to be careful about on their line and length.

Second Innings

Shaun Pollock has been really agile in the filed and he lead the team in the absence of Sachin. We enjoyed couple of big sixers from Pollock one over point and other over the mid wicket. I was enjoying watching the game it doesn’t matter who player against whom and what was the score.

Delhi came to bat with in-form Ghambir and Shewag. The left hander failed to open his account and went back to pavilion as he was caught in short cover of a tight bowling from Mumbai Indians. Shewag was really awesome in hitting the ball without moving his feet. He played a mammoth six over the covers of Pollock and a one huge six over mid wicket of Sanath.The elegance with which the game has been played in the international level makes the game seems to be played effortlessly.Brutally punishing bowlers and ear tearing music for cheering the batsman and the cheer leaders dancing for every shot played has made this game as a tool for earning money. I guess I would be wonderful to watch a test match in DY Patil stadium,Mumbai.

Relaxing or Harbhajan Singh !!

2008-04-28T09:11:00.003-04:00

This is not a serious analysis on why Bhajji slapped the pace man from Kerala. Harbhajan was known for his atrocities on and off the ground. There were number of incidents where he misbehaved and got suspended. He was suspended from National cricket Academy for misbehaving in the camp. He was fined for racially abusing Symonds. (Sachin helped him in getting the punishment less).It clearly shows that the man from Jalandhar don’t have control over his self. His character is leading himself as an Akthar of India, Talent with immutable animosity.
Actually I have started writing the blog for sharing a Joke I have read about this slapping inceident.By the way I lost my track. Read this !!

Harbhanjan Singh was enjoying the Match. Yuvraj Singh came and asked him, are you relaxing?? Harbhajan answered No I am Harbhajan Singh. VRV Singh Came and asked the same Question. Sardar answered No No Me Harbhajan Singh. Third one came and asked the same question Sardar was totally annoyed and decided to shift his place. While walking Harbhajan saw Sreesanth enjoying the Match. He went and asked him are you Relaxing?? Sreesanth was much educated and answered Yes I am relaxing. Harbhajan slapped him on his face and said Idiot, Sab tere Ko wahahn dhoond rahe hai aur tu Yahaan Aaram Kar raha hai

Query to find Nth MAX or MIN of a column

2008-04-25T08:59:00.009-04:00

Writing a query for eccentric requirement is always exiting and challenging. Today I was asked to write a query to find Nth maximum or minimum value of a column in a table with one more column having a common data. (Not that much odd requirement right?).OK, I decided to write it directly without googling it. I manage to write this below query in couple of minutes. Check this query

select [column] from
(select [column],
rank() over(order by [column ]) rnk,
(select count(distinct [column]) from [table]) cnt
from [table] t ) where rnk=cnt+1-&N;

N will be the variable deciding the position of maximum data. For Nth minimum we can use the same query with desc clause in the order by section of the analytic function. Check the steps involved in this requirement

SQL> create table test_tbl(
2 id number,
3 num number);

Table created.

SQL> insert into test_tbl(
2 select rownum,dbms_random.random from task where rownum < 11);

10 rows created.

SQL> commit;

Commit complete.

SQL> select * from test_tbl;

ID NUM
---------- ----------
1 8576
2 566
3 3343
4 100
5 4
6 356
7 345
8 222
9 7465
10 122

10 rows selected.

SQL> select num from
2 (select num,
3 rank() over(order by num ) rnk,
4 (select count (distinct id ) from test_tbl) cnt
5 from test_tbl) where rnk=cnt+1-&n;
Enter value for n: 3
old 5: from test_tbl) where rnk=cnt+1-&n
new 5: from test_tbl) where rnk=cnt+1-3

NUM
----------
3343

SQL> /
Enter value for n: 2
old 5: from test_tbl) where rnk=cnt+1-&n
new 5: from test_tbl) where rnk=cnt+1-2

NUM
----------
7465

SQL> /
Enter value for n: 4
old 5: from test_tbl) where rnk=cnt+1-&n
new 5: from test_tbl) where rnk=cnt+1-4

NUM
----------
566

SQL> spool off

After writing this query I thought of checking the same functionality in the web.I found couple of queries. One of them from oracle site is

select * from tab1 a
where &n = (select count(distinct(b.col1))
from tab1 b where a.col1<=b.col1);

But if you compare the execution plan of the above two queries you will find the first one as much better. Guys, reading this can make a better query and add it as a comment in this blog!!

God equated to energy !

2008-04-19T14:28:00.002-04:00

I remember those long discussion with my friends about the existence of God.Mostly all of those discussion use to start politely and gain some verbosity, finally end up with every one insisting their own views.Mostly It use to happen with me and Reuben.We use to give shape and life to our thoughts with little explanation using physics.This physics has created a bond between me and him when we were in eleventh standard, where we play some ridiculous game with SI units.

After college life we depart, I am in Mumbai now and he is working in Chennai.Two days back I got a mail from him explaining God and something spiritual.I thought of replying my thought / understanding of god, to that mail.

What I feel is God in general is the energy involved in this world. It may be in the form of nature or inside a human being or may be as a thought in someone's mind. Man has no power on the energy existing in this word as we cannot create or destroy it, we are just transformers (as Law of conservation of Energy says).you have transformed your energy to get a job. I am transforming my energy to write this letter. Now you might have a question of the source energy from where all the existing energies are transformed. Science has some prediction for this. I guess you know about this..I.e. the single hydrogen atom blasted out and formed these galaxies. But Science don't have proof for this!

You know pretty well you cannot give shape to energy, But we humans are perceiving it with a shape of the object where energy resides. For some people god is stone as he thinks that the energy is within the stone; for some people it is light as they believe the energy of light is god. We all know that energy is the source of life; you can say god is source of life if you believe god is nothing but this cosmos with energy. Study of energy for understanding it logically is science. Experiencing the same energy within you (Feeling the same energy within you) is what is spiritual. For Einstein it is E where he found that Energy can be derived or transformed from mass. He has not experienced it but he experimented with energies around him to find the relationship between the mass and energy inside the mass.

I know people are saying that you cannot formulate everything as Einstein did for Energy, and they are saying you can just feel/experience it. Logically reasoning the existence and the energy with which it has been imbibed may be practically not possible for a normal human brain.

But for me, since from my first class to this letter all are logical. My brain hesitate to accept anything without logical base (i.e experiencing the energy).I firmly believe that one day this world will have formulation or scientific explanation for energy in this ambience

I just wrote what I understood.

Regards

Karthikeyan M

Science of Color

2008-04-11T04:49:00.005-04:00

Today we will talk about color, the most sensational aspect which makes life lively without which life could be a monotonus black and white picture.According to Maxwell, color is an electromagnetic wave of particular range of wavelength. We know that visible range of electromagnetic spectrum is from 380 to 750 nm. Electromagnetic radiation in this range of wavelengths is called visible light or simply light. So we can say light/energy is wavelength (point A)White light is a bundle of electromagnetic wavelength of all colors. When white light falls on a prism the different colors or wavelength will be unbundled according to the refractive index of the prism. The electromagnetic waves are colorful according to the wavelength it carry but how come objects are having colors. Interesting?

Every object is this universe is made up of atoms which have its own nucleus and electrons revolve around it in shells and orbits. The shell in which the electrons revolve depends on the energy carried by the electron. When it gain energy from ambience and it tends to move to higher orbits which we call as higher energy level. As it loses some energy to the ambience it comes down to lower orbit. The stable state will be reached when electrons reach it ground level.

So electrons in an object absorb required energy i.e. wavelength (point A) to move from one level to another and thus it will reflect the rest of the wavelength. The color of the particular reflected wavelength appears to be the color of the object. The wavelength that got reflected depends on the atomic structure of the object. So obviously the color of any object will be decided by the atomic structure and energy level of electrons.

Chilly is red because it absorbs all wavelengths from white light apart from 625–740 nm which is the wavelength of color red. This concept suits for all the objects which are having color complexion.To prove this concept if you place a green leaf in red light which is nothing but a filtered vibration of 480-405 THz ,then leaf which will absorb all the red light will not be green any more as the light fall on it is not having the green wavelength.It’s quite evident that the color of the leaf will be black as all wavelengths have been absorbed by the leaf.

Now we know why iron is red as we heat it.

English words of Tamil origin

2008-04-06T09:12:00.004-04:00

I don't know whether I am obsessive in understanding the roots of Tamil words in English. I really find it interesting in reading and learning the root of words. My subconscious mind always insists me that the Latin and Greek roots from which English got derived are directly or indirectly from Tamil.
For last one week I was in search of a good etymological site which perhaps gives me better understanding of words by explaining the root and history of it. Obviously, the book in my shelf is also a result of this search.
Finally I found a site which is fulfilling my requirement specification. I was morbidly obnoxious(I have started using this phrase more after reading Normal Lewis Word Power) in searching the word Tamil there also. I found a rich result set. Those are English words of Tamil origin, after reading those 20 odd words the synapse in my brain, which has the above mentioned subconscious understanding, got a bit stronger.

I would reckon you to have a glance through these intresting roots

Time is Absolutely Relative

2008-04-01T06:53:00.006-04:00

Time is really a fascinating concept, which is tricky to understand. I was attracted by reality and excitement involved in learning physics in my high school. I use to spend more time in reading physics textbook than others, which gave me good understanding of time. Here I just want to share the concept of time and possibility of a machine that can take us over to different instant of time

As all we learned in our higher school that Second is defined as
"The second is the duration of 9 192 631 770 periods of the radiation corresponding to the transition between the two hyperfine levels of the ground state of the cesium 133 atom"

So the standard time taken by cesium 133 atom to move from one energy level to another energy level after radiating energy has been considered as a second. Please do remember this point; we will come back to this point again.

Concept of Radioactivity

Nucleus of an electron has protons and neutrons. The protons which are positively charged particle will be repelling each other inside the nucleus. The repelling force will be directly propositional to the number of protons in nucleus. Nuclear reaction is nothing but separating a proton or adding protons to the nucleus and thus generating huge energy. Metals heavier than Iron will have more protons, so more repulsive force inside the nucleus. Repulsive nature makes these elements highly unstable. Uranium with 92 protons is an example for reactive elements. It will emit energy in the form of radioactive signals until it come to ground state. We call these elements as Radioactive.

Relation between Mass and Speed

In quantum physics explained by Einstein, mass can be converted to energy and vice versa. This has been governed by the equation E=mC2.That is,when a mass of m Kilogram travels at a speed of light it will be converted to energy equal to the product of mass of the object and square of the speed of light. It is quite oblivious that tremendous energy will be released (because of C2 ).

Time Machine

All the properties of any object traveling in the speed of light will change with respect to the object which is stable. According to Einstein’s equation as the object approaches speed of light the mass of the object become infinite. Likewise the time taken by the cesium 133 atom to change from one energy level to another level will change. This shows that the standard one second is no more same as you started travelling at light's speed.

So in the condition of a mass travelling at the speed of light, the time taken for cesium 133 atom to move from one level to another will be different.So time differs between that object and us. I guess this is the concept people are trying to use in Time machine.May be in future we can bombard a mass with light speed so the entire property of the object changes. If it carries some human being (which is also composed of electrons) will also undergo the same changes, which will be some thing next to fatal.

Lack of Foresight !

2008-03-03T05:55:00.006-05:00

Foresight is an important thing in life which is like a selfcompass.It guides one in choosing direction in life. It decides how much you are aware of your interest, capabilities, passion and more over knowledge on the ambience you are living. when I was doing my graduate I came across lot of people who were not happy with the work they were doing and the life they were leading. I use to question on these guys' attitude and behavior. But now a days I am feeling the same kind of boring you can say monotonous feeling which is really cumbersome.

I am here because of lack of foresight on my carrier, future, ability, desire ??
Nooo.!!
I was interested and involved in designing electronics circuits and programming processors for automating systems. I was passionate for controlling small systems and components through PC, but where I am now is an irrelevant area. This was outcome of the fact that I was complacent after getting placed in my pre final year. So my complacent attitude (lack of foresight) stopped me from travelling in my favorite path

I was morbidly demoralized when I got into this world of support. Because I thought of doing design of electronic product, developing software applications which involve problem solving through logical thinking. But I had only dreamt of designing, coding and delivering a product to the society.I was not having any plan (foresight) like where I need to be so that I will be enjoying doing things.

Also I was obsessed for learning all things.As I firmly believe everything in this universe is made up of electrons and driven by some logic, I was just learning things which were intresting for me. I have not even thought about what I will do after joining the company, so simple obsession for knowledge without thinking (foresight) about future won’t help anyone in getting what they need.

Being a strong introvert I had avoided to avail the opportunity to interact with professors regarding my interest and with my friends regarding goals in life. This seems to be atrocious right? I was not having any goal and I use to set my goal according to the goals in my ambience. So I was lack in setting a goal (lack of foresight) for me and having plans to attain the goal.

To summarize

• Getting complacent easily
• Lack of future planning
• Getting obsessed with anything
• Lack of Goal in life

Could have finally sent Karthikeyan here. But I cannot simply deny my exponential learning in IT in last couple of years. I have been completely exposed to new things which I have learned quickly and delivering in decent manner.Learning new things is always exiting. But if you are not focused on something and learning everything that come across your life,it won’t make you complete instead it will make you jack of all.So even though there is no harm in being obsessed we need to set a goal so that you can get something out of your input.

Telugu - derivative of Tamil

2008-02-01T01:43:00.001-05:00

Italian of the east.That's how the Sweet telugu has been portrayed.It is a Dravidian language. I guess it should be a derivative of Tamil with respect to Sanskrit.Being in Mumbai I am very much fortunate to hear almost all widely spoken Indian languages(So called Mumbai exposure).This has given me the opportunity to correlate the similarities between my mother tongue and the new languages I am coming across.

Also I got a Telugu friend as my roommate so I am getting a lot of Telugu words as input to my processor.From my understanding Telugu has its words from Tamil and its scripts from Sanskrit.According to Wiki the Telugu script is an descendant of the Brahmi script.

If you consider words of Telugu the nouns are from Tamil and the verbs are from both Sanskrit and Tamil.For example Nouns like eye and ear are from Tamil.

Tamil	English	Telugu
Kan கண்	Eye	Kannu కన్ను
Chevi செவி	Ear	Chevi చెవి
Kaal கால்	Leg	Kaallu కాళ్ళు
Manam மனம்	Heart	Manasu మనసు

Most of the time you will get Telugu word by appending a "Lu" at the end of corresponding Tamil word.Hindi words are also there like Ghanta(hour).One fourth is called as paaw(पाव) in Hindi and same in Telugu.

Now comes the real trick where the a combination of Tamil and Sanskrit word is there in Telugu.In Tamil we say three as moonu (மூணு)and thirty as muppathu(முப்பது).And we call 3/ 4 as muk-kaal means (three * one fourth).In Telugu the same has been called as

Mupp-Paaw-Ghanta

Mupp-Tamil word for three(முப்)
Paaw-Hindi word for one fourth(पाव)
Ganta-Hindi word for an hour(घंटा)

This shows that Telugu is a derivative of Tamil wrt Sanskrit.As I started hearing more words in Telugu I found it familiar because more words are descendant of Tamil.For example Allosanai,pli,Cheii..lots of words.One interesting fact is Telugu still preserve some typical Tamil words which are not in existence in colloquial Tamil language.For example the word

Cheii (செய்),
Allosanai (ஆலோசனை)
Pilzi (பிழி)

are Tamil words from sangam period which are not used most frequently now a days.But these words are more colloquial in Telugu.Apart from language I found lot more similarity in culture between Tamil and Telugu people starting from the food habits to

So you can say Telugu as a backup of Tamil.Since the backup has been taken by 200 BC still it has those old words of Tamil.Learning new language is always exciting as it will improve your comparison skills and more importantly you will get acquainted to new language soon,if start comparing it with your language.

Language Courtesy : http://www.google.com/transliterate/indic

(I wonder at the algorithm they are using in Google transliteration especially from English to Tamil.Transliterating simple 26 letter language to complex 247 letter is not easy !)

I Love learning !

2008-01-26T05:54:00.001-05:00

It has been long time since I have attended a classroom training after my "Computer Networks" in eight semester.Yesterday I have been scheduled to attend instructor-led training in Quality Management.Even though it is management related topic I have to attend as it was compulsory for all associates

Unusually I went to class by 45 minutes late.But The instructor was kind enough to allow me to attend(I use to be punctual in attending all my classes in under grads).When I entered in to the class,I remember that he was asking some questions regarding "How you will identify a resource for a project and induct him in to the project ?".I thought how these manager are always thinking something which is intangible ??.As we started looking in to more concepts, subconsciously I got interested in the class and I started listening with enthusiasm.

"Quality is the conformance to requirement specification,Defect is non conformance to the requirement spec."

Great!! I was able to remember all the definition in Quality engineering I have learned my UG.He explained about Metrics used in each Project and process involved in review.I was impressed by two concepts

Your code will be reviewed and the bugs in the code will be documented and submitted to that COE(team excellent in that tool/language) in that regional branch.Then the COE team will send trainers to train the developers in to annul the bad coding standard or related problem in future
Second one is there are lot of metrics available to estimate and track your project.The metrics will be calculated and send to dashboard of the CEO so that he can monitor and raise issue regarding the non compliance of standard or process.

It was really good feeling to know new things and spending time in thinking about the new thing.It gives fresh blood in your mind to think.After got migrated to employee life from a student life has become monotonous.

Daily I am thinking about Metasolv and the problem in Metasolv and the numerous ways to improve the system performance(Though I am not getting the rating I deserve for my work).So it has become monotonous for me.Learning new thing is always a good refreshment when you are doing repetitive things.I love learning things which involves logic which basically consumes less memory in your brain.

I guess its time to change my mode back to a student

Cool Stuff from Google for Bloggers

2008-01-19T02:26:00.000-05:00

This is an amazing facility by Google for bloggers. Don’t worry even if you don’t have access to blogspot.com.

Just send Blog to the predefined mail id. You Blog will we posted in the same way as this Blog has been posted

I am posting this from my mail id. J

Regards

Karthikeyan M

My first presentation about Best practices in PL/SQL

2008-01-11T01:03:00.001-05:00

Yes,it is my first presentation after joining the company.Initially I thought I am not the correct person for giving a presentation on BEST practices of PL/SQL,which I think can be given only by Mr.Steven.Since the audience were a set of freshers, joining our project .I made up my mind to share the experience in PL/SQL so that they wont follow any bad practices in PL/SQL.

I was very clear that what ever the bad practices I have seen and which is screwing the performance of the system should not be repeated.So I prepared my presentation with points like

• Take more time in designing

• Follow coding standard
• Avoid hard coding
• Avoid writing more SQL
• Write tiny chunk of code
• Don’t repeat anything

I was happy to share what I have learned from Steven's presentation.Since all were freshers I was not getting more questions from the audience.But they were listening well and responded, whenever I asked then some questions.It was a bit of tumbling start(coz its my first time) but as I move on to concepts like FORALL and BULKCOLLECT I was pretty comfortable and I started delivering steadily.I have given examples of codes I have written and problem we have faced while supporting our database.I explained them the importance of modularizing the logic into small blocks of code and reusing it where ever required."please don't dump your logic inside a single procedure",I urged.

I mentioned the importance of having repeated SQLs inside a function.So that hard parsing of frequently executed queries will be avoided and performance will improve.I remembered the fact that one SQL has executed 20 thousand time and still was in the data buffer cache(mentioned by Steven). I stressed them to have a separate exception handling and error logging procedure.I substantiate my point with some examples.I suggest them to log as more data as possible when an exception has occurred which could help them in debugging and problem.At the end I stressed with high vocal,

"Don't repeat anything and write tiny chunk of code ".

It was a like sound of a guy who got screwed by worst design and bad coding practice.It gives you real satisfaction if you share something you know to others.I thanked Anoop , my friend for giving this opportunity.

A Blissful trip to Alibag !

2008-01-07T04:40:00.001-05:00

I can count the number of times I went out with my friends in Mumbai.So I accepted the invitation from Vinoth when he asked me for the first time.We planned to have a trip to Nagaon a beach in Alibag near Mumbai.

As I planned, I woke up by half past five in morning and got ready to move to Thane station by 7.AM.As we planned we all six were there in station.I wondered to see same normal Mumbai crowd even by morning 7 AM .(I questioned myself where these guys are going ? why the hell Mumbai is hyper crowded !!).We finally managed to catch a fast local by 7.30 AM.We reached CST (Chhatrapati Shivaji Terminus) within the next 45 minutes.(that's why people in Mumbai prefers local I guess).

Pulkit, one of our partner was waiting there with ticket ready.Actually the ticket is for a traveling in a ferry from CST to Alibag .we got in to the ferry and stared our one hour journey towards Alibag .It was really an entertaining journey from Colaba which started with panoramic view of gateway of India followed by cool breeze from sea.We reached Alibag by half past 10 AM and had our breakfast there.

We bargained with an auto Bhai for 150 bucks for traveling from Alibag to Nagaon.Apart from me and Vinoth everyone use to converse in Hindi. I really enjoyed Hindi when they are talking to each other and even when I tried to converse.Sunny was translating to me when I was not getting some tough typical words in Hindi.Everyone was showing their talent in photography and giving pose to snaps.we reached Nagaon by 11 AM finally.

It was a beach with decent crowd and less waves.We played football where me,Pulkit and Himanshu was a team and rest four as one team lead by Vinoth.we have made seven attempts to score but all went in vain.If you considered ball possession we had the ball for more than 75% of time.After 20 minutes all of our voltage level drops to zero.so we decide to have an additional time of 10 minutes where any goal will be the golden goal.Finally I managed to score one goal ( like Therriy Henry use to do for Arsenal now for Barcelona :) ).

Then we played for sometime in water and had lunch by 3 PM.Finally we started from there by ferry and reached Colaba.I heard from Hari that India lost the match @ Sydney by 122 Runs.I was really disappointed .I came to know from news that couple of bad decision from umpires made India down.

Over all it was a really a blissful tour with my seniors like Pulkit and Vinoth.

Is Masters a MUST ...?

2008-01-04T03:56:00.001-05:00

Recently I have attended a seminar by Steven Feuerstein ,arranged by Quest software.There I met a person named Krishan Thyagarajan ,executive officer for Quest for Asia pacific.we were discussing about Oracle,PL/SQL and products of Quest and Indian IT industry.He told that with employees of around 1 lakh, these big Indian IT industries are like Indian railways.I got a bit angry when he said this ,but when I think later I realized it is true.

Now the strategy of almost all Indian IT company is to hire more people to bid more more projects with less margin.Since we are bidding for low margin the quality of product we are expected to deliver is also less.So the work our IT industry doing is not a creative one ,its just following some set of process to deliver a product in working condition.Now new engineers are flooding into IT industry.If you can manage a bit of English and little knowledge to write a code to sort n numbers in C will get you a job in current IT industry,from where you can manage to be an ML in one year,then so called onsite in two years and then after 4 or 5 years you will be a PL.you will earn money for sure But the question is the quality of work we are doing.!

The real view of Indian IT industry will show you how bad it is and where it is heading to ?

I was really interested in knowing how the industry will be in US , I got an opportunity to meet my friend's brother who has completed his bachelor of engineering in PILANI and completed his MS is University of Texas and doing his executive MBA in London business school.We talked to him about.... what MS is all about....what kind of Job we will get...Indian education system....etc.I understood that real difference in the quality of work they are doing and the product they are delivering.

When I was in my under-grads I got a couple of friends preparing for GRE to get in to their grads in US.Since I was unaware of Indian IT industries' standard and attracted by the package I trapped myself here.More over I was complacent about getting placed in campus after my bachelors.

I think going for masters after you bachelors will give you real depth of knowledge ,which I love to gain and explore.you will also get the exposure to international standard in studies and research.So I think people who are feeling they are not the correct person to slog for poor Indian managers can think about going for MS / MBA.

Implementing all as Procedures - Bad Practice in PL/SQL

2007-12-24T11:21:00.001-05:00

I have seen a lot of programmers implementing their complete logic as a single procedure.After getting a small overview of what has to be done,they will simply create a procedure and dump all their selects,inserts,updates and merges with in a single BEGIN and END block with a single EXCEPTION block that too some time with WHEN OTHERS NULL which will literally eat the occurred exception.

I have seen code (written by programmers with 2 years of experience) with 730 odd lines of code with single exception block.If any one select fails in the procedure then we wont be able to troubleshoot where the ERROR has occurred and which statement caused the error.As PL/SQL guru said SQL is as bad as hard coding we should avoid SQL inside our begin end block.Basically we are spending time on writing more code and less time on design which is a bad approach in development.

The ideal way of implementing a logic should be

Breaking the requirement in to logical blocks and implementing them as packages.
Providing Interface only to the required procedures in the package and hiding the reset.
Making all selects as a Functions (Table APIs would be better).
Repeated activity as procedure inside a package.
Maximum use of bind variables
Tuning the query before making it live.

I would like to stress the point of implementing the selects as functions.Because these frequently used functions will be there in the cache memory which will avoid hard parsing there by time to execute the query.If we follow these simple steps we will get better performing and maintainable code which will give our user a better feeling and the support team a better life.

The point to learn from this is

We should spent more time on designing and validating the design and less time on coding the same.

Handy Windows Live writer

2007-12-21T06:54:00.001-05:00

Just now I have installed Windows Live writer in my Laptop.It is pretty handy and a very effective blogging tool.you can be a decent blogger if you have this Writer ------you can do

Insert an Image easily(Difficult in blogspot.com)
Edit the format of your blog
Spell check

I have not explored completely ....as just now I have installed !

Couple of days as a manager

2007-12-20T01:51:00.001-05:00

I don't want to be actually but circumstances made me to be.... for last couple of days, not to manage a project, just to manage a team of five.Most of the time I was sending mails to my mates for closing the issue.I use to expect the reply soon and get disappointed.I think man management is a skill as such.As a manager/lead we need to

Identify the work
Assign to the concern person
Get it done
Motivate people(you should not compete with your team member)
Should not be short tempered

If you do everything you will get the output at the end of the day that your team has accomplished things.But I think

the activity of management will eat your time and stop you from spending time on things you are interested in.

It all depends on what you want in life :)

After a Loooong Break !

2007-12-12T10:05:00.000-05:00

I am been writing this blog after a long time. I am feeling happy to back here. I remember I wrote my last blog about Feddys class @ Wimbledon. Days passed and months passed.
were I came across things like Himanshu left.....Feddy won US open again...Rahul resigned… Got 4 rating.... got new laptop... new interest in Oracle... completed OCA....died for M6 for last 6 months again got same rating :(...New interest in MS....
Life is going onnn in its own way....... Now I am thinking that I have to focus on what I need in life.... not doing what ever i like on that day. So my actions will be focused and I will start moving towards what i want.
But I know life is not about the destiny.. Its about enjoying the journey towards our destiny!

Expecting NEW Interface from Gmail

2007-10-03T15:07:00.001-04:00

Google is planning for an enhanced and smooth interface for Gmail.We can soon experience a cool and comfortable environment for our gmail with some additional features.

Finally India Found Sourav's successor from Ranchi !

2007-09-24T12:52:00.001-04:00

Dhoni,a new leader we have found from the latest T-20 World cup.He has been natural leader,the way he commands and get work done in the team has been outstanding.After Sourav even we got Rahul as skipper but his nature was not suiting for a leadind a side like India, as he take pressure which finally results in his resignation.But no second thought in Rahul as technically the best player India has ever produced.But Dhoni has got the command which Kapil had when India was top during 1983 and Sourav showed when India dominates all team during 2003.

People may say that T-20 is shorter version and it wont be a correct yardstick to measure once capability as captain,but even then it need more guts and determination to hold your nerve to win matches where one bad delivery cause you a match.

As Sourav commented on a column "Its all about GUTS and DETERMIANTION "to captain a side like India where atleast 70 crores of hearts always want you to win.

All are Blocked Here :(

2007-09-20T01:21:00.001-04:00

I am just trying to post this from my blocked LAN :)

Just a try from Live writer.Hope it should work.

All are Blocked Here :(

2007-09-19T12:35:00.001-04:00

I am just trying to post this from my blocked LAN :)

Just a try from Live writer.Hope it should work.

All are Blocked Here :(

2007-09-19T12:34:00.001-04:00

I am just trying to post this from my blocked LAN :)

Just a try from Live writer.Hope it should work.

Federer's way of mauling the opponent

2007-07-20T01:07:00.001-04:00

After I wrote the last blog about Federer, my friends started pinging me and asking more "hows and whys".But it is quite obvious that Federer is highly talented calm and greatly composed character.Also his excellence in all parts of the game are just replica of coaching manual.This is Federer's coaching manual I have read.

Summary
Federer possesses outstanding control over his racket speed, angle and topspin. Aided further by superior anticipation and unusually quick movement, he can subtly dictate the momentum and the direction of the game. He also shows rare mental adaptability and stroke-making versatility as he is known to switch his playing style in the middle of a match or tweak a few things in his game to outsmart and outplay his opponents. He displays unusual calm and an uncommon lack of visible frustration when he makes errors, perhaps a result of his confidence in his unmatched abilities.

Service
Federer's serves are relatively fast, hovering around 120mph. More important than the speed of his serve is his deceptive ability to produce them accurately at different angles and bounces using the same serving motion, a skill that was perfected by Pete Sampras. The Guardian points out that "[Federer's] brightest jewels [are] slow-motion aces, objects of beauty because the rare combination of insidious accuracy and slick disguise [makes] great speed redundant."

Service Return
Federer is also exceptional at reading fast serves and returning them. He doesn't punish services with his returns like Andre Agassi does, and seems to prefer the steadier slice or bunt that neutralizes the server's advantage, but his anticipation and ability to read the service appears equal to or superior to Agassi's. During Wimbledon 2003, Sports Illustrated magazine noted the following about Federer's return game against Andy Roddick, the fastest server in the history of tennis: "Federer has a knack for reading Roddick's serve, getting enough of his racket on them to cut down on aces. Roddick had only a pair of aces in each of the first two sets and none in the third. He had 64 aces in his five matches on the way to the semis."

Forehand and Backhand
Federer has technically flawless forehand and backhand shots that he can unleash with great power, often at speeds near 100mph, anywhere on the court, prompting many commentators to exclaim that he makes the court look smaller or that he reduces tennis to mere ping-pong. He is one of the few top players who play with a one-handed backhand. Rod Laver is especially fond of the Federer backhand and says that it "is the best shot he plays, as he can roll his racket over the top of the ball, or hit it straight. I don't know how he manages to hit the ball so cleanly all the time."

Shotmaking in Exceptional Circumstances
Federer usually plays with moderate aggression and doesn't go for the dominant shots all the time. Like all great players, he has a knack for creating all kinds of spectacular shots when pushed into compromising positions, usually when an opponent approaches the net expecting easy putaways. But Federer's responses are probably far more varied then any other player in the history of the game: looping crosscourt backhand passes, wristy and instinctive backhand pickups from the midcourt placed at very acute angles, exceptionally accurate down-the-line backhand passing shots while on the run, a heavily-topspinned forehand crosscourt pull from the baseline that, upon bounce, spins and fades away from lunging opponents, crushing forehand shots from the baseline that land inside the service box and speed away, and more.

Defense
Federer has great defense at the back of the court and is exceptionally good at returning deep, close-to-the-baseline shots from his opponents with effortless, Andre Agassi-like but even better, instinctive half-volleys and John McEnroe-like behind-the-body backhand flick returns. He is among the best in the world - one might say on par with Lleyton Hewitt, but without the gritty terrier-like tenacity and with nonchalant grace at chasing down his opponents' dominant baseline shots and keeping balls in play. Federer is, however, not entirely invincible at the baseline and shows vulnerability (and incidentally, a rare room for improvement) at his backhand side. There are times, though seldom, when an opponent can force errors from Federer's backhand defensive shots either by pounding relentless, accurate, flat and deep shots at his backhand corner (exposed against Marat Safin on hardcourt at the Australian Open 2005 semi-final) or by employing high-bouncing topsin shots at the same corner (exposed against Rafael Nadal on clay at the French Open 2005 semi-final).

Deliberative Shotmaking
In addition to these, he deliberately "mixes up" his game to keep his opponents guessing all the time. One of his more creative shots while not under pressure is a beautifully executed, both feet on the air, inside-out forehand from his backhand side generated using a unique, almost-complete lateral rotation of his torso --- a shot that he uses selectively for more power and angle instead of using the stock backhand. He has also reintroduced the backhand slice in fast courts to deliberately slow down the tempo of the game, and it serves well for the seemingly "cat-and-mouse" games he plays with his opponents. He is also adept at unexpectantly producing dying, back-spinning dropshots at the foot of the net, both forehand and backhand, and often employs them successfully from the back of the court against the fastest runners and anticipators in the game. Furthermore, his flexibility and quickness allow him to hit clean winners with perfect racket preparation and positioning - even when he is facing low-bouncing balls at the midcourt.

At the Net
Federer's playing style at the net, like the rest of his game, rarely seems rushed or fidgety. He almost always makes sure-footed steps at the net. At times his flexibility allows him to make galloping strides to his left or right and help himself in positions to make seemingly effortless volleys from well below the net level. And the volleys themselves are exquisitely executed, especially the stop-volleys. Federer often employs the right amount of backspin on his stop-volleys so that after the ball barely clears the net and lands on the other side, it either stops dead with minimal bounce or, to the further frustration of his opponent, backspins. This explains why Federer doesn't usually have prolonged net enounters with his opponents. He likes to finish off his net points early. The lack of such encounters, however, may prove to be his Achilles' Heel during crucial points against an opponent who is extremely quick to reach the net and who thrives at the prospect of making agile, instinctive counterpunch in such situations. Federer's sure-footedness and effortless pickups at the net reminds one of Sampras, whereas the crisp, timely execution of volleys are reminiscent of Stefan Edberg, who is incidentally one of Federer's childhood idols. Federer's net game is most suited for grass, and it has helped him capture three back-to-back Wimbledon titles.

The Feel and other Intangibles
Federer also demonstrates uncanny disguise in his ability to hold the point of contact with the ball (and consequentially his opponent) a split second longer. In the absence of anticipatory cues, Federer's opponents cannot readily get a jump on his shots. He can play down the line or crosscourt off the identical stance and seemingly identical swing - directing the ball either left or right by a subtle change in timing. As his ATP peer Tim Henman points out: "I can watch when I'm playing him and there are certain times where I will hit a shot, I will be at the net and it almost looks he's got a split second longer than most other players...Sometimes he comes across to hit a backhand pass when you feel like you've hit a good approach and it's like he has got a bit longer to hit it."

Federer's mastery, beyond being able to hit all shots and angles, combines a number of intangible factors, including fluid strokes with little mental interference, genius in constructing points, seamless transitions from defense to offense, an intuitive understanding of his opponent's options and likely responses, and a clear, calm mind that executes instantly. As he commented after the Australian Open 2004 final win against Safin: "I feel when a guy is going to hit the ball, I know exactly with the angles and the spins, I just feel that I've got that figured out. And that is just a huge advantage."⁵ Fellow ATP player Ivan Ljubicic also points out that "[Federer] usually tries to hit winner[sic] at the beginning of game which causes panic in his opponent. After that, he patiently waits for his opportunity or hits winner[sic] when needed.

It's a matter of class not the power

2007-07-10T04:23:00.001-04:00

After the famous fifth consecutive win at the center court in All England Tennis club,I expected people will start talking about Federer's supremacy in grass.but the reverse is happening ever column writer is trying to project as if Federer some how got the mark of "consecutive five" and praising Nadal for his effort to made the final as five setter.

I also agree that Nadal is good with his powerful forehand and cross-court shot(Because of which he won the last two final at Roland Garros).But I wont agree with people saying that Rafa will takeover the supremacy from Federer.People are stating that Nadal has broken the serves of Federer in wimbledon final and made him running for cover to get the fifth consecutive one,yes Rafa played a good game and was tough opponent for Federer to beat.But if you take a comparison of these two players you wont say that Federer's supremacy can be taken over from him by a guy like Nadal whose depends purely on power.

Nadal's Power

Basically Nadal's strength is power and stamina which purely depends on his age.As he gets older his speed and stamina will be questioned.Now he is 21 young and energetic to run across the court and take volley and drop shots from the opponent and to hit he ball hard with his forehand and cut the ball across the court.But as he gets older he will find his favorite shots difficult to play with same power.so his game is a inverse function of his age

Federer's Class

Feddy with the trophy for the fifth time in a row

But If you take Federer his game does not rely on his power.he is a kind of player who served with pace(24 aces in the 2007 wimbledon final) and accuracy and using his backhand to save energy and occasionally use the forehand to cruise the opponent across the court.he has been known for this accuracy and all round in his game so he is playing the same way as he did when he was 19 years old.So his game depends very less on his age.So when you compare age and class age may be effective instantaneously but class prolongs for time and will make you a legend whose fame will exists in the tennis world irrespective of time.

So I personally believe that Federer will dominate the tennis world for atleast next three odd years.Even Four more powerful Nadal come into picture they cannot take over the crown from the classy grass king with their power and stamina.It needs shear class to take over the crown from Feddy as he did in 2001 from the classy Pete.

[I think it is analogous comparison people have made by comparing Jayawardene with Sachin the legend when Jayawardene made 200 and we know how Jayawardene's game changed as he spent five odd years in cricket]

The Laws of Computing

2007-07-09T10:18:00.001-04:00

First law - The Computer is always right.
Lemma one - Programmers are occasionally right.
Second law - The amount of time needed to debug a program is inversely proportional to the time allotted for debugging.
Corollary - Programs never work the first time unless there is virtually unlimited time to complete the program.
Third law - Any programmer can find 90% of his bugs simply by explaining his program to an uninterested observer.
Corollary - The uninterested observer may be sleeping, dead, nonhuman, or, in extreme cases, nonexistent.
Fourth law - The most difficult or nearly impossible programming problems appear obvious or extremely simple to anyone with little or no knowledge of programming.
Corollary - Those problems most easily solved by a programmer appear to be overwhelmingly complicated and marvelous to the layman.
Fifth law - Computers are never more intelligent than their programmers.
Corollary - Most computers are incredibly stupid.
Sixth law - The rarest bugs in any operating system or major programming effort will always show up in a demonstration of its use to prospective users or customers.
Corollary - These bugs usually cannot be reproduced and therefore cannot be located.
Lemma one - Customers will never purchase programs which appear to be riddled with bugs as verified by demonstration.
Paradox - Most programs are unfit for sale.

Our ancestors have predicted google by 1964!

2007-06-28T09:29:00.001-04:00

Google has been predicted by our ancestors 40 odd years ago,as they have predicted ship as large moving body and computer as data processing machine.It has been said in a magazine released by 1964 ,that there will a answer machine which will give you the suggestion if you ask your query to it.

Now Google is doing the same by getting user query as input and the result for their queries as output using a sophisticated algorithm.The cool one(as Thala said) is the picture they have published in that magazine is almost matching the way now people are Googling .

Google page creator Beta

2007-06-23T06:22:00.001-04:00

The Google Page Creator beta allows you to design and post a quick Web page in a few easy steps. First, because it's still in development, you must sign up to try this service via your Gmail account. Once Google gives you the green light to try its Page Creator beta editing tool, you'll receive access to 100MB of hosting space and a domain name derived from your Gmail handle (such as gmail.google.com/karthikeyanmect), plus space for your page on googlepages.com.

Google Page Creator uses JavaScript and AJAX technologies to present a largely drag-and-drop Web-page creation environment within your browser window. It's simple to use and great for producing basic Web pages based on the provided templates, although you can't include blogs, message boards or even simple forms. Google does allow HTML edits, but not enough to influence the layout of the entire page. Thankfully, the Google Page Creator beta produces clean CSS and HTML code.

However, there are still some areas for improvement. For example, one template provided a horizontal divider that was impossible to move using the visual interface or by HTML editing. As a result, whenever we changed the style of the page, the divider remained, albeit obscured by text. Although Google Page Creator may be a good option for knocking up a quick placeholder Web page, the Microsoft Office Live beta provides more full-featured tools and also offers you a domain name. For professional Web editing, we recommend Dreamweaver 8 instead.

Lemuria Part-2

2007-06-22T11:16:00.001-04:00

Lemuria had been the place where human race was belived to be originated.That part of the world had been termed as KUMARI-KANDAM in tamil.The culture of people and language used by them ,about he kings ruled that part of the world and literature existed at that time in Kumarikandam has been clearly explained in the tamil literature SILAPATHIKARAM by a tamil scholar Ilangovadikal.

We all know that there were three kingdom in tamil Pandiya,Chera and Chola.I have read that initially there were only one kingdom in the Lemuria called Pandiya then one king separated the entire landscape into three parts to his children,as time rolls they become three separate kingdom.

Also the geographical structure of Lemuria has been explained a bit in his literature.There was a mountain near present Kanyakumari similar to Himalayas and You can see the map drawn according to the data we got from literatures in that age

Figure-Lemuria Map-Predicted Map

People in this region of Lemuria spoke Tamil.They had their language with structure grammar and more literatures and poets,as we know people has been divided according to the place where they live like

Kurunji
Marutham
Mulai
Neithal
Palai

These five types of land and people and their foods and dresses all have been discussed in literatures from that time.Sivan was the primary GOD for those people apart from their "Kula-theivam" a god for group of people.

I found this word Kula-theivam has been still used in all part of India in almost all languages as follows

Kula-Thevam	Tamil
Kula-Theivam	Kannada
Kula-theiva	Telugu
Kula-theivak	Marati

This shows how people from the continent of Lemuria migrated towards northern India.In the next part we will see the disaster happen to our Lemuria

Let me continue later........

Lets do a small comparision.

2007-06-20T08:59:00.000-04:00

Efficient Google searches

2007-06-19T04:47:00.001-04:00

Even I have written already about Google search...... this could also be
useful for google users

For millions of people, Google is an indispensable search tool that they use
every day.From work or school, research, to looking up movies and celebrities to
news and gossip, Google is the go-to search engine.

But instead of just typing in a phrase and wading through page after page
of results, there are a number of ways to make your searches more
efficient.

some of the best ways to get exactly what you're looking for, and
quickly.

Either/or. Google normally searches for pages that contain all the
words you type in the search box, but if you want pages that have one term or
another (or both), use the OR operator -- or use the "|" symbol (pipe symbol) to
save you a keystroke. [karthikeyan| mect| mectianz]

Quotes. If you want to search for an exact phrase, use quotes.
["Albert Einstein"] will only find that exact phrase. [India "karthikeyanmect"]
will find pages that contain the word dumb and the exact phrase "karthikeyanmect".

Not. If you don't want a term or phrase, use the "-" symbol.
[mectianz-karthi] will return pages that contain "mectianz" but that don't
contain "karthi".

Similar terms. Use the "~" symbol to return similar terms.
[~db2 database architecture -db2 ] will get you pages that contain "oracle
database architecture " and "mssql database architecture " but not "db2 database
architecture"

Site-specific. Use the "site:" operator to search only within a
certain website. [site:karthikeyanmect.googlepages.com thiruvasagam] will search
for the term "thiruvasagam" only within this site.

Lemuria Where human race originated.

2007-06-14T11:58:00.000-04:00

After I have been to Mumbai, more precisely after I am in to IT industry / started using Google search more I search more about the origin of Tamil.
I found a lot of interesting and amazing data about our origin. When I searched I got the word LEMURIA. It was a continent that got cooled first in the surface of hot earth which is believed to be a bit of piece that came out of centrifugal force of a rotating star may be sun before million of years.
Lemuria was a continent connecting Australia in the east to Africa in the west covering the entire Indian Ocean. It was believed to be the place, where human race originated. Then they travel across the globe and differentiated and integrated as multiple races. Tamil people believed to be originated here as Lemurs.

" Kal thoonri mann thonra kaalethe mun toonriya mootha tamzhil"

As decades passed they got civilized along with change in their language and living style. This is quiet obvious from way their Tamil changes from
“Purananooru to Puthu kavithai by Bharatithasaan.”
--------------------I will pen more on this as i get time
(http:karthikeyanmect.googlepages.com)

A nice article about Google - New York Times

2007-06-08T09:59:00.000-04:00

THESE days, Google seems to be doing everything, everywhere. It takes pictures of your house from outer space, copies rare Sanskrit books in India, charms its way onto Madison Avenue, picks fights with Hollywood and tries to undercut Microsoft’s software dominance.

But at its core, Google remains a search engine. And its search pages, blue hyperlinks set against a bland, white background, have made it the most visited, most profitable and arguably the most powerful company on the Internet. Google is the homework helper, navigator and yellow pages for half a billion users, able to find the most improbable needles in the world’s largest haystack of information in just the blink of an eye.

Yet however easy it is to wax poetic about the modern-day miracle of Google, the site is also among the world’s biggest teases. Millions of times a day, users click away from Google, disappointed that they couldn’t find the hotel, the recipe or the background of that hot guy. Google often finds what users want, but it doesn’t always.

That’s why Amit Singhal and hundreds of other Google engineers are constantly tweaking the company’s search engine in an elusive quest to close the gap between often and always.

Mr. Singhal is the master of what Google calls its “ranking algorithm” — the formulas that decide which Web pages best answer each user’s question. It is a crucial part of Google’s inner sanctum, a department called “search quality” that the company treats like a state secret. Google rarely allows outsiders to visit the unit, and it has been cautious about allowing Mr. Singhal to speak with the news media about the magical, mathematical brew inside the millions of black boxes that power its search engine.

Google values Mr. Singhal and his team so highly for the most basic of competitive reasons. It believes that its ability to decrease the number of times it leaves searchers disappointed is crucial to fending off ever fiercer attacks from the likes of Yahoo and Microsoft and preserving the tidy advertising gold mine that search represents.

“The fundamental value created by Google is the ranking,” says John Battelle, the chief executive of Federated Media, a blog ad network, and author of “The Search,” a book about Google.

Online stores, he notes, find that a quarter to a half of their visitors, and most of their new customers, come from search engines. And media sites are discovering that many people are ignoring their home pages — where ad rates are typically highest — and using Google to jump to the specific pages they want.

“Google has become the lifeblood of the Internet,” Mr. Battelle says. “You have to be in it.”

Users, of course, don’t see the science and the artistry that makes Google’s black boxes hum, but the search-quality team makes about a half-dozen major and minor changes a week to the vast nest of mathematical formulas that power the search engine.

These formulas have grown better at reading the minds of users to interpret a very short query. Are the users looking for a job, a purchase or a fact? The formulas can tell that people who type “apples” are likely to be thinking about fruit, while those who type “Apple” are mulling computers or iPods. They can even compensate for vaguely worded queries or outright mistakes.

“Search over the last few years has moved from ‘Give me what I typed’ to ‘Give me what I want,’ ” says Mr. Singhal, a 39-year-old native of India who joined Google in 2000 and is now a Google Fellow, the designation the company reserves for its elite engineers.

Google recently allowed a reporter from The New York Times to spend a day with Mr. Singhal and others in the search-quality team, observing some internal meetings and talking to several top engineers. There were many questions that Google wouldn’t answer. But the engineers still explained more than they ever have before in the news media about how their search system works.

As Google constantly fine-tunes its search engine, one challenge it faces is sheer scale. It is now the most popular Web site in the world, offering its services in 112 languages, indexing tens of billons of Web pages and handling hundreds of millions of queries a day.

Even more daunting, many of those pages are shams created by hucksters trying to lure Web surfers to their sites filled with ads, pornography or financial scams. At the same time, users have come to expect that Google can sift through all that data and find what they are seeking, with just a few words as clues.

“Expectations are higher now,” said Udi Manber, who oversees Google’s entire search-quality group. “When search first started, if you searched for something and you found it, it was a miracle. Now, if you don’t get exactly what you want in the first three results, something is wrong.”

Google’s approach to search reflects its unconventional management practices. It has hundreds of engineers, including leading experts in search lured from academia, loosely organized and working on projects that interest them. But when it comes to the search engine — which has many thousands of interlocking equations — it has to double-check the engineers’ independent work with objective, quantitative rigor to ensure that new formulas don’t do more harm than good.

As always, tweaking and quality control involve a balancing act. “You make a change, and it affects some queries positively and others negatively,” Mr. Manber says. “You can’t only launch things that are 100 percent positive.”

THE epicenter of Google’s frantic quest for perfect links is Building 43 in the heart of the company’s headquarters here, known as the Googleplex. In a nod to the space-travel fascination of Larry Page, the Google co-founder, a full-scale replica of SpaceShipOne, the first privately financed spacecraft, dominates the building’s lobby. The spaceship is also a tangible reminder that despite its pedestrian uses — finding the dry cleaner’s address or checking out a prospective boyfriend — what Google does is akin to rocket science.

At the top of a bright chartreuse staircase in Building 43 is the office that Mr. Singhal shares with three other top engineers. It is littered with plastic light sabers, foam swords and Nerf guns. A big white board near Mr. Singhal’s desk is scrawled with graphs, queries and bits of multicolored mathematical algorithms. Complaints from users about searches gone awry are also scrawled on the board.

Any of Google’s 10,000 employees can use its “Buganizer” system to report a search problem, and about 100 times a day they do — listing Mr. Singhal as the person responsible to squash them.

“Someone brings a query that is broken to Amit, and he treasures it and cherishes it and tries to figure out how to fix the algorithm,” says Matt Cutts, one of Mr. Singhal’s officemates and the head of Google’s efforts to fight Web spam, the term for advertising-filled pages that somehow keep maneuvering to the top of search listings.

Some complaints involve simple flaws that need to be fixed right away. Recently, a search for “French Revolution” returned too many sites about the recent French presidential election campaign — in which candidates opined on various policy revolutions — rather than the ouster of King Louis XVI. A search-engine tweak gave more weight to pages with phrases like “French Revolution” rather than pages that simply had both words.

At other times, complaints highlight more complex problems. In 2005, Bill Brougher, a Google product manager, complained that typing the phrase “teak patio Palo Alto” didn’t return a local store called the Teak Patio.

So Mr. Singhal fired up one of Google’s prized and closely guarded internal programs, called Debug, which shows how its computers evaluate each query and each Web page. He discovered that Theteakpatio.com did not show up because Google’s formulas were not giving enough importance to links from other sites about Palo Alto.

It was also a clue to a bigger problem. Finding local businesses is important to users, but Google often has to rely on only a handful of sites for clues about which businesses are best. Within two months of Mr. Brougher’s complaint, Mr. Singhal’s group had written a new mathematical formula to handle queries for hometown shops.

But Mr. Singhal often doesn’t rush to fix everything he hears about, because each change can affect the rankings of many sites. “You can’t just react on the first complaint,” he says. “You let things simmer.”

So he monitors complaints on his white board, prioritizing them if they keep coming back. For much of the second half of last year, one of the recurring items was “freshness.”

Freshness, which describes how many recently created or changed pages are included in a search result, is at the center of a constant debate in search: Is it better to provide new information or to display pages that have stood the test of time and are more likely to be of higher quality? Until now, Google has preferred pages old enough to attract others to link to them.

But last year, Mr. Singhal started to worry that Google’s balance was off. When the company introduced its new stock quotation service, a search for “Google Finance” couldn’t find it. After monitoring similar problems, he assembled a team of three engineers to figure out what to do about them.

Earlier this spring, he brought his squad’s findings to Mr. Manber’s weekly gathering of top search-quality engineers who review major projects. At the meeting, a dozen people sat around a large table, another dozen sprawled on red couches, and two more beamed in from New York via video conference, their images projected on a large screen. Most were men, and many were tapping away on laptops. One of the New Yorkers munched on cake.

Mr. Singhal introduced the freshness problem, explaining that simply changing formulas to display more new pages results in lower-quality searches much of the time. He then unveiled his team’s solution: a mathematical model that tries to determine when users want new information and when they don’t. (And yes, like all Google initiatives, it had a name: QDF, for “query deserves freshness.”)

Mr. Manber’s group questioned QDF’s formula and how it could be deployed. At the end of the meeting, Mr. Singhal said he expected to begin testing it on Google users in one of the company’s data centers within two weeks. An engineer wondered whether that was too ambitious.

“What do you take us for, slackers?” Mr. Singhal responded with a rebellious smile.

THE QDF solution revolves around determining whether a topic is “hot.” If news sites or blog posts are actively writing about a topic, the model figures that it is one for which users are more likely to want current information. The model also examines Google’s own stream of billions of search queries, which Mr. Singhal believes is an even better monitor of global enthusiasm about a particular subject.

As an example, he points out what happens when cities suffer power failures. “When there is a blackout in New York, the first articles appear in 15 minutes; we get queries in two seconds,” he says.

Mr. Singhal says he tested QDF for a simple application: deciding whether to include a few news headlines among regular results when people do searches for topics with high QDF scores. Although Google already has a different system for including headlines on some search pages, QDF offered more sophisticated results, putting the headlines at the top of the page for some queries, and putting them in the middle or at the bottom for others.

GOOGLE’S breakneck pace contrasts with the more leisurely style of the universities and corporate research labs from which many of its leaders hail. Google recruited Mr. Singhal from AT&T Labs. Mr. Manber, a native of Israel, was an early examiner of Internet searches while teaching computer science at the University of Arizona. He jumped into the corporate fray early, first as Yahoo’s chief scientist and then running an Amazon.com search unit.

Google lured Mr. Manber from Amazon last year. When he arrived and began to look inside the company’s black boxes, he says, he was surprised that Google’s methods were so far ahead of those of academic researchers and corporate rivals.

“I spent the first three months saying, ‘I have an idea,’ ” he recalls. “And they’d say, ‘We’ve thought of that and it’s already in there,’ or ‘It doesn’t work.’ ”

The reticent Mr. Manber (he declines to give his age), would discuss his search-quality group only in the vaguest of terms. It operates in small teams of engineers. Some, like Mr. Singhal’s, focus on systems that process queries after users type them in. Others work on features that improve the display of results, like extracting snippets — the short, descriptive text that gives users a hint about a site’s content.

Other members of Mr. Manber’s team work on what happens before users can even start a search: maintaining a giant index of all the world’s Web pages. Google has hundreds of thousands of customized computers scouring the Web to serve that purpose. In its early years, Google built a new index every six to eight weeks. Now it rechecks many pages every few days.

And Google does more than simply build an outsized, digital table of contents for the Web. Instead, it actually makes a copy of the entire Internet — every word on every page — that it stores in each of its huge customized data centers so it can comb through the information faster. Google recently developed a new system that can hold far more data and search through it far faster than the company could before.

As Google compiles its index, it calculates a number it calls PageRank for each page it finds. This was the key invention of Google’s founders, Mr. Page and Sergey Brin. PageRank tallies how many times other sites link to a given page. Sites that are more popular, especially with sites that have high PageRanks themselves, are considered likely to be of higher quality.

Mr. Singhal has developed a far more elaborate system for ranking pages, which involves more than 200 types of information, or what Google calls “signals.” PageRank is but one signal. Some signals are on Web pages — like words, links, images and so on. Some are drawn from the history of how pages have changed over time. Some signals are data patterns uncovered in the trillions of searches that Google has handled over the years.

“The data we have is pushing the state of the art,” Mr. Singhal says. “We see all the links going to a page, how the content is changing on the page over time.”

Increasingly, Google is using signals that come from its history of what individual users have searched for in the past, in order to offer results that reflect each person’s interests. For example, a search for “dolphins” will return different results for a user who is a Miami football fan than for a user who is a marine biologist. This works only for users who sign into one of Google’s services, like Gmail.

(Google says it goes out of its way to prevent access to its growing store of individual user preferences and patterns. But the vast breadth and detail of such records is prompting lust among the nosey and fears among privacy advocates.)

Once Google corrals its myriad signals, it feeds them into formulas it calls classifiers that try to infer useful information about the type of search, in order to send the user to the most helpful pages. Classifiers can tell, for example, whether someone is searching for a product to buy, or for information about a place, a company or a person. Google recently developed a new classifier to identify names of people who aren’t famous. Another identifies brand names.

These signals and classifiers calculate several key measures of a page’s relevance, including one it calls “topicality” — a measure of how the topic of a page relates to the broad category of the user’s query. A page about President Bush’s speech about Darfur last week at the White House, for example, would rank high in topicality for “Darfur,” less so for “George Bush” and even less for “White House.” Google combines all these measures into a final relevancy score.

The sites with the 10 highest scores win the coveted spots on the first search page, unless a final check shows that there is not enough “diversity” in the results. “If you have a lot of different perspectives on one page, often that is more helpful than if the page is dominated by one perspective,” Mr. Cutts says. “If someone types a product, for example, maybe you want a blog review of it, a manufacturer’s page, a place to buy it or a comparison shopping site.”

If this wasn’t excruciating enough, Google’s engineers must compensate for users who are not only fickle, but are also vague about what they want; often, they type in ambiguous phrases or misspelled words.

Long ago, Google figured out that users who type “Brittany Speers,” for example, are really searching for “Britney Spears.” To tackle such a problem, it built a system that understands variations of words. So elegant and powerful is that model that it can look for pages when only an abbreviation or synonym is typed in.

Mr. Singhal boasts that the query “Brenda Lee bio” returns the official home page of the singer, even though the home page itself uses the term “biography” — not “bio.”

But words that seem related sometimes are not related. “We know ‘bio’ is the same as ‘biography,’ ” Mr. Singhal says. “My grandmother says: ‘Oh, come on. Isn’t that obvious?’ It’s hard to explain to her that bio means the same as biography, but ‘apples’ doesn’t mean the same as ‘Apple .’ ”

In the end, it’s hard to gauge exactly how advanced Google’s techniques are, because so much of what it and its search rivals do is veiled in secrecy. In a look at the results, the differences between the leading search engines are subtle, although Danny Sullivan, a veteran search specialist and blogger who runs Searchengineland.com, says Google continues to outpace its competitors.

Yahoo is now developing special search formulas for specific areas of knowledge, like health. Microsoft has bet on using a mathematical technique to rank pages known as neural networks that try to mimic the way human brains learn information.

Google’s use of signals and classifiers, by contrast, is more rooted in current academic literature, in part because its leaders come from academia and research labs. Still, Google has been able to refine and advance those ideas by using computer and programming resources that no university can afford.

“People still think that Google is the gold standard of search,” Mr. Battelle says. “Their secret sauce is how these guys are doing it all in aggregate. There are 1,000 little tunings they do.”

Ajax good interms of UI and Response

2007-06-07T04:46:00.000-04:00

As J2EE developers, it seems we are constantly focused on "backend mechanics." Often, we forget that the main success of J2EE has been around the Web application; people love developing applications that utilize the Web for many reasons, but mainly because the ease of deployment allows a site to have millions of users with minimal cost. Unfortunately, over the years we have invested too much time in the back end and not enough time in making our Web user interfaces natural and responsive to our users.

The key lies in the combination of browser-side JavaScript, DHTML, and asynchronous communication with the server. This article also demonstrates just how easy it is to start using this approach, by leveraging an Ajax framework (DWR) to construct an application that communicates with backend services directly from the browser. If used properly, this tremendous power allows your application to be more natural and responsive to your users, thereby providing an improved browsing experience.

Introduction

The term Ajax is used to describe a set of technologies that allow browsers to provide users with a more natural browsing experience. Before Ajax, Web sites forced their users into the submit/wait/redisplay paradigm, where the users' actions were always synchronized with the server's "think time." Ajax provides the ability to communicate with the server asynchronously, thereby freeing the user experience from the request/response cycle. With Ajax, when a user clicks a button, you can use JavaScript and DHTML to immediately update the UI, and spawn an asynchronous request to the server to perform an update or query a database. When the request returns, you can then use JavaScript and CSS to update your UI accordingly without refreshing the entire page. Most importantly, users don't even know your code is communicating with the server: the Web site feels like it's instantly responding.

While the infrastructure needed by Ajax has been available for a while, it is only recently that the true power of asynchronous requests has been leveraged. The ability to have an extremely responsive Web site is exciting as it finally allows developers and designers to create "desktop-like" usability with the standard HTML/CSS/JavaScript stack.

Traditionally in J2EE, developers have been so focused on developing the service and persistence layers that the usability of the user interface has lagged behind. It is common to hear phases such as, "we don't have time to invest in the UI" or "you can't do that with HTML" during a typical J2EE development cycle. The following Web sites prove that these excuses don't hold water any longer:

* BackPack
* Google Suggest
* Google Maps
* PalmSphere

AJAX stands for...

Ajax isn't a technology. It's really several technologies, each flourishing in its own right, coming together in powerful new ways. Ajax incorporates:

Standards-based presentation using XHTML and CSS
Dynamic display and interaction using the Document Object Model
Asynchronous server communication using XMLHttpRequest
JavaScript binding everything together

This is all fine and dandy, but why the name Ajax? Well, the term Ajax was coined by Jesse James Garrett, and as he puts it, it is "short-hand for Asynchronous JavaScript + XML."

Dinesh Karthik-A guy to be watch out @ Green Top!!

2007-05-29T10:39:00.000-04:00

We have lot of talented players, Sehwag who is hitting the ball with out moving the feet [contradicting the Coaching manual] and succeeding in that too. He scored awesome 195 against Aussies in Melbourne in first two session of day1.He demolished all spinners effortlessly.

Yuvraj is a booming talent in our side with capability of hard hitting and making quick runs.There is no need to explain Dhoni's thundering flat six hitting talent. But Karthik does not seem to have any special talent as his mates have. But what I believe is that

"Talent will bring you up, But you need character to stay on the TOP".

Karthik got this character,but need to improve his skills a bit. We can think of an analogy with Steve Waugh:
Steve Waugh was not as talented as Ponting or Kallis, but he got the mind and guts to play {and sledge} great fast bowlers of his time. Waugh was termed as "Cool cat" and he less bothered about fearing spearheads in green top and spin-wizards in turning track he keeps himself cool, calm and composed. But he does not forget to punish bad deliveries [sweep slog].

Initially I was really wondering why Karthik has been picked up for the ODI team when his name was short listed for the first time in 14 member Indian squad.[At that time I had great faith in talented guysL]To be honest I thought he will be one among in the list of Sameer Dighe,M.S.K.Prasad,Aja Ratra and Parthiv patel

I saw him playing against South Africa, Windies and in the last series against Banlgadesh.He is having a decent technique. I would say his defense is pretty good. And his shot selection is decent which enough in sub-continent pitches is. But when you play in pitches that has something for bowlers to swing or seam then it will be a different ball game. His success depends on how well he is goanna adapt that condition, where the ball will move in air and bounce above your rib normally. So this England tour will be an important stage where Karthik can prove his talent and character.

Google Encouraging young talented Guns!!

2007-05-29T08:52:00.000-04:00

We all know that Google apart from providing web search and exciting web tools they are also providing solution for enterprise like Enterprise search, Google Apps etc.Now Google starts sponsoring students and scientists who are working in search algorithm.

I have read in a Blog that google has bought a search algorithm from 26 year old Ori Allon, a computer scientist from Israel, who is currently doing his research in UNSW.University of New south Wales[Where Kiwis and Aussies are playing for a same team].The tool searches only the most relevant textual results, and offers a list of topics directly related to the original source. It is planned to be completed within the next 18 months. There were supposedly talks with Yahoo, Google and MSN, before the final decision was struck to work with Google.

Now this scientist is a part of Google Mountain View Headquarters. As usual Google is not revealing the DEAL data to media. But the good part is where ever the talent is Google acknowledges it!!

Google's Future--->Knowing users more personally !!

2007-05-23T10:06:00.000-04:00

Increasing revenue,Hike in market share,best and simple user interface,best search algorithm in the world,number of users increasing exponentially,made a new revolution in web searching,created panic to Microsoft in their core area of OS.delivered tools like G-Earth and G-Analytics for free!
Most importantly "Not Evil",After having this many attributes,can we imagine how Google will be five years from now.??
When some one asked the CEO Eric Schmidt said in Financial Times:
"gathering more personal information on users is a logical extension of their mission".
Eric was asked to give an outlook of what Google might look another five years from now, saying:

"We are very early in the total information we have within Google. The algorithms will get better and we will get better at personalization.
The goal is to enable Google users to be able to ask the question such as “What shall I do tomorrow?” and “What job shall I take?"

He continued....

"We cannot even answer the most basic questions because we don’t know enough about you. That is the most important aspect of Google’s
expansion".

I remembered the Add-line of Quatar Airlines :"Taking You More Personally"

3 Wired hardware - MY 89s52 Burner

2007-05-22T12:39:00.000-04:00

When I was in my college I was crazy for Embedded Electronics.Almost I use to spend all my week ends in making circuits and interfacing into PC.I love interfacing systems to my PC through serial and parallel port.
I still believe that the tool Visual basic 6.0 from MS was really helpful for me to get my interface done in a single night.My first successful interfacing was with a microcontroller,i believe it was in my 4th Sem.I was able to control l a stepper motor step angle dynamically from PC.Then I should talk about my burner for 89s52,it was having simple three wire interface with PC. Even it look simple the program has been complex to convert HEX to binary then doing serial transmission through DB25. Simple look at program:

uC89S52.cls: This class file consists of all the sub functions of the programmers like

· Switch on_off the microcontroller.

· Applying the high_low pulse

· Reading data through MISO

· Writing data through MOSI

Applying SCK pulse

Hexreader.cls:this file performs the following functions

Fetch the hex file data in INTEL Hex format
Decode thr file to get the hex data equivalent for the ALP program.
Chck the hex code by using the check sum for each line
Send the hex data to the frmmain to display in a spreadsheet

Feddy Set for a clean sweep of four for this Year !!

2007-05-22T10:15:00.000-04:00

The match between "cool cat of grass" and the talented young lad at Hamburg was really a good one to watch (especially for a fan of Feddy like me).
Even the swiss started slowly with one unforced error the way he progressed in the second set and the way he crushed the Nadal in third set has been phenomenal.
It is not easy for anyone to beat a guy who is winning successively for the past 2 years in clay.The highlight of the match is the way Federer improve his perfection in all aspects of the game as match progress.I would say he improved exponentially in the last set to get 6-0.You cannot imagine beating a player 6-0 (in a set) who won consecutively his last 81 matches.I remember the semis of Austrlian open 2007 when Federer crushed Andy for 6-0 in last set of a straght set win.(when Andy was belived to be at his best!!).This show that a platform is ready for Feddy to become the"All time great" surpassing the Sampras by winning a grand-slam in Clay.
People still believe that Nadal is a hot favorite for this French open.Because Nadal want to show his rivalry to Federer for ending his winning streak of 81.But guys ,now Federer got the confident of beating this young talented spaniard!!

Verasaa!! I want this to be Google's sister concern !!

2007-05-20T03:27:00.000-04:00

Guys who are from deep southern part of tamilnadu knows this word "verasaa",which is a word of urgency used to express any speedy action.'Speed' a critical word in this world ,connected through network.It is also critical in the world of searching

As of now Google is the master in this area of searching even we call it as "Unevil search and products".Let me come to the point !
We are a pack of engineers from Southern India now working in Mumbai for one of India's biggest service company.Even we got in to this job with great enthusiasm and expectation but this job doesn't fulfill even 50% of our expectation.We are not complaining about our salary but after completing four hard years of engineering we have been asked to work in a project which is considering us as a resource, only for" billing" the customer.I wont blame my company because mangers from Indian IT industries are focussed on getting revenue not in getting or delivering quality projects.After spending few months in this "service industry" our interest turned towards "searching algorithm".So it is quite obvious that our attention turned towards the Giant Google.So what we are planning is to innovate a search algorithm called verasaa...and make this as a sister concern for Google.We are fans of google because of its Algorithm's diginity and their un-evilness in delivering products for free of cost.So you guys can expect Verasaa !! soon.

Smart Transducer Interface (STI)----It was My dream :(

2007-05-18T09:27:00.000-04:00

For automating a system, we need different types of sensors and actuators. Also we need to write separate program for acquiring data from the real world through sensor and for actuators to provide data to the real world. It will be tedious to write separate programs for each resource i.e. sensors and actuators. Our project provides solution for this by constructing a microcontroller based system consists of programmable resources known as Smart Transducer Interface (STI). Programmability of resources can be made flexible and easier using a control word for each resource. Thus automation is made flexible by reading the status word of each sensor and writing the control word of each actuator. The STI comprises of the stepper motor controller, linear sensor module, a simple communication module, frequency measurement module and digital to analog converter. This can be realized through microcontroller, ADC, DAC, centronics connecter, optocoupler and buffer.

Getting exactly what you anticipate from Goolge search !!

2007-05-18T07:37:00.000-04:00

Most of us are not aware of secrets of google starting from its algorithm for searching and page ranking to effective web searching.For a normal person it may seems to be a odd business to learn G algorithm even it is an intellectual work of a computer engineer.But if we got aleast the basic of searching techniques in Goolge,then the time we take to reach the data we anticipate out of the 20 Billion pages will be bit reduced.
These are basic catalyst in the reaction of google search to get the product (data) quicker than expected.It can be used for critical information digging.
Here we go !!
[ intitle: ]
The “intitle:” syntax helps Google restrict the search results to pages containing that word in the title. For
example, “intitle: karthikeyanmect google” (without quotes) will return links to those pages that has the word
"karthikeyanmect" in their title, and the word "google" anywhere in the page.
Similarly, if one has to query for more than one word in the page title then in that case “allintitle:” can be
used instead of “intitle” to get the list of pages containing all those words in its title. For example using
“intitle: karthikeyanmect intitle: google” is same as querying “allintitle: karthikeyanmect google”.

[ inurl: ]
The “inurl:” syntax restricts the search results to those URLs containing the search keyword. For
example: “inurl: smart transducer” (without quotes) will return only links to those pages that have "smart transducer"in the
URL.
Similarly, if one has to query for more than one word in an URL then in that case “allinurl:” can be used
instead of “inurl” to get the list of URLs containing all those search keywords in it. For example: “allinurl:
etc/passwd“ will look for the URLs containing “etc” and “passwd”. The slash (“/”) between the words will
be ignored by Google.

[ site: ]
The “site:” syntax restricts Google to query for certain keywords in a particular site or domain. For
example: “My101 site:karthikeyanmect.googlepages.com” (without quotes) will look for the keyword “My101” in those
pages present in all the links of the domain “karthikeyanmect.googlepages.com”. There should not be any space between
“site:” and the “domain name”.

[ filetype: ]
This “filetype:” syntax restricts Google search for files on internet with particular extensions (i.e. doc, pdf
or ppt etc). For example: “filetype:doc site:gov confidential” (without quotes) will look for files with “.doc”
extension in all government domains with “.gov” extension and containing the word “confidential” either in
the pages or in the “.doc” file. i.e. the result will contain the links to all confidential word document files on
the government sites.

[ link: ]
“link:” syntax will list down webpages that have links to the specified webpage. For Example:
“link:www.karthikeyanmect.googlepages.com” will list webpages that have links pointing to the my home page.
Note there can be no space between the "link:" and the web page url.

[ related: ]
The “related:” will list web pages that are "similar" to a specified web page. For Example:
“related:www.google.com” will list web pages that are similar to the google homepage(like yahoo vivisimo etc). Note
there can be no space between the "related:" and the web page url.

[ intext: ]
The “intext:” syntax searches for words in a particular website. It ignores links or URLs and page titles.
For example: “intext:example, “intitle: karthikeyanmect google” (without quotes)” (without quotes) will return only links to those web pages that has the
search keyword you mentioned .[You will get the same page]

[ phonebook: ]
“phonebook” searches for U.S. street address and phone number information. For Example:
“phonebook:Lisa+CA” will list down all names of person having “Lisa” in their names and located in
“California (CA)”. This can be used as a great tool for hackers incase someone want to do dig personal
information for social engineering.

I would rekon all guys to use google and its products to improve you and your business!!

Google Experimental-Today's exitement from Google !

2007-05-17T06:22:00.000-04:00

Google the search engine giant as usual playing with their search algorithm for providing more sophistication for their users.
Google Experimental search is one of the brain child of Google from their Labs released today.
When users search for a word.It will categories the search in to different types like........
Timeline and map views-- where you can see the results on timeline or map.With the timeline and map views, Google’s technology extracts key dates and locations from select search results so you can view the information in a different dimension. With the timeline and map views, Google’s technology extracts key dates and locations from select search results so you can view the information in a different dimension.

Type the following in Google

nanotechnology view:timeline

Keyboard shortcuts--This is for navigating easily through search result quicly and easily minimizing use of your mouse.I would say this is really a good enchancement in the searching tool.
Check out this link for actual shortcuts--http://www.google.com/experimental/
Left-hand search navigation---Search deeper in a particular type of content—patents, products or news, for example. Google searches across all kinds of content, then ranks results by relevance
Right-hand contextual search navigation---Similar to the left-hand search navigation, right-hand contextual search navigation allows you to search deeper in a particular type of content or to search related terms—but from the right side of the page.

Google Earth 4.1 released

2007-05-15T10:15:00.001-04:00

Google just recently released Google Earth 4.1.
The new was launched with support for several additional languages like Portuguese, Dutch, Russian, Polish, Korean, Arabic, and Czech. This list expands on the previous one which included English, Arabic,French, German, Italian, Japanese and Spanish.In this version, Google has apparently also added Windows Vista support — though I thought they did this in an earlier 4.0.x release too?

In addition to the new language and operating system changes, there are several other things they added to the product as well. One of the only real new "features" though is the "open in maps" button. Clicking it launches an embedded browser control pointed to the Google map of
your current view.Here is the complete list of what's new from the user guide:

* Support for many new language versions
* Default view shows your location
* Ability to deactivate Plus and Pro versions
* Support for Microsoft Vista
* Display current view in Google Maps
* Improved rendering performance
* Start up tips
* MSI installer for enterprises

SEO nothing but hacking G-Algorithim

2007-05-12T07:11:00.001-04:00

If you want Your website to be on the first page of every Search Engine - SEO Techniques will help You get there! The Techniques on this page will enpower You with the information that will move You towards that goal. Set Your aim high, the sky is the limit! Others have done it, so why can't You -- Search Engine Optimization ( SEO ) is really quite simple!If You have been putting off optimizing Your website for a higher Search Engine results position, today is a good day to make Your start. SEO Techniques will make it much easier that You expected!
The following list of SEO Techniques will help you optimize your website so you will get a higher Search Engine Results Position (SERP). Some of the items can be done quickly -- others will take a bit of time.
If you complete all the items on the following list of SEO Techniques, give the Search Engines some time to send out their bots to deep crawl your website, your site traffic will increase. Make sure you are ready for it!

Google the future of Web !!

2007-05-12T05:36:00.001-04:00

Google Search Market Share Continues To Rise (Hitwise April 2007)

Hitwise’s latest numbers are out for April 2007, and Google has had another up month. Take a look:

Google’s now at 65.26%, more than tripling Yahoo’s 20.73%, almost eight times Microsoft(MSN/Live)’s 8.46%, and almost eighteen times Ask’s 3.69%. Ask is the only engine holding its share (albeit small) for the last year, Microsoft keeps falling, and Yahoo almost seemed like it was rising, but, eh, no.That chart is based on Hitwise data for only certain months between 3/06 and 4/07. If you have full data, or just a good number of months, I’d appreciate it.

2007-04-27T06:15:00.000-04:00

Australian Cricket
Cricket is a game which gives excitement when you watch.It might sound odd for a debutant.
But guys who follows cricket for long time would have felt this when Rahul playing a cover-drive or Wasim is swinging the ball both the ways.
Even though we guys have immense passion for cricket, we have messed our passion with sentiment.But people from Australia looks cricket as something more than their life.
You can feel this when you see Australian supporters in the gallery.I personally think that sledging has become habit of Australians in the same manner as they have the habit of winning.