Viva Questions For Data Warehouseing And Datamining

1 DWDM Stands For Data Warehouseing And Datamining.

2 ETL Stands For Extract Transform And Load.

3 TPS Stands For Transaction Processing System.

4 MIS Stands For Management Information System.

5 OLTP V/S OLAP

  OLTP :-  OLTP Stands For Online Transaction Processing.

  OLAP   :-  OLAP Stands For Online Analytical Processing.

6 What Is Data Warehouse?

A Data Warehouse Is A Federated Repository For All The Data That An Enterprise's Various Business Systems Collect. The Repository May Be Physical Or Logical.

7 What Is Data Mining?

Data Mining Is The Process Of Sorting Through Large Data Sets To Identify Patterns And Establish Relationships To Solve Problems Through Data Analysis. Data Mining Tools Allow Enterprises To Predict Future Trends.

8 ETL Process In Warehousing.

Extraction Of Data

During Extraction, The Desired Data Is Identified And Extracted From Many Different Sources, Including Database Systems And Applications. Very Often, It Is Not Possible To Identify The Specific Subset Of Interest, Therefore More Data Than Necessary Has To Be Extracted, So The Identification Of The Relevant Data Will Be Done At A Later Point In Time. Depending On The Source System's Capabilities (For Example, Operating System Resources), Some Transformations May Take Place During This Extraction Process. The Size Of The Extracted Data Varies From Hundreds Of Kilobytes Up To Gigabytes, Depending On The Source System And The Business Situation. The Same Is True For The Time Delta Between Two (Logically) Identical Extractions: The Time Span May Vary Between Days/Hours And Minutes To Near Real-Time. Web Server Log Files, For Example, Can Easily Grow To Hundreds Of Megabytes In A Very Short Period Of Time.

Transportation Of Data

After Data Is Extracted, It Has To Be Physically Transported To The Target System Or To An Intermediate System For Further Processing. Depending On The Chosen Way Of Transportation, Some Transformations Can Be Done During This Process, Too. For Example, A SQL Statement Which Directly Accesses A Remote Target Through A Gateway Can Concatenate Two Columns As Part Of The SELECT Statement.

The Emphasis In Many Of The Examples In This Section Is Scalability. Many Long-Time Users Of Oracle Database Are Experts In Programming Complex Data Transformation Logic Using PL/SQL. These Chapters Suggest Alternatives For Many Such Data Manipulation Operations, With A Particular Emphasis On Implementations That Take Advantage Of Oracle's New SQL Functionality, Especially For ETL And The Parallel Query Infrastructure.

9 What Is The CRISP-DM ?

CRISP-DM Stands For Cross-Industry Process For Data Mining. The CRISP-DM Methodology Provides A Structured Approach To Planning A Data Mining Project. It Is A Robust And Well-Proven Methodology. We Do Not Claim Any Ownership Over It. We Did Not Invent It. We Are However Evangelists Of Its Powerful Practicality, Its Flexibility And Its Usefulness When Using Analytics To Solve Thorny Business Issues. It Is The Golden Thread Than Runs Through Almost Every Client Engagement. The CRISP-DM Model Is Shown On The Right.

This Model Is An Idealised Sequence Of Events. In Practice Many Of The Tasks Can Be Performed In A Different Order And It Will Often Be Necessary To Backtrack To Previous Tasks And Repeat Certain Actions. The Model Does Not Try To Capture All Possible Routes Through The Data Mining Process.

You Can Jump To More Information About Each Phase Of The Process Here:

Business Understanding

Data Understanding

Data Preparation

Modeling

Evaluation

Deployment

How To Build Android Rating bar Example In Eclips

This Is A Simple Example For How To  Build Rating bar in Android............

Following Are The Example.....

[1] Ratingbarctivity.java File

package com.dvp.rat;

import android.app.Activity;

import android.os.Bundle;

import android.view.View;

import android.widget.Button;

import android.widget.RatingBar;

import android.widget.Toast;

public class RaringbarActivity extends Activity {

    /** Called when the activity is first created. */

RatingBar r;

Button b;

    @Override

    public void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.main);

        r=(RatingBar)findViewById(R.id.ratingBar1);

        b=(Button)findViewById(R.id.button1);

        b.setOnClickListener(new View.OnClickListener() {

public void onClick(View v) {

// TODO Auto-generated method stub

String rat= String.valueOf(r.getRating());

Toast.makeText(getApplicationContext(),rat, 2).show();

}

});

        

    }

}

