Submitted by: Submitted by lucialiu1227
Views: 40
Words: 3261
Pages: 14
Category: Business and Industry
Date Submitted: 02/09/2015 08:05 PM
What are the distinguishing characteristics of OLAP and data mining analyses? Compare
and
contrast
OLTP
and
OLAP
queries.
OLAP(Online
analytical
processing)is
a
typical
analytical
technology,
which
means
computer
processing
that
enables
a
user
to
easily
and
selectively
extract
and
view
data
from
different
points
of
view.
For
example,
a
user
can
request
the
data
be
analyzed
and
showed
in
a
spreadsheet
to
indicate
how
many
ZARA’s
hats
are
sold
in
the
October
in
New
York.
Also,
it
also
can
show
that
the
data
in
the
same
period
but
in
different
years.
Further
more,
the
user
can
also
request
for
the
same
year’s
data
but
in
the
different
month
in
New
York,
or
the
same
month
but
in
different
area
like
Chicago.
OLAP
data
is
stored
in
a
multidimensional
database
to
facilitate
this
kind
of
analysis.
Multidimensional
database
considers
each
data
attribute
as
a
separate
dimension.
For
example,
product,
sales
quantity,
area,
time
period
etc.
,
all
these
could
be
considered
as
a
“dimension”.
Furthermore,
attributes
can
be
broken
into
sub-‐attributes.
OLAP
software
can
locate
the
intersection
of
dimensions
and
display
them.
Data
Mining
is
also
a
typical
analytical
technology
which
means
the
process
of
analyzing
data
from...