This IBM® Redbooks® publication provides guidance about how to configure, monitor, and manage your IBM System Storage® DS8800 and DS8700 storage systems to achieve optimum performance. It describes the DS8800 and DS8700 performance features and characteristics, including IBM System Storage Easy Tier® and DS8000® I/O Priority Manager. It also describes how they can be used with the various server platforms that attach to the storage system. Then, in separate chapters, we detail specific performance recommendations and discussions that apply for each server environment, as well as for database and DS8000 Copy Services environments. We also outline the various tools available for monitoring and measuring I/O performance for different server environments, as well as describe how to monitor the performance of the entire DS8000 storage system. This book is intended for individuals who want to maximize the performance of their DS8800 and DS8700 storage systems and investigate the planning and monitoring tools that are available. The IBM System Storage DS8800 and DS8700 storage system features, as described in this book, are available for the DS8700 with Licensed Machine Code (LMC) level 6.6.2x.xxx or higher and the DS8800 with Licensed Machine Code (LMC) level 7.6.2x.xxx or higher. For information about optimizing performance with the previous DS8000 models, DS8100 and DS8300, see the following IBM Redbooks publication: DS8000 Performance Monitoring and Tuning, SG24-7146.

To meet today's complex and ever-changing business demands, you need a solid foundation of compute, storage, networking, and software resources. This system must be simple to deploy, and be able to quickly and automatically adapt to changing conditions. You also need to be able to take advantage of broad expertise and proven guidelines in systems management, applications, hardware maintenance, and more. The IBM® PureFlex™ System combines no-compromise system designs along with built-in expertise and integrates them into complete, optimized solutions. At the heart of PureFlex System is the IBM Flex System™ Enterprise Chassis. This fully integrated infrastructure platform supports a mix of compute, storage, and networking resources to meet the demands of your applications. The solution is easily scalable with the addition of another chassis with the required nodes. With the IBM Flex System Manager, multiple chassis can be monitored from a single panel. The 14 node, 10U chassis delivers high speed performance complete with integrated servers, storage, and networking. This flexible chassis is simple to deploy now, and to scale to meet your needs in the future. This IBM Redbooks® publication describes IBM PureFlex System and IBM Flex System. It highlights the technology and features of the chassis, compute nodes, management features, and connectivity options. Guidance is provided about every major component, and about networking and storage connectivity. This book is intended for customers, Business Partners, and IBM employees who want to know the details about the new family of products. It assumes that you have a basic understanding of blade server concepts and general IT knowledge.

Beginning T-SQL 2012 is the first step toward learning the T-SQL language that underlies Microsoft's SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL 2012 starts you on the path to mastering T-SQL, with an emphasis on best practices and sound coding techniques. Beginning T-SQL 2012 begins with an introduction to databases, normalization, and to SQL Server Management Studio. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in each chapter give readers an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional. Imparts best practices for writing T-SQL Helps you avoid common errors Shows how to write scalable code for good performance

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals. What you'll learn from Expert Performance Indexing for SQL Server 2012 will help you understand what indexes are doing in the database and what can be done to mitigate and improve their effects on performance. The final destination is a guided tour through a number of real-world scenarios and approaches that can be taken to investigate, mitigate, and improve the performance of your database. Defines indexes and provides an understanding of their role Uncovers and explains the statistics that are kept in indexes Teaches strategies and approaches for indexing databases What you'll learn Fully understand the index types at your disposal Recognize and remove unnecessary indexes Review statistics to understand indexing choices made by the optimizer Properly apply strategies such as covering indexes, included columns, index intersections, and more Write queries to make good use of the indexes already in place Design effective indexes for full-text, spatial, and XML data types Manage the big picture: Encompassing all indexes in a database, and all database instances on a server Who this book is for Expert Performance Indexing for SQL Server 2012 is intended for database administrators and developers who are ready to boost the performance of their environments without the need to go in blindly building indexes.

