Archives of the TeradataForum

Message Posted: Tue, 22 Aug 2006 @ 14:40:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

TeradataForum wrote:

>From the Teradata Database Design Manual:

Special Design Considerations?

Are there any special database design considerations for building a Teradata data warehouse? The short answer is no, there are no special concerns, but certain aspects of commonly recommended data warehousing strategies should be evaluated for their veracity before you begin designing the database that supports your data warehouse. For these evaluations, see the following:

- "Usage Considerations for Design: OLTP and DSS" on page 25

- "Usage Considerations for Design: Summary Data and Detail Data" on page 29

- "Usage Considerations for Design: Simple and Complex Queries" on page 31

- "Usage Considerations for Design: Ad Hoc Queries" on page 35

- Chapter 17: "Design Issues for Tactical Queries."

The Teradata parallel technology is optimized to perform tasks in a normalized environment that other relational DBMSs cannot match with a denormalized schema. Among the special performance advantages built into the Teradata system are the following: star join and other join optimizations, full table scan optimization, specially designed index types, a full complement of SQL aggregate and ordered analytical functions, and the most sophisticated parallel-aware SQL query optimizer available.

jdg

www.jgraas.com

	<Prev	Next>		<<First	<Prev	Next>	Last>>