1st Edition

Cloud Database Development and Management




ISBN 9781466565050
Published July 26, 2013 by Auerbach Publications
487 Pages 225 B/W Illustrations

USD $94.95

Prices & shipping based on shipping country


Preview

Book 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

...
View More

Author(s)

Biography

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.