In Part 1 of this article (see the March issue of DM Review), we established basic and essential definitions for analytical modeling. In this second part, we will address a number of issues critical to analytical modeling of real applications. Along the way, we will discuss how they are handled in logical modeling, physical design and dimensional design. (Figures 1-10 are in Part 1 of the article.)
Surrogate keys are often touted to be a means to database (DB) performance. A surrogate key is a single immutable, non-intelligent identifier used to substitute for the natural key, especially (but not only) a compound natural key.
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access