Why Can Data in a Dimensional Database with a Star

question 3

Essay

Why can data in a dimensional database with a star or snowflake structure be retrieved more quickly than from a relational database?

---

Definitions:

Certificate Of Deposit

A savings certificate with a fixed maturity date and specified fixed interest rate, issued by a bank to a depositor.

Bank

A financial institution licensed to receive deposits and make loans, offering various other financial services.

Currency Requirement

The necessity for a form of payment to be accepted as valid currency within a financial transaction.

Negotiability

The ability of a financial instrument to be transferred from one party to another with the title passing legally to the transferee.