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 [...]
Computer
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 [...]
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 [...]
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. [...]
VLSI COMPUTING
Over the past four decades the computer industry has experienced four generations of development, physically marked by the rapid changing of building blocks from relays and vacuum tubes (1940-1950s) to discrete diodes and transistors (1950-1960s), to small- and medium-scale integrated (SSI/MSI) circuits (1960-1970s), and to large- and very-large-scale integrated (LSI/VLSI) devices (1970s and beyond). Computer [...]
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 [...]
HOW DO WE CATEGORIZE DATA MINING SYSTEMS?
There are many data mining systems available or being developed. Some are specialized systems dedicated to a given data source or are confined to limited data mining functionalities, other are more versatile and comprehensive. 1. Classification according to the type of data source mined: this classification categorizes data mining systems according to the type of [...]
WHAT CAN DATA MINING DO?
The kinds of patterns that can be discovered depend upon the data mining tasks employed. By and large, there are two types of data mining tasks: descriptive data mining tasks that describe the general properties of the existing data, and predictive data mining tasks that attempt to do predictions based on inference on available data. [...]
WHAT KIND OF DATA CAN BE MINED?
In principle, data mining is not specific to one type of media or data. Data mining should be applicable to any kind of information respiratory. However, algorithms and approaches may differ when applied to different types of data. Indeed, the challenges presented by different types of data very significantly. Data mining is being put into [...]
OEM Event Manager
OEM automatically alert the DBA, through an e-mail message or page, to error conditions or conditions that may signal an impending error. Using OEM’s Event Manager, accessible as one of the nodes in the OEM Navigator pane, the DBA can monitor a variety of error conditions, such as an abnormal termination of the Oracle instance [...]
