Data Warehouse – DBWDBD301

We have 128 guests and no members online

03136096
Today
Yesterday
This Week
Last Week
This Month
Last Month
All days
301
1169
4127
3121722
36232
42441
3136096

Your IP: 10.23.0.200
Server Time: 2017-09-27 01:18:58

Request Here

Data Warehouse – DBWDBD301

In oder to supplying the better references to students, lecturers and researchers; FPT Library and Information Center delighted to inform you about the subject guide for this subject: Data Warehouse – DBW 301.

Main book

Data warehousing fundamentals for IT professionals

data-warehousing-fundamentals-for-it-professionals

Call number: 005.745 P797

Author: PaulrajPonniah

- 2nd ed. – Hoboken, N.J. : John Wiley & Sons, 2010. – xxviii, 571 p. : ill. ; 26 cm.

ISBN: 9780470462072

Library code:  FSE (05)

Call number: 005.745 P797

Since the first edition of “Data Warehousing Fundamentals”, there has been an increase in enterprises either already having or in the process of obtaining the data warehousing programs. “Data Warehousing Fundamentals” not only explores important topics, like planning requirements, architecture, infrastructure, data preparation, and information delivery, but also the most up-to-date research on areas of technological improvements since the first edition. Additionally, Information Technologists will find expert advice, review questions, exercises, as well as an answer section are all included in this revised text.

Reference books

Modern Data Warehousing, Mining, and Visualization : Core Concepts

modern-data-warehousing-mining-and-visualization

Call number: 658.4/038 M299

Author: George M. Marakas .

- us : Prentice Hall, Inc, 2003. – 274p. ; 23cm

ISBN: 0131014595

Library code:   FSE (01)

Call number:  658.4/038 M299

For undergraduate/graduate-level Data Mining or Data Warehousing courses in Information Systems or Operations Management Departments electives. Taking a multidisciplinary user/manager approach, this text looks at data warehousing technologies necessary to support the business processes of the twenty-first century. Using a balanced professional and conversational approach, it explores the basic concepts of data mining, warehousing, and visualization–with an emphasis on both technical and managerial issues and the implication of these modern emerging technologies on those issues. Data mining and visualization exercises–using an included fully-enabled, but time-limited version of Megaputer’sPolyAnalyst and TextAnalyst data mining and visualization software–give students hands-on experience with real-world applications.

Data Warehousing

data-warehousing

Call number: 005.74 T367

Author: ReemaThareja

1st. – ii : Oxford, 2009. – 474p. ; 24cm.

ISBNL: 0195699610/ 9780195699616

Library code:   FSE (01)

Call number:  005.74 T367

Data Warehousing is designed to serve as a textbook for students of Computer Science & Engineering (BE/Btech), computer applications (BCA/MCA) and computer science (B.Sc) for an introductory course on Data Warehousing. It provides a thorough understanding of the fundamentals of Data Warehousing and aims to impart a sound knowledge to users for creating and managing a Data Warehouse.

The book introduces the various features and architecture of a Data Warehouse followed by a detailed study of the Business Requirements and Dimensional Modelling. It goes on to discuss the components of a Data Warehouse and thereby leads up to the core area of the subject by providing a thorough understanding of the building and maintenance of a Data Warehouse. This is then followed up by an overview of planning and project management, testing and growth and then finishing with Data Warehouse solutions and the latest trends in this field. The book is finally rounded off with a broad overview of its related field of study, Data Mining. The text is ably supported by plenty of examples to illustrate concepts and contains several review questions and other end-chapter exercises to test the understanding of students. The book also carries a running case study that aims to bring out the practical aspects of the subject. This will be useful for students to master the basics and apply them to real-life scenario.

Building the Data Warehouse

building-the-data-warehouse-fourth-edition

Call number: 005.74 I57

Author: Inmon, William H.

4th. – Wiley, 2005. – 543tr. ; 24cm.

9780764599446

Library code:   FSE (01)

Call number:  005.74 I57

The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himself. In addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media, and discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects. It covers advanced topics, including data monitoring and testing. Although the book includes an extra 100 pages worth of valuable content, the price has actually been reduced from $65 to $55.

Reference Ebooks (Books24x7)

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

the-microsoft-data-warehouse-toolkit

Call number: 5.74 I57

