Top : Computers : Software : Databases : Data Warehousing :
Articles
Websites
Intelligent Enterprise Magazine article by Ralph Kimball that explains the first 12 of twenty criteria for comparing data webhouses.
http://www.intelligententerprise.com/000428/webhouse.shtml
Intelligent Enterprise Magazine article by Ralph Kimball completes the 20 criteria for rating your dimensional data warehouse by adding 8 expression criteria.
http://www.intelligententerprise.com/000515/webhouse.shtml
DBMS Online article by Ralph Kimball discussing two types of useful fact tables that contain no facts at all.
site exerpt
DBMS September 1996 Data Warehouse Architect I have given many examples of fact tables in dimensional data warehouses. You should recall that fact tables are the large tables in the middle of a dimensional schema. Fact tables always have a multipart key, in which each component...Bill Inmon's DM Review article discussing dimensional modeling.
http://www.dmreview.com/master.cfm?NavID=55&EdID=2184
DBMS Online article by Ralph Kimball about keeping control over record identifiers by generating new keys for the data.
site exerpt
DBMS May 1998 Data Warehouse Architect Keep control over record identifiers by generating new keys for the data warehouse According to the Websterýs Unabridged Dictionary, a surrogate is an artificial or synthetic product that is used as a substitute for a natural product Thatýs a great...DBMS Online article by Ralph Kimball discussing design solutions for handling changes in very large dimensions.
http://www.dbmsmag.com/9605d05.html
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.
site exerpt
TDAN CA Managing Meta Data Most large organizations today have had some experience with data warehousing implementations. Today, these typically take the form of data mart style implementations in various departmental focus areas such as financial analysis or customer focused systems assisting business units. Many...Arthur Moore and David Wells. The essence of data warehousing assessment is directed at refining the warehousing process and revitalizing the warehousing initiative.
site exerpt
TDAN Moore Wells Warehouse Assessments In the relative time scale of technology change, data warehousing has been around for a while. Discussion of “the mature data warehouse” and “second generation warehousing” is becoming increasingly common. Many, if not most, large organizations have something that they...Intelligent Enterprise Magazine article by Ralph Kimball on the data warehouse design challenge of describing the past accurately.
http://www.intelligententerprise.com/000209/webhouse.shtml
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.
http://www.dmreview.com/master.cfm?NavID=198&EdID=780
DM Review article by Douglas Hackney that addresses federated data warehouse architecture.
http://dmreview.com/master.cfm?NavID=55&EdID=1761
DM Review article by Colin White about federated data warehouses.
http://dmreview.com/master.cfm?NavID=198&EdID=1953
DM Review article by Douglas Hackney with some frequently asked questions about federated data warehouses.
http://www.dmreview.com/master.cfm?NavID=55&EdID=2077
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.
site exerpt
Databased Advisor 11 Steps to Successful Data Warehousing Business Intelligence Database Database Development Marketing Software Data Acquisition Data Analysis Data Mining Data Replication Mining your corporate data for valuable customer information can improve your business performance. But it's not as simple as it sounds. By Phillip Blackwood There's 1 reader comment on this topic. Add yours! ADVERTISEMENT More and more companies are using...DM Review article by Douglas Hackney discussing conditions that can merit a federated BI architecture.
http://dmreview.com/master.cfm?NavID=55&EdID=2185
DM Review article by Douglas Hackney that looks in more detail at how you build a federated BI architecture.
http://www.dmreview.com/master.cfm?NavID=55&EdID=2276
Bill Inmon article originally published in DM Review about the differences between a data mart and a data warehouse.
http://www.dmreview.com/master.cfm?NavID=55&EdID=1675
Ralph Kimball article from DBMS Online discussing how to use helper tables to handle dimensions with complex hierarchies.
site exerpt
DBMS September 1998 Data Warehouse Architect Helper tables handle dimensions with complex hierarchies In last month's column, I talked about the difficult modeling situation in which one dimension you want to attach to a fact table takes on multiple values for each fact table record. The...Nick Galemmo's Intelligent Enterprise article that offers a modeling solution for when differing entities share a role.
http://www.intelligententerprise.com/010613/warehouse1_1.shtml
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.
site exerpt
Data Warehouse Quality Management This article 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. In addition to their involvement in data warehouse research and...Technical magazine for data warehouse professionals interested in NCR's Teradata database management system.
http://www.teradatamagazine.com/
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.
site exerpt
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. There is always an architecture, either ad hoc...Ralph Kimball's Intelligent Enterprise article that offers tips for stitching late-arriving records into an existing data warehouse.
http://www.intelligententerprise.com/000929/webhouse.shtml
Michael Jennings' DM Review article on managing current and historical views of information.
http://www.dmreview.com/master.cfm?NavID=198&EdID=3849
Michael Reed of TechnologyEvaluation.Com gives a brief overview of the definition of a data warehouse.
site exerpt
Intranet Journal: Feature: Finding Your Way Around E-commerce WHITEPAPER: Regulatory Compliance Best Practices: Mitigating Information Security and Availability Risks, and Achieving Sustainable Compliance IT MANAGEMENT CIO Update Datamation eCRMGuide DRM Watch eSecurity Planet ITSMWatch Intranet Journal Inside ID Grid Computing Planet NETWORKING EnterpriseNetworkingPlanet InstantMessagingPlanet EnterpriseStorageForum OpticallyNetworked PracticallyNetworked WEB...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.
http://www.inmoncif.com//library/articles/dwrefres.asp
Ralph Kimball's Intelligent Enterprise article comparing the dominant approaches to enterprise data warehousing.
http://www.intelligententerprise...Article.jhtml?articleID=17800088
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.
site exerpt
BI Brief Four Legs of a Successful Business Intelligence (BI) Project Team The following brief is part of a series from Athena IT Solutions. If you would like to receive additional briefs in this series probably one or two a month please sign up at this page or send mail to info@athena-solutions.com....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.
site exerpt
Business intelligence, data warehousing and analytics editorial from DMReview These have been selected by our editors as some of the most informative articles that have run in DM Review. Beyond CRM: A New Strategy for Service Doug Tanoury Intelligent Solutions: Crystal Clear Customers: The Role of the Operational Data...The site gives access to Ralph Kimball and other Kimball Group members's columns and articles on data warehouse for the period 1995-2005.
site exerpt
Kimball Group: Data Warehouse Training: Articles Group members have written over 120 columns for Intelligent Enterprise Magazine and its predecessor, DBMS Magazine. Articles by date 20052004200320022001200019991998199719961995 Articles by topic Data Warehouse Fundamentals Data Warehouse Architecture and Modeling -Bus Architecture and Conformed Dimensions/Facts -Advanced Dimension Table Topics...Intelligent Enterprise article by Ralph Kimball that encourages you to ask questions when sales pitches fly in the face of conventional wisdom.
site exerpt
Is that sales pitch flying in the face of conventional wisdom? Start asking questions now. By RalphKimball An objection remover is a claim made during the sales cycle intended to counter a fear or concern that you have. Objection removers...