rssHome » Database Administration

Developing with Couchbase Server

eBook Details:

  • Paperback: 88 pages
  • Publisher: O’Reilly Media (February 14, 2013)
  • Language: English
  • ISBN-10: 1449331165
  • ISBN-13: 978-1449331160

eBook Description:

Developing with Couchbase Server

  • Learn about Couchbase Server’s cluster-based architecture and how it differs from SQL databases
  • Choose a client library for Java, .NET, Ruby, Python, PHP, or C, and connect to a cluster
  • Structure data in a variety of formats, from serialized objects, a stream of raw bytes, or as JSON documents
  • Learn core storage and retrieval methods, including document IDs, expiry times, and concurrent updates
  • Create views with map/reduce and learn Couchbase mechanisms for querying and selection

Today’s highly interactive websites pose a challenge for traditional SQL databases the ability to scale rapidly and serve loads of concurrent users. With this concise guide, you’ll learn how to build web applications on top of Couchbase Server 2.0, a NoSQL database that can handle websites and social media where hundreds of thousands of users read and write large volumes of information.

Using food recipe information as examples, this book demonstrates how to take advantage of Couchbase’s document-oriented database design, and how to store and query data with various CRUD operations. Discover why Couchbase is better than SQL databases with memcached tiers for managing data from the most interactive portions of your application. CLICK TO DOWNLOAD

Resilience and Reliability on AWS

eBook Details:

  • Paperback: 150 pages
  • Publisher: O’Reilly Media (January 10, 2013)
  • Language: English
  • ISBN-10: 1449339190
  • ISBN-13: 978-1449339197

eBook Description:

Resilience and Reliability on AWS

  • Build cloud applications with the “rip, mix, and burn” approach
  • Get a crash course on Amazon Web Services
  • Learn the top ten tips for surviving outages in the cloud
  • Use elasticsearch to build a dependable NoSQL data store
  • Combine AWS and PostgreSQL to build an RDBMS that scales well
  • Create a highly available document database with MongoDB Replica Set and SimpleDB
  • Augment Redis with AWS to provide backup/restore, failover, and monitoring capabilities
  • Work with CloudFront and Route 53 to safeguard global content delivery

Cloud services are just as susceptible to network outages as any other platform. This concise book shows you how to prepare for potentially devastating interruptions by building your own resilient and reliable applications in the public cloud. Guided by engineers from 9apps an independent provider of Amazon Web Services and Eucalyptus cloud solutions you’ll learn how to combine AWS with open source tools such as PostgreSQL, MongoDB, and Redis. CLICK TO DOWNLOAD

Hadoop MapReduce Cookbook

eBook Details:

  • Paperback: 300 pages
  • Publisher: Packt Publishing (January 25, 2013)
  • Language: English
  • ISBN-10: 1849517282
  • ISBN-13: 978-1849517287

eBook Description:

Hadoop MapReduce Cookbook

  • Learn to process large and complex data sets, starting simply, then diving in deep
  • Solve complex big data problems such as classifications, finding relationships, online marketing and recommendations
  • More than 50 Hadoop MapReduce recipes, presented in a simple and straightforward manner, with step-by-step instructions and real world examples

Hadoop MapReduce Cookbook

We are facing an avalanche of data. The unstructured data we gather can contain many insights that might hold the key to business success or failure. Harnessing the ability to analyze and process this data with Hadoop MapReduce is one of the most highly sought after skills in today’s job market.

Hadoop MapReduce Cookbook is a one-stop guide to processing large and complex data sets using the Hadoop ecosystem. The book introduces you to simple examples and then dives deep to solve in-depth big data use cases. CLICK TO DOWNLOAD

Implementing Splunk: Big Data Reporting and Development for Operationa...

eBook Details:

  • Paperback: 448 pages
  • Publisher: Packt Publishing (January 24, 2013)
  • Language: English
  • ISBN-10: 1849693285
  • ISBN-13: 978-1849693288

eBook Description:

Implementing Splunk: Big Data Reporting and Development for Operational Intelligence

  • Learn to search, dashboard, configure, and deploy Splunk on one machine or thousands
  • Start working with Splunk fast, with a tested set of practical examples and useful advice
  • Step-by-step instructions and examples with a comprehensive coverage for Splunk veterans and newbies alike

