Leveraging Db2 Data Warehouse Edition For Business Intelligence

Download Leveraging Db2 Data Warehouse Edition For Business Intelligence full books in PDF, epub, and Kindle. Read online Leveraging Db2 Data Warehouse Edition For Business Intelligence ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!

Leveraging DB2 10 for High Performance of Your Data Warehouse

Author : Whei-Jen Chen
Publisher : IBM Redbooks
ISBN 13 : 0738438979
Total Pages : 218 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis Leveraging DB2 10 for High Performance of Your Data Warehouse by : Whei-Jen Chen

Download or read book Leveraging DB2 10 for High Performance of Your Data Warehouse written by Whei-Jen Chen and published by IBM Redbooks. This book was released on 2014-01-08 with total page 218 pages. Available in PDF, EPUB and Kindle. Book excerpt: Building on the business intelligence (BI) framework and capabilities that are outlined in InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence, SG24-7813, this IBM® Redbooks® publication focuses on the new business insight challenges that have arisen in the last few years and the new technologies in IBM DB2® 10 for Linux, UNIX, and Windows that provide powerful analytic capabilities to meet those challenges. This book is organized in to two parts. The first part provides an overview of data warehouse infrastructure and DB2 Warehouse, and outlines the planning and design process for building your data warehouse. The second part covers the major technologies that are available in DB2 10 for Linux, UNIX, and Windows. We focus on functions that help you get the most value and performance from your data warehouse. These technologies include database partitioning, intrapartition parallelism, compression, multidimensional clustering, range (table) partitioning, data movement utilities, database monitoring interfaces, infrastructures for high availability, DB2 workload management, data mining, and relational OLAP capabilities. A chapter on BLU Acceleration gives you all of the details about this exciting DB2 10.5 innovation that simplifies and speeds up reporting and analytics. Easy to set up and self-optimizing, BLU Acceleration eliminates the need for indexes, aggregates, or time-consuming database tuning to achieve top performance and storage efficiency. No SQL or schema changes are required to take advantage of this breakthrough technology. This book is primarily intended for use by IBM employees, IBM clients, and IBM Business Partners.

Oracle Data Warehousing and Business Intelligence Solutions

Author : Robert Stackowiak
Publisher : John Wiley & Sons
ISBN 13 : 047012718X
Total Pages : 410 pages
Book Rating : 4.4/5 (71 download)

DOWNLOAD NOW!

Book Synopsis Oracle Data Warehousing and Business Intelligence Solutions by : Robert Stackowiak

Download or read book Oracle Data Warehousing and Business Intelligence Solutions written by Robert Stackowiak and published by John Wiley & Sons. This book was released on 2007-01-06 with total page 410 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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. Avoid many common pitfalls while learning best practices for: Leveraging Oracle technologies to design, build, and manage data warehouses Integrating specific database and business intelligence solutions from other vendors Using the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more Handling typical data warehouse performance challenges Uncovering initiatives by your business community, security business sponsorship, project staffing, and managing risk

Leveraging DB2 Data Warehouse Edition for Business Intelligence

Author : IBM Redbooks
Publisher : IBM.Com/Redbooks
ISBN 13 : 9780738496689
Total Pages : 570 pages
Book Rating : 4.4/5 (966 download)

DOWNLOAD NOW!

Book Synopsis Leveraging DB2 Data Warehouse Edition for Business Intelligence by : IBM Redbooks

Download or read book Leveraging DB2 Data Warehouse Edition for Business Intelligence written by IBM Redbooks and published by IBM.Com/Redbooks. This book was released on 2006-01-01 with total page 570 pages. Available in PDF, EPUB and Kindle. Book excerpt:

InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence

Author : Chuck Ballard
Publisher : IBM Redbooks
ISBN 13 : 0738434329
Total Pages : 636 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence by : Chuck Ballard

