Data Warehousing Fundamentals

A Comprehensive Guide for IT Professionals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

ISBN: 0471463892

Category: Computers

Page: 544

View: 8045

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. Market: IT Professionals, Consultants.

Data Warehousing Fundamentals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

ISBN: 9788126509195

Category:

Page: 544

View: 2220

Market_Desc: · IT professionals· Undergraduate students specializing in information technology· Consultants Special Features: · Includes review questions and exercises· Filled with industry examples· The author has 25 years of experience in IT specializing in data warehousing About The Book: 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. This book covers the fundamentals of data warehousing specifically for the IT professionals who wants to get into the field.

Data Warehousing Fundamentals for IT Professionals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

ISBN: 1118211308

Category: Computers

Page: 600

View: 2826

Cutting-edge content and guidance from a data warehousing expert—now expanded to reflect field trends Data warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of Data Warehousing Fundamentals, numerous enterprises have implemented data warehouse systems and reaped enormous benefits. Many more are in the process of doing so. Now, this new, revised edition covers the essential fundamentals of data warehousing and business intelligence as well as significant recent trends in the field. The author provides an enhanced, comprehensive overview of data warehousing together with in-depth explanations of critical issues in planning, design, deployment, and ongoing maintenance. IT professionals eager to get into the field will gain a clear understanding of techniques for data extraction from source systems, data cleansing, data transformations, data warehouse architecture and infrastructure, and the various methods for information delivery. This practical Second Edition highlights the areas of data warehousing and business intelligence where high-impact technological progress has been made. Discussions on developments include data marts, real-time information delivery, data visualization, requirements gathering methods, multi-tier architecture, OLAP applications, Web clickstream analysis, data warehouse appliances, and data mining techniques. The book also contains review questions and exercises for each chapter, appropriate for self-study or classroom work, industry examples of real-world situations, and several appendices with valuable information. Specifically written for professionals responsible for designing, implementing, or maintaining data warehousing systems, Data Warehousing Fundamentals presents agile, thorough, and systematic development principles for the IT professional and anyone working or researching in information management.

Data Warehousing in the Age of Big Data

Author: Krish Krishnan

Publisher: Newnes

ISBN: 0124059201

Category: Computers

Page: 370

View: 1492

Data Warehousing in the Age of the Big Data will help you and your organization make the most of unstructured data with your existing data warehouse. As Big Data continues to revolutionize how we use data, it doesn't have to create more confusion. Expert author Krish Krishnan helps you make sense of how Big Data fits into the world of data warehousing in clear and concise detail. The book is presented in three distinct parts. Part 1 discusses Big Data, its technologies and use cases from early adopters. Part 2 addresses data warehousing, its shortcomings, and new architecture options, workloads, and integration techniques for Big Data and the data warehouse. Part 3 deals with data governance, data visualization, information life-cycle management, data scientists, and implementing a Big Data–ready data warehouse. Extensive appendixes include case studies from vendor implementations and a special segment on how we can build a healthcare information factory. Ultimately, this book will help you navigate through the complex layers of Big Data and data warehousing while providing you information on how to effectively think about using all these technologies and the architectures to design the next-generation data warehouse. Learn how to leverage Big Data by effectively integrating it into your data warehouse. Includes real-world examples and use cases that clearly demonstrate Hadoop, NoSQL, HBASE, Hive, and other Big Data technologies Understand how to optimize and tune your current data warehouse infrastructure and integrate newer infrastructure matching data processing workloads and requirements

The Data Warehouse Toolkit

The Definitive Guide to Dimensional Modeling

Author: Ralph Kimball,Margy Ross

Publisher: John Wiley & Sons

ISBN: 1118732286

Category: Computers

Page: 600

View: 8969

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence Begins with fundamental design recommendations and progresses through increasingly complex scenarios Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

Building the Data Warehouse

Author: W. H. Inmon

Publisher: John Wiley & Sons

ISBN: 0471774235

Category: Computers

Page: 543

View: 4115

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 Discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects 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

Dimensional Modeling: In a Business Intelligence Environment

Author: Chuck Ballard,Daniel M. Farrell,Amit Gupta,Carlos Mazuela,Stanislav Vohnik,IBM Redbooks

Publisher: IBM Redbooks

ISBN: 0738496448

Category: Computers

Page: 664

View: 7864

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.

Fundamentals of Data Warehouses

Author: Matthias Jarke,Maurizio Lenzerini,Yannis Vassiliou,Panos Vassiliadis

Publisher: Springer Science & Business Media

ISBN: 3662041383

Category: Computers

Page: 195

View: 1766

The first comparative review of the state of the art and best current practice in data warehousing. It covers source and data integration, multidimensional aggregation, query optimisation, update propagation, metadata management, quality assessment, and design optimisation. Also, based on results of the European DWQ project, it offers a conceptual framework by which the architecture and quality of data warehousing efforts can be assessed and improved using enriched metadata management combined with advanced techniques from databases, business modelling, and artificial intelligence. An excellent introduction to the issues of quality and metadata usage for researchers and database professionals in academia and industry. XXXXXXX Neuer Text This book presents the first comparative review of the state-of-the-art and the best current practices of data warehouses. It covers source and data integration, multidimensional aggregation, query optimization, metadata management, quality assessment, and design optimization. A conceptual framework is presented by which the architecture and quality of a data warehouse can be assessed and improved using enriched metadata management combined with advanced techniques from databases, business modeling, and artificial intelligence.

Star Schema The Complete Reference

Author: Christopher Adamson

Publisher: McGraw Hill Professional

ISBN: 9780071744331

Category: Computers

Page: 510

View: 5803

The definitive guide to dimensional design for your data warehouse Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a comprehensive resource for experts. This all-inclusive volume begins with dimensional design fundamentals and shows how they fit into diverse data warehouse architectures, including those of W.H. Inmon and Ralph Kimball. The book progresses through a series of advanced techniques that help you address real-world complexity, maximize performance, and adapt to the requirements of BI and ETL software products. You are furnished with design tasks and deliverables that can be incorporated into any project, regardless of architecture or methodology. Master the fundamentals of star schema design and slow change processing Identify situations that call for multiple stars or cubes Ensure compatibility across subject areas as your data warehouse grows Accommodate repeating attributes, recursive hierarchies, and poor data quality Support conflicting requirements for historic data Handle variation within a business process and correlation of disparate activities Boost performance using derived schemas and aggregates Learn when it's appropriate to adjust designs for BI and ETL tools

Business Intelligence and Data Warehousing Simplified

500 Questions, Answers, and Tips

Author: Arshad Khan

Publisher: Mercury Learning & Information

ISBN: 9781936420322

Category: Computers

Page: 296

View: 6946

This book targets business and IT professionals who need an introduction to business intelligence and data warehousing fundamentals through a simple question / answer format. Topics include evolution and fundamentals, characteristics and process, architecture and objects, metadata, data conversion, ETL, data storage, infrastructure, data access, data marts, implementation approaches, planning, design, Inmon vs. Kimball, multi-dimensionality, OLAP, facts and dimensions, common mistakes and tips, trends, etc.

An R and S-Plus® Companion to Multivariate Analysis

Author: Brian S. Everitt

Publisher: Springer Science & Business Media

ISBN: 1846281245

Category: Mathematics

Page: 221

View: 9372

Applied statisticians often need to perform analyses of multivariate data; for these they will typically use one of the statistical software packages, S-Plus or R. This book sets out how to use these packages for these analyses in a concise and easy-to-use way, and will save users having to buy two books for the job. The author is well-known for this kind of book, and so buyers will trust that he’s got it right.

E-Data

Turning Data Into Information with Data Warehousing

Author: Jill Dyché

Publisher: Addison-Wesley Professional

ISBN: 9780201657807

Category: Business & Economics

Page: 335

View: 7812

Dyche presents the complete manager's briefing on what data warehousing technology can do today and how to achieve optimal results. Using real-world case studies from Charles Schwab, Bank of America, Qantas, 20th Century Fox, and others, she covers decision support, database marketing, and many industry-specific data warehouse applications.

Mastering Data Warehouse Aggregates

Solutions for Star Schema Performance

Author: Christopher Adamson

Publisher: John Wiley & Sons

ISBN: 1118429184

Category: Computers

Page: 384

View: 5591

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

Managing the data warehouse

Author: William H. Inmon,J. D. Welch,Katherine L. Glassey

