Get Started Scaling Your Database Infrastructure for High-Volume Big Data Applications “Understanding Big Data Scalability presents the fundamentals of scaling databases from a single node to large clusters. It provides a practical explanation of what ‘Big Data’ systems are, and fundamental issues to consider when optimizing for performance and scalability. Cory draws on many years of experience to explain issues involved in working with data sets that can no longer be handled with single, monolithic relational databases.... His approach is particularly relevant now that relational data models are making a comeback via SQL interfaces to popular NoSQL databases and Hadoop distributions.... This book should be especially useful to database practitioners new to scaling databases beyond traditional single node deployments.” —Brian O’Krafka, software architect presents a solid foundation for scaling Big Data infrastructure and helps you address each crucial factor associated with optimizing performance in scalable and dynamic Big Data clusters. Understanding Big Data Scalability Database expert Cory Isaacson offers practical, actionable insights for every technical professional who must scale a database tier for high-volume applications. Focusing on today’s most common Big Data applications, he introduces proven ways to manage unprecedented data growth from widely diverse sources and to deliver real-time processing at levels that were inconceivable until recently. Isaacson explains why databases slow down, reviews each major technique for scaling database applications, and identifies the key rules of database scalability that every architect should follow. You’ll find insights and techniques proven with all types of database engines and environments, including SQL, NoSQL, and Hadoop. Two start-to-finish case studies walk you through planning and implementation, offering specific lessons for formulating your own scalability strategy. Coverage includes Understanding the true causes of database performance degradation in today’s Big Data environments Scaling smoothly to petabyte-class databases and beyond Defining database clusters for maximum scalability and performance Integrating NoSQL or columnar databases that aren’t “drop-in” replacements for RDBMSes Scaling application components: solutions and options for each tier Recognizing when to scale your data tier—a decision with enormous consequences for your application environment Why data relationships may be even more important in non-relational databases Why virtually every database scalability implementation still relies on sharding, and how to choose the best approach How to set clear objectives for architecting high-performance Big Data implementations The Big Data Scalability Series is a comprehensive, four-part series, containing information on many facets of database performance and scalability. is the first book in the series. Understanding Big Data Scalability Learn more and join the conversation about Big Data scalability at bigdatascalability.com.

Your hands-on guide to Azure SQL Database fundamentals Expand your expertise—and teach yourself the fundamentals of Microsoft Azure SQL Database. If you have previous programming experience but are new to Azure, this tutorial delivers the step-by-step guidance and coding exercises you need to master core topics and techniques. Discover how to: Perform Azure setup and configuration Explore design and security considerations Use programming and reporting services Migrate data Backup and sync data Work with scalability and high performance Understand the differences between SQL Server and Microsoft Azure SQL Database

Pro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems. Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use. Pro SQL Server Internals does the following: Explains how to design efficient database schema, indexing, and transaction strategies. Shows how various database objects and technologies are implemented internally and when they should or should not be used. Demonstrates how SQL Server executes queries and works with data and transaction logs.

A Fully Integrated Study System for OCP Exam 1Z0-060 Prepare for the Oracle Certified Professional Upgrade to Oracle Database 12 c exam with this exclusive Oracle Press guide. Each chapter features step-by-step examples, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of the new features of Oracle Database 12 c, including: Oracle Enterprise Manager Database Express and additional tools for database monitoring Multitenant container databases and pluggable databases Auditing, administrative privileges, data redaction, and other Oracle security features Adaptive execution plans, adaptive statistics, and automatic SQL plan management Oracle Recovery Manager backup and recovery improvements Oracle Database Resource Manager and other performance enhancements Oracle Data Pump, SQL*Loader, external tables, and online operations enhancements Improvements to information lifecycle management and storage, including automatic data optimization, in-database archiving, and temporal validity Electronic content includes: 170 practice exam questions with detailed answer explanations

Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian Antognini brings a decade and a half experience to his topic. His first edition is one of the most well-respected books in its field. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11 g Release 2 through Oracle Database 12 c. What do you do when your database application isn't running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It's finding a solution that's difficult. Troubleshooting Oracle Performance, 2nd Edition helps by providing a systematic approach to addressing the underlying causes of poor database application performance. The author freely shares his experience while explaining the underlying foundations of how SQL statements are executed by the Oracle database engine. You'll be able to draw a solid foundation of theory and shared experience as you face head-on the performance challenges in your daily work. Written for developers by an application developer who has learned by doing Gives a systematic approach to solving database application performance problems Helps you plan for performance as you would for any other application requirement What you'll learn Systematically identify performance problems Configure the query optimizer to meet performance goals Read and recognize inefficient execution plans Minimize the impact of parsing upon performance Optimize data access, joins, and the physical design of your database Improve performance through parallel processing, materialized views, and result caching Apply SQL tuning techniques such as hints, SQL profiles, stored outlines, and SQL plan baselines Reduce inefficiencies from too much procedural code Who this book is for Troubleshooting Oracle Performance, Second Edition is targeted at application developers and database administrators involved in troubleshooting performance problems in Oracle-based applications.