Download or read book InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence written by Chuck Ballard and published by IBM Redbooks. This book was released on 2010-06-22 with total page 636 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this IBM® Redbooks® publication we describe and demonstrate Version 9.7 of IBM InfoSphereTM Warehouse. InfoSphere Warehouse is a comprehensive platform with all the functionality required for developing robust infrastructure for business intelligence solutions. It enables companies to access and analyze operational and historical information, whether structured or unstructured, to gain business insight for improved decision making. InfoSphere Warehouse solutions simplify the processes of developing and maintaining a data warehousing infrastructure and can significantly enhance the time to value for business analytics. The InfoSphere Warehouse platform provides a fully integrated environment built around IBM DB2® 9.7 server technology on Linux®, UNIX® and Microsoft® Windows® platforms, as well as System z®. Common user interfaces support application development, data modeling and mapping, SQL transformation, online application processing (OLAP) and data mining functionality from virtually all types of information. Composed of a component-based architecture, it extends the DB2 data warehouse with design-side tooling and runtime infrastructure for OLAP, data mining, inLine analytics and intra-warehouse data movement and transformation, on a common platform.

Building the Data Warehouse

Author : W. H. Inmon
Publisher : John Wiley & Sons
ISBN 13 : 0471270482
Total Pages : 434 pages
Book Rating : 4.4/5 (712 download)

DOWNLOAD NOW!

Book Synopsis Building the Data Warehouse by : W. H. Inmon

Download or read book Building the Data Warehouse written by W. H. Inmon and published by John Wiley & Sons. This book was released on 2002-10-01 with total page 434 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Mastering the SAP Business Information Warehouse

Author : Kevin McDonald
Publisher : John Wiley & Sons
ISBN 13 : 047008345X
Total Pages : 722 pages
Book Rating : 4.4/5 (7 download)

DOWNLOAD NOW!

Book Synopsis Mastering the SAP Business Information Warehouse by : Kevin McDonald

Download or read book Mastering the SAP Business Information Warehouse written by Kevin McDonald and published by John Wiley & Sons. This book was released on 2007-03-15 with total page 722 pages. Available in PDF, EPUB and Kindle. Book excerpt: "This book is the definitive guide for SAP NetWeaver BI professionals. Based on their extraordinary expertise with the product, the authors provide deep insights about key innovations in the areas of user experience, query performance, integrated planning, and enterprise-wide data warehousing." —Stefan Sigg, Vice President, SAP NetWeaver Business Intelligence The long-anticipated publication of this second edition reflects the growing success of SAP NetWeaver as well as the various Business Intelligence (BI) capabilities that are embedded with SAP BW version 7.0. Written by SAP insiders, this comprehensive guide takes into account the ever-changing features, functionality, and toolsets of SAP NetWeaver to bring you the most updated information on how to use SAP BW to design, build, deploy, populate, access, analyze, present, and administer data. You'll discover the options that are available in SAP NetWeaver and uncover a new means to improve business performance. This book reflects the process an organization goes through during an implementation of the software. The authors begin with an introduction to BI and SAP NetWeaver and quickly progress to information modeling and enterprise data warehouse concepts. You'll learn how to access and deliver meaningful analytic information to the organization, as well as perform integrated planning functions. Finally, the authors share invaluable insight on warehouse administration, performance, and security. With more than 50 percent new or revised material, this second edition of Mastering the SAP Business Information Warehouse shows you how to: Extract data from online transaction processing systems Store transformed data in a way that best supports reporting and analysis Use the various Business Explorer tools such as BEx Report Designer, BEx Analyzer, BEx Broadcaster, and BEx Web Application Designer Schedule, monitor, troubleshoot, and archive data loads The companion Web site contains sample chapters in Wiki format and the authors' blog where readers may enter discussions about the book and SAP. Wiley Technology Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/ Visit the companion Web site at www.wiley.com/compbooks/mcdonald The companion Web site contains the sample code presented in the text of the book, plus implementation templates.

Leveraging IBM Cognos 8 BI for Linux on IBM System z

Author : Paolo Bruni
Publisher : IBM Redbooks
ISBN 13 : 0738433756
Total Pages : 218 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis Leveraging IBM Cognos 8 BI for Linux on IBM System z by : Paolo Bruni