Author: Mundy, Joy, Warren Thornthwaite, and Ralph Kimball.

2nd Edition. John Wiley & Sons.© 2011.

<http://common.books24x7.com/toc.aspx?bookid=40851&gt; (accessed October 5, 2011)

ISBN: 0470640383/ 9780470640388

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.

 Building the Unstructured Data Warehouse

building-the-unstructured-data-warehouse

Call number: 5.74 I57

Author: Inmon, W. H., and Krish Krishnan…

© 2011

<http://common.books24x7.com/toc.aspx?bookid=38016&gt; (accessed October 5, 2011)

ISBN:1935504045/ 9781935504047

Learn essential techniques from data warehouse legend Bill Inmon on how to build the reporting environment your business needs now! Answers for many valuable business questions hide in text. How well can your existing reporting environment extract the necessary text from email, spreadsheets, and documents, and put it in a useful format for analytics and reporting? Transforming the traditional data warehouse into an efficient unstructured data warehouse requires additional skills from the analyst, architect, designer, and developer. This book will prepare you to successfully implement an unstructured data warehouse and, through clear explanations, examples, and case studies, you will learn new techniques and tips to successfully obtain and analyse text. Master these ten objectives: Build an unstructured data warehouse using the 11-step approach; Integrate text and describe it in terms of homogeneity, relevance, medium, volume, and structure; Overcome challenges including blather, the Tower of Babel, and lack of natural relationships; Avoid the Data Junkyard and combat the ‘Spider’s Web’; Reuse techniques perfected in the traditional data warehouse and Data Warehouse 2.0 , including iterative development; Apply essential techniques for textual Extract, Transform, and Load (ETL) such as phrase recognition, stop word filtering, and synonym replacement; Design the Document Inventory system and link unstructured text to structured data; Leverage indexes for efficient text analysis and taxonomies for useful external categorisation; Manage large volumes of data using advanced techniques such as backward pointers; and, Evaluate technology choices suitable for unstructured data processing, such as data warehouse appliances.

Relentlessly Practical Tools for Data Warehousing and Business Intelligence

D1Author: Kimball, Ralph, and Margy Ross.

John Wiley & Sons.© 2010.

<http://common.books24x7.com/toc.aspx?bookid=34943&gt; (accessed October 5, 2011)

ISBN:0470563109/ 9780470563106

This is an unparalleled collection of recommended best practices from the data warehousing pioneers of the Kimball Group. Recognized and respected throughout the world as the most influential leaders in the data warehousing industry, Ralph Kimball and the Kimball Group have pioneered methods and standards that have been adopted by nearly every leading data warehouse vendor. For the first time ever, the Kimball Group’s incomparable advice, design tips, and best practices have been gathered in this remarkable collection of articles, which spans a decade of data warehousing innovation. Each group of articles is introduced with original commentaries that explain their role in the overall lifecycle methodology developed by the Kimball Group. These practical, hands-on articles are fully updated to reflect current practices and terminology; they cover such topics as pre-project planning, organizing the project, business requirements, data architecture, dimensional modeling, ETL, technical architecture, business intelligence and analytics, and maintenance and growth. The Kimball Group is a world-renowned consulting and training group that has pioneered innovative data warehousing methods and techniques. This title presents a collection of updated articles that share best practices and invaluable advice on every major topic involved in designing, building, and managing a data warehouse. It covers the complete data warehouse lifecycle. It provides novel data warehouse design techniques not found in their previously published books. This useful and easily referenced collection is nothing less than vital if you are involved with data warehousing in any capacity.

Strategic Data Warehousing: Achieving Alignment with Business.

strategic-data-warehousingAuthor: Bhansali, Neera

Auerbach Publications.© 2010.

<http://common.books24x7.com/toc.aspx?bookid=32120&gt; (accessed October 5, 2011)

ISBN:1420083945/ 9781420083941

Organization of data warehouses are vital but often ignored aspects of growing enterprises. This work merges technological know-how with managerial practices to show both the business manager and the IT professional how better alignment between data warehouse plans and business strategies can lead to a successful data warehouse adoption.

Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL.

pentaho-solutionsAuthor: Bouman, Roland, and Jos van Dongen.

John Wiley & Sons.© 2009.

