Wow! eBook – Blog

Book Description

Expert Indexing in Oracle Database 11g is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the proliferation of computing into everything from phones to tablets to PCs in our increasingly connected world. At the heart of any good-performing database lies a sound indexing strategy that makes appropriate use of indexing, and especially of the vendor-specific indexing features on offer.

Few databases fully exploit the wealth of data access mechanisms provided by Oracle. Expert Indexing in Oracle Database 11g helps by bringing together information indexing and how to use it into one, convenient and blissfully short volume that you can read quickly and have at your fingertips for reference. Learn the different types of indices available and when each is best applied. Recognize when queries aren’t using indices as you intend. Manage your indexing for maximum performance. Let Expert Indexing in Oracle Database 11g be your guide to deep mastery of the most fundamental performance optimization structure in Oracle Database.

• Explains how indices work, how they help, and how they hinder
• Demystifies the various index choices
• Describes the database administration chores associated with indices

What you’ll learn Download Now »

Book Description

Database Systems: The Complete Book is ideal for Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments. A basic understanding of algebraic expressions and laws, logic, basic data structure, OOP concepts, and programming environments is implied.

Written by well-known computer scientists, this introduction to database systems offers a comprehensive approach, focusing on database design, database use, and implementation of database applications and database management systems.

The first half of the book provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. It covers the latest database standards SQL:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other texts. The second half of the book provides in-depth coverage of databases from the point of view of the DBMS implementor. It focuses on storage structures, query processing, and transaction management. The book covers the main techniques in these areas with broader coverage of query optimization than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques.

NOTEWORTHY FEATURES

• Offers a readable presentation with engaging, real-world examples. Includes aspects of SQL programming not found in some other texts: SQL/PSM (persistent stored modules) Download Now »

Book Description

Working with data and databases in C# certainly can be daunting if you’re coming from VB6, VBA, or Access. With this hands-on guide, you’ll shorten the learning curve considerably as you master accessing, adding, updating, and deleting data with C#—basic skills you need if you intend to program with this language.

No previous knowledge of C# is necessary. By following the examples in this book, you’ll learn how to tackle several database tasks in C#, such as working with SQL Server, building data entry forms, and using data in a web service. The book’s code samples will help you get started on your own projects.

• Create a Windows Forms application with a datagrid
• Connect to multiple data sources, including Access and SQL Server
• Add, edit, and update data in a database you choose and design
• Enable users to choose their data source at runtime
• Learn the roles of DataTable, DataView, BindingSource, Filters, and other objects
• Understand where variables are declared and how they impact the code
• Build a simple web service that connects to a database

Table of Contents
Chapter 1. First Steps: Form with a Datagrid
Chapter 2. C# Data Access to SQL Server Download Now »

Book Description

CouchDB is a new breed of database for the Internet, geared to meet the needs of today’s dynamic web applications. With this concise introduction, you’ll learn how CouchDB’s simple model for storing, processing, and accessing data makes it ideal for the type of data and rapid response users now demand from your applications—and how easy CouchDB is to set up, deploy, maintain, and scale.

The code-packed examples in this book will help you learn how to work with documents, populate a simple database, replicate data from one database to another, and a host of other tasks.

• Install CouchDB on Linux, Mac OS X, Windows, or (if you must) from the source code
• Interact with data through CouchDB’s RESTful API, and use standard HTTP operations, such as PUT, GET, POST, and DELETE
• Use Futon—CouchDB’s web-based interface— to manage databases and documents, and to configure replications
• Learn how to create, update, and delete documents in JSON format, and how to create and delete databases
• Work with design documents to get the formatting and indexing your application requires

Table of Contents
Chapter 1. Why CouchDB?
Chapter 2. Installation
Chapter 3. CouchDB Basics Download Now »

Book Description

With this digital Early Release edition of Hadoop: The Definitive Guide, you get the entire book bundle in its earliest form – the author’s raw and unedited content – so you can take advantage of this content long before the book’s official release. You’ll also receive updates when significant changes are made, as well as the final ebook version.p>Ready to unleash the power of your massive dataset? With the latest edition of this comprehensive resource, you’ll learn how to use Apache Hadoop to build and maintain reliable, scalable, distributed systems. It’s ideal for programmers looking to analyze datasets of any size, and for administrators who want to set up and run Hadoop clusters.

This third edition covers recent changes to Hadoop, including new material on the new MapReduce API, as well as version 2 of the MapReduce runtime (YARN) and its more flexible execution model. You’ll also find illuminating case studies that demonstrate how Hadoop is used to solve specific problems.

• Store large datasets with the Hadoop Distributed File System (HDFS), then 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
• Use Pig, a high-level query language for large-scale data processing Download Now »

Book Description

Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g.

This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on:

• Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i)
• Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle’s self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition)
• Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing)
• Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider

The latest Oracle Database 11g features: query result set caching Download Now »