数据库处理-基础.设计与实现(第十版)(英文版)
- ISBN:7121026066
- 装帧:简裝本
- 册数:暂无
- 重量:暂无
- 开本:16开
- 页数:675
- 出版时间:2006-06-01
- 条形码:9787121026065 ; 978-7-121-02606-5
目录
Preface
Part 1: Getting Started 1
Chapter 1: Introduction 3
The Characteristics of Databases 4
Database Examples 5
Components of a Database System 8
The Database 11
Database Design 13
What You Need to Learn 17
A Brief History of Database Processing 18
Chapter 2: Introduction to Structured
Query Language 27
SQL Background 28
Cape Codcl Outdoor Sports 28
The SQL SELECT/FROM/WHERE Framework 31
Continuation of SQL for Querying a Single Table 40
Performing Calculations in SQL Queries 45
Grouping 50
Looking for Patterns in NASDAQ Trading 52
Querying Two or More Tables with SQL 55
Part 2: Database Design 67
Chapter 3: The Relational Model
and Normalization 69
Relational Model Terminology 71
Normal Forms 81
Chapter 4: Database Design
Using Normalization 101
Assess Table Structure 102
Designing Updatable Databases 103
Designing Read-Only Databases 106
Common Design Problems 109
Chapter 5: Data Modeling with the Entity-Relationship
Model 119
The Purpose of a Data Model 120
The Entity-Relationship Model 120
Patterns in Forms, Reports, and
Entity-Relationship Models 135
The Data Modeling Process 153
Chapter 6: Transforming Data Models
into Database Designs 171
Create a Table for Each Entity 172
Create Relationships 177
Design for Minimum Cardinality 194
The View Ridge Gallery Database 204
Part 3: Database Implementation 217
Chapter 7: SQL for Database Construction
and Application Processing 219
SQL DDL, DML, and Joins 220
SQL DML 232
New Forms of Join 234
Using SQL Views 239
Embedding SQL in Program Code 247
Use Triggers 248
Using Stored Procedures 254
Chapter 8: Database Redesign 265
The Need for Database Redesign 266
Additional SCIL Statements 266
Analyzing the Existing Database 271
Changing Table Names and Table Columns 275
Changing Relationship Cardinalities
and Properties 279
Adding and Deleting Tables and Relationships 283
Forward Engineering (?) 284
Part 4: Multiuser Database Processing 291
Chapter 9: Managing Multiuser Databases 293
Database Administration 294
Concurrency Control 296
Database Security 309
Database Recovery 314
Managing the DMBS 317
Chapter 10: Managing Databases with Oracle 325
Installing Oracle 326
Creating an Oracle Database 326
Data Dictionary 354
Concurrency Control 356
Oracle Security 358
Oracle Backup and Recovery 363
Topics Not Discussed in This Chapter 365
Chapter 11 : Managing Databases with SQL Server 2000 371
Installing SQLServer 2000 372
Creating a SQL Server 2000 Database 372
Application Logic 382
Concurrency Control 393
SQL Server Security 397
SQL Server Backup and Recovery 40o
Topics Not Discussed in This Chapter 404
Part 5: Database Access Standards 409
Chapter 12: ODBC, aLE DB, ADO, and ASP 411
The Web Server Data Environment 412
Open Database Connectivity (ODBC) Standard 414
OLE DB 418
Active Data Objects (ADO) 422
ADO Examples 428
Chapter 13: XML and ADO.NET 449
The Importance of XML 450
XML as a Markup Language 451
XML Schema 456
ADO.NET 474
Additional XML Standards 488
Chapter 14: JDBC, Java Server Pages, and MySQL 497
JDBC 498
Java Server Pages 5o7
MySOL 519
Part 6: Conclusion 529
Chapter 15: Database Processing for Business
Intelligence Systems 531
Repasting and Data Mining Applications 532
Data Warehouses and Data Marts 533
Reporting Systems 537
Data Mining 549
Appendix A Introduction to Microsoft Access 561
Appendix B The IDEF1XStandard 575
Appendix G UML-Style Entity-Relationship Diagrams 583
Appendix D Data Structures for Databas
作者简介
David M.Kroenke是一位多产的计算机畅销书作家。他撰写或与人合著的图书专业性强,涉及面广。注重专业理论与实践运用的结合,精通数据库处理、数据库概念、商用计算机系统和管理信息系统等。
-
Excel高效办公应用于技巧大全
¥21.4¥49.8 -
计算机二级office通关秘籍
¥19.6¥28.0 -
大师谈游戏设计 创意与节奏
¥37.4¥49.8 -
全图解零基础word excel ppt 应用教程
¥14.4¥48.0 -
C++面向对象程序设计习题解答与上机指导 第2版
¥35.4¥59.0 -
全国计算机等级考试最新真考题库模拟考场及详解·二级MSOffice高级应用
¥31.5¥45.0 -
DAMA数据管理知识体系指南(原书第2版)
¥94.7¥128.0 -
Python数据爬取技术与实战手册
¥22.7¥59.8 -
HTML & CSS设计与构建网站
¥43.9¥79.8 -
flash经典课堂动画、游戏与多媒体制作案例教程
¥54.5¥99.0 -
推荐系统:产品与算法解析
¥62.2¥79.8 -
社交网络对齐
¥77.8¥99.8 -
大数据基础
¥22.8¥38.0 -
技术之外
¥48.3¥69.0 -
贝叶斯数据分析(第2版)
¥151.8¥199.8 -
零基础玩转STABLE DIFFUSION
¥72.9¥99.8 -
Blender超级学习手册
¥86.3¥119.9 -
高效C/C++调试
¥69.3¥99.0 -
AIGC从入门到实战:CHATGPT+MIDJOURNEY+STABLE DIFFUSION+行业应
¥48.9¥69.8 -
实战AI大模型
¥74.3¥99.0