Pixel shaders are some of the more powerful graphic tools available for XAML programmers, but shader development bears little resemblance to traditional .NET programming. With this hands-on book, you’ll not only discover how to use existing shaders in your Windows Presentation Foundation (WPF) and Silverlight applications, you’ll also learn how create your own effects with XAML and Microsoft’s HLSL shading language. In the process, you’ll write, compile, and test custom XAML shaders with the Shazzam Shader Editor, a free utility developed by author Walt Ritscher. The book includes XAML and C# sample code, and Shazzam contains all of the sample shaders discussed. Learn how shaders help you extend the GPU’s rendering capabilities Explore prevailing shader types, such as color modification, blurring, and spatial transformation Get a quick tour of the shader features, and use pre-built effects on image elements in your application Examine the XAML ShaderEffect class to understand how WPF and Silverlight use shaders Learn about the shader-specific tools available in Visual Studio and Expression Blend Get up to speed on HLSL basics and learn how to create a variety of graphics effects

Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you'll learn to discover and represent the details and scope of any design problem you choose to attack. Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit. Provides solid design principles by which to avoid pitfalls and support changing needs Includes numerous examples of good and bad design decisions and their consequences Shows a modern method for documenting design using the Unified Modeling Language What you'll learn Avoid the most common pitfalls in database design. Create clear use cases from project requirements. Design a data model to support the use cases. Apply generalization and specialization appropriately. Secure future flexibility through a normalized design. Ensure integrity through relationships, keys, and constraints. Successfully implement your data model as a relational schema. Who this book is for Beginning Database Design, Second Edition is aimed at desktop power users, developers, database administrators, and others who are charged with caring for data and storing it in ways that preserve its meaning and integrity. Desktop users will appreciate the coverage of Excel as a plausible "database" for research systems and lab environments. Developers and database designers will find insight from the clear discussions of design approaches and their pitfalls and benefits. All readers will benefit from learning a modern notation for documenting designs that is based upon the widely used and accepted Universal Modeling Language.

Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You'll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source. Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers. Helps you design and develop robust, efficient, scalable ETL solutions Walks you through using the built-in, stock components Shows how to programmatically extend the power of SSIS to cover any possible scenario

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

Longitudinal studies often investigate how a marker that is repeatedly measured in time is associated with a time to an event of interest. An example is prostate cancer studies where longitudinal PSA level measurements are collected in conjunction with the time-to-recurrence. This book provides a full treatment of joint models for longitudinal and time-to-event data. The content is explanatory rather than mathematically rigorous and emphasizes applications. All illustrations put forward are available in the R programming language via the freely available package JM written by the author.

Queries not running fast enough? Tired of the phone calls from frustrated users? Grant Fritchey's book SQL Server 2012 Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques. It is current with SQL Server 2012. It provides the tools you need to approach your queries with performance in mind. SQL Server 2012 Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You'll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. You'll learn to recognize bottlenecks and defuse them before the phone rings. You'll learn some quick solutions too, but emphasis is on designing for performance and getting it right, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server 2012 Query Performance Tuning into practice today. Establish performance baselines and monitor against them Troubleshoot and eliminate bottlenecks that frustrate users Plan ahead to achieve the right level of performance

To meet today’s complex and ever-changing business demands, you need a solid foundation of compute, storage, networking, and software resources that is simple to deploy and can quickly and automatically adapt to changing conditions. You also need to be able to take advantage of broad expertise and proven preferred practices in systems management, applications, hardware maintenance, and more. The IBM® Flex System™ p260 and p460 Compute Nodes are IBM Power Systems™ servers optimized for virtualization, performance, and efficiency. The nodes support IBM AIX®, IBM i, or Linux operating environments, and are designed to run various workloads in IBM PureFlex™ System. This IBM Redbooks® publication is a comprehensive guide to IBM PureFlex System and the Power Systems compute nodes. We introduce the offerings and describe the compute nodes in detail. We then describe planning and implementation steps and go through some of the key the management features of the IBM Flex System Manager management node. This book is for customers, IBM Business Partners, and IBM technical specialists that want to understand the new offerings and to plan and implement an IBM Flex System installation that involves the Power Systems compute nodes.

