Search
Home
Saved
0
420 views
Upload
Sign In
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
Download
1
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
A Paper Presentation on
Mr. Amit Himansu Shah
[email protected] your semester with Scribd Mobile no. 9860699801
Master & The New York Times Special offer for students: Only $4.99/month.
Mr. Sumeet Jain
[email protected] Read Free Foron 30this Days Sign up to vote title Mobile no. 9890526031 Not useful Useful Cancel anytime.
T.E. (CSE)
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
Join
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Abstract
Organisations are today suffering from a malaise of data overflow. The develop
the transaction processing technology has given rise to a situation where the amount an
data capture is very high, but the processing of this data into information that can be ut
decision making, is not developing at the same pace. Data warehousing and data min
data & text) provide a technology that enables the decision-maker in the corporate secto pro process ess
this his
huge amoun ount
of data ata
in
a
reasonable
amount unt
of
time,
intelligence/knowledge in a near real time.
The data warehouse allows the storage of data in a format that facilitates its acce
the tools for deriving information and/or knowledge and presenting them in a form
Master your semester with Scribd useful useful for decisi decision on making making are not provid provided ed & The New York Times
the Read whole rat ionale ale for existe Free For 30this Days Sign up toration vote on titlethe existe
Not useful Cancel anytime.
Useful
warehouse disappears. Various technologies for extracting new insight from the data w
Special offer for students: Only $4.99/month.
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
Join
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Indexing the things….. Sr. No. 1.
2.
Concept
Page No. 4
INTRODUCTION
WAREHOUSE AND DATABASE
5
3.
WHAT IS DATA-WAREHOUSING?
5
4.
WAREHOUSING FUNCTIONS
7
5.
6.
7.
ARCHITECTURE OF DATA WAREHOUSE
8
9
WHAT IS DATA- MINING
9
WARE HOUSING AND MINING
Master your semester with Scribd Read Free Foron 30this Days Sign up to vote title & The New York TimesDATA MINING AS A PART OF Useful Not useful 8. 10 Special offer for students: Only $4.99/month. KNOWLEDGE DISCOVERY
Cancel anytime.
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
Download
1
of 14
Data Mining and Warehousing
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
DATA MINING AND DATA
Data Warehousing &
Search document
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
Join
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
compet competito itors rs for achievi achieving ng busine business ss excell excellenc ence. e. Inform Informati ation on techno technolog logy y (IT) (IT) too
oriented towards knowledge processing can provide the edge that organizations need t
and thrive in the current era of fierce competition. The increasing competitive pressure
desire to leverage information technology techniques have led many organizations to ex
benefits of new emerging technology – viz. "Data Warehousing and Data Mining".
needed today is not just the latest and updated to the nano-second information, but t functional information that can help decisions making activity as "on-line" process. Evolution of Information Technology Tools
The evolution of the information systems characterize the evolution of systems f mainte maintenanc nancee syste systems, ms, to syste systems ms that that trans transfor form m the data data into into "infor "informat mation ion"" for
decision making process. These systems supported the information acquisition from the
of transa transacti ctional onal data. data. The manage manageria riall knowled knowledge ge acquisi acquisitio tion n functi function on is/was is/was not
supported by these systems. The evolution of new patterns in the changing scenario cou
provided by these systems directly, the planner was supposed to do this from experience
Data
Processing
Information
Master your semester with Scribd & The New York Times Transaction s
Special offer for students: Only $4.99/month.
Management Information
Processing
Knowledge
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Data Mining Tools & On-Line Analytical
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
Download
1
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
And, these days, change is occurring at an ever-increasing rate. A key chal
implementing an information infrastructure that allows your company to rapidly respond change. One solution to this challenge is the datawarehouse. Data warehousing is an information infrastructure based on d etail data that supports the
making process and provides businesses; the ability to acce ss and analyze data to increas organization's competitive advantage.
Data warehousing is a process, not an off-the-shelf solution you buy, but hardware--data
tools integrated into an evolving information infrastructure--that changes with the dynam the business.
What is Data-Warehousing? Data-Warehousing?
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
*
This This data data is taken taken from vario various us,, perha perhaps ps incomp incompat atib ible le,, sour sources ces and st uniform format
*
Severa Severall tools trans transfor form m this data into into meaningfu meaningfull business business inform informati ati purpose of comparisons, trends and forecasting
*
Data Data in a warehou warehouse se is not not update updatess or changed changed in in any way, way, but is is only l accessed later on
*
Data Data is organi organized zed accor accordin ding g to subject subject inste instead ad of applic applicati ation. on.
In general a database is not a data warehouse unless it has the following two featu
It collects information from a number of different disparate sources a place where this disparity is reconciled, and •
•
It allows several different applications to make use of the same informati
Conceptually, a Data Warehouse looks like this:
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Decision Support Tools are used to analyze the information stored in the wa typically to identify trends and new business opportunities..
The Data Warehouse itself is the bridge between the operational systems and the support tools. It holds a copy of much of the operational system data in a logical
which is more conducive to analysis. The Data Warehouse, which will be ref schedu scheduled led bursts bursts from from operati operationa onall system systemss and from from releva relevant nt extern external al dat provi provides des a single single,, consist consistent ent view view of corpor corporate ate data, data, leavin leaving g operat operation ion unaffected.
Data – Warehouse Functions
The main function behind a data warehouse is to get the enterprise-wide data in
that is most useful to end-users, regardless of their locations. Data warehousing is used f
•
Increasing the speed and flexibility of analysis.
Master your semester with Scribd Read Free Foraccess. 30this Days Sign up to and vote on title Providing a foundation for enterprise-wide integration & The New York Times Useful Not useful •
Special offer for students: Only $4.99/month. •
Improving or re-inventing business processes.
Cancel anytime.
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Upload
Sign In
Join
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Each implementation of a data warehouse is different in its detailed design (a s
high-level of the architecture and its components is given in the figure below), bu characterized by a handful of the following key components: •
A data model to define the warehouse contents.
•
A carefully carefully designed warehouse database, whether hierarchica hierarchical, l, rela
multidimensional. While choosing a DBMS it must be kept in view that the managem management ent syste system m should should be powerf powerful ul enough enough to handle handle huge huge amo running up to terabytes. •
A front end for Decision Support System (DSS) for reporting and for st
and unstructured analysis.
Query and reporting Multi• Metadata dimensiona analysis Data tools Warehous Other OLA • tools Read Free Foron 30this Days Sign up to vote title Data mining • Useful Not useful tools Cancel anytime. •
Legacy Database
Operational Database
Extract Transform Maintain
Data Source Master yourExternal semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Upload
Sign In
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Data Data base base mining mining or Data Data minin mining g (DM) (DM) (forma (formally lly termed termed Knowled Knowledge ge Dis
Databases – KDD) is a process that aims to use existing data to invent new facts and to
new relationships previously unknown even to experts thoroughly familiar with the d
like extracting precious metal (say gold etc.) and/or gems, hence the term “mining”, I
on filtration and assaying of mountain of data “ore” in order to get “nuggets” of knowle data mining process is diagrammatically exemplified in Figure below Transformed Data
Data Sources 1
2
Extracted Information
Data Warehouse
Selected Data
N Select
Master your semester with Scribd The Data Mining Process. & The New York Times Special offer for students: Only $4.99/month.
Transform
Mine
Assimilate
Read Free Foron 30this Days Sign up to vote title
Useful Not useful Cancel anytime. Data Mining and Data Warehousing
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
Download
1
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Data Mining as a Part of the Knowledge Discovery Process
· Knowledge Discovery in Databases, frequently abbreviated as KDD, typica more than data mining. · The knowledge discovery process comprises six phases:
Data selection ,Data about specific items or categories of items, or from stores in
specific region or area of the country, coun try, may be selected.
Data cleansing process then may correct invalid zip codes or eliminate records w
incorrect phone prefixes. Enrichment typically enhances the data with additional sources of information. Data transformation and encoding may be done to reduce the amount of data.
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
Join
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Goals of Data Mining and Knowledge Discovery The goals of data mining fall into the following classes:
Prediction : Data mining can show how certain attributes within the data wi
future. Identification: Data patterns can be used to identify the existence of an item
activity.
Classification : Data mining can partition the data so that different classes or c
identified based on combinations of parameters.
Optimization :One eventual goal of data mining may be to optimize the use of l
such as time, space, money, or materials and to maximize output variables profits under a given set of constraints.
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
1
Download
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Compendium A data warehouse takes the organisations operational data, historical data and external a)
consolidates it into a separately designed database (which can relational or multi-dimensional in nature)
b) b)
mana manage gess it into into a form format at that that is opti optimi mise sed d for for end end user userss to acce access ss an
When a data warehouse has been constructed, it provides a complete pictu enterp enterpris rise. e. It provid provides es an unpara unparalle lleled led opportu opportunit nity y to the managem management ent to learn learn customers.
The data warehouse technology together with online transaction process data mining , allows the management to provide better customer service, create greater
loyalty and activity, focus customer acquisition and retention of the most profitable c
increase revenue, reduce operating cost; provides tools that facilitate sounder decision
improves worker/management knowledge and productivity; spares the operational datab
ad-hoc queries with the resulting performance degradation and clears the legacy databas whilesemester moving the corporate architecture forward. Master your withsystem Scribd Read Free Foron 30this Days Sign up to vote title With the incorporati incorporation on of new data delivery and presentati presen tation on useful techniques, techniques, like & The New York Times Useful Not Cancel anytime.
Special offer for students: $4.99/month. mark Only up language (HTML), Open Database Connectivity (ODBC) etc. the database min
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
Search
Home
Saved
420 views
0
Sign In
Upload
RELATED TITLES
0
Data warehousing and data mining Uploaded by Bridget Smith
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Join
Data warehousing and data mining (both data & text) provide a technology that enables the decision-maker in the corporate sector/govt. to process this huge amount of data in a reasonable amo… Full description
Save
Embed
Share
Print
Download
1
of 14
Data Mining and Warehousing
DATA MINING AND DATA
Data Warehousing &
Search document
Bibliography
Developer IQ – India’s First Software Magazine ,May 2002 Vol.2 No.6 Computers Today – Smart Facts about Data Warehousing by Atanu Roy Using Information Technology by William Sawyers Hutchinson Data Base System Concepts by Silberschatz ,Korth and Sudharshan http://www.google.com/ http://www.altavista.com/ http://www.infogoal.com/ http://www.cse.buffalo.edu/ http://www.datawarehousingonline.com/
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Read Free Foron 30this Days Sign up to vote title
Not useful Cancel anytime.
Useful
Home
Saved
Books
Audiobooks
Magazines
News
Documents
Sheet Music
Master your semester with Scribd & The New York Times Special offer for students: Only $4.99/month.
Upload
Sign In
Read Free For 30 Days Cancel anytime.
Join
