World's first personal supercomputer launched

A desktop supercomputer talk of past is a reality now. nVidia US based company has successfully developed and is getting ready to launch Tesla. It has been priced between 4000-8000 pounds/ $10,000.

The Tesla built on compute unified device architecture (CUDA) would not replace the CPU (central processing unit) of a personal computer, but it would complement the work of the CPU with the help of GPU numerous times.

It is said to be 25 times faster than normal PCs.The scientists claim that Tesla will completely revolutionize the way researchers and medical professionals carry out their work. For example, doctors would be able to examine the result of brain and body scans in much more less time and inform patients within hours whether they are suffering from a tumour.

Microsoft tech, Bruton says, Heterogeneous computing, where GPUs work in tandem with CPUs, is what makes such a breakthrough possible. It is said that Tesla has also reached record setting performance.
Computer makers such as Dell, Lenovo, and Hewlett-Packard came forward to power their desktops and laptops by Tesla.

On the long run for a fast paced world, this is no doubt going to be the NExtGen computer to invade every home.

consciousness !!!

Our consciousness in not what we think !!!

Life on Earth

Its all about Life on Earth

Relax your mind

Relax !!!

Face of the Legend

Want to know how the Leonardo looked like ??

Mozilla Firefox

There are various browsers available in the market of software. The intelligence lies in which browser is to be used under what circumstances.

One of the browsers adorable is Mozilla Firefox.Though Mozilla installs small, efficient products, it is build on a very large open source that supports a complex and flexible structure underneath as a SQL db server with Linux kernel or J2EE. Use of XUL instead of simply HTML-applications also called LAMP X, allows Mozilla to overcome all UI mess in terms of navigation, layout and performance.The Mozilla platform and applications can be sliced a number of ways so that the balance between client and server is determined by people, not dictated by the technology.

1. Can add multiple home pages on launch of browser.i.ie by inserting "|" in the default bookmark without quotation.
2. debug scripts using programming
3. Few key commands to work faster
    -- Ctrl- and Ctrl+ can be used to zoom in and out
            -- Ctrl+t new tab
            -- Ctrl+k to move cursor to the search box
            -- Ctrl+w close window
            -- Ctrl+F3 search
            -- find text as u type using /
            -- back and forward alt+<-- alt+-->
            -- Ctrl+ and Ctrl- change font size
            -- Ctrl+l to move to the location bar
            -- switch between tabs ctrl+tab
      and lots more of them...
4. can add-ons to get working more colorful and fast.
5. Add ons supporting different themes and templates, mail notifications, cross platform ftp support and many more.(something similar to winscp)
6. customise browser using monkeygrease and greasemonkey.
7. seesion restore oncrash

There must be many more stuff available.On the whole its cool to work on such applications knowing their potential rather blindly using them.

Walks of Life !!!

A human being comes to this world, lives and finally leaves the world. When I say this word I remember the words of shakespeare "Men may come and Men may go but the stage remains the same." When we look the life cycle of a human being, he takes different roles at different stages of life. to begin with he is a sweet child with no tooth,everybody likes to play with him,they take utmost care of him. When he grows up he gets on to school where he mingles with a lot of people of his age and starts learning new things and when he moves into the adolescent age, he feels something unsual within himself, falls in love with almost all gals he sees, tries to do all wrong things in his life. feels old people are there in this world only to give advice, thinks he is the boss and knows how to live his life. He gets into the college and feels like in heaven. he knows no fear and no boundaries, enjoys life to the core.


Out of college things change, he gets to know the situation of his life and get to know what life is and what people are, how people behave and what status they give for a person and how and when. He gets into the phase of realizing his dreams, works hard and gets a life which suits his lifestyle and tries to make up his own family.

Once he has somebody with him he again starts running to make his and his dependant life better. He tries to enjoy life but could not. He becomes a father which he would always be proud of, tries to give the best to his children, wants his children to get everything which he didnt get.

Things fly by he becomes old and becomes a grandfather and tries to rewind his life with his old memories only to find that he has not lived the way he wanted.

Roles that a person plays in different walks of life are
1. baby
2. Kid
3. School boy
4. Teenager
5.College Student
6. Professional
7.Lover
8.Husband
9.Boss
10. Father
11. A responsible person in the society
12. Grandfather
13. A human being who leaves this world without knowing the truth of life

Well this is the normal life cycle of a human being, but how many of us think beyond this, how many of us think that there is a reason for our existence. how many of us think that there is reason behind every action in our life. how many of us think about the lessons that has been taught to us in the walk of life. How many of us tend to follow the rules of the game.

Life is something which is not to be lived anyway we wanted, it is to be lived the way it is supposed to be.