Starting with the core architecture and structure of Couchbase Server, this title will tell you everything you need to know to install and setup your first Couchbase cluster. You'll be given guidance on sizing your cluster so that you maximise your performance. After installation, you'll be shown how to use the admin web console to administer your server, and then learn the techniques behind the specific tasks behind cluster management. This includes adding and removing nodes, rebalancing, and backing up and restoring your cluster.

If you love Essbase and hate seeing it misused, then this is the book for you. Written by 12 Essbase professionals that are either acknowledged Essbase gurus or certified Oracle ACEs, Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals provides an unparalleled investigation and explanation of Essbase theory and best practices. Detailing the hows and the whys of successful Essbase implementation, the book arms you with simple yet powerful tools to meet your immediate needs, as well as the theoretical knowledge to proceed to the next level with Essbase. Infrastructure, data sourcing and transformation, database design, calculations, automation, APIs, reporting, and project implementation are covered by subject matter experts who work with the tools and techniques on a daily basis. In addition to practical cases that illustrate valuable lessons learned, the book offers: —Dan Pressman describes the previously unpublished and undocumented inner workings of the ASO Essbase engine. Undocumented Secrets Authoritative Experts—If you have questions that no one else can solve, these 12 Essbase professionals are the ones who can answer them. Unpublished—Includes the only third-party guide to infrastructure. Infrastructure is easy to get wrong and can doom any Essbase project. Comprehensive—Let there never again be a question on how to create blocks or design BSO databases for performance—Dave Farnsworth provides the answers within. Innovative—Cameron Lackpour and Joe Aultman bring new and exciting solutions to persistent Essbase problems. With a list of contributors as impressive as the program of presenters at a leading Essbase conference, this book offers unprecedented access to the insights and experiences of those at the forefront of the field. The previously unpublished material presented in these pages will give you the practical knowledge needed to use this powerful and intuitive tool to build highly useful analytical models, reporting systems, and forecasting applications.

This IBM® Redbooks® publication is one in a series of books that are written specifically for the IBM System Blue Gene® supercomputer, Blue Gene/Q®, which is the third generation of massively parallel supercomputers from IBM in the Blue Gene series. This book provides an overview of the system administration environment for Blue Gene/Q. It is intended to help administrators understand the tools that are available to maintain this system. This book details Blue Gene Navigator, which has grown to be a full featured web-based system administration tool on Blue Gene/Q. The book also describes many of the day-to-day administrative functions, such as running diagnostics, performing service actions, and monitoring hardware. There are also sections that cover BGmaster and the Control System processes that it monitors. This book is intended for Blue Gene/Q system administrators. It helps them use the tools that are available to maintain the Blue Gene/Q system.

For the first time it is possible to deploy an integrated hardware platform that brings mainframe and distributed technologies together: a system that can start to replace individual islands of computing and that can work to reduce complexity, improve security, and bring applications closer to the data that they need.

A must-have guide for the latest updates to the new release of Reporting Services SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent, BI semantic model's impact on report design and creation, semantic model design, and more. You'll explore the major enhancements to Report Builder and benefit from best practices shared by the authors. Builds on the previous edition while also providing coverage of the new features introduced with SQL Server 2012 Explains Reporting Services architecture and BI fundamentals Covers advanced report design and filtering techniques, walking you through each design, discussing its purpose and the conditions where it could be more efficient Discusses semantic model design, Report Builder, Crescent, and more Targets business analysts and report designers as well as BI solution developers Professional Microsoft SQL Server 2012 Reporting Services is mandatory reading if you are eager to start using the newest version of SQL Server Reporting Services.