<http://common.books24x7.com/toc.aspx?bookid=40766&gt; (accessed October 5, 2011)

ISBN:0470484322/ 9780470484326

Your all-in-one resource for using Pentaho with MySQL for Business Intelligence and Data Warehousing Open-source Pentaho provides business intelligence (BI) and data warehousing solutions at a fraction of the cost of proprietary solutions. Now you can take advantage of Pentaho for your business needs with this practical guide written by two major participants in the Pentaho community. The book covers all components of the Pentaho BI Suite. You’ll learn to install, use, and maintain Pentaho-and find plenty of background discussion that will bring you thoroughly up to speed on BI and Pentaho concepts.* Of all available open source BI products, Pentaho offers the most comprehensive toolset and is the fastest growing open source product suite* Explains how to build and load a data warehouse with Pentaho Kettle for data integration/ETL, manually create JFree (pentaho reporting services) reports using direct SQL queries, and create Mondrian (Pentaho analysis services) cubes and attach them to a JPivot cube browser* Review deploying reports, cubes and metadata to the Pentaho platform in order to distribute BI solutions to end-users* Shows how to set up scheduling, subscription and automatic distribution The companion Web site provides complete source code examples, sample data, and links to related resources/.

Greening the Data Center: Opportunities for Improving Data Center Energy Efficiency.

greening-the-data-center-opportunities-for-improving-data-center-energy-efficiencyAuthor: Spafford, George

IT Governance.© 2009. Books24x7.

<http://common.books24x7.com/toc.aspx?bookid=36112&gt; (accessed October 5, 2011)

ISBN:1849280096/ 9781849280099

IT organizations are under intense pressure to manage the power consumed by data centers and the resulting cooling demands. To address these needs, IT needs to properly blend people, process and technology to create solutions. In my first Green IT pocket guide, we reviewed governance and processes for Green IT. In this guide we will provide a sample of technical improvement opportunities at a high-level. By doing so, the intent is to foster discussions in your own organization around what should be done first, second, third and so on. The result of this should be a technical implementation roadmap that supports the objectives of Green IT. Indeed, most data centers will not suffer from a lack of opportunities to improve. What is needed is careful planning and deliberate execution to manage power and cooling while continuing to create and protect value for the organization.

Data Mining and Data Warehousing

D2Author: Agarwal, Bharat Bhushan, and Sumit Prakash Tayal.

Laxmi Publications.© 2009.

<http://common.books24x7.com/toc.aspx?bookid=30704&gt; (accessed October 5, 2011)

Data Warehouse Design: Modern Principles and Methodologies.

data-warehouse-design-modern-principles-and-methodologiesAuthor: Golfarelli, Matteo, and Stefano Rizzi.

McGraw-Hill/Osborne.© 2009.

<http://common.books24x7.com/toc.aspx?bookid=33003&gt; (accessed October 5, 2011)

ISBN:0071610391/9780071610391

Foreword by Mark Stephen LaRow, Vice President of Products, MicroStrategy “A unique and authoritative book that blends recent research developments with industry-level practices for researchers, students, and industry practitioners.” Il-Yeol Song, Professor, College of Information Science and Technology, Drexel University

Oracle Warehouse Builder 11g: Getting Started: Extract, Transform, and Load Data to Build a Dynamic, Operational Data Warehouse.

oracle-warehouse-builder-11g-getting-startedAuthor: Griesemer, Bob.

Packt Publishing. © 2009.

<http://common.books24x7.com/toc.aspx?bookid=32413&gt; (accessed October 5, 2011)

ISBN:1847195741/9781847195746

This easy-to-understand tutorial covers Oracle Warehouse Builder from the ground up, and taps into the author’s wide experience as a software and database engineer. Written in a relaxed style with step-by-step explanations, lots of screenshots are provided throughout the book. There are numerous tips and helpful hints throughout that are not found in the original documentation. By following this book, you can use Oracle Warehouse Builder in the best possible way and maximize your learning potential. This book is a good starting point for database engineers, administrators, and architects who are responsible for data warehouse projects and need to design them and load data into them. If you are someone who wants to learn Oracle Warehouse Builder and expand your knowledge of the tool and data warehousing, this is an ideal book for you. No prior data warehouse or database experience is presumed with all new database and data warehouse technical terms and concepts explained in clear easy-to-understand language.