I dont want to confuse more than this. Just think about it. !!!!

Products of Google

we are listing some of the products of Google here

google official site         www.google.com/
gmail                            www.gmail.com
orkut                            www.orkut.com
Google Reader             http://reader.google.com
Webmasters                 www.Google.com/webmasters
Blogs                            www.blogger.com
News                           http://news.google.com
Google Product Search http://www.google.com/prdhp?hl=en&tab=wf
Google code                 http://code.google.com
Google Maps                http://maps.Google.com
Google video                 http://video.google.com
Youtube                        www.youtube.com
Google Groups              http://groups.google.com
Google books                http://books.google.com
Google scholar               http://scholar.google.com
Google finance               http://finance.google.com
Google calendar             http://calendar.google.com
Google photos                http://picasaweb.google.com
Google Docs                  http://docs.google.com
Google sites                    http://sites.google.com
Google alerts                   http://www.google.com/alerts?hl=en
Google Earth                   http://earth.google.com
Google blog search          http://www.google.com/blogsearch?hl=en
Google labs                     http://labs.google.com/
Knol                                http://knol.google.com/k#
Google translate               http://translate.google.com/translate_t?hl=en#
Google sketchup              http://sketchup.google.com/
Google talk                      http://www.google.com/talk/
Google health                   http://www.google.com/health
IGoogle                            http://www.google.com/ig?source=mpues&hl=en
Google checkout               http://checkout.google.com
Google adsense                 http://www.google.com/adsense
Google Chrome                 http://www.google.com/chrome
Google desktop                 http://desktop.google.com
GOOG -411                     http://www.google.com/goog411
Google adwords                http://adwords.google.com
Movie search                     http://www.google.com/movies
Google analytics                 http://www.google.com/analytics
Google website optimizer    http://google.com/websiteoptimizer
Google base                       http://www.google.com/base

we hope there are more hidden links in google which are worth trying

Happy Googling !!!!

Life as such

Life this four letter word is the prime factor of existence of any living being that is known to exists in this world, In simple terms life just means breathing, pumping in Oxygen and pumping out CO2, well one of the definition of life is the experience of being alive.

Whole of the human race is driven by money,fame,satisfaction,spirituality,greediness,hatred,love,affection,cruelty and lot more and any one of these characteristics is adpoted by an individual inorder for him to lead a better life. Lot of people are of the illusion that they are having a great life, a better life without knowing the fact that they dont know what life is but they think that they have a better life.

Each and every living being wants to have a happy and peaceful life, but how does one know what life is or how does one say that they are having a happy and peaceful life, If suppose a person is happy if people appreciate him, does it mean that he wil lead a happy life if people keep on appreaciating him. In this case does it mean that life is nothing but sheer satisfaction of the heart or is it the mind which makes a man lead a peaceful life, If a man does not have any tension does it mean that he is having a peaceful life.

No matter whether your happy,sad,in peace. Life remains static and is a straight line, its only the emotions that travels over this line of life that decides the mood or state of an individual. If you come out of your emotions and feelings and look at life, life is nothing but a straight line.

Kill and Zero

kill is a command used to send simple messages to processes running on the system. By default, the message sent is the "termination" signal, which requests that the process exit. But kill is something of a misnomer; the signal sent may have nothing to do with process killing. The kill command is a wrapper around the kill()system call, which sends signals to processes or process groups on the system

We all know about kill command and how much we use it especially kill -9 the forceful exit of a process.

The kill command associates itself with options ranging from (0-9). But the most fascinating one is 0 the number close to India. Remember (Aryabhata is the first of the great astronomers of the classical age of India who invented "0").

The interesting part is kill -0 actually does not kill a process. The kill -0 option can be used to 

figure out whether a particular process id exists. It never sends a signal. 

This option can be used in logics where programmer wants to know how long a process exists and if any action is to be taken based on its usage.

Assuming the command is called after certain duration of sleep, the command gets executed and remains silent until it gets to know the process is terminated. And would return an output like "-bash: kill: (8141) - No such process".

Wonders of zero are unlimited !!!

Features of Google Chrome

Its been close to a week since Google announced its first browser called Chrome. One of the prime goals of the development team of Google chrome was to minimize or remove the chrome from the browser and this is what the development team as actually done.

The browser is simple and loads pretty quickly, the setup file (which I got after a long wait) is of 475 KB and it installs just like Ubuntu a quicky OS which I have loved always. The browser design is simple viz a viz Google, it looks transparent to the desktop and its thin background makes it look light. It has no menu bar like the traditional browsers.

Some of the key features of Chrome