FileMaker® 12 In Depth Do more in less time! FileMaker 12 In Depth is the most comprehensive, coherent, and practical guide to creating professional-quality solutions with the newest versions of FileMaker! Drawing on his unsurpassed real-world experience as a FileMaker user, consultant, and developer, Jesse Feiler helps you gain practical mastery of today’s newest, most advanced FileMaker tools and features. • Use themes to build solutions for FileMaker Pro on Windows and OS X, FileMaker Go on iOS, and Instant Web Publishing • Get the most out of new container field technology • Quickly become a FileMaker 12 power user • Make the most of FileMaker fields, tables, layouts, and parts • Iteratively design reliable, high-performance FileMaker relational databases • Work with relationships, including self-joins and cross-product relationships • Write calculation formulas and use functions • Use event-driven scripts to make databases more interactive • Build clear and usable reports, publish them, and incorporate them into workflows • Secure applications with user accounts, privileges, file-level access, network security, and authentication • Use FileMaker’s Web Viewer to access live web-based data • Convert systems from older versions of FileMaker, and troubleshoot successfully • Share, exchange, export, and publish data via SQL and XML • Instantly publish databases on the web, and use advanced Custom Web Publishing techniques • Trigger automated behaviors whenever specific events occur • Extend FileMaker’s functionality with plug-ins • Set up, configure, tune, and secure FileMaker Server All In Depth books offer • Comprehensive coverage with detailed solutions • Troubleshooting help for tough problems you can’t fix on your own • Outstanding authors recognized worldwide for their expertise and teaching style Learning, reference, problem-solving... the only FileMaker 12 book you need!

In just a short time, you can learn how to use PHP, MySQL, and Apache together to create dynamic, interactive websites and applications using the three leading open-source web development technologies. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of PHP scripting, MySQL databases, and the Apache web server from the ground up. Julie C. Meloni is a technical consultant who has been developing web-based applications since the Web first saw the light of day. She has authored numerous books and articles on web application development and HTML/CSS, and you can find translations of her work in 18 different languages. Learn how to… • Install, configure, and set up the PHP scripting language, the MySQL database system, and the Apache Web server • Get these technologies to work together to create a dynamic, database-backed website • Interact with MySQL using PHP • Work with forms and files • Create a web-based discussion forum or mailing list • Add a storefront and shopping cart to your site • Optimize your MySQL databases • Fine-tune the Apache server’s performance • Restrict access to your applications • Set up a secure web server

The rapid change of the culture of communication constantly poses new threats for the right to privacy. These do not only emanate from States, but also from private actors. The global network of digital information has turned the protection of privacy since a long time into an international challenge. In this arena, national legal systems and their underlying common values collide. This collection convenes contributions from European, Australian and US experts. They take on the challenge of providing an intercontinental analysis of the issue and answer the question how the right to privacy could be defended in future.

This book is your go-to guide for mastering Oracle Data Integrator 11g through practical, hands-on instructions. You will learn the foundational concepts of data integration using ODI, empowering you to build efficient workflows and handle complex data scenarios confidently. What this Book will help me do Understand the components and architecture of Oracle Data Integrator (ODI). Install and configure ODI using best practices. Design complex workflows and perform data integration tasks with ease. Handle error processing and monitoring with ODI's tools and techniques. Leverage ODI to connect to various data sources like Oracle DB, SQL Server, and XML. Author(s) The authors have extensive experience in data integration and Oracle technologies, bringing over 15 years of combined real-world expertise. Their practical teaching approach focuses on empowering readers to solve real-life data challenges effectively. Who is it for? This book is tailored for software developers, ETL specialists, and database administrators who wish to get hands-on experience with Oracle Data Integrator. Whether you're starting with intermediate database knowledge or transitioning from other ETL tools, this book provides the foundations and advanced topics to enhance your proficiency in data integration.

Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It's an ideal book for those new to database administration, as well for those moving to SQL Server from other database brands such as Oracle and IBM DB2. SQL Server is more than just a database. It's situated within a larger context that includes solutions for reporting, for integrating data from other systems, for business intelligence and analysis, and more. Beginning SQL Server 2012 Administration paints the big picture to help you understand SQL Server's place in the grand scheme. Then you'll move into the nuts and bolts of installing the product, learning the management tools at your disposal, creating your first database, and maintaining that database in an ongoing state of readiness. Beginning SQL Server 2012 Administration goes beyond teaching just the core competencies of effective database administration. You will also learn the latest trends in SQL Server such as virtualizing and consolidating of servers, and using SQL Server in the cloud as a service. Administrators experienced on other platforms will find insight from comparisons of key features between SQL Server and other platforms. Beginning SQL Server 2012 Administration lays an excellent foundation for success as an SQL Server database administrator. Provides the essentials of successful SQL Server administration Covers the latest trends such as virtualization and cloud computing Paints the big picture of Microsoft's data platform

