Archive for the ‘Technology’ Category

Read/Write operation on indexed and non-indexed table

Today, I got a question related to database indexes. It was a tricky question which is very easy to say in words but was very difficult to say in exact or approximately figures.The question is:

if we have one million records in the table and we want to perform Read/Write operations, but in different cases. Which are:

Case 1: We have indexed table.
Case 2: We have non-indexed table.

Query:
If one query take 1 unit (time) to read from indexed table. Then
1. How much it will take from non-indexed table to read?
2. How much to write in indexed table?
3. how much to write in non-indexed table?

The answer may be approximately not exactly.

Unit may be any time: for example it may be 1 micro second.

Now the matrix is:

Indexed Table Non-Indexed Table
Read Operation 1 Unit ?
Write Operation ? ?

So, What do u say? any idea for this query?

PS: You may consider different Data base servers like SQL Server, MySql, Oracle etc. Also please cosider the Web and desktop technologies iff there is any difference. Otherwise this is general query.

Virus: Olympic Torch Hoax [Sophos] – “Invitation”

If you receive a mail called “invitation”, though sent by a friend, do not open it and shut down your computer immediately.

The Olympic Torch Hoax is being spread through email. It has been reported that the following text of the hoax may differ slightly in the various messages going around. This hoax email includes the following warning: Subject: Invitation. This virus does not exist.

You should be alert during the next days:
Do not open any message with an attached filed called “Invitation” regardless of who sent it . It is a virus that opens an Olympic Torch which “burns” the whole hard disc C of your computer. This virus will be received from someone who has your e-mail address in his/her contact list, that is why you should send this e-mail to all your contacts. It is better to receive this message 25 times than to receive the virus and open it.

If you receive a mail called “invitation”, though sent by a friend, do not open it and shut down your computer immediately.This is the worst virus announced by CNN, it has been classified by Microsoft as the most destructive virus ever.

This virus was discovered by McAfee yesterday, and there is no repair yet for this kind of virus.

This virus simply destroys the Zero Sector of the Hard Disc, where the vital information is kept.

Pakistan’s First Machine Translation Portal


Machine translation (MT) is the application of computers to the task of translating texts from one natural language to another. One of the very earliest pursuits in computer science, Machine Translation (MT) has proved to be an elusive goal, but today a number of systems are available which produce output which, if not perfect, is of sufficient quality to be useful in a number of specific domains.”

There are different transaltion websites working. some are
Altavista
Applied Language
SDL Internation
Google
InterTran
Systran

Same as another project working as PakTranslations.com to translate into Urdu. Although this is beta but it is a good try in Pakistan.


PakTranslations.com project marks the first attempt of its kind to set Pakistani audience free, to reach out and no longer let language be a barrier to information and technology. The translations would be always free of charge for the end user, constantly improving, evolving and supporting more local languages.The features are:free website translation service;
free text translation service;
free dictionary service; or
enable translation on your website via free offerings.You can translate your website from www.paktranslations.com or by entering the URL in the following format

How to translate website