Building, Using, and Managing the Data Warehouse

Author: Ramón C. Barquín,Herb Edelstein

Publisher: Prentice Hall

ISBN: 9780135343555

Category: Computers

Page: 317

View: 7125

DOWNLOAD NOW »

When it comes to making organizations smarter, faster, and more competitive, few technologies have more promise than data warehousing. This book shows you how to translate that promise into reality.
Release

Analyzing Application Service Providers

Author: Alexander Factor

Publisher: Prentice Hall Professional

ISBN: 9780130894250

Category: Computers

Page: 326

View: 2105

DOWNLOAD NOW »

An enterprising Computing series title that focuses on the power of ISD to increase productivity by defining scope of services and responsibilities throughout the IT Enterprise.
Release

Data Warehousing and Mining: Concepts, Methodologies, Tools, and Applications

Concepts, Methodologies, Tools, and Applications

Author: Wang, John

Publisher: IGI Global

ISBN: 159904952X

Category: Technology & Engineering

Page: 4092

View: 5718

DOWNLOAD NOW »

In recent years, the science of managing and analyzing large datasets has emerged as a critical area of research. In the race to answer vital questions and make knowledgeable decisions, impressive amounts of data are now being generated at a rapid pace, increasing the opportunities and challenges associated with the ability to effectively analyze this data.
Release

Corporate Information Factory

Author: W. H. Inmon,Claudia Imhoff,Ryan Sousa

Publisher: John Wiley & Sons

ISBN: 0471437506

Category: Computers

Page: 400

View: 1028

DOWNLOAD NOW »

The "father of data warehousing" incorporates the latesttechnologies into his blueprint for integrated decision supportsystems Today's corporate IT and data warehouse managers are required tomake a small army of technologies work together to ensure fast andaccurate information for business managers. Bill Inmon created theCorporate Information Factory to solve the needs ofthese managers. Since the First Edition, the design of the factoryhas grown and changed dramatically. This Second Edition, revisedand expanded by 40% with five new chapters, incorporates thesechanges. This step-by-step guide will enable readers to connecttheir legacy systems with the data warehouse and deal with a hostof new and changing technologies, including Web access mechanisms,e-commerce systems, ERP (Enterprise Resource Planning) systems. Thebook also looks closely at exploration and data mining servers foranalyzing customer behavior and departmental data marts forfinance, sales, and marketing.
Release

The Microsoft Data Warehouse Toolkit

With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Author: Joy Mundy,Warren Thornthwaite

Publisher: John Wiley & Sons

ISBN: 9781118067956

Category: Computers

Page: 704

View: 3093

DOWNLOAD NOW »

Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming “Business Intelligence release” of SQL Server, referred to as SQL Server 2008 R2. In this new edition, the authors explain how SQL Server 2008 R2 provides a collection of powerful new tools that extend the power of its BI toolset to Excel and SharePoint users and they show how to use SQL Server to build a successful data warehouse that supports the business intelligence requirements that are common to most organizations. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, as well as Microsoft Office, the authors walk you through a full project lifecycle, including design, development, deployment and maintenance. Features more than 50 percent new and revised material that covers the rich new feature set of the SQL Server 2008 R2 release, as well as the Office 2010 release Includes brand new content that focuses on PowerPivot for Excel and SharePoint, Master Data Services, and discusses updated capabilities of SQL Server Analysis, Integration, and Reporting Services Shares detailed case examples that clearly illustrate how to best apply the techniques described in the book The accompanying Web site contains all code samples as well as the sample database used throughout the case studies The Microsoft Data Warehouse Toolkit, Second Edition provides you with the knowledge of how and when to use BI tools such as Analysis Services and Integration Services to accomplish your most essential data warehousing tasks.
Release

Building a Data Warehouse

With Examples in SQL Server

Author: Vincent Rainardi

Publisher: Apress

ISBN: 9781590599310

Category: Computers

Page: 523

View: 8277

