Dimensional Modeling: In a Business Intelligence Environment

Dimensional Modeling: In a Business Intelligence Environment
Author :
Publisher : IBM Redbooks
Total Pages : 670
Release :
ISBN-10 : 9780738496443
ISBN-13 : 0738496448
Rating : 4/5 (43 Downloads)

Book Synopsis Dimensional Modeling: In a Business Intelligence Environment by : Chuck Ballard

Download or read book Dimensional Modeling: In a Business Intelligence Environment written by Chuck Ballard and published by IBM Redbooks. This book was released on 2012-07-31 with total page 670 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this IBM Redbooks publication we describe and demonstrate dimensional data modeling techniques and technology, specifically focused on business intelligence and data warehousing. It is to help the reader understand how to design, maintain, and use a dimensional model for data warehousing that can provide the data access and performance required for business intelligence. Business intelligence is comprised of a data warehousing infrastructure, and a query, analysis, and reporting environment. Here we focus on the data warehousing infrastructure. But only a specific element of it, the data model - which we consider the base building block of the data warehouse. Or, more precisely, the topic of data modeling and its impact on the business and business applications. The objective is not to provide a treatise on dimensional modeling techniques, but to focus at a more practical level. There is technical content for designing and maintaining such an environment, but also business content. For example, we use case studies to demonstrate how dimensional modeling can impact the business intelligence requirements for your business initiatives. In addition, we provide a detailed discussion on the query aspects of BI and data modeling. For example, we discuss query optimization and how you can determine performance of the data model prior to implementation. You need a solid base for your data warehousing infrastructure . . . . a solid data model.


Dimensional Modeling: In a Business Intelligence Environment Related Books

IBM Data Warehousing
Language: en
Pages: 706
Authors: Michael L. Gonzales
Categories: Computers
Type: BOOK - Published: 2003-02-25 - Publisher: John Wiley & Sons

DOWNLOAD EBOOK

Reviews planning and designing architecture and implementing the data warehouse. Includes discussions on how and why to apply IBM tools. Offers tips, tricks, an
Dimensional Modeling: In a Business Intelligence Environment
Language: en
Pages: 670
Authors: Chuck Ballard
Categories: Computers
Type: BOOK - Published: 2012-07-31 - Publisher: IBM Redbooks

DOWNLOAD EBOOK

In this IBM Redbooks publication we describe and demonstrate dimensional data modeling techniques and technology, specifically focused on business intelligence
Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC
Language: en
Pages: 484
Authors: Chuck Ballard
Categories: Computers
Type: BOOK - Published: 2012-03-12 - Publisher: IBM Redbooks

DOWNLOAD EBOOK

To make better informed business decisions, better serve clients, and increase operational efficiencies, you must be aware of changes to key data as they occur.
IBM Cloud Pak for Data
Language: en
Pages: 337
Authors: Hemanth Manda
Categories: Computers
Type: BOOK - Published: 2021-11-24 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Build end-to-end AI solutions with IBM Cloud Pak for Data to operationalize AI on a secure platform based on cloud-native reliability, cost-effective multitenan
DB2 9 for Z/OS
Language: en
Pages: 0
Authors: Paolo Bruni
Categories: Database management
Type: BOOK - Published: 2009 - Publisher:

DOWNLOAD EBOOK

Locking is the generic term used to refer to the database management system function that is required for managing interprocess concurrency and maintaining data