Implementing Splunk: Big Data Reporting and Development for Operational Intelligence

Implementing Splunk: Big Data Reporting and Development for Operational Intelligence takes you on a journey right from inception to a fully functioning implementation of Splunk. Using a real-world data walkthrough, you’ll be shown how to search effectively, create fields, build dashboards, reports, and package apps, manage your indexes, integrate into the enterprise, and extend Splunk. This practical implementation guide equips you with high-level knowledge for configuring, deploying, extending, and integrating Splunk. Depending on the goal and skills of the reader, enough topics are covered to get you on your way to dashboard guru, app developer, or enterprise administrator. This book uses examples curates reference, and sage advice to help you make the most of this incredibly powerful tool. CLICK TO DOWNLOAD

Murach’s ADO.NET 4 Database Programming with C# 2010

eBook Details:

  • Paperback: 756 pages
  • Publisher: Mike Murach & Associates; 4th edition (April 26, 2011)
  • Language: English
  • ISBN-10: 1890774634
  • ISBN-13: 978-1890774639

eBook Description:

Murach’s ADO.NET 4 Database Programming with C# 2010

  • In section 1, you’ll get a basic introduction to databases, SQL, and ADO.NET. If you already have ADO.NET experience, you can skip ahead.
  • In section 2, you’ll quickly be creating database applications using Rapid Application Development (RAD) tools like data sources.
  • In section 3, you’ll build 3-layer applications the way the pros do, with presentation, business, and database classes. This is where you’ll get into ADO.NET coding to create your own classes. You’ll also learn how to use object data sources to make this approach even more effective.
  • In section 4, you’ll develop database applications for the web using ASP.NET 4 data controls like GridView and DetailsView, along with object data sources.
  • In section 5, you’ll complete the set of skills that every .NET database programmer should have by learning how to (1) handle XML data in your applications, (2) create reports with Visual Studio’s Report Designer and the ReportViewer control, (3) use LINQ to SQL to query datasets and SQL Server databases, and (4) use the Entity Framework and LINQ to Entities to work with database data through an Entity Data Model.

It teaches you how to use Visual Studio 2010 and ADO.NET 4 to develop professional database applications for both Windows and the web as quickly and easily as possible. And it covers the full gamut of skills you need, from using built-in data tools that generate ADO.NET code to writing your own ADO.NET code from scratch so you can closely control how the database processing works. CLICK TO DOWNLOAD

Murach’s ADO.NET 4 Database Programming with VB 2010

eBook Details:

  • Paperback: 756 pages
  • Publisher: Mike Murach & Associates; 4th edition (March 4, 2011)
  • Language: English
  • ISBN-10: 9781890774622
  • ISBN-13: 978-1890774622

eBook Description:

Murach’s ADO.NET 4 Database Programming with VB 2010

Now in its 4th Edition, this book shows Visual Basic developers how to use Visual Studio and ADO.NET to develop database applications the way the best professionals do. You’ll learn how to:

  • quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010
  • code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications…the route the professionals take for flexibility and control
  • display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView
  • work with XML-specific features of ADO.NET and SQL Server to read, write, and manipulate XML data in your applications
  • create local reports using Visual Studio’s Report Designer and Report Viewer to display data easily…and clearly!…in tables, matrices, lists, and charts
  • Use the Entity Framework to create an entity data model that maps business objects to database objects, then retrieve and maintain data through that model
  • Use LINQ to query datasets, SQL Server databases, and entity data

Now in its 4th Edition, this book shows Visual Basic developers how to use Visual Studio and ADO.NET to develop database applications the way the best professionals do. CLICK TO DOWNLOAD

Pro SQL Database for Windows Azure: SQL Server in the Cloud, 2nd Editi...

eBook Details:

  • Paperback: 320 pages
  • Publisher: Apress; 2nd edition (December 10, 2012)
  • Language: English
  • ISBN-10: 1430243953
  • ISBN-13: 978-1430243953

eBook Description:

Pro SQL Database for Windows Azure: SQL Server in the Cloud, 2nd Edition

Pro SQL Database for Windows Azure: SQL Server in the Cloud, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft’s worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database for Windows Azure. You can create and deploy a database in mere minutes that is accessible worldwide and takes advantage of SQL Database’s high-availability features to protect your data while ensuring 99.9% uptime.

