Software safety and hazard analysis are SQA activities that focus on the identification and assessment of potential hazards that may impact software negatively and cause entire system to fail. If hazards can be identified early in the software engineering process software design features can be specified that will either eliminate or control potential hazards. A [...]
Software
DATA MINING FOR FINANCIAL DATA ANALYSIS
Most banks and financial institutions offer a wide variety of banking services (for example saving balance checking, individual transactions), credit (such as loans, mortgage) and investment services (mutual funds). Some also offer insurance services and stock investment services. Financial data collected in the banking and financial i9ndustry are often relatively complete,reliable and of high quality,which [...]
Requirements for Clustering in Data Mining
Clustering is a challenging and interested field potential applications pose their own special requirements. The following are typical requirements of clustering in data mining: 1. Scalability: Many clustering algorithms work well on small data sets containing fewer than 200 data objects. However, a large database may contain millions of objects. Clustering on a sample of [...]
CLUSTERING IN DATA MINING
Clustering is a division of data into groups of similar objects. Each group, called cluster, consists of objects that are similar between themselves and dissimilar to objects of other groups. Representing data by fewer clusters necessarily loses certain fine details (akin to lossy data compression), but achieves simplification. It represents many data objects by few [...]
Event-Driven Programming
Windows enables you to execute programs by using a mouse. When you click on a control, an event is generated. An event is an action performed by the user. Windows generates messages in response to each event performed by the user. These messages are sent to the application and, depending on the messages received, the [...]
Types of Dialog Boxes in Windows
Windows provides the following types of dialog boxes : Modal System modal Modeless Modal Dialog Box A modal dialog box does not allow you to switch focus to another area of the application which has invoked the dialog box. However, you can switch to other windows applications while the modal dialog box is being [...]
Subqueries
A subquery places one query inside another one. The second query resides somewhere within the WHERE clause of a SELECT statement. One or more values returned by the subquery are used by the main query to return the results to the user Subquery: A query that is embedded in a main, or parent, query and used [...]
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 [...]
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 [...]
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. [...]
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 [...]
