Home > Articles > Data


RSS Feed Subscribe to this topic  RSS details

504 Items

Sort by Date | Title

SQL Server AlwaysOn and Availability Groups
By Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Jun 29, 2015
SQL Server's AlwaysOn is taking the database world by storm. This chapter from Microsoft SQL Server 2014 Unleashed dives into the AlwaysOn new features and availability groups.
Swift Development: Nobody Knows the Tuples I've Seen
By Erica Sadun
Jun 23, 2015
In the Swift programming language, tuples play specialized roles that lend power and flexibility to your development. Erica Sadun, bestselling author of The Gourmet iOS Developer's Cookbook: Even More Recipes for Better iOS App Development, explores tuples in depth.
In-Memory Optimization and the Buffer Pool Extension in SQL Server 2014
By Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
Jun 18, 2015
To take maximum advantage of the performance improvements that can be achieved from having your critical OLTP tables memory resident, Microsoft developed the In-Memory Optimization feature for SQL Server. Another feature introduced in SQL Server 2014 to take advantage of the lower costs and increased sizes of SSDs, is the Buffer Pool Extension feature. The authors of Microsoft SQL Server 2014 Unleashed discuss both of these exciting new features in this chapter.
Preface to Microsoft SQL Server 2014 Unleashed
By Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
May 26, 2015
The authors of Microsoft SQL Server 2014 Unleashed introduce their book and discuss its intended audience, what the book covers, and conventions used in the book.
NoSQL for Mere Mortals: Designing for Document Databases
By Dan Sullivan
May 19, 2015
In this chapter from NoSQL for Mere Mortals, Dan Sullivan helps you understand ways of assessing document database models and choosing the best techniques for your needs.
Video: Oracle SQL Performance Tuning for Developers: Introduction
By Dan Hotka
May 14, 2015
Dan Hotka introduces his video course in this excerpt from Oracle SQL Performance Tuning for Developers LiveLessons (Video Training), Downloadable Version.
Video: Oracle SQL Performance Tuning for Developers: Understand Explain Plans
By Dan Hotka
May 12, 2015
In this excerpt from Oracle SQL Performance Tuning for Developers LiveLessons, Dan Hotka describes the role of explain plans in Oracle SQL performance tuning.
By Benjamin Rosenzweig, Elena Rakhimov
Mar 4, 2015
In this chapter from Oracle PL/SQL by Example, 5th Edition, learn how to make use of variables and the various ways to populate variables. This chapter also covers transactional control in PL/SQL by explaining what it means to commit data as well as how SAVEPOINTs are used.
Video: Working with Big Data: How to Write Data Into the Hadoop File System
By Paul Dix
Mar 3, 2015
In this video excerpt from Working with Big Data LiveLessons (Video Training): Infrastructure, Algorithms, and Visualizations, Paul Dix shows you how to copy files up to Hadoop using a StackExchange public data dump as an example.
Working with Records in FileMaker Pro 13
By Tim Dietrich
Jan 5, 2015
In this chapter from FileMaker Pro 13 Absolute Beginner's Guide, explore and work with the Filemaker database. You change, add, and delete records; navigate through records and layouts; and much more.
Practical Advice for Building Secure Android Databases in SQLite
By Godfrey Nolan
Jan 2, 2015
This chapter from Bulletproof Android: Practical Advice for Building Secure Apps looks at how developers have used SQLite and, more importantly, how they have tried to secure that data in progressively more secure ways so you don’t make the same mistakes.
Video: Hadoop Fundamentals: Install Hortonworks HDP2.1 Sandbox
By Doug Eadline
Dec 17, 2014
Are you ready to get up and running with Hadoop? One of the first things you'll want to do is install Hortonworks HDP 2.1 Sandbox. Doug Eadline shows you how in this excerpt from Hadoop Fundamentals LiveLessons (Video Training), 2nd Edition.
NoSQL Databases: An Overview
By Pramod J. Sadalage
Dec 11, 2014
Pramod Sadalage provides an overview of NoSQL databases, explaining what NoSQL is, types of NoSQL databases, and why and how to choose a NoSQL database.
HBase Data Analysis with MapReduce
By Steven Haines
Nov 26, 2014
HBase supports two types of read access: table scans by row key and MapReduce jobs. Table scans enable you to retrieve the exact subset of rows you are looking for, and MapReduce jobs enable you to perform analysis across a greater set of data. This article reviews HBase’s support for MapReduce and demonstrates how to create a MapReduce job to analyze 10,000 records in a table.
Big Data Scalability: Why Your Database Is Slow, and When You Should Start Scaling
By Cory Isaacson
Nov 12, 2014
Constant increases in the volume of Big Data worldwide have begun to overwhelm the database management systems on which we all rely. We need a comprehensive method for managing this overflow. Database expert Cory Isaacson, CEO/CTO of CodeFutures and author of Understanding Big Data Scalability, discusses how scaling can help to keep your databases from being overwhelmed, how you'll know when you should start scaling, and the best way to make it happen.
Introduction to HBase, the NoSQL Database for Hadoop: Programming HBase with Java
By Steven Haines
Nov 4, 2014
The first article in this series (“Introduction to HBase”) presented HBase, also known as the Hadoop database and described how to set up a local environment and manipulate data using the HBase shell. This article continues by demonstrating how to interact with HBase using Java. You learn how to put data into HBase, get data out of HBase, delete data from HBase, and how to perform a table scan to extract a range of records. Finally, you see how to set up an HBase project using Maven.
Introduction to HBase, the NoSQL Database for Hadoop
By Steven Haines
Oct 27, 2014
HBase is called the Hadoop database because it is a NoSQL database that runs on top of Hadoop. It combines the scalability of Hadoop by running on the Hadoop Distributed File System (HDFS), with real-time data access as a key/value store and deep analytic capabilities of Map Reduce. This article introduces HBase and describes how it organizes and manages data and then demonstrates how to set up a local HBase environment and interact with data using the HBase shell.
Introduction to Oracle Databases on Virtual Infrastructure
By Kannan Mani, Don Sullivan
Oct 22, 2014
99.9% of all database or data management systems should be considered candidates for virtualization on vSphere. In this chapter from Virtualizing Oracle Databases on vSphere, the authors argue that Oracle databases and software are prime candidates to consider migrating to virtualized infrastructure.
Introducing NoSQL and MongoDB
By Brad Dayley
Sep 18, 2014
In this chapter from NoSQL with MongoDB in 24 Hours, Sams Teach Yourself, learn about the design considerations to review before deciding how to implement the structure of data and configuration of a MongoDB database. You'll also learn which design questions to ask and then how to explore the mechanisms built into MongoDB to answer those questions.
Hit the Ground Running with MongoDB and Python
By Stephen B. Morris
Sep 16, 2014
Stephen B. Morris describes how to get started with MongoDB and Python. As usual with Python, you can get productive quickly, without worrying about complex IDEs. MongoDB has a simple data model and easy-to-understand semantics, giving you a handy on-ramp to this interesting technology.

Page 1 2 3 4 5 Next >