- 10 open source companies to watch
- Mythbuster busts his own tale
- $208 million petascale computer gets green light
- Sony recalls 73,000 Vaio laptops
- Chrome and Firefox and add-ons
Newsletters | Podcasts | Chats | Opinions | RSS Feeds | This Week In Print | IT Careers | Community | Reports | Downloads | Slideshows | New Data Center
Partner Sites:App Performance | On Demand Security | Networking Solution | SOA | Value of WDS
Business intelligence is essentially a set of best practices for building models to answer business questions. However, today's BI best practices may be suboptimal for many enterprises' decision-support requirements.
For most users, BI is a journey that's been modeled and mapped out in advance by others, following a well-marked path through vast data sets. Data models, which must often be pre-built by specialists, generate or shape the design of such key BI artifacts as queries, reports and dashboards. Essentially, every BI application is some data modeler's prediction of the types of questions that users will want to ask of the underlying data marts. Sometimes, those predictions are little more than an educated guess -- and are not always on the mark.
BI's most ubiquitous data-modeling approach is the online analytical processing (OLAP) data structure known as a "cube." The OLAP cube -- essentially a denormalized relational database -- sits at the heart of most BI data marts. OLAP cubes, usually implemented as multidimensional "star" or "snowflake" schemas, allow large recordsets to be quickly and efficiently summarized, sorted, queried and analyzed.
However, no matter how well designed the dimensional data models within any particular cube, users eventually outgrow these constraints and demand the ability to drill down, up and across tabular record sets in ways not built into the underlying data structures.
The chief disadvantage of multidimensional OLAP cubes is their inflexibility. Cubes are built by pre-joining relational data tables into fixed, subject-specific structures. One way of getting around these constraints is the approach known as relational OLAP, which retains the underlying normalized relational storage approach while speeding multidimensional query access through "projections." However, relational OLAP also suffers from the need for explicit, upfront modeling of relationships within and among the underlying tabular data structures.
From the average user's point of view, all of this is mere plumbing -- invisible and boring -- until it prevents them from obtaining the new query tools, structured reports and dashboards needed to do their jobs. One unfortunate consequence of OLAP cubes' inflexibility is that requests for new BI applications inevitably wind up in a backlog of IT projects that can take weeks or months to deliver.

It's safe to say that most companies, if presented with hard numbers on their energy consumption...
Secure Wireless Printing OptionsDiscover how you can reduce the TCO of your wireless printers in this whitepaper. Learn how to...
Tuning ERP and the Supply Chain for Profitable GrowthThe supply chain is, of course, the primary processing mechanism of every manufacturing company....

Double-Take (r) Software and Microsoft are teaming up on September 9, 2008 for a webinar focusing...
PoE Plus: Impact on the PoE MarketThe standard for Power over Ethernet (PoE), IEEE Std. 802.3af(tm)-2003, advanced networking,...
Harnessing the power of communications to increase workplace performanceDue to the convergence of IT and telecommunications technologies, the business workplace has been...

Increasingly popular technologies such as virtualization, wireless networking and data center...
Virtualization Reality CheckFind out why analysts say approaching virtualization with an ounce of caution is wise. And also why...
Closing the Loop: Extending Wireless LAN Security to Wireless PrintersEnterprises cannot overlook wireless printers when assessing network security. The print jobs and...
Partner Content
CA Network & Voice Resource Center
Comprehensive Network & Voice Management Visit CA Network & Voice Management Resource Center and get insights into industry best practices, information that helps you to address your challenges.
CA Network & Voice Management Resource Center
Managing Voice Over IP for Successful Convergence
Voice over IP (VoIP) has much to offer in cost savings but some customers have concerns about VoIP call quality compared to the quality of traditional voice services. This white paper will help you learn how to take the right steps so that voice quality is assured.
Managing VoIP for Successful Convergence
The Changing Face of Network Management
Managing your network is serious business. This paper discusses the benefits of integrating configuration change-awareness into your network fault management solution
Download Whitepaper
Comment