Discuss the concepts associated with dimensionality modeling.

What will be an ideal response?


Every dimensional model (DM) is composed of one table with a composite primary key,
called the fact table, and a set of smaller tables, called dimension tables. Each dimension table
has a simple (noncomposite) primary key that corresponds exactly to one of the components
of the composite key in the fact table. In other words, the primary key of the fact table is made
up of two or more foreign keys. This characteristic “star-like” structure is called a star schema
or star join. Another important feature of a DM is that all natural keys are replaced with
surrogate keys. This means that every join between fact and dimension tables is based on
surrogate keys, not natural keys. Each surrogate key should have a generalized structure based
on simple integers. The use of surrogate keys allows the data in the warehouse to have some
independence from the data used and produced by the OLTP systems.

Computer Science & Information Technology

You might also like to view...

__________ sockets and the __________ protocol are more desirable for the vast majority of Java programmers.

a. Stream, UDP. b. Stream, TCP. c. Datagram, UDP. d. Datagram, TCP.

Computer Science & Information Technology

What are the problems of server-side scripts that client-side programs solve?

What will be an ideal response?

Computer Science & Information Technology

Heading 1 is an example of a(n) ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

All operands used in an expression must ____ before the expression is evaluated.

A. have values assigned to them B. be simplified C. be parameterized D. be printed out

Computer Science & Information Technology