Datawarehouse

Only available on StudyMode
  • Download(s) : 21
  • Published : February 27, 2013
Open Document
Text Preview
REQUIREMENT
 1
 
 

Prepare
 a
 minimum
 of
 10
 page
 (short
 bond
 paper)
 report
 for
 the
 following
 items
 stated
 below:
 
  1. Discuss
 what
 is
 meant
 by
 the
 following
 terms
 when
 describing
 the
 characteristics
 of
 the
 data
 in
 a
  data
 warehouse:
 
  a.
 Subject-­‐oriented
 
  b.
 Integrated
 
  c.
 Time-­‐variant
 
  d.
 Non-­‐volatile
 
  2.
 Discuss
 how
 online
 transaction
 processing
 (OLTP)
 systems
 differ
 from
 data
 warehousing
 systems
 
  3.
 Present
 a
 diagrammatic
 representation
 of
 the
 typical
 architecture
 and
 main
 components
 of
 a
 data
  warehouse.
 
  4.
 Describe
 the
 characteristics
 and
 main
 functions
 of
 the
 following
 components
 of
 a
 data
 warehouse:
 
  a.
 Load
 manager
 
  b.
 Warehouse
 manager
 
  c.
 Query
 manager
 
  d.
 Meta-­‐data
 
  e.
 End-­‐user
 access
 tools
 
  5.
 Differentiate
 data
 marts
 from
 data
 warehouses
 and
 identify
 the
 reasons
 for
 implementing
 a
 data
 mart,
  rather
 than
 a
 data
 warehouse.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

REQUIREMENT
 2
 
 
 

Instruction:
 
  Identify
  the
  correct
  term/s
  described
  by
  the
  descriptions
  after
  each
  number.
  Wirte
  your
  answers
 on
 the
 space
 provided.
 
  __________________________________
 1.
 It
 stands
 for
 Extraction,
 Transformation,
 and
 Loading.
 The
 movement
 of
  data
 from
 one
 area
 to
 another.
 
  __________________________________
  2.
  It
  is
  numeric
  data
  based
  on
  columns
  in
  a
  fact
  table.
  They
  are
  the
  primary
  data
  which
  end
  users
  are
  interested
  in.
  E.g.
  a
  sales
  fact
  table
  may
  contain
  a
  profit
  column
  which
  represents
 profit
 on
 each
 sale.
 
  __________________________________
 3.
 These
 are
 data
 processing
 units
 composed
 of
 fact
 tables
 and
 dimensions
  from
  the
  data
  warehouse.
  They
  provide
  multidimensional
  views
  of
  data,
  querying
  and
  analytical
  capabilities
 to
 clients.
 
  __________________________________
  4.
  One
  way
  of
  speeding
  up
  query
  performance.
  Facts
  are
  summed
  up
  for
  selected
  dimensions
  from
  the
  original
  fact
  table.
  The
  resulting
  aggregate
  table
  will
  have
  fewer
  rows,
  thus
  making
 queries
 that
 can
 use
 them
 go
 faster.
 
  __________________________________
  5.
  It
  represents
  a
  single
  type
  of
  information
  in
  a
  dimension.
  For
  example,
  year
 in
 the
 Time
 dimension.
 
  __________________________________
  6.
  A
  dimension
  that
  has
  exactly
  the
  same
  meaning
  and
  content
  when
  being
  referred
tracking img