Download or read book Leveraging IBM Cognos 8 BI for Linux on IBM System z written by Paolo Bruni and published by IBM Redbooks. This book was released on 2010-02-01 with total page 218 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this IBM® Redbooks® publication, we describe the role Cognos® plays in an Information On Demand (IOD) solution for IBM System z® and detail the functions of IBM Cognos 8 BI for Linux® on System z in current deployment scenarios. We show typical deployment architectures that show how to access disparate data sources both on and off the System z platform and show how the functions of the Cognos family of products provides a way to consolidate different BI solutions on System z. We provide examples of Cognos functions for resolving business requirements using reporting and OLAP capabilities as well as general deployment considerations of IBM Cognos 8 BI for Linux on System z. This publication is meant to help the Cognos Business Intelligence professional understand the strong points of System z architecture and the database specialist appreciate the Cognos family of products.

Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services

Author : Chuck Ballard
Publisher : IBM Redbooks
ISBN 13 : 0738432628
Total Pages : 276 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services by : Chuck Ballard

Download or read book Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services written by Chuck Ballard and published by IBM Redbooks. This book was released on 2009-04-27 with total page 276 pages. Available in PDF, EPUB and Kindle. Book excerpt: In this IBM Redbooks publication, we discuss and describe a multidimensional data warehousing infrastructure that can enable solutions for complex problems in an efficient and effective manner. The focus of this infrastructure is the InfoSphere Warehouse Cubing Services Feature. With this feature, DB2 becomes the data store for large volumes of data that you can use to perform multidimensional analysis, which enables viewing complex problems from multiple perspectives, which provides more information for management business decision making. This feature supports analytic tool interfaces from powerful data analysis tools, such as Cognos 8 BI, Microsoft Excel, and Alphablox. This is a significant capability that supports and enhances the analytics that clients use as they work to resolve problems with an ever growing scope, dimension, and complexity. Analyzing problems by performing more detailed queries on the data and viewing the results from multiple perspectives yields significantly more information and insight. Building multidimensional cubes based on underlying DB2 relational tables, without having to move or replicate the data, enables significantly more powerful data analysis with less work and leads to faster problem resolution with the capability for more informed management decision making. This capability is known as No Copy Analytics and is made possible with InfoSphere Warehouse Cubing Services.

Dimensional Modeling: In a Business Intelligence Environment

Author : Chuck Ballard
Publisher : IBM Redbooks
ISBN 13 : 0738496448
Total Pages : 670 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

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.

Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OS

Author : Paolo Bruni
Publisher : IBM Redbooks
ISBN 13 : 0738437093
Total Pages : 454 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OS by : Paolo Bruni

Download or read book Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OS written by Paolo Bruni and published by IBM Redbooks. This book was released on 2012-12-20 with total page 454 pages. Available in PDF, EPUB and Kindle. Book excerpt: The IBM® DB2® Analytics Accelerator Version 2.1 for IBM z/OS® (also called DB2 Analytics Accelerator or Query Accelerator in this book and in DB2 for z/OS documentation) is a marriage of the IBM System z® Quality of Service and Netezza® technology to accelerate complex queries in a DB2 for z/OS highly secure and available environment. Superior performance and scalability with rapid appliance deployment provide an ideal solution for complex analysis. This IBM Redbooks® publication provides technical decision-makers with a broad understanding of the IBM DB2 Analytics Accelerator architecture and its exploitation by documenting the steps for the installation of this solution in an existing DB2 10 for z/OS environment. In this book we define a business analytics scenario, evaluate the potential benefits of the DB2 Analytics Accelerator appliance, describe the installation and integration steps with the DB2 environment, evaluate performance, and show the advantages to existing business intelligence processes.

IBM Data Warehousing

Author : Michael L. Gonzales
Publisher : John Wiley & Sons
ISBN 13 : 0471457361
Total Pages : 706 pages
Book Rating : 4.4/5 (714 download)

DOWNLOAD NOW!