A Complete Study System for OCA Exam 1Z0-062 Prepare for the Oracle Certified Associate Oracle Database 12 c Installation and Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-062, including: Installing and upgrading Oracle Database software Managing the database instance Configuring the Oracle network environment Managing database storage structures Administering user security Managing undo data and data concurrency Implementing Oracle Database auditing Performing database maintenance Managing performance and tuning SQL Managing resources using Oracle Database Resource Manager Automating tasks Moving data Performing backup and recovery Installing Oracle Grid Infrastructure for a standalone server Electronic content includes: 185+ practice exam questions with detailed answers and explanations Test engine that provides custom exams by chapter or by domain

"Learning Cypher" provides an in-depth look into Cypher, the functional query language for Neo4j, the powerful graph database. Whether you're transitioning from relational databases or exploring graph technology for the first time, this book offers practical guidance to help you write efficient, clear, and reusable queries. What this Book will help me do Master the Cypher declarative query syntax for graph databases. Write optimized Cypher queries for better application performance. Transform relational database data to graph database structures with ease. Understand the nuances of transitioning from SQL to graph paradigms. Learn the common pitfalls in Neo4j programming and how to avoid them. Author(s) Onofrio Panzarino is an experienced database developer specializing in graph technologies and Neo4j. He is passionate about teaching industry best practices to developers and has extensive experience in designing graph-based solutions. Through his approachable style, he empowers readers to excel in using graph databases effectively. Who is it for? This book is for database developers, data analysts, and software engineers who want to expand their knowledge into graph databases. If you work with large-scale connected data or are transitioning from SQL to a graph model, this book is ideal for you. Prior experience with any database query language will be helpful. The book is also suitable for students and professionals looking to integrate graph technology into their projects.

A Complete Study System for OCA Exam 1Z0-061 Prepare for the Oracle Certified Associate Oracle Database 12 c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including: Data retrieval using the SQL SELECT statement Restricting and sorting data Single-row functions Using conversion functions and conditional expressions Reporting aggregated data with the group functions Displaying data from multiple tables with joins Using subqueries to solve problems Using the set operators Manipulating data with DML statements Using DDL statements to create and manage tables Electronic content includes: 150+ practice exam questions with detailed answers and explanations Score report performance assessment tool

Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. Implement new best practices for effective use of SSIS Work through tutorials for hands-on learning of complex techniques Read case studies that illustrate the more advanced concepts Learn directly from the foremost authority on SSIS SQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.

