What does slicing do to a data cube?

Selects one value on one dimension, giving a sub-cube with one fewer dimension

Selects values on two or more dimensions, keeping all dimensions

Aggregates over all dimensions into a single value

Slicing a (time, item, location) cube with time = Q1 gives what?

A 2-D table of item vs location for Q1

A table of time vs item for all locations

Which feature distinguishes slice from dice?

Slice picks a single value on one dimension; dice picks on two or more

Slice raises dimensions; dice reduces them

Slice uses hierarchy; dice does not

Year not given

Define slicing

Short answer

Slicing is an OLAP operation that selects one value on one dimension of a data cube, producing a sub-cube with one dimension fewer. Example: slicing a sales cube by time = 'Q1' gives a two-dimensional item-versus-location table for Q1 only.

Define slicing with example.

Slicing is an OLAP operation that selects one value on one dimension of a data cube, producing a sub-cube (a "slice") with one dimension fewer. It is like a WHERE condition on a single dimension.

Example: sales cube with dimensions time (quarter), item (type) and location (city). Slice with time = "Q1" returns a two-dimensional table of item vs location showing the sales of Q1 only.

 Cube(time, item, location)  --slice time=Q1-->  Table(item, location)

✓ Answer checked by Claude Opus 5.5 (high effort)

All Data Mining chapter 2 questions →