Showing posts with label Data Mining. Show all posts
Showing posts with label Data Mining. Show all posts

Saturday, October 29, 2016

Oracle Data Mining Algorithms

Two major categories:

- Supervised learning
- Unsupervised learning

Supervised learning requires the data analyst to identify a target attribute (dependent variable). The supervised-learning technique then sifts through data trying to find patterns and relationships between the independent attributes (predictors) and the dependent attribute (target attribute).

In unsupervised learning, the user does not specify a target attribute for the data mining algorithm. 
Unsupervised learning techniques such as Associations and Clustering make no assumptions about a target attribute. Instead, they allow the data mining algorithm to finds associations and clusters in the data independent of any defined business objective.

What is Oracle Data Mining?

Oracle Data Mining is powerful data mining software embedded in the Oracle Database that enables users to discover new insights hidden in data. Oracle Data Mining helps find patterns in data, identify key attributes, discover new clusters and associations, and discover valuable new insights. With Oracle Data Mining, everything occurs in the Oracle Database—in a single, secure, scalable, platform for business intelligence.

Data mining and Other Tools 

Query and reporting tools;
-  help you to get information out of your database or data warehouse. These tools are good at answering questions such as “Who purchased digital cameras in the past 3 years?”

OLAP tools;
-  go beyond this and allow users to interactively “drill down” into the data for summaries, comparisons, analysis, and forecast (technically, simple extrapolation forecast). OLAP is good at drill-downs into the details to find, for example, “What is the average income of digital camera buyers by year by region?”

Statistical tools;
-  are used to draw conclusions from representative samples taken from larger amounts of data. 
- statistical tools are useful for finding patterns and correlations in “small to medium” amounts of data but fall short when the amount of data begins to overwhelm the tool. 



Thursday, January 10, 2013

Storage Types in Data Warehousing

MOLAP - Multidimensional OLAP

The MOLAP environment consists of a multi-dimensional cube with all possible perspectives pre-calculated. Therefore MOLAP applications do have a high performance. At the same time the need a lot of disk capacity to store all the pre-calculated figures.

ROLAP - Relational OLAP

The ROLAP environment consist of a relational database with a OLAP query engine. Every information need is calculated on the fly by the OLAP query engine. therefore ROLAP most times has a slower performance. Never the less, it needs less disk space to store the data.

HOLAP - Hybrid OLAP

The HOLAP environment consists of both a relation database and a preconfigured multi-dimension cube. Most times you can be flexible in keeping information in the relational database and/or the preconfigured multi-dimensional cube.

WOLAP - Web enabled OLAP

The frontend user can access the OLAP application through a web browser.

DOLAP - Desktop OLAP

All the OLAP functionality can be performed on a Desktop PC. Most other OLAP mentioned here are client-server and/or server based database applications.

Types of Data Warehousing

Off line Data Warehouse

Data warehouses at this stage are updated from data in the operational systems on a regular basis and the data warehouse data is stored in a data structure designed to facilitate reporting. 

Real Time Data Warehouse 

Data warehouses at this stage are updated every time an operational system performs a transaction (e.g. an order or a delivery or a booking.) 

Integrated Data Warehouse

Data warehouses at this stage are updated every time an operational system performs a transaction. The data warehouses then generate transactions that are passed back into the operational systems.

What is Data Warehousing

A comprehensive technology that provides the key people within an enterprise with access to any level of required information within the enterprise. It is an enterprise wide framework that permits the management of all enterprise information.

Extracting data from legacy systems and other resources; cleaning, scrubbing and preparing da|a for dmcision support; maintaining data in appropriate data stores; accessing and analyzing data using a variety of end user tools; and mining data for significant relationships. The primary purpose of these efforts is to provide easy access to specifically prepared data that can be used with decision support applications such as management reports, queries, decision support systems, executive information systems and data mining.

Linear Regression


Discuss basic ideas of linear regression and correlation.
_ Create and interpret a line of best fit.
_ Calculate and interpret the correlation coefficient.
_ Calculate and interpret outliers.

1.1 Introduction

Professionals often want to know how two or more variables are related. For example, is there a relationship between the grade on the second math exam a student takes and the grade on the final exam? If there is a relationship, what is it and how strong is the relationship?
In another example, your income may be determined by your education, your profession, your years of experience, and your ability. The amount you pay a repair person for labor is often determined by an initial amount plus an hourly fee. These are all examples in which regression can be used. The type of data described in the examples is bivariate data - "bi" for two variables. In reality, statisticians use multivariate data, meaning many variables.

In this chapter, you will be studying the simplest form of regression, "linear regression" with one independent variable (x). This involves data that fits a line in two dimensions. You will also study correlation which measures how strong the relationship is.


1.2 Linear Equations

Linear regression for two variables is based on a linear equation with one independent variable. It has the form:
                        y = a + bx
where a and b are constant numbers.

x is the independent variable, and  is the dependent variable. Typically, you choose a value to substitute for the independent variable and then solve for the dependent variable.

Example 1

The following examples are linear equations.
                                     y = 3 + 2x
                                    y = 0.01 + 1.2x
The graph of a linear equation of the form y = a + bx is a straight line. Any line that is not vertical can be described by this equation.

Example 2




Figure 1: Graph of the equation y = -1 + 2x.


Linear equations of this form occur in applications of life sciences, social sciences, psychology, business etc.

Example 2

Svetlana tutors to make extra money for college. For each tutoring session, she charges a one time fee of $25 plus $15 per hour of tutoring. A linear equation that expresses the total amount of money Svetlana earns for each session she tutors is y = 25 + 15x.
What are the independent and dependent variables? What is the y-intercept and what is the slope? Interpret them using complete sentences.

Solution

The independent variable (x) is the number of hours Svetlana tutors each session. The dependent variable (y) is the amount, in dollars, Svetlana earns for each session.
The y-intercept is 25 (a = 25). At the start of the tutoring session, Svetlana charges a one-time fee of $25 (this is when x = 0). The slope is 15 (b = 15). For each session, Svetlana earns $15 for each hour she tutors.

1.3 Scatter Plots
Before we take up the discussion of linear regression and correlation, we need to examine a way to display the relation between two variables x and y. The most common and easiest way is a scatter plot. The following example illustrates a scatter plot.
  
1.4 Slope and Y-Intercept of a Linear Equation

For the linear equation y = a + bx, b = slope and a = y-intercept. From algebra recall that the slope is a number that describes the steepness of a line and the y-intercept is the y coordinate of the point (0, a) where the line crosses the y-axis.

1.5 Facts about the Correlation Coefficient for Linear Regression
_ A positive r means that when x increases, y increases and when x decreases, y decreases (positive correlation).
_ A negative r means that when x increases, y decreases and when x decreases, y increases (negative correlation).
_ An r of zero means there is absolutely no linear relationship between x and y (no correlation).
_ High correlation does not suggest that x causes y or y causes x. We say "correlation does not imply causation." For example, every person who learned math in the 17th century is dead. However, learning math does not necessarily cause death!