Cloud Database Development and Management: 1st Edition (Hardback) book cover

Cloud Database Development and Management

1st Edition

By Lee Chao

Auerbach Publications

487 pages | 225 B/W Illus.

Purchasing Options:$ = USD
Hardback: 9781466565050
pub: 2013-07-26
SAVE ~$18.19
$90.95
$72.76
x
eBook (VitalSource) : 9780429100185
pub: 2013-07-26
from $45.48


FREE Standard Shipping!

Description

Although today’s job market requires IT professionals to understand cloud computing theories and have hands-on skills for developing real-world database systems, there are few books available that integrate coverage of both. Filling this void, Cloud Database Development and Management explains how readers can take advantage of the cloud environment to develop their own fully functioning database systems without any additional investment in IT infrastructure.

Filled with step-by-step instructions, examples, and hands-on projects, the book begins by providing readers with the required foundation in database systems and cloud-based database development tools. It supplies detailed instructions on setting up data storage on Windows Azure and also explains how readers can develop their own virtual machines with Windows Server 2012 as the guest operating system.

The book’s wide-ranging coverage includes database design, database implementation, database deployment to the cloud environment, SQL Database, Table Storage service, Blob Storage service, Queue Storage service, and database application development. The text deals with all three aspects of database design: conceptual design, logical design, and physical design. It introduces the SQL language, explains how to use SQL to create database objects, and introduces the migration of the database between Windows Azure and the on-premises SQL Server. It also discusses the management tasks that keep both SQL Database and Windows Azure running smoothly.

Detailing how to design, implement, and manage database systems in the cloud, the book provides you with tools that can make your cloud database development much more efficient and flexible. Its easy-to-follow instructions will help you develop the hands-on skills needed to store and manage critical business information and to make that data available anytime through the Internet.

Table of Contents

Introduction to Database Systems and Cloud Computing

Objectives

Introduction

Overview of Database Management Systems

Database Components

Database Development Process

Overview of Cloud Computing

Software as a Service

Platform as a Service

Infrastructure as a Service

Personal Cloud

Summary

Review Questions

Database Design and Windows Azure Data Storage

Objectives

Introduction

Database Conceptual Design

Interview Key Players

Observe How Data Are Used in Business Processes

Examine Documents Used in Business Processes

Analyze Collected Information

Entity–Relationship Data Model

Integration Definition for Information Modeling

Entities

Attributes, Identifiers, and Domains

Relationships

Database Physical Design

Database System Architecture

Windows Azure Data Storage Overview

Windows Azure SQL Database

Windows Azure Storage

Summary

Review Questions

Table Normalization and Windows Azure SQL Database

Objectives

Introduction

Overview of Relational Database

Functional Dependency

Keys

Linking Tables

Normalization

Why Table Normalization?

Normal Forms

Denormalization

Transferring Data Model to Relational Database

Representing Entities

Representing Relationships

Enforcing Constraints

Summary

Review Questions

Database Development and Management with SQL

Objectives

Introduction

Structured Query Language

Creating Database Objects

Defining Data Types

Constraints

Creating Database

Creating Tables

Managing Database Objects

Viewing Table Structures

Modifying Table Structures

Controlling Database Object Privileges

Manipulating Data in Tables

Inserting Data

Modifying Data

Querying Data

Deleting Data

Summary

Review Questions

Importing and Exporting Database Objects

Objectives

Introduction

SQL Server Management Studio

Data-Tier Application

Windows Azure SQL Database Migration Wizard

Moving Data in and out of Windows Azure SQL Database Using SSIS

Import and Export Data with Bulk Copy Program

Working with XML Data

Introduction to Extensible Markup Language

XML Data Type

Summary

Review Questions

Querying Information in Windows Azure SQL Database

Objectives

Introduction

Retrieving Data from Tables with SQL

Querying Data with SELECT, FROM, and WHERE Statements

Logical Operators

Comparison Operators

Arithmetic Operators

Subqueries

Joining Multiple Tables with SQL

Inner Join

Outer Join

Multiple Joins

Self-Join

SQL Built-In Functions

Aggregate Functions

Scalar Functions

Summary

Review Questions

Windows Azure SQL Database Procedures and Functions

Objectives

Introduction

SQL Programming Extensions

Variables

Flow-Control Structures

Procedures and Functions

Functions

Scalar Functions

Table Functions

APPLY Operator

Procedures

Creating and Executing Stored Procedures

Modifying and Deleting Stored Procedures

Triggers

Creating, Modifying, and Deleting Triggers

Using Triggers

Validating Business Constraints

Implementing Dynamic Application Logic

Keeping Database Integrity

Summary

Review Questions

Windows Azure SQL Database Views, Indexes, and Federations

Objectives

Introduction

Views

Create Views

Modify Views

Modify Data in a View

Drop Views

Indexes

Create Indexes

Manage Indexes

Remove Indexes

Federations

Federation Design

Generating Federation Key

Database Operations across Multiple Federation Members

Data Distribution across Multiple Federation Members

Applications and Federation Logic

Federation Implementation with T-SQL

Summary

Review Questions

Database Application Development

Objectives

Introduction

Database Application Design

Application Design

GUI Design

Database Application Development

Form Development

Report Development

Summary

Review Questions

Windows Azure and Deployment of Applications to the Cloud

Objectives

Introduction

Windows Azure

Windows Azure Structure

Windows Azure Management Portal

Windows Azure SDK

Windows Azure Compute Emulator

Windows Azure Storage Emulator

Application Development with Windows Azure SDK

Windows Azure Application Design

Windows Azure Application Development

Developing Applications on Local Computers

Role Definition and Configuration

Authentication

Windows Azure Application Deployment

Summary

Review Questions

Windows Azure Storage

Objectives

Introduction

Windows Azure Storage Services

Use of Table Storage

Use of Blob Storage

Use of Queue Storage

Deploy Applications to Windows Azure

Summary

Review Questions

Windows Azure Management

Objectives

Introduction

Windows Azure SQL Database Security

Managing Windows Azure SQL Database

Managing Windows Azure

Monitoring Windows Azure

Summary

Review Questions

Bibliography

Index

About the Author

Lee Chao, PhD, is a professor in the Science, Technology, Engineering, and Mathematics division at the University of Houston–Victoria, USA. He earned his PhD at the University of Wyoming, USA.

Dr. Chao has been teaching IT courses for over 20 years. His current research interests are database system development and cloud computing. Dr. Chao is the author of over a dozen research articles and books in various areas of IT.

Subject Categories

BISAC Subject Codes/Headings:
COM021000
COMPUTERS / Database Management / General
COM043000
COMPUTERS / Networking / General
COM051230
COMPUTERS / Software Development & Engineering / General