The analytic sandbox should be minimally governed. The idea is to create an environment that lives without all the overhead of the data warehouse environment. It should not be used to support the organization’s mission critical capabilities. It shouldn’t be used to directly control or support any core operational capabilities. Likewise, it is not intended to be utilized for ongoing reporting or analytics required by the business on an ongoing basis, especially any reporting that supports external reporting to meet financial or government regulations.
Source: Design Tip #174 Does Your Organization Need an Analytic Sandbox? – Kimball Group
Built one of these in 1992. It was retired in 2014.
This Design Tip reflects on the remarkable durability of the basic Extract-Transform-Load paradigm, while at the same time recognizing some profound changes that must be addressed. These changes are due to new data demands, new classes of users, and new technology opportunities.
via Design Tip #169 New Directions for ETL | Kimball Group.
Ralph Kimball introduced the data warehouse/business intelligence industry to dimensional modeling in 1996 with his seminal book, The Data Warehouse Toolkit. Since then, the Kimball Group has extended the portfolio of best practices.Drawn from The Data Warehouse Toolkit, Third Edition, the “official” Kimball dimensional modeling techniques are described on the following links and attached .pdf:
via Dimensional Modeling Techniques – Kimball Group.
Whilst a truncate table operation is underway a lock mutex around the table is created to ensure data consistency; if using innodb file per table the physical .ibd file must be removed which is a painfully slow operation under ext3.
via A quicker drop table within MySQL:
Customer interactions create a wealth of timely data that marketing departments are eager to exploit. The customer status fact table provides a central switchboard for using this fast-moving data.
via IntelligentEnterprise : Kimball University: Extreme Status Tracking For Real Time Customer Analysis (printable version).