A Manager’s Guide to Data Warehousing.

a-managers-guide-to-data-warehousingAuthor: Reeves, Laura L.

John Wiley & Sons.© 2009. Books24x7.

<http://common.books24x7.com/toc.aspx?bookid=31998&gt; (accessed October 5, 2011)

ISBN:0470176385/9780470176382

Aimed at helping business and IT managers clearly communicate with each other, this helpful book addresses concerns straight-on and provides practical methods to building a collaborative data warehouse . You’ll get clear explanations of the goals and objectives of each stage of the data warehouse lifecycle while learning the roles that both business managers and technicians play at each stage. Discussions of the most critical decision points for success at each phase of the data warehouse lifecycle help you understand ways in which both business and IT management can make decisions that best meet unified objectives.

Data Warehousing For Dummies,

data-warehousing-for-dummiesAuthor: Hammergren, Thomas C., and Alan R. Simon

2nd Edition.John Wiley & Sons.© 2009.

<http://common.books24x7.com/toc.aspx?bookid=29531&gt; (accessed October 5, 2011)

Data warehousing is one of the hottest business topics, and there’s more to understanding data warehousing technologies than you might think. Find out the basics of data warehousing and how it facilitates data mining and business intelligence with Data Warehousing For Dummies, 2nd Edition. Data is probably your company’s most important asset, so your data warehouse should serve your needs. The fully updated Second Edition of Data Warehousing For Dummies helps you understand, develop, implement, and use data warehouses, and offers a sneak peek into their future.

Oracle Database 11g Data Warehousing & Oracle Warehouse Builder.

D3Author: Corporation, Sideris Courseware

Sideris.© 2008.

<http://common.books24x7.com/toc.aspx?bookid=42390&gt; (accessed October 5, 2011)

DW 2.0: The Architecture for the Next Generation of Data Warehousing.

dw-2-0-the-architecture-for-the-next-generation-of-data-warehousingAuthor: Inmon, William H., Derek Strauss, and GeniaNeushloss

Morgan Kaufmann Publishers.© 2008.

<http://common.books24x7.com/toc.aspx?bookid=32330&gt; (accessed October 5, 2011)

Data Warehousing has been around for 20 years and has become part of the information technology infrastructure. Data warehousing originally grew in response to the corporate need for information – not data – and it supplies integrated, granular, and historical data to the corporation. There are many kinds of data warehouses, in large part due to evolution and different paths of software and hardware vendors. But DW 2.0, defined by this author in many talks, articles, and his b-eye-network newsletter that reaches 65,000 professionals monthly, is the well-identified and defined next generation data warehouse. The book carries that theme and describes the future of data warehousing that is technologically possible now, at both an architectural level and technology level. The perspective of the book is from the top down: looking at the overall architecture and then delving into the issues underlying the components.

Building and Maintaining a Data Warehouse.

building-and-maintaining-a-data-warehouseAuthor: Silvers, Fon.

Auerbach Publications.© 2008.

<http://common.books24x7.com/toc.aspx?bookid=26399&gt; (accessed October 5, 2011)

As it is with building a house, most of the work necessary to build a data warehouse is neither visible nor obvious when looking at the completed product. While it may be easy to plan for a data warehouse that incorporates all the right concepts, taking the steps needed to create a warehouse that is as functional and user-friendly as it is theoretically sound, is not especially easy. That’s the challenge that Building and Maintaininga Data Warehouse answers. Based on a foundation of industry-accepted principles, this work provides an easy-to-follow approach that is cohesive and holistic. By offering the perspective of a successful data warehouse, as well as that of a failed one, this workdetails those factors that must be accomplished and those that are best avoided. Organized to logically progress from more general to specific information, this valuable guide: Presents areas of a data warehouse individually and in sequence, showing how each piece becomes a working part of the whole Examines the concepts and principles that are at the foundation of every successful data warehouse Explains how to recognize and attend to problematic gaps in an established data warehouse Provides the big picture perspective that planners and executives require Those considering the planning and creation of a data warehouse, as well as those who’ve already built one will profit greatly from the insights garnered by the author during his years of creating and gathering information on state-of-the-art data warehouses that are accessible, convenient, and reliable.

The Data Warehouse Lifecycle Toolkit

