So far, we have been dealing with only one table at a time in our SQL query examples. But typically the information needed to satisfy a user query requires more than one table. In new SQL 1999, you can not only join two or more tables in a number of different ways, but can also [...]
Continue reading → 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 [...]
Continue reading → 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 [...]
Continue reading → 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 [...]
Continue reading → 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 [...]
Continue reading → In Linux, if a program crashes, it often dumps a “core ” into your home directory. This is accompanied by an appropriate message. A core is a memory image and is a debugging tool. If you are a user who does not intend to debug the program, you may simply delete the core : Rm [...]
Continue reading → 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. [...]
Continue reading → 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 [...]
Continue reading → 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 [...]
Continue reading → 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 [...]
Continue reading → 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. [...]
Continue reading → 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 [...]
Continue reading → 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 [...]
Continue reading → The alert log file grows in size slowly but without limit. After a few weeks, it can become cumbersome to review the file, so it’s a good idea to archive or delete the file on a periodic basis. The alert log file can be safely renamed or deleted, even when the database is up and [...]
Continue reading → The alert log file is a grab bag of messages about the state of the database instance. It contains entries about significant database events, such as database startup and shutdown, nondefault initialization parameters, ALTER SYSTEM commands, and various errors. Alert Log File : A text file that contains entries about significant database events, such as [...]
Continue reading →