Create custom applications with the Google Maps API Featuring step-by-step examples, this practical resource gets you started programming the Google Maps API with JavaScript in no time. Learn how to embed maps on web pages, annotate the embedded maps with your data, generate KML files to store and reuse your map data, and enable client applications to request spatial data through web services. Google Maps: Power Tools for Maximizing the API explains techniques for visualizing masses of data and animating multiple items on the map. You’ll also find out how to embed Google maps in desktop applications to combine the richness of the Windows interface with the unique features of the API. You can use the numerous samples included throughout this hands-on guide as your starting point for building customized applications. Create map-enabled web pages with a custom look Learn the JavaScript skills required to exploit the Google Maps API Create highly interactive interfaces for mapping applications Embed maps in desktop applications written in .NET Annotate maps with labels, markers, and shapes Understand geodesic paths and shapes and perform geodesic calculations Store geographical data in KML format Add GIS features to mapping applications Store large sets of geography data in databases and perform advanced spatial queries Use web services to request spatial data from within your script on demand Automate the generation of standalone web pages with annotated maps Use the Geocoding and Directions APIs Visualize large data sets using symbols and heatmaps Animate items on a map Bonus online content includes: A tutorial on The SQL Spatial application A bonus chapter on animating multiple airplanes Three appendices: debugging scripts in the browser; scalable vector graphics; and applying custom styles

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQLPlus and SQL Developer. SQLPlus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries. Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results What you'll learn Create database tables and define their relationships. Add data to your tables. Then change and delete that data. Write database queries that generate accurate results. Avoid common traps and pitfalls in writing SQL queries, especially from nulls. Reap the performance and expressiveness of analytic and window functions. Make use of Oracle Database's support for object types. Write recursive queries to query hierarchical data. Who this book is for Beginning Oracle SQL is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.

Tap the power of Big Data with Microsoft technologies Big Data is here, and Microsoft's new Big Data platform is a valuable tool to help your company get the very most out of it. This timely book shows you how to use HDInsight along with HortonWorks Data Platform for Windows to store, manage, analyze, and share Big Data throughout the enterprise. Focusing primarily on Microsoft and HortonWorks technologies but also covering open source tools, Microsoft Big Data Solutions explains best practices, covers on-premises and cloud-based solutions, and features valuable case studies. Best of all, it helps you integrate these new solutions with technologies you already know, such as SQL Server and Hadoop. Walks you through how to integrate Big Data solutions in your company using Microsoft's HDInsight Server, HortonWorks Data Platform for Windows, and open source tools Explores both on-premises and cloud-based solutions Shows how to store, manage, analyze, and share Big Data through the enterprise Covers topics such as Microsoft's approach to Big Data, installing and configuring HortonWorks Data Platform for Windows, integrating Big Data with SQL Server, visualizing data with Microsoft and HortonWorks BI tools, and more Helps you build and execute a Big Data plan Includes contributions from the Microsoft and HortonWorks Big Data product teams If you need a detailed roadmap for designing and implementing a fully deployed Big Data solution, you'll want Microsoft Big Data Solutions.

Master Oracle Database 12 c PL/SQL Application Development Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12 c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries

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.

The 'SQL Server Analysis Services 2012 Cube Development Cookbook' equips you with the practical skills needed to design and implement OLAP cubes using both multidimensional and tabular models. By working through hands-on recipes, you'll quickly gain the expertise to create robust Business Intelligence solutions with SQL Server Analysis Services. What this Book will help me do Build and enhance multidimensional and tabular models for effective data analysis. Implement key OLAP features like dimensions, cubes, actions, and aggregations. Scale and optimize your Business Intelligence solutions for enterprise-level performance. Utilize MDX and DAX languages proficiently to query and manipulate data. Develop skills in securing, monitoring, and troubleshooting SQL Server Analysis Services. Author(s) None Dewald is an experienced business intelligence professional with years of hands-on expertise with SQL Server Analysis Services. His approach to teaching focuses on practical application and equipping his audience with tools to be successful in deploying and maintaining BI solutions. Who is it for? This book is perfect for BI and ETL developers who work with SQL Server Analysis Services to build OLAP cubes. It assumes familiarity with relational database management systems, Excel, and SQL. If you're looking to deepen your understanding of Microsoft's BI stack and improve your practical skills in SSAS, this book is for you.

"SAP HANA Cookbook" is a hands-on guide to learning SAP HANA, a powerful in-memory database platform. Through over 50 practical recipes, you'll understand the inner workings of SAP HANA's architecture, and learn techniques to optimize operations and analytics. What this Book will help me do Understand SAP HANA's architecture and in-memory capabilities. Effectively load and integrate data from various source systems. Develop and optimize SAP HANA models such as attribute, analytical, and calculation views. Gain proficiency in using the SAP HANA SQL scripting language. Master user and role management for secure and efficient SAP HANA operation. Author(s) This book is authored by industry specialists with extensive experience in SAP HANA technology. Drawing from real-world projects, the authors provide nuanced insights and practical guidance, enabling readers to implement SAP HANA solutions effectively. Who is it for? This book is suited for solution architects, developers, and managers seeking to develop expertise in SAP HANA. Whether you are new to SAP technologies or looking to deepen your skillset, this resource provides comprehensive and actionable guidance.