Book Synopsis IBM Data Warehousing by : Michael L. Gonzales

Download or read book IBM Data Warehousing written by Michael L. Gonzales and published by John Wiley & Sons. This book was released on 2003-02-25 with total page 706 pages. Available in PDF, EPUB and Kindle. Book excerpt: Reviews planning and designing architecture and implementing the data warehouse. Includes discussions on how and why to apply IBM tools. Offers tips, tricks, and workarounds to ensure maximum performance. Companion Web site includes technical notes, product updates, corrections, and links to relevant material and training.

InfoSphere Warehouse: Cubing Services and Client Access Interfaces

Author : Chuck Ballard
Publisher : IBM Redbooks
ISBN 13 : 073843194X
Total Pages : 446 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis InfoSphere Warehouse: Cubing Services and Client Access Interfaces by : Chuck Ballard

Download or read book InfoSphere Warehouse: Cubing Services and Client Access Interfaces written by Chuck Ballard and published by IBM Redbooks. This book was released on 2008-12-16 with total page 446 pages. Available in PDF, EPUB and Kindle. Book excerpt: Formerly known as DB2® Warehouse, InfoSphereTM Warehouse enables a unified, powerful data warehousing environment. It provides access to structured and unstructured data, as well as operational and transactional data. In this IBM® Redbooks® publication, we provide a brief overview of InfoSphere Warehouse, but the primary objective is to discuss and describe the capabilities of one particular component of the InfoSphere Warehouse, which is InfoSphere Warehouse Cubing Services. InfoSphere Warehouse Cubing Services is designed to provide a multidimensional view of data stored in relational databases, for significantly improved query and analysis capabilities. For this, there are particular schema designs that are typically used for these data warehouse and data mart databases, called dimensional, or cube, models. Optimization techniques are used to dramatically improve the performance of the OLAP queries, which are a core component of data warehousing and analytics. InfoSphere Warehouse Cubing Services works with business intelligence (BI) tools, and clients, such as Cognos® , Alphablox, and Microsoft® Excel® , through client interfaces, to accelerate OLAP queries from many data sources. We describe these interfaces and provide examples of how to use them to improve the performance of your OLAP queries.

Analytics Across the Enterprise

Author : Brenda L. Dietrich
Publisher : IBM Press
ISBN 13 : 013383588X
Total Pages : 223 pages
Book Rating : 4.1/5 (338 download)

DOWNLOAD NOW!

Book Synopsis Analytics Across the Enterprise by : Brenda L. Dietrich

Download or read book Analytics Across the Enterprise written by Brenda L. Dietrich and published by IBM Press. This book was released on 2014-05-15 with total page 223 pages. Available in PDF, EPUB and Kindle. Book excerpt: How to Transform Your Organization with Analytics: Insider Lessons from IBM’s Pioneering Experience Analytics is not just a technology: It is a better way to do business. Using analytics, you can systematically inform human judgment with data-driven insight. This doesn’t just improve decision-making: It also enables greater innovation and creativity in support of strategy. Your transformation won’t happen overnight; however, it is absolutely achievable, and the rewards are immense. This book demystifies your analytics journey by showing you how IBM has successfully leveraged analytics across the enterprise, worldwide. Three of IBM’s pioneering analytics practitioners share invaluable real-world perspectives on what does and doesn’t work and how you can start or accelerate your own transformation. This book provides an essential framework for becoming a smarter enterprise and shows through 31 case studies how IBM has derived value from analytics throughout its business. Coverage Includes Creating a smarter workforce through big data and analytics More effectively optimizing supply chain processes Systematically improving financial forecasting Managing financial risk, increasing operational efficiency, and creating business value Reaching more B2B or B2C customers and deepening their engagement Optimizing manufacturing and product management processes Deploying your sales organization to increase revenue and effectiveness Achieving new levels of excellence in services delivery and reducing risk Transforming IT to enable wider use of analytics “Measuring the immeasurable” and filling gaps in imperfect data Whatever your industry or role, whether a current or future leader, analytics can make you smarter and more competitive. Analytics Across the Enterprise shows how IBM did it--and how you can, too. Learn more about IBM Analytics

Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Author : Whei-Jen Chen
Publisher : IBM Redbooks
ISBN 13 : 0738437255
Total Pages : 506 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition by : Whei-Jen Chen

Download or read book Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition written by Whei-Jen Chen and published by IBM Redbooks. This book was released on 2012-10-02 with total page 506 pages. Available in PDF, EPUB and Kindle. Book excerpt: IBM® InfoSphere® Warehouse is the IBM flagship data warehouse platform for departmental data marts and enterprise data warehouses. It offers leading architecture, performance, backup, and recovery tools that help improve efficiency and reduce time to market through increased understanding of current data assets, while simplifying the daily operations of managing complex warehouse deployments. InfoSphere Warehouse Advanced Enterprise Edition delivers an enhanced set of database performance, management, and design tools. These tools assist companies in maintaining and increasing value from their warehouses, while helping to reduce the total cost of maintaining these complex environments. In this IBM Redbooks® publication we explain how you can build a business intelligence system with InfoSphere Warehouse Advanced Enterprise to manage and support daily business operations for an enterprise, to generate more income with lower cost. We describe the foundation of the business analytics, the Data Warehouse features and functions, and the solutions that can deliver immediate analytics solutions and help you drive better business outcomes. We show you how to use the advanced analytics of InfoSphere Warehouse Advanced Enterprise Edition and integrated tools for data modeling, mining, text analytics, and identifying and meeting the data latency requirements. We describe how the performance and storage optimization features can make building and managing a large data warehouse more affordable, and how they can help significantly reduce the cost of ownership. We also cover data lifecycle management and the key features of IBM Cognos® Business Intelligence. This book is intended for data warehouse professionals who are interested in gaining in-depth knowledge about the operational business intelligence solution for a data warehouse that the IBM InfoSphere Warehouse Advanced Enterprise Edition offers.

Business Analytics Case Studies

Author : Praveen Gujjar J.
Publisher : Rudra Publications
ISBN 13 : 9393767246
Total Pages : 97 pages
Book Rating : 4.3/5 (937 download)

DOWNLOAD NOW!

Book Synopsis Business Analytics Case Studies by : Praveen Gujjar J.

Download or read book Business Analytics Case Studies written by Praveen Gujjar J. and published by Rudra Publications. This book was released on with total page 97 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book is directed to Graduate (B.E, B.Com, BBM, BBS, and other related courses) post graduate diploma courses, Post Graduate (MBA, PGDM, M.Com, MMM, MFM, MHRM, and other Diploma courses in Management/Business Administration), taught-courses in Business, Commerce, Public Administration and Management fields.

Effective Business Intelligence Systems

Author : Robert J. Thierauf
Publisher : Bloomsbury Publishing USA
ISBN 13 : 0313001197
Total Pages : 390 pages
Book Rating : 4.3/5 (13 download)

DOWNLOAD NOW!

Book Synopsis Effective Business Intelligence Systems by : Robert J. Thierauf

Download or read book Effective Business Intelligence Systems written by Robert J. Thierauf and published by Bloomsbury Publishing USA. This book was released on 2001-06-30 with total page 390 pages. Available in PDF, EPUB and Kindle. Book excerpt: One step above knowledge management systems are business intelligence systems. Their purpose is to give decision makers a better understanding of their organization's operations, and thus another way to outmaneuver the competition, by helping to find and extract the meaningful relationships, trends, and correlations that underlie the organization's operations and ultimately contribute to its success. Thierauf also shows that by tying critical success factors and key performance indicators into business intelligence systems, an organization's most important financial ratios can also be improved. Comprehensive and readable, Thierauf's book will advance the knowledge and skills of all information systems providers and users. It will also be useful as a text in upper-level courses covering a wide range of topics essential to an understanding of executive business systems generally, and specifically their creation and management. The theme underlying Thierauf's unique text is that a thorough understanding of a company's operations is crucial if the company is to be moved to a higher level of competitive advantage. Although data warehousing, data mining, the Internet, the World Wide Web, and other electronic aids have been in place for at least a decade, it is the remarkable and unique capability of business intelligence systems to utilize them that has in turn revolutionized the ability of decision makers to find, accumulate, organize, and access a wider range of information than was ever before possible. Effective business intelligence systems give decision makers a means to keep their fingers on the pulse of their businesses every step of the way. From this it follows that they are thus able to develop new, more workable means to cope with the competition successfully. Comprehensive and readable, Thierauf's book will advance the knowledge and skills of all information systems providers and users. It will also be useful as a text in upper-level courses covering a wide range of topics essential to an understanding of executive business systems generally, and specifically their creation and management.

