July 2008
Learn how to model your database to support both market basket and affinity analysis.
June 2008
Find out how to map control numbers to a fact table and associate them with each line item.
May 2008
Find out how you can keep your data warehouse design simple by placing miscellaneous attributes into junk dimensions.
April 2008
Save yourself from having to deal with large, difficult-to-manage fact tables by partitioning the rows.
February 2008
You can manage rapidly changing monster dimensions by splitting the stable and hot attributes or by creating non-overlapping value ranges for each rapidly changing attribute.
January 2008
When dealing with slowly changing dimensions, you can respond in three different ways. Find out what these responses to change are, and under what circumstances each response type should be used.
December 2007
Dimensional roles can play many different parts in an accumulating snapshot fact table. Find out how dimensional role-playing can benefit your star schema.
December 2007
If you ever have rows in the dimension that participate in more than one role, it's best to use indexed views rather than partitioned tables.
November 2007
Find out how conformed dimensions and facts make up an enterprise data warehouse.
October 2007
As you plan and create your data warehouse, you'll need to decide the level of detail you want—how finely grained you want your dimensions to be—and you'll need to flatten hierarchies to make data more accessible for users.
October 2007
You just don't save significant space by normalizing hierarchies in a data warehouse.
August 17, 2007
Think of a bitmap index as a grid, wherein the grid columns represent each discrete data value and the grid rows represent the position of each row in the table.
July 27, 2007
Give us your feedback about these data warehousing topics, which Michelle Poolet will discuss in future Solutions by Design articles.
July 2007
The star schema is the standard for supporting multidimensional cubes and supporting BI analysis across the organization.
September 2007
With dimensional modeling, you can build a user-friendly data structure that makes data access intuitive. Start by learning the components of the dimensional model and why they're designed as they are.
May 2007
SQL Server sprawl is becoming an increasing headache for DBAs everywhere. But database consolidation's no picnic either. A centralized structure will ensure you keep your consolidation as simple as possible.
March 2007
Wouldn’t it be wonderful to create a graphic representation of your business rules? A Fact Model approach can help database pros extend their thinking about data beyond the boundaries of traditional data modeling.
January 2007
By using the Master Data Management approach to integrate data into a single, trusted source, you'll be able to capitalize on missed business opportunities.
November 2006
Are you unsure how to use supertypes and subtypes to your advantage? Learn why they are used and how to implement them correctly.
September 2006
Naming conventions, regulatory compliance, primary keys are some of the topics in this month's Solutions by Design column. Read about these data modeling concepts and join the discussions at SQL Server Magazine's Database Design forum.
Add these Headlines to your Website
