talk-data.com talk-data.com

Event

O'Reilly Data Engineering Books

2001-10-19 – 2027-05-25 Oreilly Visit website ↗

Activities tracked

3406

Collection of O'Reilly books on Data Engineering.

Filtering by: data ×

Sessions & talks

Showing 1851–1875 of 3406 · Newest first

Search within this event →
Expert Consolidation in Oracle Database 12c

Expert Consolidation in Oracle Database 12c is your key to reducing data management costs and increasing data center efficiency. Consolidation and cloud computing are converging trends sweeping the industry. The same technologies enabling cloud computing enable consolidation as well, leading to savings on all fronts from the amount of power used for servers to the amount of floor space consumed to the number of administrators needed to manage an installation. Yet the consolidation process can be a long and winding road. Success requires planning, and consideration to the impacts on supporting infrastructure. Expert Consolidation in Oracle Database 12c guides you through planning and implementing a consolidated Oracle Database installation using the many new features built into the latest release of Oracle's database management system. You'll learn to identify candidates for consolidation and to recognize instances that are best left stand-alone. The book guides in working with clustered systems and ASM storage in the consolidated environment. Focus is given to Oracle Enterprise Manager 12c Cloud Control as a monitoring and management dashboard. Always the goal is to drive towards a cost-effective environment that is efficient both in technology and people. Focuses on the new consolidation features in Oracle Database 12c Helps you evaluate and correctly decide when to consolidate Leads to cost savings and improved data center efficiency What you'll learn Master the new consolidation and cloud features in Oracle Database 12c Correctly decide when to consolidate and when to remain standalone Reduce cost by reducing demand for rack space, power, and floor space Streamline administration with Oracle Enterprise Manager 12c Cloud Control Ensure the correct supporting infrastructure for a rock-solid environment Safeguard your new consolidate infrastructure from disaster and data loss Who this book is for Expert Consolidation in Oracle Database 12c is aimed at database administrators involved in consolidation efforts, or who are interested in exploring Oracle Database 12c's strong support for consolidation and cloud computing.

Cloud Storage Forensics

To reduce the risk of digital forensic evidence being called into question in judicial proceedings, it is important to have a rigorous methodology and set of procedures for conducting digital forensic investigations and examinations. Digital forensic investigation in the cloud computing environment, however, is in infancy due to the comparatively recent prevalence of cloud computing. Cloud Storage Forensics presents the first evidence-based cloud forensic framework. Using three popular cloud storage services and one private cloud storage service as case studies, the authors show you how their framework can be used to undertake research into the data remnants on both cloud storage servers and client devices when a user undertakes a variety of methods to store, upload, and access data in the cloud. By determining the data remnants on client devices, you gain a better understanding of the types of terrestrial artifacts that are likely to remain at the Identification stage of an investigation. Once it is determined that a cloud storage service account has potential evidence of relevance to an investigation, you can communicate this to legal liaison points within service providers to enable them to respond and secure evidence in a timely manner. Learn to use the methodology and tools from the first evidenced-based cloud forensic framework Case studies provide detailed tools for analysis of cloud storage devices using popular cloud storage services Includes coverage of the legal implications of cloud storage forensic investigations Discussion of the future evolution of cloud storage and its impact on digital forensics

Microsoft Mapping: Geospatial Development with Bing Maps and C#

Geospatial mapping applications have become hugely popular in recent years. With smart-phone and tablet numbers snow-balling this trend looks set to continue well into the future. Indeed, it is true to say that in today's mobile world location-aware apps are becoming the norm rather than the exception. In Microsoft Mapping author Ray Rischpater showcases Microsoft's Bing Maps API and demonstrates how its integration features make it by far the strongest mapping candidate for business that are already using Windows 8 or the .NET Framework. Whether you want to build a new app from scratch of add a few modest geospatial features to your existing website Ray's carefully chosen examples will provide you with both the inspiration and the code you need to achieve your goals. What you'll learn Fully working code samples that show the concepts in use with ASP.NET 4.5, Windows 8 and Windows Phone. Complete solutions to the common problems of geospatial development: visualisation, hosting and localization of services are all explained. Demonstrates how the Bing Maps API can be connected to the Azure Cloud in order to provide a stand-alone mapping bolt-on with little additional up-front cost and great reliability. Unique coverage of how the Bing Maps API can be implanted within Windows Phone and iOS apps to provide a robust service tailored to the capabilities of each device. Who this book is for This book is for experienced Microsoft developers with a grounding in C# and .NET together with a basic understanding of WCF.