Co-locating Transactional and Data Warehouse Workloads on System z

Author : Mike Ebbers
Publisher : IBM Redbooks
ISBN 13 : 0738434787
Total Pages : 540 pages
Book Rating : 4.7/5 (384 download)

DOWNLOAD NOW!

Book Synopsis Co-locating Transactional and Data Warehouse Workloads on System z by : Mike Ebbers

Download or read book Co-locating Transactional and Data Warehouse Workloads on System z written by Mike Ebbers and published by IBM Redbooks. This book was released on 2010-12-03 with total page 540 pages. Available in PDF, EPUB and Kindle. Book excerpt: As business cycles speed up, many customers gain significant competitive advantage from quicker and more accurate business decision-making by using real data. For many customers, choosing the path to co-locate their transactional and analytical workloads on System z® better leverages their existing investment in hardware, software, and skills. We created a project to address a number of best practice questions on how to manage these newer, analytical type workloads, especially when co-located with traditional transactional workloads. The goal of this IBM® Redbooks® publication is to provide technical guidance and performance trade-offs associated with resource management and potentially DB2® data-sharing in a variety of mixed transactional / data warehouse System z topologies. The term co-location used here and in the rest of the book is specifically defined as the practice of housing both transactional (OLTP) and data warehouse (analytical) workloads within the same System z configuration. We also assumed that key portions of the transactional and data warehouse databases would reside on DB2 for z/OS®. The databases may or may not reside in a DB2 data-sharing environment; we discuss those pros and cons in this book. The intended audience includes DB2 data warehouse architects and practitioners who are facing choices in resource management and system topologies in the data warehouse arena. This specifically includes Business Intelligence (BI) administrators, DB2 database administrators (DBAs) and z/OS performance administrators / systems programmers. In addition, decision makers and architects can utilize this book to assist in making platform and database topology decisions. The book is divided into four parts. Part I, "Introducing the co-location project" covers the System z value proposition and why one should consider System z as the central platform for their data warehousing / business analytics needs. Some topics are risk avoidance via data consolidation, continuous availability, simplified disaster recovery, IBM Smart Analytics Optimizer, reduced network bandwidth requirements, and the unique virtualization and resource management capabilities of System z LPAR, z/VM® and WLM. Part I also provides some of the common System z co-location topologies along with an explanation of the general pros and cons of each. This would be useful input for an architect to understand where a customer is today and where they might consider moving to. Part II, "Project environment" covers the environment, products, workloads, workload drivers, and data models implemented for this study. The environment consisted of a logically partitioned z10TM 32way, running z/VM, Linux®, and z/OS operating system instances. On those instances we ran products such as z/OS DB2 V9, IBM Cognos® Business Intelligence Version 8.4 for Linux on System z, InfoSphereTM Warehouse for System z, InfoSphere Change Data Capture, z/OS WebSphere® V7, Tivoli® Omegamon for DB2 Performance expert. Utilizing these products we created transactional (OLTP), data warehouse query, and data warehouse refresh workloads. All the workloads were based on an existing web-based transactional Bookstore workload, that's currently utilized for internal testing within the System p® and z labs. While some IBM Cognos BI and ISWz product usage and experiences information is covered in this book, we do not go into the depth typically found in IBM Redbooks publications, since there's another book focused specifically on that