Advertisement

Free Site RegistrationFree Site Registration

Sign up today and access Information Management on the web!
Your FREE registration entitles you to:

FREE email newsletters

FREE access to all Information Management content

FREE access to web seminars, resource portals, our white paper library and more!

Data Warehouse Appliances Channel

Channel Sponsored by

Data warehouse appliances are packaged (component, rack-mount or blade) combinations of hardware and software optimized for a particular purpose involving very high throughput of data and analytic functions. Arriving only recently (around 2002), DW appliances have quickly become a large and important segment of the data warehousing market due to cost and data processing efficiencies, which continue to scale against slower and costlier traditional methods. Appliances optimize different areas of data processing, but are not yet meant to supplant traditional business intelligence (BI) functions including warehousing, extract, transform, load (ETL), analysis and reporting. Led by startups, the data appliance market has increasingly attracted large traditional competitors that are expected to deliver most or all data warehousing in a high-performance form factor in the near to intermediate future.

Articles

A Generalized Approach to the Creation of Bridge Records

Applied to data warehousing, a bridge table relates a fact record to one or more dimension records. Where a fact has a one-to-many relationship with a dimension, or many-to-many, you may choose to handle that with a bridge table

Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?

Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing.

Columns

Drill Down to Ask Why, Part 2

In this month’s column, I’ll continue with this example and explore how to implement analytic capabilities to explore “why” in a real data warehouse/business intelligence system.