The new edition of a bestseller, now revised and update throughout! This new edition of the unparalleled bestseller serves as a full training course all in one and as the world's largest data storage company, EMC is the ideal author for such a critical resource. They cover the components of a storage system and the different storage system models while also offering essential new material that explores the advances in existing technologies and the emergence of the "Cloud" as well as updates and vital information on new technologies. Features a separate section on emerging area of cloud computing Covers new technologies such as: data de-duplication, unified storage, continuous data protection technology, virtual provisioning, FCoE, flash drives, storage tiering, big data, and more Details storage models such as Network Attached Storage (NAS), Storage Area Network (SAN), Object Based Storage along with virtualization at various infrastructure components Explores Business Continuity and Security in physical and virtualized environment Includes an enhanced Appendix for additional information This authoritative guide is essential for getting up to speed on the newest advances in information storage and management.

Ready to unlock the power of your data? With this comprehensive guide, you’ll learn how to build and maintain reliable, scalable, distributed systems with Apache Hadoop. This book is ideal for programmers looking to analyze datasets of any size, and for administrators who want to set up and run Hadoop clusters. You’ll find illuminating case studies that demonstrate how Hadoop is used to solve specific problems. This third edition covers recent changes to Hadoop, including material on the new MapReduce API, as well as MapReduce 2 and its more flexible execution model (YARN). Store large datasets with the Hadoop Distributed File System (HDFS) Run distributed computations with MapReduce Use Hadoop’s data and I/O building blocks for compression, data integrity, serialization (including Avro), and persistence Discover common pitfalls and advanced features for writing real-world MapReduce programs Design, build, and administer a dedicated Hadoop cluster—or run Hadoop in the cloud Load data from relational databases into HDFS, using Sqoop Perform large-scale data processing with the Pig query language Analyze datasets with Hive, Hadoop’s data warehousing system Take advantage of HBase for structured and semi-structured data, and ZooKeeper for building distributed systems

This book provides a comprehensive guide to the advanced features of PL/SQL, Oracle's procedural extension for SQL. It is especially designed for developers looking to master complex concepts, optimize code, and prepare for the Oracle 11g Advanced PL/SQL Professional certification (1Z0-146). Through clear explanations, practical examples, and exercises, you will advance your skills effectively. What this Book will help me do Master the use of advanced PL/SQL interface methods for robust database interactions. Implement Virtual Private Database settings with Fine Grained Access Control. Effectively use collections and data caching techniques to optimize your programs. Apply techniques to protect PL/SQL code from various security vulnerabilities, including injections. Implement result caching strategies and learn performance tuning methods to enhance application efficiency. Author(s) Saurabh K. Gupta is an experienced database professional specializing in Oracle technologies, with a focus on advanced PL/SQL development and optimization. He brings years of hands-on expertise to his writing, making complex subjects accessible for developers. In this book, he combines practical knowledge with certification-focused insights to guide readers towards programming excellence. Who is it for? This book is designed for PL/SQL programmers who have intermediate experience and are aiming to elevate their skills to a professional level. If you are preparing for the Oracle 1Z0-146 Professional certification or wish to deepen your understanding of advanced PL/SQL topics, this guide is ideal for you. A foundational knowledge of PL/SQL programming is assumed to fully benefit from the content.

Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2012 introduces SQL Server's spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You'll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth. Author Alastair Aitchison first introduces you to SQL Server's spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You'll learn to query, analyze, and interpret spatial data using tools such as Bing Maps and SQL Server Reporting Services. Throughout, you'll find helpful code examples that you can adopt and extend as a basis for your own projects. Explains spatial concepts from the ground up—no prior knowledge is necessary Provides comprehensive guidance for every stage of working with spatial data, from importing through cleansing and storing, to querying, and finally for retrieval and display of spatial data in an application layer Brilliantly illustrated with code examples that run in SQL Server 2012, that you can adapt and use as the basis for your own projects.