Oracle Exadata Survival Guide

Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar compression, and more. You'll learn about performance metrics and execution plans, and how to optimize SQL running in Oracle's powerful, new environment. The authors also cover migration from other servers. Oracle Exadata is fast becoming the standard for large installations such as those running data warehouse, business intelligence, and large-scale OLTP systems. Exadata is like no other platform, and is new ground even for experienced Oracle database administrators. The Oracle Exadata Survival Guide helps you navigate the ins and outs of this new platform, de-mystifying this amazing appliance and its exceptional performance. The book takes a highly practical approach, not diving too deeply into the details, but giving you just the right depth of information to quickly transfer your skills to Oracle's important new platform. Helps transfer your skills to the platform of the future Covers the important ground without going too deep Takes a practical and hands-on approach to everyday tasks What you'll learn Learn the components and basic architecture of an Exadata machine Reduce data transfer overhead by processing queries in the storage layer Examine and take action on Exadata-specific performance metrics Deploy Hybrid Columnar Compression to reduce storage and I/O needs Create worry-free migrations from existing databases into Exadata Understand and address issues specific to ERP migrations Who this book is for Oracle Exadata Survival Guide is for the busy enterprise Oracle DBA who has suddenly been thrust into the Exadata arena. Readers should have a sound grasp of traditional Oracle database administration, and be prepared to learn new aspects that are specific to the Exadata appliance.

Set up Linux on IBM System z for Production

This IBM® Redbooks® publication shows the power of IBM System z® virtualization and flexibility in sharing resources in a flexible production environment. In this book, we outline the planning and setup of Linux on System z to move from a development or test environment into production. As an example, we use one logical partition (LPAR) with shared CPUs with memory for a production environment and another LPAR that shares some CPUs, but also has a dedicated one for production. Running in IBM z/VM® mode allows for virtualization of servers and based on z/VM shares, can prioritize and control their resources. The size of the LPAR or z/VM resources depends on the workload and the applications that run that workload. We examine a typical web server environment, Java applications, and describe it by using a database management system, such as IBM DB2®. Network decisions are examined with regards to VSWITCH, shared Open Systems Adapter (OSA), IBM HiperSockets™ and the HiperPAV, or FCP/SCSI attachment used with a storage area network (SAN) Volume Controller along with performance and throughput expectations. The intended audience for this IBM Redbooks publication is IT architects who are responsible for planning production environments and IT specialists who are responsible for implementation of production environments.

The Handbook of Financial Modeling: A Practical Approach to Creating and Implementing Valuation Projection Models

The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in The Financial Modeling Handbook, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance. Based on the author's extensive experience building models in business and finance—and teaching others to do the same— The Handbook of Financial Modeling takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel. Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, The Handbook of Financial Modeling also covers: The accounting and finance concepts that underpin working financial models; How to approach financial issues and solutions from a modeler's perspective; The importance of thinking about end users when developing a financial model; How to plan, design, and build a fully functional financial model; And more. A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models. What you'll learn Key financial modeling principles, including best practices, principles around calculations, and the importance of producing clean, clear financial models How to design and implement a projection model that allows the user to change inputs quickly for sensitivity testing The proper way to approach a financial modeling assignment, from project planning all the way through to the documentation of the model's findings and effectiveness How to model in Microsoft Excel, including how to set up an Excel environment, how to format worksheets, and the correct application of various modeling formulae The skills and knowledge they need to become more proficient financial modelers and differentiate themselves from their professional competitors. Who this book is for Written in a clear, concise manner and filled with screen grabs that will facilitate readers' comprehension of the financial modeling process, The Handbook of Financial Modeling is appropriate for intermediate to advanced financial modelers who are looking to learn how to enhance their modeling proficiency.

Passwords & Internet Addresses Journal For Dummies