1. There is no homepage as such in Chrome. However the homepage is where 8 recently visited sites are shown as site snippets .
2. It has integrated google search in the address bar, so you start typing "Y" in the address bar and it start suggesting you the websites
3. It also has the google calculator integrated in the address bar, so want to make any calculations,type it in the address bar.
4. In chrome every tab acts as a process and all the plugins act as process and there is a inbuilt exclusive task manager where you can have a look at the different process(tabs viz a viz website) and the memory they are occupying at any given time
5. Chrome as the same feature like the IGoogle where you can move the gadgets around the IGoogle, similarly just move a tab out of the browser and it opens as a new window and when u pull this window back into the main window it becomes a tab again.

6. In chrome the default search in the address bar is Google search, you can also choose, Live, Yahoo search , AOL , Ask by right clicking on the address bar and choosing the edit search engine
7. Its open source, so the code is given to you for you to tweak

8. Downloading option is good, it directly starts the downloading and the file stays at the bottom of the browser and once the download is complete you can drag and drop it in any place you want.
9. You want security, its google so it has it , its called inconginitive window ( more like the inPrivate in IE 8) where you browse anything , it leaves no trace of browsing.
10. For developers or beginners, it has a inbuilt html text viewer, so no more boring notepad to view the source of the html page, infact the text viewer highlights the syntax and it is more user friendly, parses each and every aspect of the webpage and categorises the same.

Built on V8 and webkit this browser is one of the trend setter for the modern web based applications, Two years of hard work from the Google engineers is ought to pay back.

Have a nice time with the new baby of Google !!!!!!!!!!!!

Google bangs again with Google Chrome with a cartoon

It was just the news of IE8 and Mozilla enhancing itself, the all time challenger Google swings back with a suprise launch of its new browser Chrome adding onto its growing application list.

Its an open source browser,which supports Javascript VM called V8 (That can be used by other browsers too to enhance the speed of web browsing) with a Webkit engine (supported in Safari), multi process design, special tab support,address bar with auto complete mode,default home page with speed dial feature as a default page(which will summarize recent searches,webpages visited and so on). The "InPrivate" feature of Microsoft is provided as "incognito" here.(enable /disable privacy) and finally constant download of lists of harmful sites...

The search giant said Chrome had been created to better handle interactive applications and resource-hungry web pages such as video clips and online games. It is also less likely to crash,

Indeed Google proves itself again and again...The browser seems to become the master of all browsers very much close to the user. The Chrome comic is not a joke.

Google simply makes others go "Googly Goooooooooo"

IE 8.0 Beta2 is on !!!

Microsoft announced the release of Internet Explorer 8 Beta2. Its more of a combination of features of Safari and Firefox, Some of the features which the beta version has is the Inpage search which is more like the safari inpage search. The new explorer has a DOM inspector, a JavaScript profiler, a color picker and ruler, options to outline objects, disable CSS and validate web pages. The New IE is developed on the new standards of the world wide web.

The new IE concentrates on AJAX enhancements,CSS and Support for data URI and one more feature that is added in IE 8 is that we dont need to view the source of the same old notepad software where the syntax are not highlighted, however the new browser has a inliner editor which displays the HTML source code with all the highlights of syntax.

Interms of security where Micorosoft always has a concern the browsing history,cookies,form data,usernam,password can be made not to be stored in the browser, It also blocks adult sites this feature is called Inprivate Browsing This can be set by navigating to Safety -> InPrivate browsing.

Finally Google maps and Gmail works fine in IE,

I'm sure lot of people will start using IE more often now, more of open source features is really drawing people to use IE, All the best to the microsoft team and hope to see IE 8 to be another successful product from Microsoft.

Monkeygrease says now Java's cool too

We have all heard of Greasemonkey but what s Monkeygrease now...(something still evolving not enrolled in wiki).Well Monkeygrease is a proxy-based server-side solution. That means a servlet filter that will allow a web developer to inject JavaScript, CSSor other elements within a web page. It will enable you to move your web application to the Web 2.0 world.

Monkeygrease helps in:

• Changing the look and feel of a web application
• Adding DHTML/AJAX features/effects on your site
• Adding WYSIWYG editing to any textarea field on your site
• Enhance pages by contextually adding content from external providers
• Fix usability issues on any page
  

A typical request from the browser is handled by a web application on a server. Once a request is received by a server, an appropriate response is sent back to the browser. This is how all websites work. Monkeygrease is akin to a proxy. When a web application is enhanced with Monkeygrease, the request is passed through Monkeygrease and if the URL of that request matches a Monkeygrease rule, Monkeygrease applies the rule by modifying the response back to the browser. In the end, you get a page that’s been “enhanced” by Monkeygrease.

