Operational vs Analytical DB Design

[bruceR]

I am currently reading "Star Schema: The Complete Reference" by Adamson. I am finding many of the concepts extremely helpful, and I do not seem to find many of these concepts discussed in the FileMaker community. Maybe I travel in the wrong circles; maybe they really are not being discussed much.

http://www.amazon.com/dp/0071744320/

Concepts include data warehouses; operational vs analytical database; fact tables vs dimension tables; designing for dimension table conformance; ETL; drilling across processes as well as drilling down and rolling up; data warehouses as places where non-3NF data are acceptable.