Articles (Data Warehousing)

Articles Sites:

Data Security: Protecting the Warehouse from Within Data Security: Protecting the Warehouse from Within: 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. (Articles) http://www.dmreview.com/master.cfm?NavID=198&EdID=780 Backward in Time Backward in Time: Ralph Kimball's Intelligent Enterprise article that offers tips for stitching late-arriving records into an existing data warehouse. (Articles) http://www.intelligententerprise.com/000929/webhouse.shtml The Four Legs of a Successful Business Intelligence (BI) Project Team The Four Legs of a Successful Business Intelligence (BI) Project Team: 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 (Articles) http://www.athena-solutions.com/bi-brief/april03.html Managing Meta Data Within and Across Warehousing Efforts Managing Meta Data Within and Across Warehousing Efforts: 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. (Articles) http://www.tdan.com/i013hy02.htm Differences of Opinion Differences of Opinion: Ralph Kimball's Intelligent Enterprise article comparing the dominant approaches to enterprise data warehousing. (Articles) http://www.intelligententerprise.com/info_centers/dataWarehousing/showArticle.jhtml?articleID=17800088 Monster Dimensions Monster Dimensions: DBMS Online article by Ralph Kimball discussing design solutions for handling changes in very large dimensions. (Articles) http://www.dbmsmag.com/9605d05.html Refreshment Strategies in the Data Warehouse Environment Refreshment Strategies in the Data Warehouse Environment: 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. (Articles) http://www.inmoncif.com//library/articles/dwrefres.asp Data Warehouse Delivery: When to Federate Data Warehouse Delivery: When to Federate: DM Review article by Douglas Hackney discussing conditions that can merit a federated BI architecture. (Articles) http://dmreview.com/master.cfm?NavID=55&EdID=2185 Data Warehouse Delivery: The Federated Future Data Warehouse Delivery: The Federated Future: DM Review article by Douglas Hackney that addresses federated data warehouse architecture. (Articles) http://dmreview.com/master.cfm?NavID=55&EdID=1761 Data Mart Does Not Equal Data Warehouse Data Mart Does Not Equal Data Warehouse: Bill Inmon article originally published in DM Review about the differences between a data mart and a data warehouse. (Articles) http://www.dmreview.com/master.cfm?NavID=55&EdID=1675 The Unity Dimension The Unity Dimension: Nick Galemmo's Intelligent Enterprise article that offers a modeling solution for when differing entities share a role. (Articles) http://www.intelligententerprise.com/010613/warehouse1_1.shtml Factless Fact Tables Factless Fact Tables: DBMS Online article by Ralph Kimball discussing two types of useful fact tables that contain no facts at all. (Articles) http://www.dbmsmag.com/9609d05.html How to do a Warehouse Assessment (And Why) How to do a Warehouse Assessment (And Why): Arthur Moore and David Wells. The essence of data warehousing assessment is directed at refining the warehousing process and revitalizing the warehousing initiative. (Articles) http://www.tdan.com/i013fe03.htm A Definition of Data Warehousing A Definition of Data Warehousing: Michael Reed of TechnologyEvaluation.Com gives a brief overview of the definition of a data warehouse. (Articles) http://www.intranetjournal.com/features/datawarehousing.html Data Warehouse Delivery: Federated FAQs Data Warehouse Delivery: Federated FAQs: DM Review article by Douglas Hackney with some frequently asked questions about federated data warehouses. (Articles) http://www.dmreview.com/master.cfm?NavID=55&EdID=2077 11 Steps to Successful Data Warehousing 11 Steps to Successful Data Warehousing: 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. (Articles) http://www.advisor.com/Articles.nsf/aid/BLACP01 Rating Your Dimensional Data Warehouse Rating Your Dimensional Data Warehouse: Intelligent Enterprise Magazine article by Ralph Kimball that explains the first 12 of twenty criteria for comparing data webhouses. (Articles) http://www.intelligententerprise.com/000428/webhouse.shtml The Problem with Dimensional Modeling The Problem with Dimensional Modeling: Bill Inmon's DM Review article discussing dimensional modeling. (Articles) http://www.dmreview.com/master.cfm?NavID=55&EdID=2184 Intelligent Enterprise Magazine Intelligent Enterprise Magazine: 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. (Articles) http://www.intelligententerprise.com/ Data Warehouse Quality Management Data Warehouse Quality Management: 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. (Articles) http://www.users.qwest.net/~lauramh/resume/dwqual.htm Many Alternate Realities Many Alternate Realities: Intelligent Enterprise Magazine article by Ralph Kimball on the data warehouse design challenge of describing the past accurately. (Articles) http://www.intelligententerprise.com/000209/webhouse.shtml Help for Hierarchies Help for Hierarchies: Ralph Kimball article from DBMS Online discussing how to use helper tables to handle dimensions with complex hierarchies. (Articles) http://www.dbmsmag.com/9809d05.html The Federated Data Warehouse The Federated Data Warehouse: DM Review article by Colin White about federated data warehouses. (Articles) http://dmreview.com/master.cfm?NavID=198&EdID=1953 Is Your Dimensional Data Warehouse Expressive? Is Your Dimensional Data Warehouse Expressive?: Intelligent Enterprise Magazine article by Ralph Kimball completes the 20 criteria for rating your dimensional data warehouse by adding 8 expression criteria. (Articles) http://www.intelligententerprise.com/000515/webhouse.shtml Data Warehouse Delivery: How to Federate Data Warehouse Delivery: How to Federate: DM Review article by Douglas Hackney that looks in more detail at how you build a federated BI architecture. (Articles) http://www.dmreview.com/master.cfm?NavID=55&EdID=2276 Developing a Data Warehouse Architecture Developing a Data Warehouse Architecture: 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. (Articles) http://www.users.qwest.net/~lauramh/resume/thorn.htm Teradata Review Teradata Review: Technical magazine for data warehouse professionals interested in NCR's Teradata database management system. (Articles) http://www.teradatamagazine.com/ Managing Current and Historical Views of Information in The Data Warehouse Managing Current and Historical Views of Information in The Data Warehouse: Michael Jennings' DM Review article on managing current and historical views of information. (Articles) http://www.dmreview.com/master.cfm?NavID=198&EdID=3849 Surrogate Keys Surrogate Keys: DBMS Online article by Ralph Kimball about keeping control over record identifiers by generating new keys for the data. (Articles) http://www.dbmsmag.com/9805d05.html