The general Concept of Computer Technology

3 03 2009

The General Concept of Computer Technology

The word ‘Computer’ has been derived from the Latin word ‘ Compute’ which means to count. In former time, computer was used to manipulate data like words and numbers. So, it was called as a ‘Computing machine’. Presently, a computer has become an electrically powered device through different evolutions of technology. According to the definition made by the Microsoft technologists- “A Computer is an electrically powered device or set of devices which works under the control of a stored program automatically accepting and processing data with minimum human intervention to produce results. Hence, a computer is automatic, re-programmable and a data processor to store information’. That is to say, the following concepts may be accepted apropos the definition of computer. • Literally, the term computer means equipment that can compute. • The computer is a combination of electronic devices used to process data. • In the computer all types of data is converted to numbers. The computer can only work with numbers, not letters, sounds or pictures. All forms of data are converted to numbers for processing. • Computers can receive, analyze, store information and produce reports. • Computers are useful for accurate and fast processing of accounts. • A computer is an electrically powered device. • It works under the control of a stored program. • It accepts data, analyzes data, preserves data and displays them in the form of result. • It completes work related to accounts very speedily and correctly • It works out complex mathematical problems • It analyzes data and displays results by the representation of charts and graphs. Brief History of Computer: • On about 3000 BC ‘Abacus’ was invented in China which was the earliest calculator. It was used for addition, subtraction, multiplication and division. • On the 17th century a number of instruments were invented which could be used as calculator. • On the 18th century a French scientist named Jacquard, invented an automated loom that could receive designs from punched cards. • At a certain step of perpetual research, came Charles Babbage with unique ideas. He is often called the father of modern computers. He invented ‘Differential Engine’ on 1812. • He performed fast calculations with this machine. On 1833 he planned to make a ‘Analytical Engine’. This research did not go far due to hindrance of promised fund by the Royal Society of England. • Later Lady Ada Augusta invented a number of techniques, which utilized the concept of the Analytical Engine. She was the daughter of the English poet Lord Byron and a close friend of Babbage. She invented the techniques required to solve mathematical problems, step by step. This is why she is considered as the first computer programmer in the world. • On 1944, A machine called ‘Mark-1’ was built under the supervision Professor Howard Eken of Harvard University of USA. This machine was 51 feet wide, 8 feet high. It had 5000 miles of electric cable and combination 7.5 lakh electronic parts. Though a dinosaur among today’s neat compact computers, this was the first computer of the first computer-age (1944-50). • The ENIAC (Electronic Numerical Integrator and Calculator) was built in the University of Pennsylvania on 1946; it consisted of almost eighteen thousand valves. It was made for the Ministry of Defense. In 1948 transistors were introduced, which ultimately replaced the valves. Transistors are miniature electronic switches that functions the same as the electronic valves and then some. 1958 saw the introduction of Integrated Circuits, popularly known as IC, which made the huge availability of computers today possible. • Then came Gordon Moore on 1971 with his revolutionary invention of microprocessors. • After the microprocessors, the progress was fast. IBM of USA introduced Microcomputers, which is now popularly known as PC or Personal Computer. In view of the above, it is evident that the Computer is a wonderful contribution of Modern Science. In a nutshell, it is an electrically powered device or a set of devices which work on the basis of a stored program. The computer is such machine which automatically accepts data, process data and finally it controls data to produce information. The speed of data processing depends on how powerful the processor is. Currently a processor with speed above 500 MHz is available in the market. The latest magic in the computer world today is the Internet; virtually the whole world can be reached through this little box with an Internet connection. We conclude, on the note that the computer has become an inseparable part of the modern civilization.





An Epigrammatic Account of SQL

14 12 2007

The time gone by of SQL begins in an IBM laboratory in San Jose, California, where SQL was developed in the late 1970s. The fundamental pose for Structured Query Language and the language itself is time and again referred to as “SEQEL.” It was built-up in the inauguration for IBM’s DB2 item for utilization as a basic criterion of a Relational Database Management System. In fact, SQL creates an RDBMS reachable for tailored software as a separate entity in Modern Technology. SQL is a nonprocedural language, in disparity to the third-generation languages such as COBOL, BASIC, PASCAL and C that had been formed up to that time. The quality that categorizes a DBMS from an RDBMS is that the RDBMS provides a set-oriented database language. For most RDBMS, this set-oriented database language is SQL. Two standards association, the American National Standards Institute and the International Standards Organization, currently prop up SQL standards to exchange others to add a new dimension to qualify the product virtually. Even though, these standard-making object oriented standard systematize values for database system designers to tag along, all database products differ from the ANSI standard to some extent. In addition, for the most part systems provide some proprietary extensions to SQL that enlarge the language into a true practical language.

It was an inquiring feeling whether there is a modest background on the evolution of databases and database conjecture would facilitate value the workings of SQL. Database systems stock up in sequence in every feasible business environment. From outsized pathway databases such as airline proviso systems to a child’s baseball card collection, database systems store and hand out the data that depends on. Until the last few years, large database systems could be run only on large mainframe computers. These machines have customarily been exclusive to design, purchase, and maintain. However, today’s generation of powerful, inexpensive workstation computers enables programmers to design software that maintains and distributes data quickly and inexpensively with the active support of Structured Query Language.