Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Headquarters and Field Sales Sort

2 posters

Go down

Headquarters and Field Sales Sort Empty Headquarters and Field Sales Sort

Post  apc Fri Aug 16, 2013 4:16 am


I was reading one of Kimball's articles in the Kimball Group Reader and got somewhat curious about something he says ("7.1 Letting the Users Sleep", Ralph Kimball, DBMS, Dec 1996 and Jan 1997):

"The physical sort order on the disk can be a significant design tool in a data warehouse. In
my data warehouse design classes, I discuss a “headquarters sort” and a “field sales sort.”
The data warehouse designer usually must choose one of these sorts at the expense of the
other. In extreme circumstances, the designer can affect performance by a factor of four
or more, depending on this choice."

Can someone help me understand what is Kimball mentioning when he refers to the “headquarters sort” and “field sales sort.”?

Is this have something to do with partitioning or indexing?



Posts : 8
Join date : 2012-10-11

Back to top Go down

Headquarters and Field Sales Sort Empty Re: Headquarters and Field Sales Sort

Post  ngalemmo Fri Aug 16, 2013 10:35 am

Considering the age of the article, it probably has to do with clustered index tables. Partitioning does not sort contents of a table.

Given 16 years worth of Moore's Law has passed since then (a 256X or more improvement in performance and capacity and the change to a 64 bit address space), clustered indexes are not as useful as they used to be. Simply providing a bunch of memory on the database server goes a long way to improving performance of sorts and joins.

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum