Data Integration Blueprint and Modeling


Book Description

Making Data Integration Work: How to Systematically Reduce Cost, Improve Quality, and Enhance Effectiveness Today’s enterprises are investing massive resources in data integration. Many possess thousands of point-to-point data integration applications that are costly, undocumented, and difficult to maintain. Data integration now accounts for a major part of the expense and risk of typical data warehousing and business intelligence projects--and, as businesses increasingly rely on analytics, the need for a blueprint for data integration is increasing now more than ever. This book presents the solution: a clear, consistent approach to defining, designing, and building data integration components to reduce cost, simplify management, enhance quality, and improve effectiveness. Leading IBM data management expert Tony Giordano brings together best practices for architecture, design, and methodology, and shows how to do the disciplined work of getting data integration right. Mr. Giordano begins with an overview of the “patterns” of data integration, showing how to build blueprints that smoothly handle both operational and analytic data integration. Next, he walks through the entire project lifecycle, explaining each phase, activity, task, and deliverable through a complete case study. Finally, he shows how to integrate data integration with other information management disciplines, from data governance to metadata. The book’s appendices bring together key principles, detailed models, and a complete data integration glossary. Coverage includes Implementing repeatable, efficient, and well-documented processes for integrating data Lowering costs and improving quality by eliminating unnecessary or duplicative data integrations Managing the high levels of complexity associated with integrating business and technical data Using intuitive graphical design techniques for more effective process and data integration modeling Building end-to-end data integration applications that bring together many complex data sources




Data Integration Blueprint and Modeling


Book Description

Making Data Integration Work: How to Systematically Reduce Cost, Improve Quality, and Enhance Effectiveness Today's enterprises are investing massive resources in data integration. Many possess thousands of point-to-point data integration applications that are costly, undocumented, and difficult to maintain. Data integration now accounts for a major part of the expense and risk of typical data warehousing and business intelligence projects--and, as businesses increasingly rely on analytics, the need for a blueprint for data integration is increasing now more than ever. This book presen.







Common Information Models for an Open, Analytical, and Agile World


Book Description

Maximize the Value of Your Information Throughout Even the Most Complex IT Project Foreword by Tim Vincent, IBM Fellow and Vice President, CTO for IBM Analytics Group To drive maximum value from complex IT projects, IT professionals need a deep understanding of the information their projects will use. Too often, however, IT treats information as an afterthought: the “poor stepchild” behind applications and infrastructure. That needs to change. This book will help you change it. Five senior IBM architects show you how to use information-centric views to give data a central role in project design and delivery. Using Common Information Models (CIM), you learn how to standardize the way you represent information, making it easier to design, deploy, and evolve even the most complex systems. Using a complete case study, the authors explain what CIMs are, how to build them, and how to maintain them. You learn how to clarify the structure, meaning, and intent of any information you may exchange, and then use your CIM to improve integration, collaboration, and agility. In today’s mobile, cloud, and analytics environments, your information is more valuable than ever. To build systems that make the most of it, start right here. Coverage Includes • Mastering best practices for building and maintaining a CIM • Understanding CIM components and artifacts: scope, perspectives, and depth of detail • Choosing the right patterns for structuring your CIM • Integrating a CIM into broader governance • Using tools to manage your CIM more effectively • Recognizing the importance of non-functional characteristics, such as availability, performance, and security, in system design • Growing CIM value by expanding their scope and usage • Previewing the future of CIMs




IBM Cognos 10 Report Studio


Book Description

IBM Cognos 10 is the next generation of the leading performance management, analysis, and reporting standard for mid- to large-sized companies. One of the most exciting and useful aspects of IBM Cognos software is its powerful custom report creation capabilities. After learning the basics, report authors in the enterprise need to apply the technology to reports in their actual, complex work environment. This book provides that advanced know how. Using practical examples based on years of teaching experiences as IBM Cognos instructors, the authors provide you with examples of typical advanced reporting designs and complex queries in reports. The reporting solutions in this book can be directly used in a variety of real-world scenarios to provide answers to your business problems today. The complexity of the queries and the application of design principles go well beyond basic course content or introductory books. IBM Cognos 10 Report Studio: Practical Examples will help you find the answers to specific questions based on your data and your business model. It will use a combination tutorial and cookbook approach to show real-world IBM Cognos 10 Report Studio solutions. If you are still using IBM Cognos 8 BI Report Studio, many of the examples have been tested against this platform as well. The final chapter has been dedicated to showing those features that are unique to the latest version of this powerful reporting solution.




IBM Cognos Business Intelligence v10


Book Description