the-data-warehouse-lifecycle-toolkitAuthor: Kimball et al., Ralph.

Second Edition. John Wiley & Sons.© 2008.

<http://common.books24x7.com/toc.aspx?bookid=24441&gt; (accessed October 5, 2011)

The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. With this new edition, Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. They walk you through the detailed steps of designing, developing, and deploying a data warehousing/business intelligence system. With substantial new and updated content, this second edition again sets the standard in data warehousing for the next decade.

Data Warehouses and OLAP: Concepts, Architectures and Solutions

data-warehouses-and-olap-concepts-architectures-and-solutionsAuthor: Wrembel, Robert, and Christian Koncilia (eds)

IGI Global.© 2007.

<http://common.books24x7.com/toc.aspx?bookid=14716&gt; (accessed October 5, 2011)

Data warehouses and online analytical processing (OLAP) are emerging key technologies for enterprise decision support systems. They provide sophisticated technologies from data integration, data collection and retrieval, query optimization, and data analysis to advanced user interfaces. New research and technological achievements in the area of data warehousing are implemented in commercial database management systems, and organizations are developing data warehouse systems into their information system infrastructures. “Data Warehouses and OLAP: Concepts, Architectures and Solutions” covers a wide range of technical, technological, and research issues. It provides theoretical frameworks, presents challenges and their possible solutions, and examines the latest empirical research findings in the area. It is a resource of possible solutions and technologies that can be applied when designing, implementing, and deploying a data warehouse, and assists in the dissemination of knowledge in this field.

Oracle Data Warehousing and Business Intelligence Solutions.

1129Author: Stackowiak, Robert, Joseph Rayman, and Rick Greenwald.

John Wiley & Sons.© 2007.

<http://common.books24x7.com/toc.aspx?bookid=17063&gt; (accessed October 5, 2011)

Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools.You’ll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you’ll get valuable tips and insight based on the authors’ real-world experiences and their own implementations.

Oracle Database 10g: Implement Parallel SQL & Partitioning For Data Warehouses.

D4Author: Corporation, Sideris Courseware

Sideris.© 2006.

<http://common.books24x7.com/toc.aspx?bookid=42347&gt; (accessed October 5, 2011)

Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

New1131Author: Adamson, Christopher.

John Wiley & Sons. © 2006.

<http://common.books24x7.com/toc.aspx?bookid=17039&gt; (accessed October 5, 2011)

This is the first book to provide in–depth coverage of star schema aggregates used in dimensional modeling–from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects* Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates* Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads

Encyclopedia of Data Warehousing and Mining

encyclopedia-of-data-warehousing-and-miningAuthor: John Wang

Volume I, A-H.IGI Global.© 2006.

<http://common.books24x7.com/toc.aspx?bookid=14698&gt; (accessed October 5, 2011)

 

Encyclopedia of Data Warehousing and Mining

D5John Wang., Volume II,

I-Z.IGI Global.© 2006.

<http://common.books24x7.com/toc.aspx?bookid=15518&gt; (accessed October 5, 2011)

There are more than one billion documents on the Web, with the count continually rising at a pace of over one million new documents per day. As information increases, the motivation and interest in data warehousing and mining research and practice remains high in organizational interest. The Encyclopedia of Data Warehousing and Mining, Second Edition, offers thorough exposure to the issues of importance in the rapidly changing field of data warehousing and mining. This essential reference source informs decision makers, problem solvers, and data mining specialists in business, academia, government, and other settings with over 300 entries on theories, methodologies, functionalities, and applications.

The Microsoft Data Warehouse Toolkit : With SQL Server 2005 and the Microsoft Business Intelligence Toolset.

the-microsoft-data-warehouse-toolkit-with-sql-server-2005-and-the-microsoft-business-intelligence-toolsetAuthor: Mundy, Joy, Warren Thornthwaite, and Ralph Kimball.

John Wiley & Sons.© 2006

<http://common.books24x7.com/toc.aspx?bookid=14274&gt; (accessed October 5, 2011)

Microsoft is completely revamping its database product, SQL Server, and adding a host of new tools that will provide a powerful, full featured data warehouse toolset perfectly suited for smaller organizations. This book offers practical examples implemented on the Microsoft’s Business Intelligence (BI) toolset and is structured around the major phases of a data warehouse project plan: design, develop, deploy, and maintain.

