Muutke küpsiste eelistusi

Database Systems: Design, Implementation, and Management 8th Revised edition [Kõva köide]

3.58/5 (494 hinnangut Goodreads-ist)
,
  • Formaat: Hardback, 704 pages
  • Ilmumisaeg: 01-Dec-2007
  • Kirjastus: Course Technology Inc
  • ISBN-10: 1423902017
  • ISBN-13: 9781423902010
Teised raamatud teemal:
  • Kõva köide
  • Hind: 81,54 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Database Systems: Design, Implementation, and Management 8th Revised editionSuurem pilt
  • Formaat: Hardback, 704 pages
  • Ilmumisaeg: 01-Dec-2007
  • Kirjastus: Course Technology Inc
  • ISBN-10: 1423902017
  • ISBN-13: 9781423902010
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781423902010.html
Märksõnad:
"Database Systems: Design, Implementation, and Management, Eighth Edition", a market-leader for database texts, gives readers a solid foundation in practical database design and implementation. The book provides in-depth coverage of database design, demonstrating that the key to successful database implementation is in proper design of databases to fit within a larger strategic view of the data environment. Updates for the eighth edition include additional Unified Modeling Language coverage, expanded coverage of SQL Server functions, all-new business intelligence coverage, and added coverage of data security. With a strong hands-on component that includes real-world examples and exercises, this book will help students develop database design skills that have valuable and meaningful application in the real world.
PART I. DATABASE CONCEPTS
Business Vignette: The Relational Revolution
3(1)
Database Systems
4(26)
Data vs. Information
5(1)
Introducing the Database and the DBMS
6(4)
Role and Advantages of the DBMS
7(1)
Types of Databases
8(2)
Why Database Design Is Important
10(1)
Historical Roots: Files and File Systems
10(4)
Problems with File System Data Management
14(4)
Structural and Data Dependence
15(1)
Field Definitions and Naming Conventions
15(2)
Data Redundancy
17(1)
Database Systems
18(12)
The Database System Environment
19(2)
DBMS Functions
21(4)
Managing the Database System:A Shift in Focus
25(1)
Summary
26(1)
Key Terms
26(1)
Review Questions
27(1)
Problems
27(3)
Data Models
30(32)
Data Modeling and Data Models
31(1)
The Importance of Data Models
31(1)
Data Model Basic Building Blocks
32(1)
Business Rules
33(2)
Discovering Business Rules
34(1)
Translating Business Rules into Data Model Components
34(1)
The Evolution of Data Models
35(13)
The Hierarchical Model
36(1)
The Network Model
37(1)
The Relational Model
38(2)
The Entity Relationship Model
40(3)
The Object-Oriented (OO) Model
43(1)
The Convergence of Data Models
44(1)
Database Models and the Internet
45(1)
Data Models:A Summary
45(3)
Degrees of Data Abstraction
48(13)
The External Model
48(2)
The Conceptual Model
50(1)
The Internal Model
51(1)
The Physical Model
52(1)
Summary
53(1)
Key Terms
54(1)
Review Questions
54(1)
Problems
55(6)
PART II. DESIGN CONCEPTS
Business Vignette: Database Modeling Supporting Communities
61(1)
The Relational Database Model
62(42)
A Logical View of Data
63(3)
Tables and Their Characteristics
63(3)
Keys
66(5)
Integrity Rules
71(1)
Relational Set Operators
72(6)
The Data Dictionary and the System Catalog
78(2)
Relationships within the Relational Database
80(8)
The I :M Relationship
80(2)
The I:I Relationship
82(2)
The M:N Relationship
84(4)
Data Redundancy Revisited
88(2)
Indexes
90(1)
Codd's Relational Database Rules
91(13)
Summary
93(1)
Key Terms
93(1)
Review Questions
94(2)
Problems
96(8)
Entity Relationship (ER) Modeling
104(48)
The Entity Relationship Model (ERM)
105(22)
Entities
105(1)
Attributes
105(6)
Relationships
111(1)
Connectivity and Cardinality
111(2)
Existence Dependence
113(1)
Relationship Strength
113(3)
Weak Entities
116(2)
Relationship Participation
118(2)
Relationship Degree
120(2)
Recursive Relationships
122(3)
Associative (Composite Entities
125(2)
Developing an ER Diagram
127(8)
Database Design Challenges: Conflicting Goals
135(17)
Summary
139(1)
Key Terms
139(1)
Review Questions
140(1)
Problems
141(11)
Normalization of Database Tables
152(41)
Database Tables and Normalization
153(1)
The Need for Normalization
153(4)
The Normalization Process
157(7)
Conversion to First Normal Form
158(3)
Conversion to Second Normal Form
161(2)
Conversion to Third Normal Form
163(1)
Improving the Design
164(4)
Surrogate Key Considerations
168(1)
Higher-Level Normal Forms
169(5)
The Boyce-Codd Normal Form (BCNF)
170(3)
Fourth Normal Form (4NF)
173(1)
Normalization and Database Design
174(4)
Denormalization
178(15)
Summary
182(2)
Key Terms
184(1)
Review Questions
184(1)
Problems
185(8)
Advanced Data Modeling
193(31)
The Extended Entity Relationship Model
194(6)
Entity Supertypes and Subtypes
194(1)
Specialization Hierarchy
195(1)
Inheritance
196(1)
Subtype Discriminator
197(1)
Disjoint and Overlapping Constraints
197(2)
Completeness Constraint
199(1)
Specialization and Generalization
199(1)
Entity Clustering
200(1)
Entity Integrity: Selecting Primary Keys
201(5)
Natural Keys and Primary Keys
202(1)
Primary Key Guidelines
202(1)
When to Use Composite Primary Keys
203(1)
When to Use Surrogate Primary Keys
204(2)
Design Cases: Learning Flexible Database Design
206(5)
Design Case #1: Implementing 1:1 Relationships
206(1)
Design Case #2: Maintaining History of Time-Variant Data
207(2)
Design Case #3: Fan Traps
209(1)
Design Case #4: Redundant Relationships
210(1)
Data Modeling Checklist
211(12)
Summary
213(1)
Key Terms
213(1)
Review Questions
214(1)
Problems
214(9)
PART III. ADVANCED DESIGN AND IMPLEMENTATION
Business Vignette: Using Queries to Score Runs
223(1)
Introduction to Structured Query Language (SQL)
224(73)
Introduction to SQL
225(1)
Data Definition Commands
226(14)
The Database Model
227(2)
Creating the Database
229(1)
The Database Schema
229(1)
Data Types
230(2)
Creating Table Structures
232(3)
SQL Constraints
235(4)
SQL Indexes
239(1)
Data Manipulation Commands
240(7)
Adding Table Rows
240(2)
Saving Table Changes
242(1)
Listing Table Rows
242(2)
Updating Table Rows
244(1)
Restoring Table Contents
244(1)
Deleting Table Rows
245(1)
Inserting Table Rows with a Select Subquery
245(2)
Select Queries
247(10)
Selecting Rows with Conditional Restrictions
247(4)
Arithmetic Operators: The Rule of Precedence
251(1)
Logical Operators: And, Or, and Not
251(2)
Special Operators
253(4)
Advanced Data Definition Commands
257(6)
Changing a Column's Data Type
257(1)
Changing a Column's Data Characteristics
257(1)
Adding a Column
258(1)
Dropping a Column
258(1)
Advanced Data Updates
259(2)
Copying Parts of Tables
261(1)
Adding Primary and Foreign Key Designations
262(1)
Deleting a Table from the Database
263(1)
Advanced Select Queries
263(10)
Ordering a Listing
263(2)
Listing Unique Values
265(1)
Aggregate Functions
265(5)
Grouping Data
270(3)
Virtual Tables: Creating a View
273(1)
Joining Database Tables
274(23)
Joining Tables with an Alias
277(1)
Recursive Joins
277(1)
Outer Joins
278(2)
Summary
280(1)
Key Terms
281(1)
Review Questions
281(4)
Problems
285(12)
Advanced SQL
297(75)
Relational Set Operators
298(6)
Union
299(1)
Union All
300(1)
Intersect
301(1)
Minus
301(2)
Syntax Alternatives
303(1)
SQL Join Operators
304(9)
Cross Join
306(1)
Natural Join
307(1)
Join Using Clause
308(1)
Join On Clause
309(1)
Outer Joins
310(3)
Subqueries and Correlated Queries
313(11)
Where Subqueries
314(1)
In Subqueries
315(1)
Having Subqueries
316(1)
Multirow Subquery Operators: Any and All
317(1)
From Subqueries
318(1)
Attribute List Subqueries
319(2)
Correlated Subqueries
321(3)
SQL Functions
324(7)
Date and Time Functions
325(2)
Numeric Functions
327(1)
String Functions
328(2)
Conversion Functions
330(1)
Oracle Sequences
331(4)
Updatable Views
335(3)
Procedural SQL
338(21)
Triggers
342(9)
Stored Procedures
351(6)
PL/SQL Processing with Cursors
357(2)
PL/SQL Stored Functions
359(1)
Embedded SQL
359(13)
Summary
365(1)
Key Terms
366(1)
Review Questions
366(1)
Problems
367(5)
Database Design
372(40)
The Information System
373(2)
The Systems Development Life Cycle (SDLC)
375(3)
Planning
376(1)
Analysis
376(1)
Detailed Systems Design
377(1)
Implementation
377(1)
Maintenance
378(1)
The Database Life Cycle (DBLC)
378(24)
The Database Initial Study
379(4)
Database Design
383(14)
Implementation and Loading
397(4)
Testing and Evaluation
401(1)
Operation
401(1)
Maintenance and Evolution
401(1)
Database Design Strategies
402(1)
Centralized vs. Decentralized Design
403(8)
Summary
407(1)
Key Terms
407(1)
Review Questions
407(1)
Problems
408(3)
PART IV. ADVANCED DATABASE CONCEPTS
Business Vignette: JetBlue's Database Crisis
411(1)
Transaction Management and Concurrency Control
412(30)
What Is a Transaction?
413(7)
Evaluating Transaction Results
414(3)
Transaction Properties
417(1)
Transaction Management with SQL
418(1)
The Transaction Log
418(2)
Concurrency Control
420(4)
Lost Updates
420(1)
Uncommitted Data
421(1)
Inconsistent Retrievals
422(1)
The Scheduler
423(1)
Concurrency Control with Locking Methods
424(7)
Lock Granularity
425(3)
Lock Types
428(1)
Two-Phase Locking to Ensure Serializability
429(1)
Deadlocks
430(1)
Concurrency Control with Time Stamping Methods
431(2)
Wait/Die and Wound/Wait Schemes
432(1)
Concurrency Control with Optimistic Methods
433(1)
Database Recovery Management
433(9)
Transaction Recovery
434(4)
Summary
438(1)
Key Terms
439(1)
Review Questions
439(1)
Problems
440(2)
Database Performance Tuning and Query Optimization
442(35)
Database Performance-Tuning Concepts
443(5)
Performance Tuning: Client and Server
444(1)
DBMS Architecture
444(2)
Database Statistics
446(2)
Query Processing
448(3)
SQL Parsing Phase
449(1)
SQL Execution Phase
450(1)
SQL Fetching Phase
450(1)
Query Processing Bottlenecks
450(1)
Indexes and Query Optimization
451(2)
Optimizer Choices
453(3)
Using Hints to Affect Optimizer Choices
455(1)
SQL Performance Tuning
456(3)
Index Selectivity
456(1)
Conditional Expressions
457(2)
Query Formulation
459(1)
DBMS Performance Tuning
460(2)
Query Optimization Example
462(15)
Summary
471(1)
Key Terms
472(1)
Review Questions
472(1)
Problems
473(4)
Distributed Database Management Systems
477(36)
The Evolution of Distributed Database Management Systems
478(2)
DDBMS Advantages and Disadvantages
480(1)
Distributed Processing and Distributed Databases
481(2)
Characteristics of Distributed Database Management Systems
483(1)
DDBMS Components
484(1)
Levels of Data and Process Distribution
485(4)
Single-Site Processing, Single-Site Data (SPSD)
486(1)
Multiple-Site Processing, Single-Site Data (MPSD)
487(1)
Multiple-Site Processing, Multiple-Site Data (MPMD)
488(1)
Distributed Database Transparency Features
489(1)
Distribution Transparency
490(2)
Transaction Transparency
492(5)
Distributed Requests and Distributed Transactions
492(4)
Distributed Concurrency Control
496(1)
Two-Phase Commit Protocol
496(1)
Performance Transparency and Query Optimization
497(2)
Distributed Database Design
499(6)
Data Fragmentation
499(4)
Data Replication
503(2)
Data Allocation
505(1)
Client/Server vs. DDBMS
505(1)
C. J. Date's Twelve Commandments for Distributed Databases
506(7)
Summary
508(1)
Key Terms
509(1)
Review Questions
509(1)
Problems
510(3)
Business Intelligence and Data Warehouses
513(59)
The Need for Data Analysis
514(1)
Business Intelligence
514(2)
Business Intelligence Architecture
516(4)
Decision Support Data
520(5)
Operational Data vs. Decision Support Data
520(3)
Decision Support Database Requirements
523(2)
The Data Warehouse
525(5)
Decision Support Architectural Styles
528(1)
Twelve Rules that Define a Data Warehouse
528(2)
Online Analytical Processing
530(11)
Multidimensional Data Analysis Techniques
530(1)
Advanced Database Support
531(1)
Easy-to-Use End-User Interface
532(1)
Client/Server Architecture
532(1)
OLAP Architecture
533(4)
Relational OLAP
537(2)
Multidimensional OLAP
539(1)
Relational vs. Multidimensional OLAP
540(1)
Star Schemas
541(10)
Facts
541(1)
Dimensions
542(1)
Attributes
542(2)
Attribute Hierarchies
544(2)
Star Schema Representation
546(2)
Performance-Improving Techniques for the Star Schema
548(3)
Implementing a Data Warehouse
551(2)
The Data Warehouse as an Active Decision Support Framework
551(1)
A Company-Wide Effort That Requires User Involvement
552(1)
Satisfy the Trilogy: Data, Analysis, and Users
552(1)
Apply Database Design Procedures
552(1)
Data Mining
553(3)
SQL Extensions For OLAP
556(15)
The Rollup Extension
557(1)
The Cube Extension
558(1)
Materialized Views
559(5)
Summary
564(1)
Key Terms
565(1)
Review Questions
565(1)
Problems
566(5)
PART V. DATABASES AND THE INTERNET
Business Vignette: Casio Upgrades Customer Web Experience
571(1)
Database Connectivity and Web Technologies
572(34)
Database Connectivity
573(10)
Native SQL Connectivity
573(1)
ODBC, DAO, and RDO
573(4)
OLE-DB
577(3)
ADO.NET
580(2)
Java Database Connectivity (JDBC)
582(1)
Internet Databases
583(7)
Web-to-Database Middleware: Server-Side Extensions
584(2)
Web Server Interfaces
586(1)
The Web Browser
587(2)
Client-Side Extensions
589(1)
Web Application Servers
589(1)
Extensible Markup Language (XML)
590(15)
Document Type Definitions (DTD) and XML Schemas
592(4)
XML Presentation
596(2)
XML Applications
598(2)
Summary
600(1)
Key Terms
601(1)
Review Questions
601(1)
Problems
602(3)
PART VI. DATABASE ADMINISTRATION
Business Vignette: Oreck Revises Disaster Recovery Plan After Katrina
605(1)
Database Administration and Security
606(51)
Data as a Corporate Asset
607(1)
The Need for and Role of a Database in an Organization
608(1)
Introduction of a Database: Special Considerations
609(1)
The Evolution of the Database Administration Function
610(3)
The Database Environment's Human Component
613(13)
The DBA's Managerial Role
615(5)
The DBA's Technical Role
620(6)
Security
626(4)
Security Policies
627(1)
Security Vulnerabilities
627(1)
Database Security
628(2)
Database Administration Tools
630(4)
The Data Dictionary
630(2)
Case Tools
632(2)
Developing a Data Administration Strategy
634(2)
The DBA at Work: Using Oracle for Database Administration
636(21)
Oracle Database Administration Tools
636(1)
The Default Login
637(1)
Ensuring an Automatic RDBMS Start
638(1)
Creating Tablespaces and Datafiles
639(2)
Managing the Database Objects:Tables, Views, Triggers, and Procedures
641(1)
Managing Users and Establishing Security
642(2)
Customizing the Database Initialization Parameters
644(1)
Creating a New Database
645(8)
Summary
653(1)
Key Terms
654(1)
Review Questions
654(3)
Glossary 657(21)
Index 678