Keep track of your passwords and learn how to make them better You have dozens of passwords for dozens of uses, and it seems every account has different password requirements. How can you keep them all straight while keeping them secure? This ingenious little book solves the problem! It's more than just a logbook; it's loaded with advice on creating effective passwords, maintaining your privacy on Facebook and Twitter, protecting your financial records, using online "netiquette", and much more. It also provides lots of space to record important site names, URLs, and passwords, including space for new passwords when you have to change them! With this handy guide, you can keep them all straight and up to date. Offers tips on establishing user accounts, creating effective passwords, keeping your accounts secure, maintaining your privacy on social networking sites, and more Provides space to record the site name, URL, site functions, and up to 10 passwords for each account, allowing you to change passwords from time to time for greater security Passwords & Internet Addresses Journal For Dummies combines important tips about passwords with a way to organize your information and still keep it safe. Never lose or forget another password!

IBM Systems Director 6.3 Best Practices

This IBM® Redbooks® publication describes the positioning of the IBM Systems Director in the complete management range. It also compares the IBM Systems Director with the IBM Flex Systems Manager (FSM) and describes the environments for which each tool is best suited. This publication helps you plan, install, tailor, and configure the IBM Systems Director on different platforms. It contains information about required system resources and which network ports are used. It shows how to use the Workload Estimator to select the appropriate hardware for IBM Systems Director server and provides information about the IBM Systems Director Editions. Best practices are covered for the basic management tasks that are available in IBM Systems Director, including how to perform discovery; how to collect inventory on discovered resources; how to deploy agent, driver, and firmware updates; how to manage hardware events; and other miscellaneous tasks. An overview of best practices is provided for using IBM Systems Director VMControl™. Systems Director VMControl is a cross-platform product that assists you in rapidly deploying virtual appliances to create virtual servers that are configured with the operating system and software applications that you want. It also enables you to group resources into system pools, which enable you to centrally manage and control the different workloads in your environment. The following plug-in offerings are described: Energy monitoring and management features offered by IBM Systems Director Active Energy Manager™ along with the best practice, which needs to be followed in using the IBM Systems Director Active Energy Manager. The IBM AIX® Profile Manager is a tool that can help implement and monitor the security of all AIX servers in a production environment but also implement and monitor the system compliance of those AIX servers. Best practices and the most important questions to ask before creating Workload Partition Manager (WPAR) and WPAR Manager infrastructure. In addition, how you can manage and relocate WPARs using WPAR Manager graphical interface and the command-line interface. Network Control basic functionalities and how to plan for Network Control deployments and also a number of common scenarios with best practices. The IBM Systems Director Service and Support Manager describes how to set up and how to handle serviceable events. Best practices for the Storage Monitoring and Management capabilities offered by IBM Systems Director server. This book is for IBM IT specialists and IT architects, IBM Business Partners, and clients, who are utilizing or considering implementing IBM Systems Director.

Query Acceleration for Business Using IBM Informix Warehouse Accelerator

IBM® Informix® Warehouse Accelerator is a state-of-the-art in-memory database that uses affordable innovations in memory and processor technology and trends in novel ways to boost query performance. It is a disruptive technology that changes how organizations provide analytics to its operational and historical data. Informix Warehouse Accelerator uses columnar, in-memory approach to accelerate even the most complex warehouse and operational queries without application changes or tuning. This IBM Redbooks® publication provides a comprehensive look at the technology and architecture behind the system. It contains information about the tools, data synchronization, and query processing capabilities of Informix Warehouse Accelerator, and provides steps to implement data analysis by using Informix Warehouse Accelerator within an organization. This book is intended for IBM Business Partners and clients who are looking for low-cost solutions to boost data warehouse query performance.

The Definitive Guide to MongoDB: A complete guide to dealing with Big Data using MongoDB, Second Edition