[2] Main.xml File

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    android:orientation="vertical"

    android:layout_width="fill_parent"

    android:layout_height="fill_parent"

    >

<TextView  

    android:layout_width="fill_parent" 

    android:layout_height="wrap_content" 

    android:text="@string/hello"

    />

<RatingBar android:id="@+id/ratingBar1" android:layout_width="wrap_content" android:layout_height="wrap_content"></RatingBar>

<Button android:text="Rate It" android:id="@+id/button1" android:layout_width="wrap_content" android:layout_height="wrap_content"></Button>

</LinearLayout>

Weka Data Mining Tutorial for First Time & Beginner User

This Video Is About How To Use Weka For Data Mining Process.

 And How To Create .csv File And .arff File For Weka ......

Test

Simple How To Put Email Validation In HTML 5

In Below Code Is About Put Validation In HTML 5

required="required"

 pattern="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"

title="please enter proper email"

Simple How To Use Internet Permission In Android Eclipes

This Video Is About How To Use Internet Permission In Android Application

Simple Build How To Read And Write File In Android

In This Example We See How To Read And Write File In Android With The Use
of SharedPrefrence.

In This I Tack Following Controls.

1. Two Button
2.One Edittext
3. One Textview

Following Are The Code For Read And Write File In Android....


[1] Mainactivity.java

package com.demo.file;

import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;

import android.app.Activity;
import android.content.Context;
import android.content.SharedPreferences;
import android.os.Bundle;
import android.os.Environment;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

public class FilehandlingdemoActivity extends Activity
{
String FileName = "datafile";
Button save,read;
EditText e1;
TextView t1;
String name;
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState)
    {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        save =(Button)findViewById(R.id.sbtn);
        read=(Button)findViewById(R.id.rbtn);
        e1=(EditText)findViewById(R.id.editText1);
        t1=(TextView)findViewById(R.id.textView1);
        save.setOnClickListener(new View.OnClickListener()
 {

public void onClick(View v)
 {
// TODO Auto-generated method stub

saveFile();

}


}
);
        read.setOnClickListener(new View.OnClickListener()
 {

public void onClick(View v)
 {
// TODO Auto-generated method stub
readFile();
}


}
);
     
    }
    private void saveFile()
    {
// TODO Auto-generated method stub
    String strname= e1.getText().toString();
    SharedPreferences sp = getSharedPreferences(FileName, Context.MODE_PRIVATE);
    SharedPreferences.Editor e= sp.edit();
    e.putString("name", strname);
    e.commit();
    Toast.makeText(this, "Data Save Successfully", Toast.LENGTH_SHORT).show();
}
    private void readFile()
 {
// TODO Auto-generated method stub
    SharedPreferences sp = getSharedPreferences(FileName, Context.MODE_PRIVATE);
    String defaultvalue ="defaultname";
    String name= sp.getString("name", defaultvalue);
    t1.setText(name);
    Toast.makeText(this,"Data:"+name, Toast.LENGTH_SHORT).show();


}
}

[2] Main.xml File

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:orientation="vertical"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    >
<TextView
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:text="@string/hello"
    />
<EditText android:id="@+id/editText1" android:layout_height="wrap_content" android:layout_width="match_parent">
    <requestFocus></requestFocus>
</EditText>
<LinearLayout android:id="@+id/linearLayout1" android:layout_height="wrap_content" android:layout_width="match_parent" android:orientation="vertical">
    <Button android:id="@+id/rbtn" android:layout_height="wrap_content" android:layout_width="wrap_content" android:text="read"></Button>
    <Button android:text="save" android:id="@+id/sbtn" android:layout_width="wrap_content" android:layout_height="wrap_content"></Button>
</LinearLayout>
<TextView android:text="TextView" android:id="@+id/textView1" android:layout_width="wrap_content" android:layout_height="wrap_content"></TextView>


</LinearLayout>

Following Are The Output Of Above Program

Output:-

What Is Storage API In Android PPT

Storage API In Android

 

•Shared preferences

•Internal storage

•External storage

•SQLite  Database

•Network connection

Download Here PPT