Atnaujinkite slapukų nuostatas

El. knyga: Cloud Database Development and Management [Taylor & Francis e-book]

(University of Houston-Victoria, Texas, USA)
  • Formatas: 487 pages, 225 Illustrations, black and white
  • Išleidimo metai: 26-Jul-2013
  • Leidėjas: Auerbach
  • ISBN-13: 9780429100185
Kitos knygos pagal šią temą:
  • Taylor & Francis e-book
  • Kaina: 184,65 €*
  • * this price gives unlimited concurrent access for unlimited time
  • Standartinė kaina: 263,78 €
  • Sutaupote 30%
Cloud Database Development and ManagementDidesnis paveikslėlis
  • Formatas: 487 pages, 225 Illustrations, black and white
  • Išleidimo metai: 26-Jul-2013
  • Leidėjas: Auerbach
  • ISBN-13: 9780429100185
Kitos knygos pagal šią temą:
Taylor & Francis e-booksMore info about Taylor & Francis e-books
Partnerių interneto svetainė: https://www.taylorfrancis.com/books/9780429100185
Although todays 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 books 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.
Preface xi
Acknowledgments xvii
Author xix
1 Introduction to Database Systems and Cloud Computing 1(30)
Objectives
1(1)
1.1 Introduction
1(1)
1.2 Overview of Database Management Systems
2(1)
1.3 Database Components
2(3)
1.4 Database Development Process
5(2)
1.5 Overview of Cloud Computing
7(21)
1.5.1 Software as a Service
8(1)
1.5.2 Platform as a Service
9(1)
1.5.3 Infrastructure as a Service
10(1)
1.5.4 Personal Cloud
10(18)
1.6 Summary
28(1)
Review Questions
28(3)
2 Database Design and Windows Azure Data Storage 31(40)
Objectives
31(1)
2.1 Introduction
31(1)
2.2 Database Conceptual Design
32(7)
2.2.1 Interview Key Players
33(1)
2.2.2 Observe How Data Are Used in Business Processes
33(1)
2.2.3 Examine Documents Used in Business Processes
34(3)
2.2.4 Analyze Collected Information
37(2)
2.3 Entity-Relationship Data Model
39(17)
2.3.1 Integration Definition for Information Modeling
39(1)
2.3.2 Entities
40(1)
2.3.3 Attributes, Identifiers, and Domains
40(2)
2.3.4 Relationships
42(14)
2.4 Database Physical Design
56(14)
2.4.1 Database System Architecture
56(2)
2.4.2 Windows Azure Data Storage Overview
58(13)
2.4.2.1 Windows Azure SQL Database
58(3)
2.4.2.2 Windows Azure Storage
61(9)
2.5 Summary
70(1)
Review Questions
70(1)
3 Table Normalization and Windows Azure SQL Database 71(42)
Objectives
71(1)
3.1 Introduction
71(1)
3.2 Overview of Relational Database
71(4)
3.2.1 Functional Dependency
73(1)
3.2.2 Keys
74(1)
3.2.3 Linking Tables
75(1)
3.3 Normalization
75(11)
3.3.1 Why Table Normalization?
76(2)
3.3.2 Normal Forms
78(8)
3.3.3 Denormalization
86(1)
3.4 Transferring Data Model to Relational Database
86(25)
3.4.1 Representing Entities
87(3)
3.4.2 Representing Relationships
90(8)
3.4.3 Enforcing Constraints
98(13)
3.5 Summary
111(1)
Review Questions
111(2)
4 Database Development and Management with SQL 113(50)
Objectives
113(1)
4.1 Introduction
113(1)
4.2 Structured Query Language
113(2)
4.3 Creating Database Objects
115(17)
4.3.1 Defining Data Types
115(2)
4.3.2 Constraints
117(2)
4.3.3 Creating Database
119(1)
4.3.4 Creating Tables
119(13)
4.4 Managing Database Objects
132(5)
4.4.1 Viewing Table Structures
132(1)
4.4.2 Modifying Table Structures
132(2)
4.4.3 Controlling Database Object Privileges
134(3)
4.5 Manipulating Data in Tables
137(22)
4.5.1 Inserting Data
137(1)
4.5.2 Modifying Data
137(1)
4.5.3 Querying Data
138(1)
4.5.4 Deleting Data
138(21)
4.6 Summary
159(1)
Review Questions
160(3)
5 Importing and Exporting Database Objects 163(36)
Objectives
163(1)
5.1 Introduction
163(1)
5.2 SQL Server Management Studio
164(4)
5.3 Data-Tier Application
168(6)
5.4 Windows Azure SQL Database Migration Wizard
174(3)
5.5 Moving Data in and out of Windows Azure SQL Database Using SSIS
177(10)
5.6 Import and Export Data with Bulk Copy Program
187(3)
5.7 Working with XML Data
190(6)
5.7.1 Introduction to Extensible Markup Language
191(2)
5.7.2 XML Data Type
193(3)
5.8 Summary
196(1)
Review Questions
197(2)
6 Querying Information in Windows Azure SQL Database 199(36)
Objectives
199(1)
6.1 Introduction
199(1)
6.2 Retrieving Data from Tables with SQL
199(14)
6.2.1 Querying Data with SELECT, FROM, and WHERE Statements
200(5)
6.2.2 Logical Operators
205(4)
6.2.3 Comparison Operators
209(1)
6.2.4 Arithmetic Operators
210(3)
6.3 Subqueries
213(4)
6.4 Joining Multiple Tables with SQL
217(4)
6.4.1 Inner Join
217(1)
6.4.2 Outer Join
217(2)
6.4.3 Multiple Joins
219(1)
6.4.4 Self-Join
219(2)
6.5 SQL Built-In Functions
221(10)
6.5.1 Aggregate Functions
222(1)
6.5.2 Scalar Functions
223(8)
6.6 Summary
231(1)
Review Questions
232(3)
7 Windows Azure SQL Database Procedures and Functions 235(30)
Objectives
235(1)
7.1 Introduction
235(1)
7.2 SQL Programming Extensions
235(3)
7.2.1 Variables
236(1)
7.2.2 Flow-Control Structures
236(2)
7.3 Procedures and Functions
238(8)
7.3.1 Functions
238(4)
7.3.1.1 Scalar Functions
239(1)
7.3.1.2 Table Functions
239(2)
7.3.1.3 APPLY Operator
241(1)
7.3.2 Procedures
242(4)
7.3.2.1 Creating and Executing Scored Procedures
243(1)
7.3.2.2 Modifying and Deleting Stored Procedures
244(2)
7.4 Triggers
246(17)
7.4.1 Creating, Modifying, and Deleting Triggers
247(3)
7.4.2 Using Triggers
250(16)
7.4.2.1 Validating Business Constraints
250(1)
7.4.2.2 Implementing Dynamic Application Logic
251(1)
7.4.2.3 Keeping Database Integrity
252(11)
7.5 Summary
263(1)
Review Questions
263(2)
8 Windows Azure SQL Database Views, Indexes, and Federations 265(38)
Objectives
265(1)
8.1 Introduction
265(1)
8.2 Views
266(13)
8.2.1 Create Views
266(2)
8.2.2 Modify Views
268(1)
8.2.3 Modify Data in a View
268(1)
8.2.4 Drop Views
269(10)
8.3 Indexes
279(6)
8.3.1 Create Indexes
280(1)
8.3.2 Manage Indexes
281(1)
8.3.3 Remove Indexes
281(4)
8.4 Federations
285(16)
8.4.1 Federation Design
287(2)
8.4.1.1 Generating Federation Key
287(1)
8.4.1.2 Database Operations across Multiple Federation Members
287(1)
8.4.1.3 Data Distribution across Multiple Federation Members
288(1)
8.4.1.4 Applications and Federation Logic
288(1)
8.4.2 Federation Implementation with T-SQL
289(12)
8.5 Summary
301(1)
Review Questions
302(1)
9 Database Application Development 303(34)
Objectives
303(1)
9.1 Introduction
303(1)
9.2 Database Application Design
304(4)
9.2.1 Application Design
304(3)
9.2.2 GUI Design
307(1)
9.3 Database Application Development
308(28)
9.3.1 Form Development
309(3)
9.3.2 Report Development
312(24)
9.4 Summary
336(1)
Review Questions
336(1)
10 Windows Azure and Deployment of Applications to the Cloud 337(38)
Objectives
337(1)
10.1 Introduction
337(1)
10.2 Windows Azure
338(7)
10.2.1 Windows Azure Structure
338(1)
10.2.2 Windows Azure Management Portal
339(6)
10.3 Windows Azure SDK
345(28)
10.3.1 Windows Azure Compute Emulator
345(1)
10.3.2 Windows Azure Storage Emulator
346(1)
10.3.3 Application Development with Windows Azure SDK
347(5)
10.3.3.1 Windows Azure Application Design
347(1)
10.3.3.2 Windows Azure Application Development
348(1)
10.3.3.3 Developing Applications on Local Computers
348(1)
10.3.3.4 Role Definition and Configuration
349(3)
10.3.3.5 Authentication
352(1)
10.3.4 Windows Azure Application Deployment
352(21)
10.4 Summary
373(1)
Review Questions
373(2)
11 Windows Azure Storage 375(46)
Objectives
375(1)
11.1 Introduction
375(1)
11.2 Windows Azure Storage Services
375(3)
11.3 Use of Table Storage
378(18)
11.4 Use of Blob Storage
396(4)
11.5 Use of Queue Storage
400(12)
11.6 Deploy Applications to Windows Azure
412(8)
11.7 Summary
420(1)
Review Questions
420(1)
12 Windows Azure Management 421(32)
Objectives
421(1)
12.1 Introduction
421(1)
12.2 Windows Azure SQL Database Security
422(1)
12.3 Managing Windows Azure SQL Database
423(9)
12.4 Managing Windows Azure
432(9)
12.5 Monitoring Windows Azure
441(10)
12.6 Summary
451(1)
Review Questions
451(2)
Bibliography 453(4)
Index 457
Lee Chao, PhD, is a professor in the Science, Technology, Engineering, and Mathematics division at the University of HoustonVictoria, 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.
Pastovi nuoroda: https://www.kriso.lt/db/9780429100185_pe.html
Raktažodžiai: