[AccessD] Mucking around

John Bartow john at winhaven.net
Fri Sep 28 14:03:50 CDT 2007


Terminology happens :o) 

Conceptually I think the easiest way to understand it is using the
Query/Report analogy.

You create a Query which makes it possible/easier/more efficient to create a
specific Report. Its a means to produce a product.

Remember, rarely does any lay person care about HOW data is stored, they
generally only care about how it is presented (product). Its up to the DBA
to store it correctly so that it can be presented in any one of the myriad
of ways it can be used/presented in the future. The granularity of a
properly normalized data structure allows for the most flexibility in this
regards.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
max.wanadoo at gmail.com

The terminology is throwing me a bit too (well, to be honest, it is throwing
me a lot).
With the help of you guys, I will undertand it eventually.

What is conceptually throwing me at the moment though is this:  If the
reason people use datamarts (Star/Snow) to quickly create reports which
dice/slice down through the data, then are we or are we not just moving the
"time Taken" from the report stage to the data input stage (which would make
sense to me).  But if I am completely wrong here, then I really am "all at
sea!"





More information about the AccessD mailing list