- Rating Your Dimensional Data Warehouse - http://www.intelligententerprise.com/000428/webhouse.shtml
Intelligent Enterprise Magazine article by Ralph Kimball that explains the first 12 of twenty criteria for comparing data webhouses.
- Is Your Dimensional Data Warehouse Expressive? - http://www.intelligententerprise.com/000515/webhouse.shtml
Intelligent Enterprise Magazine article by Ralph Kimball completes the 20 criteria for rating your dimensional data warehouse by adding 8 expression criteria.
- Factless Fact Tables - http://www.dbmsmag.com/9609d05.html
DBMS Online article by Ralph Kimball discussing two types of useful fact tables that contain no facts at all.
- Surrogate Keys - http://www.dbmsmag.com/9805d05.html
DBMS Online article by Ralph Kimball about keeping control over record identifiers by generating new keys for the data.
- Monster Dimensions - http://www.dbmsmag.com/9605d05.html
DBMS Online article by Ralph Kimball discussing design solutions for handling changes in very large dimensions.
- Managing Meta Data Within and Across Warehousing Efforts - http://www.tdan.com/i013hy02.htm
Many organizations must manage multiple warehousing initiatives underway simultaneously and these systems will most likely be based on products from multiple data warehousing vendors, in the typical decentralized approach of most corporations.
- How to do a Warehouse Assessment (And Why) - http://www.tdan.com/i013fe03.htm
Arthur Moore and David Wells. The essence of data warehousing assessment is directed at refining the warehousing process and revitalizing the warehousing initiative.
- Many Alternate Realities - http://www.intelligententerprise.com/000209/webhouse.shtml
Intelligent Enterprise Magazine article by Ralph Kimball on the data warehouse design challenge of describing the past accurately.
- Data Security: Protecting the Warehouse from Within - http://www.dmreview.com/master.cfm?NavID=198&EdID=780
DM Direct article by Chris Silbernagel that outlines some of the primary issues and decision points of implementing a relational on-line analytical processing data warehouse with data security.
- The Federated Data Warehouse - http://dmreview.com/master.cfm?NavID=198&EdID=1953
DM Review article by Colin White about federated data warehouses.
- Data Warehouse Delivery: Federated FAQs - http://www.dmreview.com/master.cfm?NavID=55&EdID=2077
DM Review article by Douglas Hackney with some frequently asked questions about federated data warehouses.
- 11 Steps to Successful Data Warehousing - http://www.advisor.com/Articles.nsf/aid/BLACP01
Mining your corporate data for valuable customer information can improve your business performance. But it's not as simple as it sounds. Database Advisor article by Phillip Blackwood.
- Intelligent Enterprise Magazine - http://www.intelligententerprise.com/
Offers both print and online-only articles, news and analysis focused on the business software strategies that enable IT and business decision-makers to plan, build, manage and purchase business critical enterprise applications.
- Data Warehouse Delivery: How to Federate - http://www.dmreview.com/master.cfm?NavID=55&EdID=2276
DM Review article by Douglas Hackney that looks in more detail at how you build a federated BI architecture.
- Data Mart Does Not Equal Data Warehouse - http://www.dmreview.com/master.cfm?NavID=55&EdID=1675
Bill Inmon article originally published in DM Review about the differences between a data mart and a data warehouse.
- Help for Hierarchies - http://www.dbmsmag.com/9809d05.html
Ralph Kimball article from DBMS Online discussing how to use helper tables to handle dimensions with complex hierarchies.
- The Unity Dimension - http://www.intelligententerprise.com/010613/warehouse1_1.shtml
Nick Galemmo's Intelligent Enterprise article that offers a modeling solution for when differing entities share a role.
- Data Warehouse Quality Management - http://www.users.qwest.net/~lauramh/resume/dwqual.htm
Laura Hadley examines ways in which organizations can think about quality in the data warehouse environment, as well as ideas for possible metrics to measure quality and extend warehouse value.
- Teradata Review - http://www.teradatamagazine.com/
Technical magazine for data warehouse professionals interested in NCR's Teradata database management system.
- Developing a Data Warehouse Architecture - http://www.users.qwest.net/~lauramh/resume/thorn.htm
A data warehouse architecture is a description of the elements and services of the warehouse, with details showing how the components will fit together and how the system will grow over time.
- Backward in Time - http://www.intelligententerprise.com/000929/webhouse.shtml
Ralph Kimball's Intelligent Enterprise article that offers tips for stitching late-arriving records into an existing data warehouse.
- A Definition of Data Warehousing - http://www.intranetjournal.com/features/datawarehousing.html
Michael Reed of TechnologyEvaluation.Com gives a brief overview of the definition of a data warehouse.
- Refreshment Strategies in the Data Warehouse Environment - http://www.inmoncif.com//library/articles/dwrefres.asp
William Inmon. Once the data warehouse is built, attention shifts from the building of the data warehouse to the day to day operations of making the data warehouse work.
- Differences of Opinion - http://www.intelligententerprise.com/info_centers/dataWarehousing/showArticle.jhtml?articleID=17800088
Ralph Kimball's Intelligent Enterprise article comparing the dominant approaches to enterprise data warehousing.
- The Four Legs of a Successful Business Intelligence (BI) Project Team - http://www.athena-solutions.com/bi-brief/april03.html
A successful BI project team is like a four-legged table - each leg holds up its share of the weight. Remove one and the project wobbles. The four legs of a team are Project Sponsorship and Governance, Project Management, Development Team (Core Team), and Extended Project Team.
- Classic articles in data warehousing - http://www.dmreview.com/editorial/classics.cfm
The articles are selected by DM Review editors as the most informative articles that have run in DM Review regarding business intelligence and data warehousing.
- Kimball Group: articles and columns - http://www.kimballgroup.com/html/articles.html
The site gives access to Ralph Kimball and other Kimball Group members's columns and articles on data warehouse for the period 1995-2005.
- Beware the Objection Removers - http://www.intelligententerprise.com/print_article.jhtml?articleID=167100313
Intelligent Enterprise article by Ralph Kimball that encourages you to ask questions when sales pitches fly in the face of conventional wisdom.
|