The Definitive Guide to MongoDB, Second Edition, is updated for the latest version and includes all of the latest MongoDB features, including the aggregation framework introduced in version 2.2 and hashed indexes in version 2.4. MongoDB is the most popular of the "Big Data" NoSQL database technologies, and it's still growing. David Hows from 10gen, along with experienced MongoDB authors Peter Membrey and Eelco Plugge, provide their expertise and experience in teaching you everything you need to know to become a MongoDB pro. The Definitive Guide to MongoDB, Second Edition, starts with the basics, including how to install on Windows, Linux, and OS X, and how MongoDB handles your data. Then you'll learn how to develop with MongoDB with both PHP and Python, including an example application using a PHP driver to create a blog application. Finally, you'll dig into more advanced but extremely important MongoDB features, including optimization, replication, and sharding -- load-balancing that makes MongoDB ideal for dealing with Big Data. If you're dealing with data, MongoDB should be on your must-learn list. The Definitive Guide to MongoDB, Second Edition, is just the book you need. What you'll learn Set up MongoDB on all major server platforms, including Windows, Linux, OS X, and cloud platforms like Rackspace, Azure, and Amazon EC2 Work with GridFS and the new aggregation framework Work with your data using non-SQL commands Write applications using either PHP or Python Optimize MongoDB Master MongoDB administration, including replication, replication tagging, and tag-aware sharding Who this book is for Database admins and developers who need to get up to speed on MongoDB and its Big Data, NoSQL approach to dealing with data management.

Oracle Business Intelligence Discoverer 11g Handbook

Master Oracle Business Intelligence Discoverer 11g Provide secure, immediate access to critical business information from relational and multidimensional data sources across your organization. Oracle Business Intelligence Discoverer 11g Handbook shows you how to optimize this intuitive ad hoc query, reporting, analysis, and web publishing tool for maximum performance. Real-world examples illustrate the powerful analysis, security, and reporting capabilities. Enable business users at all levels to make faster, more-informed decisions with help from this Oracle Press guide. Configure and manage Oracle Business Intelligence Discoverer 11g Run functional queries using the Workbook Wizard Add sorts, calculations, percentages, totals, and parameters using Oracle Business Intelligence Discoverer Plus Format queries into well-organized reports with graphs, tables, titles, headers, and footers Perform data analysis--statistical, classification, deviation, trend, and aging Use Oracle Business Intelligence Discoverer Viewer 11g to analyze, format, export, e-mail, and print reports Manage integration with Oracle WebLogic Server Refine existing queries using interactive pivoting, drilling, and hyper-drilling Build effective conditions and refine parameters, calculations, sorting, and percentages Manage access and sharing rights, scheduling privileges, and user preferences Build an end user layer and a business area using Oracle Business Intelligence Discoverer Administrator Use Oracle Enterprise Manager's Fusion Middleware Control feature to manage Oracle Business Intelligence Discoverer settings and preferences Implement powerful analytic functions using templates

Pro Oracle SQL, Second Edition

Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database—one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You'll learn analytic functions, the MODEL clause, and advanced grouping syntax—features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Edition also helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, and exert control over SQL execution in your database. You'll learn when to create indexes, how to verify that they make a difference, how to use SQL Baselines and Profiles to optimize and stabilize SQL execution plans, and much more. You'll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. Pro Oracle SQL, Second Edition helps you work at a truly professional level in the Oracle dialect of SQL. You'll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance Comprehensive—goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. Performance focused—teaches you how to measure the performance of your SQL statements and not just the syntax. What you'll learn Master powerful SQL features implemented in the Oracle Database Understand how the Oracle Optimizer develops execution plans Read and interpret SQL execution plans Quickly diagnose and fix badly performing SQL Control execution plans through hints, profiles, and plan baselines Optimize queries within packaged applications without touching the code Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL, Second Edition is aimed at developers and database administrators who submit SQL for execution by an Oracle database. Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle's specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and the WITH clause (subquery factoring) that are designed to help developers and database administrators exert control over their SQL environment and its execution.

Business Models for the Data Economy

You're sitting on a pile of interesting data. How do you transform that into money? It's easy to focus on the contents of the data itself, and to succumb to the (rather unimaginative) idea of simply collecting and reselling it in raw form. While that's certainly profitable right now, you'd do well to explore other opportunities if you expect to be in the data business long-term. In this paper, we'll share a framework we developed around monetizing data. We'll show you how to think beyond pure collection and storage, to move up the value chain and consider longer-term opportunities.

IBM Technical Computing Clouds

