1st Edition

Cloud Database Development and Management

By Lee Chao Copyright 2014
    487 Pages 225 B/W Illustrations
    by Auerbach Publications

    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.

    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

    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.