Pro SQL Database for Windows Azure: SQL Server in the Cloud, 2nd Edition covers the very latest in Microsoft’s fast-moving, cloud platform, showing how to program and administer it in a variety of cloud computing scenarios. You’ll learn to program SQL Azure from ASP.NET, from WinForms, and from SQL Reporting Services. You’ll learn to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. You’ll learn the unique aspects of SQL Azure such as sharding and federation support that combine to place SQL Azure a step above and ahead of the competiton.

Pro SQL Database for Windows Azure: SQL Server in the Cloud, 2nd Edition introduces you to Microsoft’s cloud-based delivery of its enterprise-caliber, SQL Server database management system showing you how to program and administer it in a variety of cloud computing scenarios. CLICK TO DOWNLOAD

View Updating and Relational Theory

eBook Details:

  • Paperback: 260 pages
  • Publisher: O’Reilly Media (December 31, 2012)
  • Language: English
  • ISBN-10: 1449357849
  • ISBN-13: 978-1449357849

eBook Description:

View Updating and Relational Theory

  • Help database products improve in the future
  • Help with a “roll your own” implementation, absent such product improvements
  • Make you aware of the crucial role of predicates and constraints
  • Show you how relational products are really supposed to behave

Views are virtual tables. That means they should be updatable, just as “real” or base tables are. In fact, view updatability isn’t just desirable, it’s crucial, for practical reasons as well as theoretical ones. But view updating has always been a controversial topic. Ever since the relational model first appeared, there has been widespread skepticism as to whether (in general) view updating is even possible.

In stark contrast to this conventional wisdom, this book shows how views, just like base tables, can always be updated (so long as the updates don’t violate any integrity constraints). More generally, it shows how updating always ought to work, regardless of whether the target is a base table or a view. The proposed scheme is 100% consistent with the relational model, but rather different from the way updating works in SQL products today. CLICK TO DOWNLOAD

Building Node Applications with MongoDB and Backbone

eBook Details:

  • Paperback: 204 pages
  • Publisher: O’Reilly Media (December 31, 2012)
  • Language: English
  • ISBN-10: 1449337392
  • ISBN-13: 978-1449337391

eBook Description:

Building Node Applications with MongoDB and Backbone

  • Learn about key modules in Node.js for building real-time apps
  • Use the Backbone.js framework to write clean browser code, and maintain better data integration with MongoDB
  • Structure project files as a foundation for code that will arrive later
  • Create user accounts and learn how to secure the data
  • Use Backbone.js templates to build the application’s UIs, and integrate access control with Node.js
  • Develop a contact list to help users link to and track other accounts
  • Use Socket.io to create real-time chat functionality
  • Extend your UIs to give users up-to-the-minute information

Build an application from backend to browser with Node.js, and kick open the doors to real-time event programming. With this hands-on book, you’ll learn how to create a social network application similar to LinkedIn and Facebook, but with a real-time twist. And you’ll build it with just one programming language: JavaScript.

If you’re an experienced web developer unfamiliar with JavaScript, the book’s first section introduces you to the project’s core technologies: Node.js, Backbone.js, and the MongoDB data store. You’ll then launch into the project a highly responsive, highly scalable application guided by clear explanations and lots of code examples. CLICK TO DOWNLOAD

Getting Started with Talend Open Studio for Data Integration

eBook Details:

  • Paperback: 320 pages
  • Publisher: Packt Publishing (November 6, 2012)
  • Language: English
  • ISBN-10: 1849514720
  • ISBN-13: 978-1849514729

eBook Description:

Getting Started with Talend Open Studio for Data Integration

  • Develop complex integration jobs without writing code
  • Go beyond “extract, transform and load” by constructing end-to-end integrations
  • Learn how to package your jobs for production use

Getting Started with Talend Open Studio for Data Integration

Talend Open Studio for Data Integration (TOS) is an open source graphical development environment for creating custom integrations between systems. It comes with over 600 pre-built connectors that make it quick and easy to connect databases, transform files, load data, move, copy and rename files and connect individual components in order to define complex integration processes.

Getting Started with Talend Open Studio for Data Integration illustrates common uses and scenarios in a simple, practical manner and, building on knowledge as the book progresses, works towards more complex integration solutions. CLICK TO DOWNLOAD