Recent Business Intelligence - Data Warehousing White Papers Added to TechRepublic.com

ROI Case Study: Microsoft BizTalk Server Virgin Entertainment

Virgin Entertainment is a multi-channel music and entertainment retailer, providing consumers with entertainment products including music, DVDs, videos, and books. Increasing competitive pressures continue to drive retailers to look for new ways to improve and protect profits. Virgin was using a hosted service to analyze its point of sale data, but the time delay in receiving the data limited Virgin's managers' ability to act on it effectively. Virgin needed to increase the percentage of recoveries and the efficiency of investigation surrounding employee theft by implementing real-time monitoring of point-of-sale activities. The company deployed Microsoft BizTalk Server 2004, SQL Server 2000 Analysis Services, and Windows SharePoint Services to replace an existing solution to reduce transaction fraud.

The Self-Managing Database: Guided Application & SQL Tuning With Oracle Database 10g Release 2

In Oracle Database 10g, the SQL tuning process has been automated by introducing a new manageability feature called the Automatic SQL Tuning. It is designed to work equally well for OLTP and Data Warehouse type applications. This paper introduces a new persistent tuning object called the SQL Tuning Set (STS), which is described in detail. The paper explains how the Automatic SQL Tuning works, then gives the details about the Automatic Tuning Optimizer. It describes the SQL Tuning Sets that enable the user to create and tune custom SQL workloads. Then the paper introduces the primary interface to the Automatic SQL Tuning using the Enterprise Manager and illustrates it with examples.

Climbing to the OLAP Summit With Oracle Warehouse Builder 10gR2

The aim of this whitepaper is to review how Oracle Warehouse Builder 10gR2 can help companies successfully implement new projects and extend existing projects to include OLAP (multi-dimensional) data models. With the introduction of 9i of the database Oracle provided a unified relational and multi-dimensional server. Oracle Warehouse builder supported this unified environment with its dimensional and cube based modeling features. However, with the availability of the next generation of Warehouse Builder the life cycle management of multi-dimensional models has moved to the next level. Oracle Warehouse Builder is the first ETL product to provide a single integrated and complete environment for managing enterprise data warehouse solutions that also incorporate multi-dimensional schemas.

Using Predictive Analytics Within Warehouse Builder

Data mining can uncover useful information buried in vast amounts of data. However, it is often the case that many users that could benefit from these results do not have any data mining expertise. To date, most predictive analytic operations require the extraction of data to a separate analytic server where the data cannot be easily joined back to the other sources. This limits the analysis of the results and also constrains the use of predictive analytic functions. The Oracle Enterprise Edition database is currently the only database available that provides a complete analytic engine that incorporates analytic and predictive functions and Warehouse Builder is the only enterprise level business intelligence integration tool that can fully leverage the features of the Oracle database.

Benefits of a Multi-Dimensional Model

Every organization knows they have rapidly expanding amounts of data. The challenge for users is to transform the knowledge inside that data into competitive advantages. To allow users to intelligently query and analyze information organizations spend large amounts of time and resources adding structure and order to their relational database schemas. This structure is intended to simplify the analysis process for end users. The zenith of this path to structure and order is the multi-dimensional model. It allows user to access a data warehouse schema and quickly, simply and easily transform data into quality information. Oracle's Online Analytical Processing (OLAP) multi-dimensional model is unique in the market place.

Category: Data Warehousing

More Feeds