This IBM® Redbooks® publication highlights IBM Technical Computing as a flexible infrastructure for clients looking to reduce capital and operational expenditures, optimize energy usage, or re-use the infrastructure. This book strengthens IBM SmartCloud® solutions, in particular IBM Technical Computing clouds, with a well-defined and documented deployment model within an IBM System x® or an IBM Flex System™. This provides clients with a cost-effective, highly scalable, robust solution with a planned foundation for scaling, capacity, resilience, optimization, automation, and monitoring. This book is targeted toward technical professionals (consultants, technical support staff, IT Architects, and IT Specialists) responsible for providing cloud-computing solutions and support.

Talend Open Studio Cookbook

Talend Open Studio Cookbook is a comprehensive guide for both beginners and intermediate users of Talend Open Studio, the leading open-source data integration software. Through practical recipes, this book covers all aspects of Talend development, from schemas and data mapping to advanced debugging and deployment techniques. What this Book will help me do Master the use of schemas for forming solid data structures. Effectively utilize tMap for data transformation and integration. Develop skills to manage and manipulate various file formats. Understand how to test and debug Talend jobs to ensure robust solutions. Learn to deploy, schedule, and manage Talend integrations in production environments. Author(s) None Barton is an experienced developer and a passionate advocate for open-source data tools. With years of hands-on experience in data integration and Talend development, they bring a practical and results-driven perspective to their writing, aiming to empower developers with actionable insights and real-world expertise. Who is it for? Ideal readers for this book are beginner and intermediate developers seeking to enhance their understanding of Talend Open Studio. Whether you've used the software for basic tasks or are completely new to it, this cookbook format is structured to guide you through practical challenges and deeper concepts. If your goal is to build confidence and efficiency in data integration tasks, this book is designed for you.

Introduction to IBM Real-time Compression Appliances

Continuing its commitment to developing and delivering industry-leading storage technologies, IBM is introducing the IBM Real-time Compression Appliances for NAS, an innovative new storage offering that delivers essential storage efficiency technologies, combined with exceptional ease of use and performance. In an era when the amount of information, particularly in unstructured files, is exploding, but budgets for storing that information are stagnant, IBM Real-time Compression technology offers a powerful tool for better information management, protection, and access. IBM Real-time Compression can help slow the growth of storage acquisition, reducing storage costs while simplifying both operations and management. It also enables organizations to keep more data available for use rather than storing it offsite or on harder-to-access tape, so they can support improved analytics and decision making. IBM Real-time Compression Appliances provide on-line storage optimization through real-time data compression, delivering dramatic cost reduction without performance degradation. This IBM® Redbooks® publication is an easy-to-follow guide that describes how to design solutions successfully using IBM Real-time Compression Appliances (IBM RTCAs). It provides practical installation examples, ease of use, remote management, high availability, and administration techniques. Furthermore, it explains best practices for RTCA solution design, application integration, and practical RTCA use cases.

JavaScript and JSON Essentials

"JavaScript and JSON Essentials" is a focused tutorial that introduces you to the lightweight JSON data format, essential for effective data storage and transfer with JavaScript. By following this book, you'll gain the expertise to work with JSON in web applications, including tasks such as serialization, asynchronous calls, and debugging. What this Book will help me do Fully understand the structure and use of JSON and how it integrates with JavaScript. Learn to implement synchronous and asynchronous data transfers using JSON. Develop skills in creating, updating, and manipulating JSON objects effectively. Master the design of web functionalities like the Carousel application using JSON. Gain knowledge about best practices in debugging and optimizing JSON for web applications. Author(s) Sai S. Sriparasa is a seasoned developer and educator with extensive experience in JavaScript and related technologies. Having worked on numerous data-driven projects, Sai integrates real-world scenarios into his writing. His tutorials are crafted to be approachable and practical, aimed at demystifying complex concepts for a diverse audience. Who is it for? This book is ideal for web developers who are familiar with JavaScript and seek to expand their understanding of JSON. Suitable for programmers who have a basic knowledge of HTML and some exposure to server-side languages like PHP or Python. Those aiming to integrate efficient data exchange formats into their web applications will find it highly beneficial. It's also a good resource for JavaScript developers wanting to delve deeper into the synchronous and asynchronous handling of data.

Implementing the IBM Storwize V5000