How do we get this working...

1. You must have Apache Tomcat 5.x. A web application whose WEB-INF directory is accessible.
2. You can download monkeygrease from here (This will include the jars, monkeygrease.xml file containing rules)
3. Installation

• 1.Extract the monkeygrease_xxx.zip file you downloaded
• 2.Upload the monkeygrease.jar file to your web application’s WEB-INF/lib directory. Depending on your application server, you might be able to do this through an administration console, however, if you have access to the web application’s directory, it’s probably easier to do it manually.
• 3.Upload the monkeygrease.xml file to your web application’s WEB-INF directory.
• 4.Modify your web application’s web.xml file and add the following lines that define rules. Click here to take the snippet of code. mentioned under point 4 in the linked page.

4. Restart your app server in order to enable the filter.
5. Output of a simple html file before and after can be seen as illustrated in view-example

Hope this start will take Monkeygrease much further...

Google Last Login Activity + Google Suggest

One of the features that is been available in Gmail for sometime now which is unnoticed by a lot of gmail users is the gmail last login activity. The gmail last login activity appears in the bottom of the gmail

The above detail shows all the locations where your gmail id is active and the ipaddress of those locations also on clicking the details link you get the following page which summarizes the same.

Now you can signout the various other sessions that are open by clicking on the signout all other sessions.

It is also useful to know if somebody else is accessing your gmail id by validating the location of the ipaddress from where you mail is being accessed.

Be secured by using the feature and make sure you logoff whenever you move out.. Play safe, the bad guy is at the back of you !!!
Google officially announced that Google suggest, a product which has been in the labs for a long time will be available by default in the Google search engine from now on. For those of you who are not aware of the Google suggest here is what Google looks like with Google suggest.



So from now on you can get the best of search experience from Google. Great move Google guys, Kudos to you !!!!

Oracle Tip

There are lot of interesting stuffs that can be done using the data dictionary tables in oracle. There are lot of data dictionary available in oracle. Some of them are

user_tables,
user_tab_cols
user_views

The different data dictionaries that are available in oracle can be viewed by querying ALL_VIEWS

select * from all_views ;

Now one of the data dictionary or one of the most powerful and useful one in oracle is dba_users. This data dictionary gives you the details about the database users that are available for a particular database. Now if suppose you want to access the database using a specific userid and you dont have the password of the user,however have the privilige to do things in the database then you can try to use the following stuff

SQL > select username,password from dba_users where username = 'SCOTT'

USERNAME PASSWORD
---------------------------
SCOTT F894844C34402B677


now alter the user to specify your custom password

SQL > Alter user scott identified by mypassword

Then login to the user scott using the password specified by you now and start working.
Once you have done with the work restore the old password by using the undocumented thing called by value

SQL> Alter user scott identified by values ' F894844C34402B677'

So that the password is restored to its originial value.

Hope the tip is helpful in certain aspects for the database administrators or it might be a way to provide an insight to the ways security breaches can be made if priviliges are available for database users.
SQL> select username,password from dba_users where username='SCOTT';

USERNAME PASSWORD
-------- ----------------
SCOTT F894844C34402B677

Greasemonkey !!!

FireFox - Greasemonkey

Greasmonkey is a firefox extension that allows you to write scripts that alter the webpages you visit

Some of the things which we can make using Greasemonkey is :

1. Make websites more readable.
2. Fix rendering bugs which the owner is not aware of.
3. Alter pages to make them work with other technologies like the speech based.
4. Retrieve data from multiple site and make them interconnected.

How to use Greasemonkey ??

To Use Greasemonkey, You need to install the Greasemonkey add-on unto yout Firefox browser and then we have to install the user script by choosing from the Tools > Install user script. The Greasemonkey is just an add-on and doesnt make any difference until the user scripts are installed. A repository of user scripts available. A user script usually ends with .user.js.

Let see how to use a sample greasemonkey script. As usuall its the Hello World script.
Example

The user script is named as helloworld.user.js

// Hello World! example user script
// version 0.1 BETA!
// 2005−04−22
// Copyright (c) 2005, Mark Pilgrim
// Released under the GPL license
// http://www.gnu.org/copyleft/gpl.html
//
// −−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−
//
// This is a Greasemonkey user script.
//
// To install, you need Greasemonkey: http://greasemonkey.mozdev.org/
// Then restart Firefox and revisit this script.
// Under Tools, there will be a new menu item to "Install User Script".
// Accept the default configuration and install.
//
// To uninstall, go to Tools/Manage User Scripts,
// select "Hello World", and click Uninstall.
//
// −−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−−
//
// ==UserScript==
// @name Hello World
// @namespace http://diveintogreasemonkey.org/download/
// @description example script to alert "Hello world!" on every page
// @include *
// @exclude http://diveintogreasemonkey.org/*
// @exclude http://www.diveintogreasemonkey.org/*
// ==/UserScript==
alert('Hello world!');