DOWNLOAD NOW »

Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The relational database management system (RDBMS) used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later. The book is organized as follows. In the beginning of this book (chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation. What you’ll learn A detailed understanding of what it takes to build a data warehouse The implementation code in SQL Server to build the data warehouse Dimensional modeling, data extraction methods, data warehouse loading, populating dimension and fact tables, data quality, data warehouse architecture, and database design Practical data warehousing applications such as business intelligence reports, analytics applications, and customer relationship management Who this book is for There are three audiences for the book. The first are the people who implement the data warehouse. This could be considered a field guide for them. The second is database users/admins who want to get a good understanding of what it would take to build a data warehouse. Finally, the third audience is managers who must make decisions about aspects of the data warehousing task before them and use the book to learn about these issues.
Release

Essential Oracle8i Data Warehousing

Designing, Building, and Managing Oracle Data Warehouses

Author: Gary Dodge,Tim Gorman

Publisher: Wiley

ISBN: N.A

Category: Computers

Page: 928

View: 3200

DOWNLOAD NOW »

"This book is the definitive guide for serious Oracle8i professionals and is required reading for all Oracle data warehousing practitioners."-Shannon Platz, Senior Director, Business Intelligence & Warehouse Global Service Line, Oracle Corporation A complete hands-on guide to Oracle8i and earlier versions In this updated and expanded edition of their critically acclaimed Oracle8 Data Warehousing, Gary Dodge and Tim Gorman clearly explain everything you'll need to know to build and manage a large, high-performance data warehouse using Oracle8i. They provide a technical roadmap to the specific Oracle8 or Oracle8i features that are relevant to designing, building, tuning, and administering an Oracle data warehouse. After a brief review of the basic concepts, you'll find descriptions of the various hardware platforms to support the Oracle data warehouse. The authors then cover the Oracle features that can enhance a large data warehouse, the design considerations for a warehouse, and the steps necessary to load data into the warehouse. You'll also find out how to perform parallel operations using Oracle8 and Oracle8i to accomplish massive tasks more quickly. And you'll discover the specific features and techniques for implementing a distributed architecture. With this book, you'll learn how to: - Design a data warehouse for optimum performance - Construct the data warehouse using Oracle8 and Oracle8i database technology - Load data into the data warehouse - Summarize and aggregate data within a warehouse - Administer and monitor a data warehouse for optimum performance - Build and manage very large (multiterabyte) data warehouses Visit our Web site at www.wiley.com/compbooks/ Visit the companion Web site at www.wiley.com/compbooks/dodge for scripts, extensions, and additional material.
Release

Data Warehousing in the Real World

A Practical Guide for Building Decision Support Systems

Author: Sam Anahory,Dennis Murray

Publisher: Addison-Wesley Professional

ISBN: 9780201175196

Category: Computers

Page: 352

View: 993

DOWNLOAD NOW »

This is a practical, hands-on guide which explains tried-and-true techniques for developing data warehouses using relational databases and open system technology. Written in "cookbook" format, this book covers all stages of implementation from project planning and requirements analysis, through architecture and design, to administrative issues such as user access, security, and back-up/recovery.
Release

Building the Operational Data Store

Author: W. H. Inmon

Publisher: Wiley

ISBN: 9780471328889

Category: Computers

Page: 336

View: 6044

DOWNLOAD NOW »

The most comprehensive guide to building, using, and managing the operational data store. Building the Operational Data Store, Second Edition. In the five years since the publication of the first edition of this book, the operational data store has grown from an intriguing concept to an exciting reality at enterprise organizations, worldwide. Still the only guide on the subject, this revised and expanded edition of Bill Inmon's classic goes beyond the theory of the first edition to provide detailed, practical guidance on designing, building, managing, and getting the most of an ODS. With the help of fascinating and instructive case studies, Inmon shares what he knows about: * How the ODS fits with the corporate information factory. * Different types of ODS and how to choose the right one for your organization. * Designing and building an ODS from scratch. * Managing and fine-tuning an ODS for peak efficiency. * ODS support technology. * The pros and cons of competing off-the-shelf ODS products. * The advantages and disadvantages of various hardware and software platforms. * Integrating the ODS with data marts. * Distributed metadata using the ODS. * Data aggregation within the ODS. * Business process reengineering and the ODS. * The role of standards in the ODS. Visit our Web site at www.wiley.com/compbooks/
Release

Building the data warehouse

Author: William H. Inmon

Publisher: John Wiley & Sons Inc

ISBN: N.A

Category: Computers

Page: 401

View: 4821

DOWNLOAD NOW »

The data warehousing bible updated for the new millennium Updated and expanded to reflect the many technological advances occurring since the previous edition, this latest edition of the data warehousing "bible" provides a comprehensive introduction to building data marts, operational data stores, the Corporate Information Factory, exploration warehouses, and Web-enabled warehouses. Written by the father of the data warehouse concept, the book also reviews the unique requirements for supporting e-business and explores various ways in which the traditional data warehouse can be integrated with new technologies to provide enhanced customer service, sales, and support-both online and offline-including near-line data storage techniques.
Release