Organizations of all sizes are faced with the challenge of managing massive volumes of increasingly valuable data. But storing this data can be costly, and extracting value from the data is becoming more difficult. IT organizations have limited resources but must stay responsive to dynamic environments and act quickly to consolidate, simplify, and optimize their IT infrastructures. The IBM® Storwize® V5000 system provides a smarter solution that is affordable, easy to use, and self-optimizing, which enables organizations to overcome these storage challenges. Storwize V5000 delivers efficient, entry-level configurations that are specifically designed to meet the needs of small and midsize businesses. Designed to provide organizations with the ability to consolidate and share data at an affordable price, Storwize V5000 offers advanced software capabilities that are usually found in more expensive systems. This IBM Redbooks® publication is intended for pre-sales and post-sales technical support professionals and storage administrators. The concepts in this book also relate to the IBM Storwize V3700. This book was written at a software level of Version 7 Release 1.

IBM Content Manager OnDemand Guide

This IBM® Redbooks® publication provides a practical guide to the design, installation, configuration, and maintenance of IBM Content Manager OnDemand Version 9.0. Content Manager OnDemand manages high-volume storage and retrieval of electronic statements and provides efficient enterprise report management. Content Manager OnDemand transforms formatted computer output and printed reports, such as statements and invoices, into electronic information for easy report management. Content Manager OnDemand helps eliminate costly, high-volume print output by capturing, indexing, archiving, and presenting electronic information for improved customer service. This publication covers the key areas of Content Manager OnDemand, some of which might not be known to the Content Manager OnDemand community or are misunderstood. The book covers various topics, including basic information in administration, database structure, storage management, and security. In addition, the book covers data indexing, loading, conversion, and expiration. Other topics include user exits, performance, retention management, records management, and many more. Because many other resources are available that address subjects on different platforms, this publication is not intended as a comprehensive guide for Content Manager OnDemand; rather, it is intended to complement the existing Content Manager OnDemand documentation and provide insight into the issues that might be encountered in the setup and use of Content Manager OnDemand.

Performance Management: Using IBM InfoSphere Optim Performance Manager and Query Workload Tuner

This IBM® Redbooks® publication describes the architecture and components of IBM InfoSphere® Optim™ Performance Manager Extended Edition. Intended for DBAs and those involved in systems performance, it provides information for installation, configuration, and deployment. InfoSphere Optim Performance Manager delivers a new paradigm used to monitor and manage database and database application performance issues. It describes product dashboards and reports and provides scenarios for how they can be used to identify, diagnose, prevent, and resolve database performance problems. IBM InfoSphere Optim Query Workload Tuner facilitates query and query workload analysis and provides expert recommendations for improving query and query workload performance. Use InfoSphere Optim Performance Manager to identify slow running queries, top CPU consumers, or query workloads needing performance improvements and seamlessly transfer them to InfoSphere Optim Query Workload Tuner for analysis and recommendations. This is done using query formatting annotated with relevant statistics, access plan graphical or hierarchical views, and access plan analysis. It further provides recommendations for improving query structure, statistics collection, and indexes including generated command syntax and rationale for the recommendations. Please note that the additional material referenced in the text is not available from IBM.

IBM Virtualization Engine TS7700 with R3.0

This IBM® Redbooks® publication highlights TS7700 Virtualization Engine Release 3.0. It is intended for system architects who want to integrate their storage systems for smoother operation. The IBM Virtualization Engine TS7700 offers a modular, scalable, and high-performing architecture for mainframe tape virtualization for the IBM System z® environment. It integrates 3592 Tape Drives, high-performance disks, and a new disk cache subsystem into a storage hierarchy. This storage hierarchy is managed by robust storage management firmware with extensive self-management capability. It includes the following advanced functions: Policy management to control physical volume pooling Cache management Dual copy, including across a grid network Copy mode control The TS7700 Virtualization Engine offers enhanced statistical reporting. It also includes a standards-based management interface for TS7700 Virtualization Engine management. The new IBM Virtualization Engine TS7700 Release 3.0 continues the next generation of TS7700 Virtualization Engine servers for System z tape: IBM Virtualization Engine TS7720 Server Model VEB with 3956-CS9 and 3 TB disk drive modules (DDMs) IBM Virtualization Engine TS7740 Server Model V07 with 3956-CC9 with 600 GB DDMs These Virtualization Engines are based on IBM POWER7® technology. They offer improved performance for most System z tape workloads compared to the first generation of TS7700 Virtualization Engine servers. TS7700 Virtualization Engine Release 3.0 builds on the existing capabilities of the TS7700 family. It also introduces the following capabilities: Up to 4,000,000 logical volumes per grid domain Disk cache refresh utilizing 3956-CC9 for TS7740 Model V07 and 3956-CS9 for TS7720 Model VEB Virtualization Engines IPv4 or IPv6 support for customer network and IP Security for grid communication