Build and Deploy Massively Scalable, Super-fast Data Management Applications with Apache Cassandra is the first hands-on developer’s guide to building Cassandra systems and applications that deliver breakthrough speed, scalability, reliability, and performance. Fully up to date, it reflects the latest versions of Cassandra–including Cassandra Query Language (CQL), which dramatically lowers the learning curve for Cassandra developers. Practical Cassandra Pioneering Cassandra developers and Datastax MVPs Russell Bradberry and Eric Lubow walk you through every step of building a real production application that can store enormous amounts of structured, semi-structured, and unstructured data. Drawing on their exceptional expertise, Bradberry and Lubow share practical insights into issues ranging from querying to deployment, management, maintenance, monitoring, and troubleshooting. The authors cover key issues, from architecture to migration, and guide you through crucial decisions about configuration and data modeling. They provide tested sample code, detailed explanations of how Cassandra works ”under the covers,” and new case studies from three cutting-edge users: Ooyala, Hailo, and eBay. Coverage includes Understanding Cassandra’s approach, architecture, key concepts, and primary use cases– and why it’s so blazingly fast Getting Cassandra up and running on single nodes and large clusters Applying the new design patterns, philosophies, and features that make Cassandra such a powerful data store Leveraging CQL to simplify your transition from SQL-based RDBMSes Deploying and provisioning through the cloud or on bare-metal hardware Choosing the right configuration options for each type of workload Tweaking Cassandra to get maximum performance from your hardware, OS, and JVM Mastering Cassandra’s essential tools for maintenance and monitoring Efficiently solving the most common problems with Cassandra deployment, operation, and application development

Maximize the New and Improved Features of Oracle Database 12 c Written by Master Principle Database Expert, Oracle, and Oracle ACE Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, you’ll find everything you need to know to get up and running quickly on Oracle Database 12 c. Supported by running commentary from world-renowned Oracle expert Tom Kyte, and with additional contributions by Oracle experts Eric Yen and Scott Black, Oracle Database 12c New Features offers detailed coverage of: Installing Oracle Database 12 c Architectural changes, such as Oracle Multitenant The most current information on upgrading and migrating to Oracle Database 12 c The pre-upgrade information tool and parallel processing for database upgrades Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System Oracle RMAN enhancements, including cross-platform backup and recovery Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync SQL, PL/SQL, DML, and DDL new features Improvements to partitioning manageability, performance, and availability Advanced business intelligence and data warehousing capabilities Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges Manageability, performance, and optimization improvements

Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 12c Performance Tuning Recipes delivers. Oracle Database 12c Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter's domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it's performance-related, you'll probably find a recipe and a solution in this book. Provides proven solutions to real-life Oracle performance problems Offers relevant background and theory to support each solution Gets straight to the point for when you're under pressure for results What you'll learn Optimize the use of memory and storage Monitor performance and troubleshoot problems Identify and improve poorly-performing SQL statements Adjust the most important optimizer parameters to your advantage Create indexes that get used and make a positive impact upon performance Automate and stabilize using key features such as SQL Tuning Advisor and SQL Plan Baselines Who this book is for Oracle Database 12c Performance Tuning Recipes is aimed squarely at Oracle Database administrators. The book especially appeals to those administrators desiring to have at their side a ready-to-go set of solutions to common database performance problems.

Learn about Cloudera Impala--an open source project that's opening up the Apache Hadoop software stack to a wide audience of database analysts, users, and developers. The Impala massively parallel processing (MPP) engine makes SQL queries of Hadoop data simple enough to be accessible to analysts familiar with SQL and to users of business intelligence tools--and it’s fast enough to be used for interactive exploration and experimentation.