Oracle Data Warehouse Tuning for 10g.

oracle-data-warehouse-tuning-for-10gAuthor: Powell, Gavin.

Digital Press.© 2005. Books24x7. <http://common.books24x7.com/toc.aspx?bookid=17819&gt; (accessed October 5, 2011)

“This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience.” – Tim Donar, Author and Systems Architect for Enterprise Data Warehouses Tuning a data warehouse database focuses on large transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame. A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.* Takes users beyond basics to critical issues in running most efficient data warehouse applications * Illustrates how to keep data going in and out in the most productive way possible * Focus is placed on Data Warehouse performance tuning

Building the Data Warehouse

building-the-data-warehouse-fourth-editionAuthor: Inmon, W. H.

Fourth Edition.

John Wiley & Sons.© 2005.

<http://common.books24x7.com/toc.aspx?bookid=12458&gt; (accessed October 5, 2011)

The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himself. In addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media, and discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects. It covers advanced topics, including data monitoring and testing.

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data.

the-data-warehouse-etl-toolkit-practical-techniques-for-extracting-cleaning-conforming-and-delivering-dataAuthor: Kimball, Ralph, and Joe Caserta.

John Wiley & Sons.© 2004

<http://common.books24x7.com/toc.aspx?bookid=11237&gt; (accessed October 5, 2011)

Cowritten by Ralph Kimball, the world’s leading data warehousing authority, whose previous books have sold more than 150,000 copies Delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality

Mastering Data Warehouse Design: Relational and Dimensional Techniques.

mastering-data-warehouse-design-relational-and-dimensional-techniquesAuthor: Imhoff, Claudia, Nicholas Galemmo, and Jonathan G. Geiger.

John Wiley & Sons.© 2003.

<http://common.books24x7.com/toc.aspx?bookid=8132&gt; (accessed October 5, 2011)

This book is a cutting-edge response to Ralph Kimball’s challenge to the data warehouse community that answers some tough questions about the effectiveness of the relational approach to data warehousing. It is written by one of the best-known exponents of the Bill Inmon approach to data warehousing. It addresses head-on the tough issues raised by Kimball and explains how to choose the best modeling technique for solving common data warehouse design problems. It weighs the pros and cons of relational vs. dimensional modeling techniques. It also focuses on tough modeling problems, including creating and maintaining keys and modeling calendars, hierarchies, transactions, and data quality.

Oracle9iR2 Data Warehousing

D6Author: Hobbs, Lilian, Susan Hillson, and ShilpaLawande

Digital Press.© 2003.

<http://common.books24x7.com/toc.aspx?bookid=5958&gt; (accessed October 5, 2011)

Data Warehousing and Data Mining for Telecommunications

Author: Mattison, Rob.

Artech House. © 1997.

<http://common.books24x7.com/toc.aspx?bookid=251&gt; (accessed October 5, 2011)

Data Warehousing for Dummies

D7Author: Simon, Alan R.

John Wiley & Sons.© 1997.

<http://common.books24x7.com/toc.aspx?bookid=18436&gt; (accessed October 5, 2011)

The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses.

the-data-warehouse-lifecycle-toolkit-expert-methods-for-designing-developing-and-deploying-data-warehousesAuthor: Kimball, Ralph, Laura Reeves, Margy Ross, and Warren Thornthwaite.

John Wiley & Sons.© 1998.

<http://common.books24x7.com/toc.aspx?bookid=781&gt; (accessed October 5, 2011)

Microsoft Data Warehousing: Building Distributed Decision Support Systems.

microsoft-data-warehousing-building-distributed-decision-support-systemsAuthor: Craig, Robert S., Joseph A. Vivona, and David Bercovitch.

John Wiley & Sons.© 1999

<http://common.books24x7.com/toc.aspx?bookid=499&gt; (accessed October 5, 2011)

