A benchmark is a sample program used for evaluating the performance of computer-based systems. It helps in the following manner: 1. Determination of the minimum hardware configuration needed t operate the system. 2. Testing the system in an ideal environment to determine comparative timings and then testing the system in a normal environment. 3. Determination [...]
General
Graphical User Interface (GUI)
The pictorial representation of information and instructions using GUI’s are more user-friendly and easy-to-understand than textual commands and lifeless screens. Nowadays, GUI (Graphical user Interface) is incorporated within most of the computer operating systems, pioneer among them being the Microsoft’s Windows 9X,2000 and XP. Note : GUI is a software design that allows you to [...]
Different types of Interview
There are two types of interviews. These are: 1. Unstructured 2. Structured Unstructured Interview Unstructured interview is an approach in which the questions and the corresponding responses are open-ended. The interviewer can ask questions which may not be directly related to the system under consideration. Unstructured interviews are conducted with only a general goal or [...]
System Design and its Characteristics
In the system design process, the primary objective is to identify user requirements and to build a system that satisfies these requirements. Design of system is largely the logical design. The logical design can be sketched on a paper or on a computer terminal. The design, also including the physical design elements, describes the data [...]
Equijoins in Oracle
Equijoins are also commonly known as simple joins, or inner joins. Given two or more tables, an equijoin will return the results of these tables where a common column between any given pair of tables has the same value (an equal value). Equijoins are typically joins between foreign keys in one table to a primary [...]
Motorcars on Fire
Of late, it has been observed that Automobiles running on the roads in Metro Cities sometimes catch fire. Many times the occupants escape unhurt but many times there are no so lucky. Daily one or the other car of different make catch fire in the city. By the time the fire brigade arrives on the [...]
PBX, PABX & EPBAX
The three are abbreviations of three small Automatic Telephone Exchanges which have been in use in the corporate sectors and small offices. PBX – stands for “Private Branch Exchange “ PABX – stands for “Private Automatic Branch Exchange “ EPBAX –stands for “Electronic Private Automatic Branch Exchange “ All are small automatic telephone exchanges having [...]
Different duties performed by System Analysts
System Analyst has the following duties to perform : Estimate personnel requirements, cost and time for system’s implementation. Review and approve proposed system’s solutions Perform resource planning and scheduling for system’s personnel. Develop, implement and enforce procedural standards for performing tasks of system analysis and design. Evaluate performance of system’s personnel and report on personnel [...]
STROUGER SYSTEM
Automatic Telephone Exchange Strouger System During the decades 1950’s 1960’s & 1970’s all the Telephone Exchange in Delhi were automatic and were using Strouger System which was imported from Belgium. This system was of minimum Ten Thousand lines which means Ten Thousand people could talk to each other at a time. There were nine such [...]
Shell in Linux
A Linux shell is the program which interprets what you type on the command line and decides what to do with that. A shell can be invoked in a non-interactive way, for example to execute a pre-typed list of commands contained in a text file (a “shell script”). Think of a shell as the equivalent [...]
ROLLUP and CUBE Operators in Oracle
Sometimes, a simple GROUP BY clause just isn’t enough in a query. Once you generate a report of, let’s say, average salary by department or the standard deviation of sick days by job title, you often must run a second query that calculates the average salary or standard deviation across the entire set of employees. [...]
APPLICATIONS OF DATA MINING
Data mining has many and varied fields of application some of which are listed below. Retail/Marketing 1. Identify buying patterns from customers 2. Find associations among customer demographic characteristics 3. Predict response to mailing campaigns 4. Markets analysis Banking 1. Detect patterns of fraudulent credit card use 2. Identify ‘loyal’ customers 3. Predict customers likely [...]
REASONS FOR THE GROWING POPULARITY OF DATA MINING
1.Growing Data Volume The main reason for necessity of automated computer systems for intelligent data analysis is the enormous volume of existing and newly appearing data that require processing. The amount of data accumulated each day by various business, scientific,and governmental organizations around the world is daunting. 2. Limitations of Human Analysis Two other problems [...]
