Cloud database development and management:
"Nowadays, cloud computing is almost everywhere. However, one can hardly find a textbook that utilizes cloud computing for teaching database and application development. This cloud-based database development book that teaches both the theory and hands-on practice with step-by-step instructions...
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Boca Raton [u.a.]
CRC Press
2014
|
| Series: | An Auerbach book
|
| Subjects: | |
| Online Access: | Cover Inhaltsverzeichnis |
| Summary: | "Nowadays, cloud computing is almost everywhere. However, one can hardly find a textbook that utilizes cloud computing for teaching database and application development. This cloud-based database development book that teaches both the theory and hands-on practice with step-by-step instructions and examples. This book helps readers to set up a cloud computing environment for teaching and learning database systems. The book will cover adequate conceptual content for students and IT professionals to gain necessary knowledge and hands-on skills to set up cloud based database systems"-- |
| Item Description: | Includes bibliographical references and index |
| Physical Description: | XIX, 467 S. Ill. |
| ISBN: | 9781466565050 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV041228098 | ||
| 003 | DE-604 | ||
| 005 | 20131105 | ||
| 007 | t | ||
| 008 | 130820s2014 a||| |||| 00||| eng d | ||
| 010 | |a 2013018420 | ||
| 020 | |a 9781466565050 |c hardback |9 978-1-4665-6505-0 | ||
| 035 | |a (OCoLC)858956034 | ||
| 035 | |a (DE-599)GBV746407181 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-473 | ||
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Chao, Lee |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Cloud database development and management |c Lee Chao |
| 264 | 1 | |a Boca Raton [u.a.] |b CRC Press |c 2014 | |
| 300 | |a XIX, 467 S. |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a An Auerbach book | |
| 500 | |a Includes bibliographical references and index | ||
| 520 | 1 | |a "Nowadays, cloud computing is almost everywhere. However, one can hardly find a textbook that utilizes cloud computing for teaching database and application development. This cloud-based database development book that teaches both the theory and hands-on practice with step-by-step instructions and examples. This book helps readers to set up a cloud computing environment for teaching and learning database systems. The book will cover adequate conceptual content for students and IT professionals to gain necessary knowledge and hands-on skills to set up cloud based database systems"-- | |
| 650 | 0 | 7 | |a Datenbankentwurf |0 (DE-588)4127613-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Windows Azure |0 (DE-588)7693533-4 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Windows Azure |0 (DE-588)7693533-4 |D s |
| 689 | 0 | 1 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 0 | 2 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | |u http://images.tandf.co.uk/common/jackets/websmall/978146656/9781466565050.jpg |3 Cover | |
| 856 | 4 | 2 | |m Digitalisierung UB Bamberg - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026202529&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-026202529 | ||
Record in the Search Index
| _version_ | 1804150668408127489 |
|---|---|
| adam_text | Contents
Preface
..................................................................................................................................xi
Acknowledgments.............................................................................................................xvii
Autbor................................................................................................................................xix
1
Introduction
to Database Systems and Cloud Computing
..........................................1
Objectives
.......................................................................................................................... 1
1.1
Introduction
............................................................................................................1
1.2
Overview of Database Management Systems
...........................................................2
1.3
Database Components
.............................................................................................2
1.4
Database Development Process
................................................................................5
1.5
Overview or Cloud Computing
...............................................................................7
1.5.1
Software as a Service
...................................................................................8
1.5.2
Platform as a Service
...................................................................................9
1.5-3
Infrastructure as a
Service
..........................................................................10
1.5.4
Personal Cloud
..........................................................................................10
1.6
Summary
...............................................................................................................28
Review Questions
...........................................................................................·.................28
2
Database Design and Windows Azure Data Storage
..................................................31
Objectives
.........................................................................................................................31
2.1
Introduction
...........................................................................................................31
2.2
Database Conceptual Design
.................................................................................32
2.2.1
Interview Key Players
................................................................................33
2.2.2
Observe How Data Are Used in Business Processes
...................................33
2.2.3
Examine Documents Used in Business Processes
.....................................34
2.2.4
Analyze Collected Information
.................................................................37
2.3
Entity-Relationship Data Model
...........................................................................39
2.3.1
Integration Definition for Information Modeling
.....................................39
2.3.2
Entities
.....................................................................................................
40
2.3.3
Attributes, identifiers, and Domains
.........................................................40
2.3.4
Relationships
............................................................................................
42
2.4
Database Physical Design
......................................................................................56
2.4.1
Database System Architecture
..................................................................56
2.4.2
Windows Azure Data Storage Overview
...................................................58
vi
■ Contents
2.4.2.1
Windows
Azure
SQL
Database
................................................ 58
2.4.2.2
Windows
Azure
Storage
.............................................................61
2.5
Summary
............................................................................................................... 70
Review Questions
............................................................................................................. 70
3
Table Normalization and Windows Azure SQL Database
.........................................71
Objectives
........................................................................................................................71
3.1
Introduction
..........................................................................................................71
3.2
Overview of Relational Database
........................................................................... 71
3.2.1
Functional Dependency
............................................................................73
3.2.2
Keys
...........................................................................................................74
3.2.3
Linking Tables
..........................................................................................75
3.3
Normalization
....................................................................................................... 75
3.3.1
Why Table Normalization?
........................................................................76
3.3.2
Normal Forms
..........................................................................................78
3.3.3 Denormal
ization
.......................................................................................86
3.4
Transferring Data Model to Relational Database
..................................................86
3.4.1
Representing Entities
................................................................................87
3.4.2
Representing Relationships
.......................................................................90
3.4.3
Enforcing Constraints
..............................................................................98
3.5
Summary
..............................................................................................................111
Review Questions
............................................................................................................111
4
Database Development and Management with SQL
................................................113
Objectives
.......................................................................................................................113
4.1
Introduction
.........................................................................................................113
4.2
Structured Query Language
.................................................................................113
4.3
Creating Database Objects
...................................................................................115
4.3.1
Defining DataTypes
...............................................................................115
4.3.2
Constraints
..............................................................................................117
4.3.3
Creating Database
...................................................................................119
4.3.4
Creating Tables
........................................................................................119
4.4
Managing Database Objects
.................................................................................132
4.4.1
Viewing Table Structures
.........................................................................132
4.4.2
Modifying Table Structures
.....................................................................132
4.4.3
Controlling Database Object Privileges
..................................................134
4.5
Manipulating Data in Tables
................................................................................137
4.5.1
Inserting Data
.........................................................................................137
4.5.2
Modifying Data
.......................................................................................137
4.5.3
Querying Data
........................................................................................138
4.5.4
Deleting Data
..........................................................................................138
4.6
Summary
..............................................................................................................159
Review Questions
............................................................................................................160
5
Importing and Exporting Database Objects
............................................................163
Objectives
.......................................................................................................................163
5.1
Introduction
.........................................................................................................163
Contents ■
vii
5.2
SQL Server Management Studio
..........................................................................164
5.3
Data-Tier
Application
...........................................................................................168
5-4
Windows
Azure SQL
Database
Migration
Wizard
...............................................174
5.5
Moving Data in and out of
Windows
Azure SQL
Database
Using SSIS
...............177
5.6
Import
and Export Data
with Bulk Copy
Program
..............................................187
5.7
Working with
XML Data.....................................................................................190
5-7.1
Introduction to Extensible Markup Language
.........................................191
5.7.2
XML Data Type
......................................................................................193
5.8
Summary
..............................................................................................................196
Review Questions
............................................................................................................197
Querying Information in Windows Azure SQL Database
.......................................199
Objectives
.............................................................................................................,.........199
6.1
Introduction
.........................................................................................................199
6.2
Retrieving Data from Tables with SQL
................................................................199
6.2.1
Querying Data with SELECT, FROM, and WHERE Statements
.........200
6.2.2
Logical Operators
...................................................................................205
6.2.3
Comparison Operators
...........................................................................209
6.2.4
Arithmetic Operators
...............................................................................210
6.3
Subqueries
............................................................................................................213
6.4
Joining Multiple Tables with SQL
........................................................................217
6.4.1
Inner Join
................................................................................................217
6.4.2
Outer Join
...............................................................................................217
6.4.3
Multiple Joins
..........................................................................................219
6.4.4
Self-Join
...................................................................................................219
6.5
SQL Built-in Functions
........................................................................................221
6.5.1
Aggregate Functions
...............................................................................222
6.5.2
Scalar Functions
.....................................................................................223
6.6
Summary
..............................................................................................................231
Review Questions
...........................................................................................................232
Windows Azure SQL Database Procedures and Functions
......................................235
Objectives
.......................................................................................................................235
7.1
Introduction
.........................................................................................................235
7.2
SQL Programming Extensions
.............................................................................235
7.2.1
Variables
.................................................................................................236
7.2.2
Flow-Control Structures
.........................................................................236
7-3
Procedures and Functions
....................................................................................238
73.1
Functions
................................................................................................238
7.3.1.1
Scalar Functions
.....................................................................239
7.3.1.2
Table Functions
......................................................................239
7.3.1.3
APPLY Operator
......................................................................241
7.3.2
Procedures
..............................................................................................242
7.3.2.1
Creating and Executing Stored Procedures
.............................243
7.3.2.2
Modifying and Deleting Stored Procedures
............................244
7.4
Triggers
...............................................................................................................246
7.4.1
Creating, Modifying, and Deleting Triggers
...........................................247
viii
■ Contents
7.4.2
Using Triggers
.........................................................................................250
7.4.2.1
Validating Business Constraints
..............................................250
7.4.2.2
Implementing Dynamic Application Logic
..............................251
7.4.2.3
Keeping Database Integrity
.....................................................252
7.5
Summary
.............................................................................................................263
Review Questions
...........................................................................................................263
8
Windows Azure SQL Database Views, Indexes, and Federations
............................265
Objectives
.......................................................................................................................265
8.1
Introduction
.........................................................................................................265
8.2
Views
...................................................................................................................266
8.2.1
Create Views
...........................................................................................266
8.2.2
Modify Views
.........................................................................................268
8.2.3
Modify Data in a View
...........................................................................268
8.2.4
Drop Views
............................................................................................. 269
8.3
Indexes
................................................................................................................279
8.3.1
Creale
Indexes
........................................................................................280
8.3.2
Manage Indexes
.......................................................................................281
8.3.3
Remove Indexes
.......................................................................................281
8.4
Federations
.......................................................................................................... 285
8.4.1
Federation Design
...................................................................................287
8.4.1.1
Generating Federation Key
..................................................... 287
8.4.1.2
Database Operations across Multiple Federation Members
.....287
8.4.1.3
Data Distribution across Multiple Federation Members
.........288
8.4.1.4
Applications and Federation Logic
..........................................288
8.4.2
Federation Implementation with T-SQL
.................................................289
8.5
Summary
..............................................................................................................301
Review Questions
...........................................................................................................302
9
Database Application Development
.........................................................................303
Objectives
................................,.....................................................................................303
9.1
Introduction
........................................................................................................303
9.2
Database Application Design
...............................................................................304
9.2.1
Application Design
.................................................................................304
9.2.2
GUI Design
............................................................................................307
9.3
Database Application Development
...................-.................................................308
9.3.1
Form Development
.................................................................................309
9-3.2
Report Development
...............................................................................312
9.4
Summary
.............................................................................................................336
Review Questions
...........................................................................................................336
10
Windows Azure and Deployment of Applications to the Cloud
..............................337
Objectives
.......................................................................................................................337
10.1
Introduction
.........................................................................................................337
10.2
Windows Azure
....................................................................................................338
10.2.1
Windows Azure Structure
.......................................................................338
10.2.2
Windows Azure Management Portal
.......................................................339
10.3
Windows Azure SDK
...........................................................................................345
Contents ■ ix
10.3.1 Windows
Azure Compute
Emulator........................................................345
10.3.2 Windows
Azure Storage
Emulator..........................................................346
10.3.3 Application Development
with
Windows
Azure SDK
............................347
10.3.3.1 Windows
Azure Application
Design.......................................347
10.3.3.2 Windows
Azure
Application Development.............................348
10.3.3.3
Developing
Applications
on Local
Computers........................348
10.3.3.4
Role
Definition
and Configuration
.........................................349
10.3.3.5
Authentication.........................................................................
352
10.3.4 Windows
Azure
Application
Deployment................................................
352
10.4
Summary
..............................................................................................................373
Review
Questions
............................................................................................................373
11 Windows
Azure Storage
...........................................................................................375
Objectives
.......................................................................................................................375
11.1
Introduction
.........................................................................................................375
1 1.2
Windows Azure Storage Services
..........................................................................375
11.3
Use of Table Storage
.............................................................................................378
11.4
Use of Blob Storage
.............................................................................................396
1 1.5
Use or Queue Storage
..........................................................................................400
1 1.6
Deploy Applications to Windows Azure
...............................................................412
1 1.7
Summary
.............................................................................................................420
Review Questions
...........................................................................................................420
12
Windows Azure Management
..................................................................................421
Objectives
.......................................................................................................................421
12.1
Introduction
.........................................................................................................421
12.2
Windows Azure SQL Database Security
..............................................................422
12.3
Managing Windows Azure SQL Database
..........................................................423
12.4
Managing Windows Azure
..................................................................................432
12.5
Monitoring Windows Azure
................................................................................441
12.6
Summary
..............................................................................................................451
Review Questions
............................................................................................................451
Bibliography
..........................................................................................................................453
Index
......................................................................................................................................457
|
| any_adam_object | 1 |
| author | Chao, Lee |
| author_facet | Chao, Lee |
| author_role | aut |
| author_sort | Chao, Lee |
| author_variant | l c lc |
| building | Verbundindex |
| bvnumber | BV041228098 |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)858956034 (DE-599)GBV746407181 |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02257nam a2200421 c 4500</leader><controlfield tag="001">BV041228098</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20131105 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">130820s2014 a||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2013018420</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781466565050</subfield><subfield code="c">hardback</subfield><subfield code="9">978-1-4665-6505-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)858956034</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV746407181</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Chao, Lee</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Cloud database development and management</subfield><subfield code="c">Lee Chao</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Boca Raton [u.a.]</subfield><subfield code="b">CRC Press</subfield><subfield code="c">2014</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIX, 467 S.</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">An Auerbach book</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index</subfield></datafield><datafield tag="520" ind1="1" ind2=" "><subfield code="a">"Nowadays, cloud computing is almost everywhere. However, one can hardly find a textbook that utilizes cloud computing for teaching database and application development. This cloud-based database development book that teaches both the theory and hands-on practice with step-by-step instructions and examples. This book helps readers to set up a cloud computing environment for teaching and learning database systems. The book will cover adequate conceptual content for students and IT professionals to gain necessary knowledge and hands-on skills to set up cloud based database systems"--</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Windows Azure</subfield><subfield code="0">(DE-588)7693533-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Windows Azure</subfield><subfield code="0">(DE-588)7693533-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://images.tandf.co.uk/common/jackets/websmall/978146656/9781466565050.jpg</subfield><subfield code="3">Cover</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026202529&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-026202529</subfield></datafield></record></collection> |
| id | DE-604.BV041228098 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T00:42:35Z |
| institution | BVB |
| isbn | 9781466565050 |
| language | English |
| lccn | 2013018420 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-026202529 |
| oclc_num | 858956034 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG |
| owner_facet | DE-473 DE-BY-UBG |
| physical | XIX, 467 S. Ill. |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | CRC Press |
| record_format | marc |
| series2 | An Auerbach book |
| spelling | Chao, Lee Verfasser aut Cloud database development and management Lee Chao Boca Raton [u.a.] CRC Press 2014 XIX, 467 S. Ill. txt rdacontent n rdamedia nc rdacarrier An Auerbach book Includes bibliographical references and index "Nowadays, cloud computing is almost everywhere. However, one can hardly find a textbook that utilizes cloud computing for teaching database and application development. This cloud-based database development book that teaches both the theory and hands-on practice with step-by-step instructions and examples. This book helps readers to set up a cloud computing environment for teaching and learning database systems. The book will cover adequate conceptual content for students and IT professionals to gain necessary knowledge and hands-on skills to set up cloud based database systems"-- Datenbankentwurf (DE-588)4127613-9 gnd rswk-swf Windows Azure (DE-588)7693533-4 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf Windows Azure (DE-588)7693533-4 s Datenbankverwaltung (DE-588)4389357-0 s Datenbankentwurf (DE-588)4127613-9 s DE-604 http://images.tandf.co.uk/common/jackets/websmall/978146656/9781466565050.jpg Cover Digitalisierung UB Bamberg - ADAM Catalogue Enrichment application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026202529&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Chao, Lee Cloud database development and management Datenbankentwurf (DE-588)4127613-9 gnd Windows Azure (DE-588)7693533-4 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| subject_GND | (DE-588)4127613-9 (DE-588)7693533-4 (DE-588)4389357-0 |
| title | Cloud database development and management |
| title_auth | Cloud database development and management |
| title_exact_search | Cloud database development and management |
| title_full | Cloud database development and management Lee Chao |
| title_fullStr | Cloud database development and management Lee Chao |
| title_full_unstemmed | Cloud database development and management Lee Chao |
| title_short | Cloud database development and management |
| title_sort | cloud database development and management |
| topic | Datenbankentwurf (DE-588)4127613-9 gnd Windows Azure (DE-588)7693533-4 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| topic_facet | Datenbankentwurf Windows Azure Datenbankverwaltung |
| url | http://images.tandf.co.uk/common/jackets/websmall/978146656/9781466565050.jpg http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026202529&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT chaolee clouddatabasedevelopmentandmanagement |