SQL Service is Microsoft’s database management system (DBMS) and is a leading DBMS on Windows NT. As the NT market has grown, so too has the SQL Server audience. With release 7.0 of SQL Server, Microsoft has targeted the Data Warehouse market through an alliance with over 20 leading software vendors. Many new features are included in version 7.0, but the key feature is the data warehousing component. This function is designed to appeal greatly to database developers and administrators currently using SQL Server, as well as new SQL Server developers who are looking for a data warehousing tool. This book is in two parts: Part One lays the framework from which the data warehouse will be built; Part Two uses that framework to build a data warehouse for a customer management system with Microsoft’s key technologies. Important topics are: data warehousing issues with Windows NT 4.0 and the upcoming 5.0; how to use all of the new components within SQL Server 7.0 – OLAP, DTS; how Microsoft’s other database technologies fit in, such as OLE DB, ADO, Universal Data Access, and the Repository; and data warehousing with SQL Server technologies will be a course offered by Microsoft approved training houses.

Data Warehouse Performance

D8Author: Inmon, W.H., Ken Rudin, Christopher K. Buss, and Ryan Sousa.

John Wiley & Sons.© 1999.

<http://common.books24x7.com/toc.aspx?bookid=471&gt; (accessed October 5, 2011)

Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits

D9Author: English, Larry P.

John Wiley & Sons.© 1999.

<http://common.books24x7.com/toc.aspx?bookid=782&gt; (accessed October 5, 2011)

The Data Webhouse Toolkit: Building the Web-Enabled Data Warehouse.

D10Author: Kimball, Ralph, and Richard Merz.

John Wiley & Sons.© 2000.

<http://common.books24x7.com/toc.aspx?bookid=779&gt; (accessed October 5, 2011)

Essential Oracle 8i Data Warehousing: Designing, Building, and Managing Oracle Data Warehouses.

D11Author: Dodge, Gary, and Tim Gorman.

John Wiley & Sons.© 2000.

<http://common.books24x7.com/toc.aspx?bookid=2545&gt; (accessed October 5, 2011)

“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.

Distributed Data Warehousing Using Web Technology.

D12Author: Moeller, R.A.

AMACOM.© 2001. Books24x7. <http://common.books24x7.com/toc.aspx?bookid=1663&gt; (accessed October 5, 2011)

Data Warehousing: Using the Wal-Mart Model.

data-warehousing-using-the-wal-mart-modelMorgan Kaufmann Publishers.

Westerman, Paul. © 2001.

<http://common.books24x7.com/toc.aspx?bookid=2317&gt; (accessed October 5, 2011)

At 70 terabytes and growing, Wal-Mart’s data warehouse is still the world’s largest, most ambitious, and arguably most successful commercial database. Written by one of the key figures in its design and construction, “Data Warehousing: Using the Wal-Mart Model” gives you an insider’s view of this enormous project. Continuously drawing from this example, the author teaches you the general principles and specific techniques you need to understand to be a valuable part of your organization’s own data warehouse project, however large or small. You’ll emerge with a practical understanding of both the business and technical aspects of building a data warehouse for storing and accessing data in a strategically useful way. What further sets this book apart is its focus on the informational needs of retail companies-including both market and organizational issues that affect the data’s collection and use. If retail is your field, this book will prove especially valuable as you develop and implement your company’s ideal data warehouse solution. It is written by a member of the team of four engineers who designed and built the Wal-Mart Data Warehouse database, a team whose database design was recognized internally in 1991 by Wal-Mart with the company’s Team Innovational Technical award. It: provides essential information for project managers, consultants, data warehouse managers, and data architects; takes an in-depth look at a wide range of technical issues, including architecture, construction approaches, tool selection, database system selection, and maintenance; addresses issues specific to retail business: vendors, inventory, sales analysis, geography, article categories, and more; and, explains how to determine business requirements at the outset of the project-and how to develop return on investment analyses after the warehouse has been brought online.

Data Warehousing and Business Intelligence for e-Commerce

data-warehousing-and-business-intelligence-for-e-commerceAuthor: Simon, Alan, and Steven Shaffer.

Morgan Kaufmann Publishers.© 2001.

<http://common.books24x7.com/toc.aspx?bookid=3151&gt; (accessed October 5, 2011)