As you read the script you might know what the script means, no install this script by using the install user script option and choosing helloworld.user.js

Once installed, whenever you move to a new page an alert will be made saying Hello World.


Greasemonkey can change the way you browse once installed and used. Hope you have got a insight on what greasemonkey is all about.

Happy browsing and cheers to Greasemonkey !!!

Gmail Temporary Error (502)

It seems that Gmail account was down for a part of users and they get the following error when trying to login.

"We're sorry, but your Gmail account is currently experiencing errors. You won't be able to use your account while these errors last, but don't worry, your account data and messages are safe. Our engineers are working to resolve this issue. Please try accessing your account again in a few minutes."



Last time such incident with respect to down of Google services were reported in the year 2004, Is the clustering effect having some bad time at Google. Google engineers seem to be working on the problem and reports say that they have narrowed down to the problem which is actually causing this 502 error. Google has confirmed that it will soon resume the services to the users as it has come up with a fix and will kill out the error in sometime.

The Service was down for more than an hour for the users.

Have you come across any errors like these when accessing any of the Google services ???. post in your comments

What's Happyness ???

Well how many of us have asked this question to ourselves and what is the answer have we got for this. Let me quote one by one

1. Is getting a 1st rank in school fetches happyness to a kid - well then is all 1st rank holders happy (answer is only when they got it and not always)
2. Is getting a riding a bicycle brings happyness to a kid (well when you ask all the kids who ride bicycle they are not happy always)
3. Is everyone who has a beautiful gal friend/boy friend happy(I dont think so :))
4. Is everyone whose child is working in abroad and well settled happy always (I've seen them only feel they could be with their children.

There are lot more examples that can be quoted and we have to agree to the point that there is no human in this world who can be happy always and never be sad, but the question I wanted to raise is , Is happiness associated with some object or thing or is it a feeling.

Is happiness momentary, Does the kid gets happy the moment he gets first rank or gets a bicycle and then his happyness vanishes or is smiling alone represent the sheer meaning of happyness

Therasus defines happyness as "state of well-being characterized by emotions ranging from contentment to intense joy"

But one way or the other I feel that inner happyness is what is permanent, inner happyness is achieved when there is a equilibrium between the external and the internal factors of the human body where mind plays a vital role, when you have a perfect balance between your inner self and the external ,your ought to enjoy happyness to the core, when you reach a state of mind where you are ready to receive both success and failure in the same frequency you are in a state of immortal happyness, this doesnt mean that we should not be aggressive in achieving our goals , but our perception of success and failure should not determine our happyness because success and failure are mutually exclusive,but happyness is not. Everybody says that we should learn from our mistakes when we fail, but we forget that we should also learn from the positive things of our success and use the same to move forward in achieving our goals. Again when you train your mind to get the balance between success and failure you will see the real happyness in your life that is unexplainable.

Be happy as always !!!!

Work, Service, Success

We all work. Some work to get fame, money, enjoy, some to spend time and some to have the highest social status. Has anyone ever thought why should we work or for what are we working. What is the correct way to work.
Since there has been no serious thought on why we work, there are many negative consequences of these. Good food only to see not eat, blessed with a good family to spend no time with.

In early times people used to work, because they wanted to help their people, make a persons life easier. Nowadays, a person will work 24 hrs round the clock to reach the highest position in a short duration which inturn drives others wantedly or unwantedly to rush at the same speed to keep his job secure.

The creativity in people is getting lost day by day. People are becoming machines day by day. No one has time to admire nature, have laughter with thier folks.
Does nature - the greatest teacher of all teach us this. SO called the most intelligent species (humans) are we probably need to turn back to the past to learn. And that we wont, only when nature will strike all of us with destruction we will be forced to learn our basics of living.

Einstein - the greatest scientist of all times had a passion for music, loved children.
Leonardo one of the greatest inventor admired to think ahead of future would represent his thoughts aroused within him as paintings.
Marie Curie - Whom i really admire to the core started her career with the love for Science and to achieve the highest degree at those times, slowly learnt and served her people without any copyright on her invention (radioactive radium whose use all of us know) whose hardwork holds no bound of explanation even at the cost of her comfort living and finally her own life.

Why did these people work so hard on their own interest , its the passion of making their lives worth living.

Nowadays people work for success not for service. We must attain success to serve. Success should be a means for service.
There is a domain of "being" and of "wanting". People are lost in the domain of wanting which imprisons us. In the mechanical life events are controlling us rather than the magnetic life to guide us.

Our success lives in earning inturn used effectively to serve.

Have a happy and successful living !!!

Reading a person by his outfit

In this materialistic world where money dons and people are running like the horses to grab money and fame, how many of us have taken time to read a persons mind. Well If I post this question to the person reading this blog, the answer would be "I Read every person mind" . I feel that is a typical business men accent, the people in business try to guess the pulse and mentality of the person they are appraoching so that they frame a strategy to make that person a prey or rather a client. Well the reading of the mind in business perspective has to be more accurate, you got to look into the nuances of each and every move the person makes, one simple example is if the person who is listening to you is hand folded, it means he will be reluctant to what you say or rather he will be defensive. another example that I would like to quote is if a person sits on the edge of the seat he is very keen and observant to what you are talking (meaning he is a potential customer go grab him). There are humpty number of examples like these that exists, As per psychology there are signals which the brain keeps on sending out to the external world which would convey even those things that a person his hiding(meaning he might talk something but his brain signals might be different which is what is the true intention of the person).

Now the question is how to read these signals. Practice makes a man perfect(though I dont believe it). You got to constantly look out for the brain signals and also understand the behaviour of the person. so that you get to know the true color of humans.

Nobody can be read just by looking at their outfit, A man dressed in a shabby way can be the best intellectual ever known, so never try to read a person by his looks, looks are just for creating respect and nothing else, the truth lies inside the person which his brains sends as signals.

Brain is the most important part of the human body, It can do wonders in a person life, it knows no boundaries and is one of the complex part of the human body which can never be explained in simple terms. It sends millions and millions of signals which when interpreted properly can really make understand a persons intentions and his behaviour.

Keep reading the mind. but never by his outfit rather by the signals from his brain.!!!

Two cool functions of SQL

There are two really cool functions in Oracle SQL that are really very helpful when we are trying to do manipulations with date. The two functions are LEAD and LAG. These are called analytical functions in oracle.

The LEAD and LAG functions are used to give access to multiple rows in a table without the need of a self join. By using the LEAD and LAG functions one can fetch the current and previous row or current and next row values in a single row. Lets go by an example

Assuming we have data in the following format

SELECT empno,
     ename,
     job,
     sal
FROM   Job
ORDER BY sal;

   EMPNO ENAME      JOB              SAL
---------- ---------- --------- ----------
    7369 SMITH      CLERK            800
    7900 JAMES      CLERK            950
    7876 ADAMS      CLERK           1100
    7521 WARD       SALESMAN        1250
    7654 MARTIN     SALESMAN        1250
    7934 MILLER     CLERK           1300
    7844 TURNER     SALESMAN        1500
    7499 ALLEN      SALESMAN        1600
    7782 CLARK      MANAGER         2450
    7698 BLAKE      MANAGER         2850
    7566 JONES      MANAGER         2975
    7788 SCOTT      ANALYST         3000
    7902 FORD       ANALYST         3000
    7839 KING       PRESIDENT       5000

Now using the LAG function we can get the current employees salary as well as the previous employees salary. This is done by using the following query

The general syntax of LAG function is

LAG  (value_expression [,offset] [,default]) OVER ([query_partition_clase] order_by_clause)

SELECT empno,
      ename,
      job,
      sal,
      LAG(sal, 1, 0) OVER (ORDER BY sal) AS sal_prev,
FROM   job;

    EMPNO ENAME      JOB              SAL   SAL_PREV  
---------- ---------- --------- ---------- ----------
     7369 SMITH      CLERK            800          0       
     7900 JAMES      CLERK            950        800       
     7876 ADAMS      CLERK           1100        950       
     7521 WARD       SALESMAN        1250       1100       
     7654 MARTIN     SALESMAN        1250       1250         
     7934 MILLER     CLERK           1300       1250        
     7844 TURNER     SALESMAN        1500       1300       
     7499 ALLEN      SALESMAN        1600       1500       
     7782 CLARK      MANAGER         2450       1600       
     7698 BLAKE      MANAGER         2850       2450       
     7566 JONES      MANAGER         2975       2850       
     7788 SCOTT      ANALYST         3000       2975        
     7902 FORD       ANALYST         3000       3000         
     7839 KING       PRESIDENT       5000       3000       

The Sal_prev field will hold the salary of the previous row employee.

Now lets see how LEAD function will work for the same given data. The general syntax of the LEAD function is

LEAD  (value_expression [,offset] [,default]) OVER ([query_partition_clase] order_by_clause)

SELECT empno,

       ename,
      job,
      sal,
      LEAD(sal, 1, 0) OVER (ORDER BY sal) AS sal_next,
FROM   job;

    EMPNO ENAME      JOB              SAL   SAL_NEXT
---------- ---------- --------- ---------- ----------
     7369 SMITH      CLERK            800        950       
     7900 JAMES      CLERK            950       1100       
     7876 ADAMS      CLERK           1100       1250       
     7521 WARD       SALESMAN        1250       1250         
     7654 MARTIN     SALESMAN        1250       1300        
     7934 MILLER     CLERK           1300       1500       
     7844 TURNER     SALESMAN        1500       1600       
     7499 ALLEN      SALESMAN        1600       2450       
     7782 CLARK      MANAGER         2450       2850       
     7698 BLAKE      MANAGER         2850       2975       
     7566 JONES      MANAGER         2975       3000        
     7788 SCOTT      ANALYST         3000       3000         
     7902 FORD       ANALYST         3000       5000      
     7839 KING       PRESIDENT       5000          0     

The SAL_NEXT field will hold the value of the next row salary.

This feature can be used in numerous occasions, one occasion where we find it to be useful is in peoplesoft where we deal with the effdt, If we want the job_end_dt of a particular person and you know only his job_begin_dt, then using the LEAD and LAG functions we can determine the job_end_dt, by doing LEAD function to the job_begin_dt and have -1 of date

for example if we have data

Emplid JOB_BEGIN_DT JOBCODE
---------- ----------------------- ----------------
0001 01/01/2006 001
0001 02/01/2006 ABC
0001 04/01/2006 CBA

Now If we need to determine the job_end_dt in each and every jobcode or how long a person has stayed in a particular job code, then the query goes this way.

select EMPLID,
JOB_BEGIN_DT,
JOBCODE
LEAD(JOB_BEGIN_DT,1,0) OVER (ORDER BY JOB_BEGIN_DT) -1 AS JOB_END_DT

The above query will determine the next job_begin_dt in the table and subtract one day from it which will become the job_end_dt for the specified. The resultant data will look like

Emplid JOB_BEGIN_DT JOBCODE JOB_END_DT
---------- ----------------------- ---------------- --------------------
0001 01/01/2006 001 01/31/2006
0001 02/01/2006 ABC 03/31/2006
0001 04/01/2006 CBA


Hope the explanation was useful !!!

Cuil vs Google

So there is yet another start up which is into the search market, but this time its a challenging start up and guess what its again the ex-googlers who are getting into the search market. The core team of cuil has been a part of the indexing and ranking features of the google(which means they know search better and what user expects). Cuil claims to have indexed 120 billion pages which is far more than google. The teragoogle team (Russell and Anna) members are now the co-founders of Cuil.Cuil seems to have the best of breed in the management side

Here is what cuil looks like, it has tried to have a similar interface like google black.



I liked the feature explored by category which gives you more information on other related and interested things that you would like to search.

Search is moving in a new dimension and in a more effecient and effective way. I wish cuil also becomes open source which will pave way to the information and index across multiple search engines, also need to know the cheats of cuil to get the most relevant and related results. On th whole a great attempt by a great team of technology enthusiast, Kudos to you guys !!!

Google Knol !!!

Google comes up with yet another spectacular product in the form of Google Knol, as the name suggest google knol is a knowledge sharingsite. In short I would call the wikipedia of Google. But after a couple of views of the google knol, I would say that its more like squidoo. Knol is more author centric and has more articles in different areas of interest i.e it is not a encylopedia !!!

Some of the features of Knol is that Google uses a rich-text editor borrowed from Page Creator, so it's much easier to edit knols than Wikipedia articles. Users can rate the articles, add comments and write reviews, much like for scholarly works.knol provides open collaburation,moderate collaburation and closed collaburation . Google also provides the access to adsense to monetize your knol articles.

Though Google has a lot of products which is used for sharing knowledge and information (blogger,Google docs,Google sites). Knol targets the experts in different domains to shared their knowledege and make a hub for information which will
shared to the billions and trillions of users across the globe.


Happy Googling !!!

A Tribute to Randy Pausch

Randy Pausch a professor of computer science in CMU delivered an inspiring speech on "Really Achieving your Childhood dreams" was one of the best lectures of all time. It is really inspiring and thought provoking. Randy was diagonised of cancer at a late stage and passed away in 2008. Google also plays tribute to this great professor by adding a line in its homepage as "In Memoriam:Randy Pausch (1960-2008)" and here is the video for you. Randy Pausch- Really Achieving your Childhood dreams

IGoogle - Limited Edition !!!

iGoogle - Limited Edition

IGoogle is a feature rather a service I would call it from google which provides an integration of all the products of Google under a single web page. You log in to IGoogle and you are ready to check your gmail,google reader,orkut, orkut birthday links.IGoogle is found in the main page of Google




You can add a lot of useful gadgets that are inhouse or you can develop your own gadgets using the google api and make them available to the billions and billions of google users online. These gadgets range from world clock to stock tickers to photo sharing, games and quiz . The gadgets are spread across a wide range of areas from science to fun. You can have cool themes for your IGoogle pages and there is a tab option also available so that you can group your gadgets according to your choice. A view of the IGoogle



Now adding spice to the IGoogle, Google has provided a test version of the new IGoogle through sandbox where it groups all the features on the left hand side and makes you choose the service you wanted and that feature will be available in the right pane and all features of gmail are made available in the new IGoogle(only restricted features are available right now). The new version of the IGoogle is




You can chat, read your feeds, search,browse your mails and watch your youtube videos and do a lot of stuff, ain't Google doing a great stuff.Check out people its one of those features worth trying. Once again Google goes beyond search with a lot of creativity and innovation.

Trick of the Day !!!

One simple trick is we can read a mail in gmail and simulatneously compose a mail in another tab. A simple way of doing it is by pressing the shift button and clicking on the compose link, this will open the compose of a new mail in the new tab leaving the current window with the mail existing.

All praise to the Turbunator

The UPA got the confidence back this evening which paves the way for the much anticipated and much awaited Nuclear Deal which will get underway with ease now. The UPA led government was keen on the Nuclear Deal which made it lose their ally in the form of Communist, which let to a vote of confidence of the lower house of the parliament. The much confident and determined as always the prime minister of India accepted the challenge and was more confident of winning the votes. Though few of the parties didnt turn up for voting and the speaker being a communist didnt want to resign and a lot of speculations and controversies happening for the past one month UPA ended up with the winning note and here are the figures for you



Now how is this news related to this blog as the blog is related to techno - psycho stuff, Well the lesson from this winning note of UPA as we see is the confidence in you can do wonders, the confidence of the UPA chairman and the prime minister has made the govt come on a winning note, the confidence to face the challenge of the communist and the ability to withstand pressure and stay focused on the goal.

In terms of psychology , confidence of the inner self can do wonders. Hope you might have read about the power of your subconcious mind. So the winning of UPA is yet another way of saying that confidence in you can do wonders. Wanted to write a lot more but will come up with some other intresting topic

A Boom which is a disaster on it Own

As i read through papers on the morning of a calm sunday , I came across the engineering admission column which took me back to my days when i used to visit counselling website daily to check the status of engineering seats in various colleges and to gather information abt colleges. those breath taking questions in the engineering, those nervous moments of counselling and the hefty competion where i was left behind 300 people for a mere 0.70 marks, those sad moments when I saw irrelevant people taking IT as major, Finally i became an engineer and now working as a consultant in a very reputed firm in India. Though I am happy that I work in the field which I wanted to, I am also sad as of why my field has dragged a lot of potential engineers in the other fields by its fancy pays and hi-tech lifes.

I turn around my cubicle and I find bright civil engineers,production engineers, mechanical engineers from one of the best institutes of India where getting admission is like a gift sitting and programming. Why did they join Civil engineering just to sit and do some certification in Java or is it be there travelling in a software company bus. Those who are supposed to build great bridges and revolutions in the Indian Industry are sitting there finding out logic for technical problems.

When I sit and think as of why are these people leaving what they have learnt whole heartedly and got a gold medal in it are sitting and coding, Only two things stuck my mind

1. Money and Fame
2. Hi-fi life
3. A Trip to abroad free of cost

I felt these are the two factors that are driving them to this field, they feel that they get recognised in the society if they are called as a Software Engineer and they get hefty money as salary which their father only got when he retired.


Because of this hefty money they try to have a hi-fi life which never belongs to them and ultimately they spoil the society in which they live in

This is the most important driving factor which driving the whole of engineers to this industry " A Trip to abroad" a word which is more often called as "Onsite". Well I dont know how people see onsite as, everybody who joins an IT company wants to go to onsite no matter they have the skill, competency, talent, communication, nothing they look out for. they bluntly ask for a onsite

Because of this enormous recuirting by the IT companies a lot of talented engineers are lost by the other industries and the environment in an IT company is totally screwed by some irrelevant guys from other streams, the whole of engineering methodology is lost, Hope this recession makes a correction in the recruiting of really skilled people by the IT companies