Maximize the Value of Business Intelligence with IBM Cognos v10 -- Hands-on, from Start to Finish This easy-to-use, hands-on guide brings together all the information and insight you need to drive maximum business value from IBM Cognos v10. Long-time IBM Cognos expert and product designer Sangeeta Gautam thoroughly illuminates Cognos BI v10’s key capabilities: analysis, query, reporting, and dashboards. Gautam shows how to take full advantage of each key IBM Cognos feature, including brand-new innovations such as Active Reports and the new IBM Cognos Workspace report consumption environment. She concludes by walking you through successfully planning and implementing an integrated business intelligence solution using IBM’s best-practice methodologies. The first and only guide of its kind, IBM Cognos Business Intelligence v10 offers expert insights for BI designers, architects, developers, administrators, project managers, nontechnical end-users, and partners throughout all areas of the business—from sales and marketing to operations and lines of business. If you’re pursuing official IBM Cognos certification, you’ll also find Cognos certification sample questions and information to help you with the certification process. Coverage Includes • Understanding IBM Cognos BI’s components and open, extensible architecture • Working with IBM Cognos key “studio” tools: Analysis Studio, Query Studio, Report Studio, and Event Studio • Developing and managing powerful reports that draw on the rich capabilities of IBM Cognos Workspace and Workspace Advanced • Designing Star Schema databases and metadata models to answer the questions your organization cares about most • Efficiently maintaining and systematically securing IBM Cognos BI environments and their objects • Using IBM Cognos Connection as your single point of entry to all corporate data • Building interactive, easy-to-manage Active Reports for casual business users • Using new IBM Cognos BI v10.1 Dynamic Query Mode (DQM) to improve performance with complex heterogeneous data • Identifying, exploring, and exploiting hidden data relationships • Creating quick ad hoc queries that deliver fast answers • Establishing user and administrator roles




Performing Information Governance


Book Description

Using case studies and hands-on activities, this book discusses topics in information governance (IG): recognizing hidden development and operational implications of IG--and why it needs to be integrated in the broader organization; integrating IG activities with transactional processing, BI, MDM, and other enterprise information management functions; the information governance organization: defining roles, launching projects, and integrating with ongoing operations; performing IG in transactional projects, including those using agile methods and COTS products; bringing stronger information governance to MDM: strategy, architecture, development, and beyond; governing information throughout the BI or big data project lifecycle; performing ongoing IG and data stewardship operational processes; auditing and enforcing data quality management in the context of enterprise information management; maintaining and evolving metadata management for maximum business value. -- $c Edited summary from book.




Beyond Big Data


Book Description

Drive Powerful Business Value by Extending MDM to Social, Mobile, Local, and Transactional Data Enterprises have long relied on Master Data Management (MDM) to improve customer-related processes. But MDM was designed primarily for structured data. Today, crucial information is increasingly captured in unstructured, transactional, and social formats: from tweets and Facebook posts to call center transcripts. Even with tools like Hadoop, extracting usable insight is difficult--often, because it's so difficult to integrate new and legacy data sources. In Beyond Big Data, five of IBM's leading data management experts introduce powerful new ways to integrate social, mobile, location, and traditional data. Drawing on pioneering experience with IBM's enterprise customers, they show how Social MDM can help you deepen relationships, improve prospect targeting, and fully engage customers through mobile channels. Business leaders and practitioners will discover powerful new ways to combine social and master data to improve performance and uncover new opportunities. Architects and other technical leaders will find a complete reference architecture, in-depth coverage of relevant technologies and use cases, and domain-specific best practices for their own projects. Coverage Includes How Social MDM extends fundamental MDM concepts and techniques Architecting Social MDM: components, functions, layers, and interactions Identifying high value relationships: person to product and person to organization Mapping Social MDM architecture to specific products and technologies Using Social MDM to create more compelling customer experiences Accelerating your transition to highly-targeted, contextual marketing Incorporating mobile data to improve employee productivity Avoiding privacy and ethical pitfalls throughout your ecosystem Previewing Semantic MDM and other emerging trends




Principles of Data Integration


Book Description

Principles of Data Integration is the first comprehensive textbook of data integration, covering theoretical principles and implementation issues as well as current challenges raised by the semantic web and cloud computing. The book offers a range of data integration solutions enabling you to focus on what is most relevant to the problem at hand. Readers will also learn how to build their own algorithms and implement their own data integration application. Written by three of the most respected experts in the field, this book provides an extensive introduction to the theory and concepts underlying today's data integration techniques, with detailed, instruction for their application using concrete examples throughout to explain the concepts. This text is an ideal resource for database practitioners in industry, including data warehouse engineers, database system designers, data architects/enterprise architects, database researchers, statisticians, and data analysts; students in data analytics and knowledge discovery; and other data professionals working at the R&D and implementation levels. - Offers a range of data integration solutions enabling you to focus on what is most relevant to the problem at hand - Enables you to build your own algorithms and implement your own data integration applications




Emerging Perspectives in Big Data Warehousing


Book Description

The concept of a big data warehouse appeared in order to store moving data objects and temporal data information. Moving objects are geometries that change their position and shape continuously over time. In order to support spatio-temporal data, a data model and associated query language is needed for supporting moving objects. Emerging Perspectives in Big Data Warehousing is an essential research publication that explores current innovative activities focusing on the integration between data warehousing and data mining with an emphasis on the applicability to real-world problems. Featuring a wide range of topics such as index structures, ontology, and user behavior, this book is ideally designed for IT consultants, researchers, professionals, computer scientists, academicians, and managers.