“Data Warehousing and Business Intelligence for e-Commerce” is a practical exploration of the technological innovations through which traditional data warehousing is brought to bear on this and other less modest e-commerce applications, such as those at work in B2B, G2C, B2G, and B2E models. The authors examine the core technologies and commercial products in use today, providing a nuts-and-bolts understanding of how you can deploy customer and product data in ways that meet the unique requirements of the online marketplace-particularly if you are part of a brick-and-mortar company with specific online aspirations. In so doing, they build a powerful case for investment in and aggressive development of these approaches, which are likely to separate winners from losers as e-commerce grows and matures. The book includes the latest from successful data warehousing consultants whose work has encouraged the field’s new focus on e-commerce; presents information that is written for both consultants and practitioners in companies of all sizes; emphasizes the special needs and opportunities of traditional brick-and-mortar businesses that are going online or participating in B2B supply chains or e-marketplaces; explains how long-standing assumptions about data warehousing have to be rethought in light of emerging business models that depend on customer intimacy; provides advice on maintaining data quality and integrity in environments marked by extensive customer self-input; advocates careful planning that will help both old economy and new economy companies develop long-lived and successful e-commerce strategies; and focuses on data warehousing for emerging e-commerce areas such as e-government and B2E environments.

Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals.

New1132Author: Ponniah, Paulraj.

John Wiley & Sons.© 2001.

<http://common.books24x7.com/toc.aspx?bookid=18416&gt; (accessed October 5, 2011)

Geared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They’ll also find a wealth of industry examples garnered from the author’s 25 years of experience in designing and implementing databases and data warehouse applications for major corporations.

Clickstream Data Warehousing.

clickstream-data-warehousingAuthor: Sweiger, Mark, Mark R. Madsen, Jimmy Langston, and Howard Lombard

John Wiley & Sons.© 2002.

<http://common.books24x7.com/toc.aspx?bookid=3768&gt; (accessed October 5, 2011)

The first, step-by-step guide to building Web-enabled data warehouses. The Web can be an incredibly rich source of customer data, and right now companies across industry sectors are hustling to get up and running with data warehouses capable of capturing the clickstream data from their Web sites. This allows companies to track exactly where a customer is going, or “clicking to,” on their site in order to gain meaningful information about that customer’s preferences. Following Ralph Kimball’s The Data Webhouse Toolkit (0-471-37680-9) where he provides the blueprint, Clickstream Data Warehousing fills developers in on all the technical details that go into building a Web-enabled data warehouse. The authors review all key architectural and design issues that developers need to masterfully build a Webhouse using examples to illustrate key points. Companion Web site features code examples from the book and links to related Web sites.

Building the Data Warehouse

D13Author: Inmon, W.H.

Third Edition .

John Wiley & Sons.© 2002.

<http://common.books24x7.com/toc.aspx?bookid=3761&gt; (accessed October 5, 2011)

Data Warehousing and Web Engineering

data-warehousing-and-web-engineeringAuthor: Becker, Shirley

IGI Global.© 2002.

<http://common.books24x7.com/toc.aspx?bookid=4093&gt; (accessed October 5, 2011)

This volume covers two pertinent topics that are continuously advancing the effective utilization and management of information technology applications. One objective of this book is to provide a forum for researchers and practitioners to share research about technical and managerial issues associated with data warehousing and mining. The other focus of this book is the concept of Web engineering, as it addresses how the originally intended use of the Web as a distributed system for knowledge-interchange seems to disappear, compared to the increasing number of e-commerce Web applications. The Web as a global point of sale seems to be very promising but obviously suffered from its heritage – the coarse-grained implementation model, which makes it harder and harder to develop, run and maintain still growing e-Commerce applications. Consequently Web engineering is applied to Web-based e-commerce applications.

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

the-data-warehouse-toolkit-the-complete-guide-to-dimensional-modelingAuthor: Kimball, Ralph, and Margy Ross.

Second Edition.

John Wiley & Sons.© 2002.

<http://common.books24x7.com/toc.aspx?bookid=6694&gt; (accessed October 5, 2011)

Single most authoritative guide from the inventor of the technique. Presents unique modeling techniques for e-commerce, and shows strategies for optimizing performance. Companion Web site provides updates on dimensional modeling techniques, links related to sites, and source code where appropriate.

ERP & Data Warehousing in Organizations: Issues and Challenges

D14Author: Gerald Grant

IGI Global.© 2003.

<http://common.books24x7.com/toc.aspx?bookid=5302> (accessed October 5, 2011)

 

магазин DVD фильмов
Battlefield 4 Beta обзоры, тесты, новости