Publisher: John Wiley & Sons Inc

ISBN: N.A

Category: Computers

Page: 386

View: 6822

A data warehouse allows enterprises to store and access vast amounts of information quickly and efficiently. The authors look at how to monitor data warehouse performance, administer the necessary tools and system interfaces, and manage growth.

Information Privacy Fundamentals for Librarians and Information Professionals

Author: Cherie L. Givens

Publisher: Rowman & Littlefield

ISBN: 1442228822

Category: Language Arts & Disciplines

Page: 146

View: 5924

This book introduces library and information professionals to information privacy, provides an overview of information privacy in the library and information science context, U.S. privacy laws by sector, information privacy policy, and key considerations when planning and creating a privacy program.

Business Metadata: Capturing Enterprise Knowledge

Author: W.H. Inmon,Bonnie O'Neil,Lowell Fryman

Publisher: Morgan Kaufmann

ISBN: 9780080552200

Category: Computers

Page: 312

View: 1723

Business Metadata: Capturing Enterprise Knowledge is the first book that helps businesses capture corporate (human) knowledge and unstructured data, and offer solutions for codifying it for use in IT and management. Written by Bill Inmon, one of the fathers of the data warehouse and well-known author, the book is filled with war stories, examples, and cases from current projects. It includes a complete metadata acquisition methodology and project plan to guide readers every step of the way, and sample unstructured metadata for use in self-testing and developing skills. This book is recommended for IT professionals, including those in consulting, working on systems that will deliver better knowledge management capability. This includes people in these positions: data architects, data analysts, SOA architects, metadata analysts, repository (metadata data warehouse) managers as well as vendors that have a metadata component as part of their systems or tools. First book that helps businesses capture corporate (human) knowledge and unstructured data, and offer solutions for codifying it for use in IT and management Written by Bill Inmon, one of the fathers of the data warehouse and well-known author, and filled with war stories, examples, and cases from current projects Very practical, includes a complete metadata acquisition methodology and project plan to guide readers every step of the way Includes sample unstructured metadata for use in self-testing and developing skills

Data Warehouse Systems

Design and Implementation

Author: Alejandro Vaisman,Esteban Zimányi

Publisher: Springer

ISBN: 3642546552

Category: Computers

Page: 625

View: 6314

With this textbook, Vaisman and Zimányi deliver excellent coverage of data warehousing and business intelligence technologies ranging from the most basic principles to recent findings and applications. To this end, their work is structured into three parts. Part I describes “Fundamental Concepts” including multi-dimensional models; conceptual and logical data warehouse design and MDX and SQL/OLAP. Subsequently, Part II details “Implementation and Deployment,” which includes physical data warehouse design; data extraction, transformation, and loading (ETL) and data analytics. Lastly, Part III covers “Advanced Topics” such as spatial data warehouses; trajectory data warehouses; semantic technologies in data warehouses and novel technologies like Map Reduce, column-store databases and in-memory databases. As a key characteristic of the book, most of the topics are presented and illustrated using application tools. Specifically, a case study based on the well-known Northwind database illustrates how the concepts presented in the book can be implemented using Microsoft Analysis Services and Pentaho Business Analytics. All chapters are summarized using review questions and exercises to support comprehensive student learning. Supplemental material to assist instructors using this book as a course text is available at http://cs.ulb.ac.be/DWSDIbook/, including electronic versions of the figures, solutions to all exercises, and a set of slides accompanying each chapter. Overall, students, practitioners and researchers alike will find this book the most comprehensive reference work on data warehouses, with key topics described in a clear and educational style.

Data Warehousing Fundamentals

A Comprehensive Guide for IT Professionals

Author: Paulraj Ponniah

Publisher: Wiley-Interscience

ISBN: 9780471412540

Category: Computers

Page: 544

View: 7034

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. Market: IT Professionals, Consultants.

Principles of Database Management

The Practical Guide to Storing, Managing and Analyzing Big and Small Data

Author: Wilfried Lemahieu,Seppe vanden Broucke,Bart Baesens

Publisher: Cambridge University Press

ISBN: 1107186129

Category: Computers

Page: 903

View: 2733

Introductory, theory-practice balanced text teaching the fundamentals of databases to advanced undergraduates or graduate students in information systems or computer science.