Oracle Database 12c Install, Configure & Maintain Like a Professional

Master the Fundamentals of Oracle Database 12c Filled with easy-to-follow tutorials, this Oracle Press guide provides detailed coverage of core database concepts, the role of the administrator, and enterprise database capabilities. Oracle Database 12c: Install, Configure & Maintain Like a Professional walks you through database configuration, administration, programming, backup and recovery, and high availability. You'll get in-depth introductions to SQL and PL/SQL as well as important information on managing large databases and using Oracle's engineered systems. This essential beginner's resource features: Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Ask the Expert--Q&A sections filled with helpful tips Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge

Implementing the IBM Storwize V3700

Organizations of all sizes are faced with the challenge of managing massive volumes of increasingly valuable data. But storing this data can be costly, and extracting value from the data is becoming more and more difficult. IT organizations have limited resources but must stay responsive to dynamic environments and act quickly to consolidate, simplify, and optimize their IT infrastructures. The IBM® Storwize® V3700 system provides a smarter solution that is affordable, easy to use, and self-optimizing, which enables organizations to overcome these storage challenges. Storwize V3700 delivers efficient, entry-level configurations that are specifically designed to meet the needs of small and midsize businesses. Designed to provide organizations with the ability to consolidate and share data at an affordable price, Storwize V3700 offers advanced software capabilities that are usually found in more expensive systems. Built upon innovative IBM technology, Storwize V3700 addresses the block storage requirements of small and midsize organizations. Providing up to 240 TB of capacity packaged in a compact 2U, Storwize V3700 is designed to accommodate the most common storage network technologies to enable easy implementation and management. This IBM Redbooks® publication is intended for pre- and post-sales technical support professionals and storage administrators. The concepts in this book also relate to the IBM Storwize V3500. This book was written at a software level of Version 7 Release 1.

The Culture of Big Data

Technology does not exist in a vacuum. In the same way that a plant needs water and nourishment to grow, technology needs people and process to thrive and succeed. Culture (i.e., people and process) is integral and critical to the success of any new technology deployment or implementation. Big data is not just a technology phenomenon. It has a cultural dimension. It's vitally important to remember that most people have not considered the immense difference between a world seen through the lens of a traditional relational database system and a world seen through the lens of a Hadoop Distributed File System.This paper broadly describes the cultural challenges that accompany efforts to create and sustain big data initiatives in an evolving world whose data management processes are rooted firmly in traditional data warehouse architectures.

DB2 10.5 with BLU Acceleration

UPGRADE TO THE NEW GENERATION OF DATABASE SOFTWARE FOR THE ERA OF BIG DATA! If big data is an untapped natural resource, how do you find the gold hidden within? Leaders realize that big data means all data, and are moving quickly to extract more value from both structured and unstructured application data. However, analyzing this data can prove costly and complex, especially while protecting the availability, performance and reliability of essential business applications. In the new era of big data, businesses require data systems that can blend always-available transactions with speed-of-thought analytics. DB2 10.5 with BLU Acceleration provides this speed, simplicity, and affordability while making it easier to build next-generation applications with NoSQL features, such as a mongo-styled JSON document store, a graph store, and more. Dynamic in-memory columnar processing and other innovations deliver faster insights from more data, and enhanced pureScale clustering technology delivers high-availability transactions with application-transparent scalability for business continuity. With this book, you'll learn about the power and flexibility of multiworkload, multi-platform database software. Use the comprehensive knowledge from a team of DB2 developers and experts to get started with the latest DB2 trial version you can download at ibm.com/developerworks/downloads/im/db2/. Stay up to date on DB2 by visiting ibm.com/db2/.