Muutke küpsiste eelistusi

Database Systems Design, Implementation, & Management, Loose-Leaf Version 13th ed. [köitmata]

3.58/5 (459 hinnangut Goodreads-ist)
,
  • Formaat: Loose-leaf, kõrgus x laius x paksus: 274x216x28 mm, kaal: 1633 g, Illustrations
  • Ilmumisaeg: 01-Jan-2018
  • Kirjastus: CENGAGE Learning Custom Publishing
  • ISBN-10: 1337688827
  • ISBN-13: 9781337688826
Teised raamatud teemal:
Database Systems Design, Implementation, & Management, Loose-Leaf Version 13th ed.Suurem pilt
  • Formaat: Loose-leaf, kõrgus x laius x paksus: 274x216x28 mm, kaal: 1633 g, Illustrations
  • Ilmumisaeg: 01-Jan-2018
  • Kirjastus: CENGAGE Learning Custom Publishing
  • ISBN-10: 1337688827
  • ISBN-13: 9781337688826
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781337688826.html
Märksõnad:
Provide a balanced approach to databases as the market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, and MANAGEMENT, 13E emphasizes the knowledge and skills necessary for success and makes databases accessible without overwhelming students. Readers gain a solid foundation in database design and implementation as diagrams, illustrations, and tables clarify in-depth coverage of database design. Students learn how successful database implementation involves designing databases to fit within a larger strategic data environment. Revised coverage of SQL introduces more examples and simpler explanations that focus on areas most important for a database career -- making supplementary SQL materials unnecessary. Additional coverage of Big Data Analytics and NoSQL, including related Hadoop technologies, offers a strong hands-on approach. MindTap now include a digital auto-graded MySQL environment.
Preface xv
Text Features xx
Additional Features xxii
Acknowledgments xxiv
Part 1: Database Concepts 1(66)
Chapter 1 Database Systems
2(32)
1.1 Why Databases?
3(1)
1.2 Data versus Information
4(2)
1.3 Introducing the Database
6(6)
1.3a Role and Advantages of the DBMS
7(2)
1.3b Types of Databases
9(3)
1.4 Why Database Design Is Important
12(3)
1.5 Evolution of File System Data Processing
15(3)
1.5a Manual File Systems
15(1)
1.5b Computerized File Systems
15(3)
1.5c File System Redux: Modern End-User Productivity Tools
18(1)
1.6 Problems with File System Data Processing
18(3)
1.6a Structural and Data Dependence
19(1)
1.6b Data Redundancy
20(1)
1.6c Data Anomalies
21(1)
1.7 Database Systems
21(7)
1.7a The Database System Environment
22(2)
1.7b DBMS Functions
24(3)
1.7c Managing the Database System: A Shift in Focus
27(1)
1.8 Preparing for Your Database Professional Career
28(2)
Summary
30(1)
Key Terms
31(1)
Review Questions
31(1)
Problems
32(2)
Chapter 2 Data Models
34(33)
2.1 Data Modeling and Data Models
35(1)
2.2 The Importance of Data Models
36(1)
2.3 Data Model Basic Building Blocks
36(2)
2.4 Business Rules
38(2)
2.4a Discovering Business Rules
38(1)
2.4b Translating Business Rules into Data Model Components
39(1)
2.4c Naming Conventions
40(1)
2.5 The Evolution of Data Models
40(14)
2.5a Hierarchical and Network Models
40(2)
2.5b The Relational Model
42(2)
2.5c The Entity Relationship Model
44(3)
2.5d The Object-Oriented Model
47(1)
2.5e Object/Relational and XML
48(1)
2.5f Emerging Data Models: Big Data and NoSQL
49(4)
2.5g Data Models: A Summary
53(1)
2.6 Degrees of Data Abstraction
54(7)
2.6a The External Model
57(1)
2.6b The Conceptual Model
58(1)
2.6c The Internal Model
59(1)
2.6d The Physical Model
60(1)
Summary
61(1)
Key Terms
62(1)
Review Questions
62(1)
Problems
63(4)
Part 2: Design Concepts 67(176)
Chapter 3 The Relational Database Model
68(45)
3.1 A Logical View of Data
69(3)
3.1a Tables and Their Characteristics
69(3)
3.2 Keys
72(4)
3.2a Dependencies
72(1)
3.2b Types of Keys
73(3)
3.3 Integrity Rules
76(2)
3.4 Relational Algebra
78(9)
3.4a Formal Definitions and Terminology
78(1)
3.4b Relational Set Operators
79(8)
3.5 The Data Dictionary and the System Catalog
87(2)
3.6 Relationships within the Relational Database
89(8)
3.6a The 1:M Relationship
89(2)
3.6b The 1:1 Relationship
91(2)
3.6c The M:N Relationship
93(4)
3.7 Data Redundancy Revisited
97(2)
3.8 Indexes
99(1)
3.9 Codd's Relational Database Rules
100(2)
Summary
102(1)
Key Terms
103(1)
Review Questions
103(3)
Problems
106(7)
Chapter 4 Entity Relationship (ER) Modeling
113(54)
4.1 The Entity Relationship Model
114(24)
4.1a Entities
114(1)
4.1b Attributes
114(6)
4.1c Relationships
120(1)
4.1d Connectivity and Cardinality
121(1)
4.1e Existence Dependence
122(1)
4.1f Relationship Strength
123(2)
4.1g Weak Entities
125(2)
4.1h Relationship Participation
127(4)
4.1i Relationship Degree
131(2)
4.1j Recursive Relationships
133(3)
4.1k Associative (Composite) Entities
136(2)
4.2 Developing an ER Diagram
138(8)
4.3 Database Design Challenges: Conflicting Goals
146(4)
Summary
150(1)
Key Terms
151(1)
Review Questions
151(3)
Problems
154(5)
Cases
159(8)
Chapter 5 Advanced Data Modeling
167(32)
5.1 The Extended Entity Relationship Model
168(7)
5.1a Entity Supertypes and Subtypes
168(1)
5.1b Specialization Hierarchy
169(1)
5.1c Inheritance
170(2)
5.1d Subtype Discriminator
172(1)
5.1e Disjoint and Overlapping Constraints
172(2)
5.1f Completeness Constraint
174(1)
5.1g Specialization and Generalization
175(1)
5.2 Entity Clustering
175(1)
5.3 Entity Integrity: Selecting Primary Keys
176(4)
5.3a Natural Keys and Primary Keys
177(1)
5.3b Primary Key Guidelines
177(1)
5.3c When to Use Composite Primary Keys
177(2)
5.3d When to Use Surrogate Primary Keys
179(1)
5.4 Design Cases: Learning Flexible Database Design
180(7)
5.4a Design Case 1: Implementing 1:1 Relationships
181(1)
5.4b Design Case 2: Maintaining History of Time-Variant Data
182(3)
5.4c Design Case 3: Fan Traps
185(1)
5.4d Design Case 4: Redundant Relationships
186(1)
Summary
187(1)
Key Terms
187(1)
Review Questions
188(1)
Problems
189(1)
Cases
190(9)
Chapter 6 Normalization of Database Tables
199(44)
6.1 Database Tables and Normalization
200(1)
6.2 The Need for Normalization
200(3)
6.3 The Normalization Process
203(10)
6.3a Conversion to First Normal Form (1NF)
205(4)
6.3b Conversion to Second Normal Form (2NF)
209(2)
6.3c Conversion to Third Normal Form (3NF)
211(2)
6.4 Improving the Design
213(4)
6.5 Surrogate Key Considerations
217(1)
6.6 Higher-Level Normal Forms
218(6)
6.6a The Boyce-Codd Normal Form
219(3)
6.6b Fourth Normal Form (4NF)
222(2)
6.7 Normalization and Database Design
224(3)
6.8 Denormalization
227(3)
6.9 Data-Modeling Checklist
230(2)
Summary
232(1)
Key Terms
233(1)
Review Questions
233(2)
Problems
235(8)
Part 3: Advanced Design and Implementation 243(238)
Chapter 7 Introduction to Structured Query Language (SQL)
244(115)
7.1 Introduction to SQL
245(4)
7.1a Data Types
245(2)
7.1b SQL Queries
247(1)
7.1c The Database Model
248(1)
7.2 Basic SELECT Queries
249(1)
7.3 SELECT Statement Options
250(6)
7.3a Using Column Aliases
251(2)
7.3b Using Computed Columns
253(1)
7.3c Arithmetic Operators: The Rule of Precedence
254(1)
7.3d Date Arithmetic
255(1)
7.3e Listing Unique Values
255(1)
7.4 FROM Clause Options
256(10)
7.4a Natural Join
257(2)
7.4b JOIN USING Syntax
259(1)
7.4c JOIN ON Syntax
260(1)
7.4d Common Attribute Names
261(1)
7.4e Outer Joins
261(3)
7.4f Cross Join
264(1)
7.4g Joining Tables with an Alias
264(1)
7.4h Recursive Joins
265(1)
7.5 ORDER BY Clause Options
266(3)
7.6 WHERE Clause Options
269(12)
7.6a Selecting Rows with Conditional Restrictions
269(2)
7.6b Using Comparison Operators on Character Attributes
271(1)
7.6c Using Comparison Operators on Dates
272(1)
7.6d Logical Operators: AND, OR, and NOT
273(2)
7.6e Old-Style Joins
275(1)
7.6f Special Operators
276(5)
7.7 Aggregate Processing
281(9)
7.7a Aggregate Functions
281(4)
7.7b Grouping Data
285(3)
7.7c HAVING Clause
288(2)
7.8 Subqueries
290(12)
7.8a WHERE Subqueries
292(1)
7.8b IN Subqueries
293(1)
7.8c HAVING Subqueries
294(1)
7.8d Multirow Subquery Operators: ALL and ANY
294(1)
7.8e FROM Subqueries
295(1)
7.8f Attribute List Subqueries
296(2)
7.8g Correlated Subqueries
298(4)
7.9 SQL Functions
302(9)
7.9a Date and Time Functions
302(4)
7.9b Numeric Functions
306(1)
7.9c String Functions
307(2)
7.9d Conversion Functions
309(2)
7.10 Relational Set Operators
311(6)
7.10a UNION
311(2)
7.10b UNION ALL
313(1)
7.10c INTERSECT
314(1)
7.10d EXCEPT (MINUS)
315(1)
7.10e Syntax Alternatives
316(1)
7.11 Crafting SELECT Queries
317(2)
7.11a Know Your Data
317(1)
7.11b Know the Problem
317(1)
7.11c Build One Clause at a Time
318(1)
Summary
319(2)
Key Terms
321(1)
Review Questions
321(2)
Problems
323(36)
Chapter 8 Advanced SQL
359(80)
8.1 Data Definition Commands
360(6)
8.1a Starting Database Model
360(1)
8.1b Creating the Database
361(1)
8.1c The Database Schema
362(1)
8.1d Data Types
362(4)
8.2 Creating Table Structures
366(9)
8.2a CREATE TABLE command
366(4)
8.2b SQL Constraints
370(3)
8.2c Create a Table with a SELECT Statement
373(1)
8.2d SQL Indexes
374(1)
8.3 Altering Table Structures
375(4)
8.3a Changing a Column's Data Type
376(1)
8.3b Changing a Column's Data Characteristics
376(1)
8.3c Adding a Column
377(1)
8.3d Adding Primary Key, Foreign Key, and Check Constraints
377(1)
8.3e Dropping a Column
378(1)
8.3f Deleting a Table from the Database
378(1)
8.4 Data Manipulation Commands
379(8)
8.4a Adding Table Rows
379(2)
8.4b Inserting Table Rows with a SELECT Subquery
381(1)
8.4c Saving Table Changes
382(1)
8.4d Updating Table Rows
383(2)
8.4e Deleting Table Rows
385(1)
8.4f Restoring Table Contents
386(1)
8.5 Virtual Tables: Creating a View
387(4)
8.5a Updatable Views
388(3)
8.6 Sequences
391(5)
8.7 Procedural SQL
396(23)
8.7a Triggers
401(10)
8.7b Stored Procedures
411(5)
8.7c PL/SQL Processing with Cursors
416(2)
8.7d PL/SQL Stored Functions
418(1)
8.8 Embedded SQL
419(4)
Summary
423(2)
Key Terms
425(1)
Review Questions
425(1)
Problems
426(7)
Cases
433(6)
Chapter 9 Database Design
439(42)
9.1 The Information System
440(2)
9.2 The Systems Development Life Cycle
442(3)
9.2a Planning
442(1)
9.2b Analysis
443(1)
9.2c Detailed Systems Design
444(1)
9.2d Implementation
444(1)
9.2e Maintenance
445(1)
9.3 The Database Life Cycle
445(12)
9.3a The Database Initial Study
445(5)
9.3b Database Design
450(1)
9.3c Implementation and Loading
451(3)
9.3d Testing and Evaluation
454(2)
9.3e Operation
456(1)
9.3f Maintenance and Evolution
457(1)
9.4 Conceptual Design
457(10)
9.4a Data Analysis and Requirements
459(2)
9.4b Entity Relationship Modeling and Normalization
461(3)
9.4c Data Model Verification
464(3)
9.4d Distributed Database Design
467(1)
9.5 DBMS Software Selection
467(1)
9.6 Logical Design
468(3)
9.6a Map the Conceptual Model to the Logical Model
468(2)
9.6b Validate the Logical Model Using Normalization
470(1)
9.6c Validate Logical Model Integrity Constraints
470(1)
9.6d Validate the Logical Model against User Requirements
471(1)
9.7 Physical Design
471(2)
9.7a Define Data Storage Organization
472(1)
9.7b Define Integrity and Security Measures
472(1)
9.7c Determine Performance Measures
473(1)
9.8 Database Design Strategies
473(1)
9.9 Centralized versus Decentralized Design
474(3)
Summary
477(1)
Key Terms
477(1)
Review Questions
477(1)
Problems
478(3)
Part 4: Advanced Database Concepts 481(210)
Chapter 10 Transaction Management and Concurrency Control
482(33)
10.1 What Is a Transaction?
483(7)
10.1a Evaluating Transaction Results
484(3)
10.1b Transaction Properties
487(1)
10.1c Transaction Management with SQL
488(1)
10.1d The Transaction Log
489(1)
10.2 Concurrency Control
490(5)
10.2a Lost Updates
490(1)
10.2b Uncommitted Data
491(1)
10.2c Inconsistent Retrievals
492(1)
10.2d The Scheduler
493(2)
10.3 Concurrency Control with Locking Methods
495(7)
10.3a Lock Granularity
496(2)
10.3b Lock Types
498(2)
10.3c Two-Phase Locking to Ensure Serializability
500(1)
10.3d Deadlocks
500(2)
10.4 Concurrency Control with Time Stamping Methods
502(1)
10.4a Wait/Die and Wound/Wait Schemes
502(1)
10.5 Concurrency Control with Optimistic Methods
503(1)
10.6 ANSI Levels of Transaction Isolation
504(2)
10.7 Database Recovery Management
506(4)
10.7a Transaction Recovery
506(4)
Summary
510(1)
Key Terms
511(1)
Review Questions
511(1)
Problems
512(3)
Chapter 11 Database Performance Tuning and Query Optimization
515(38)
11.1 Database Performance-Tuning Concepts
516(6)
11.1a Performance Tuning: Client and Server
517(1)
11.1b DBMS Architecture
518(2)
11.1c Database Query Optimization Modes
520(1)
11.1d Database Statistics
521(1)
11.2 Query Processing
522(4)
11.2a SQL Parsing Phase
523(1)
11.2b SQL Execution Phase
524(1)
11.2c SQL Fetching Phase
525(1)
11.2d Query Processing Bottlenecks
525(1)
11.3 Indexes and Query Optimization
526(2)
11.4 Optimizer Choices
528(3)
11.4a Using Hints to Affect Optimizer Choices
530(1)
11.5 SQL Performance Tuning
531(3)
11.5a Index Selectivity
531(2)
11.5b Conditional Expressions
533(1)
11.6 Query Formulation
534(2)
11.7 DBMS Performance Tuning
536(2)
11.8 Query Optimization Example
538(8)
Summary
546(1)
Key Terms
547(1)
Review Questions
547(1)
Problems
548(5)
Chapter 12 Distributed Database Management Systems
553(36)
12.1 The Evolution of Distributed Database Management Systems
554(2)
12.2 DDBMS Advantages and Disadvantages
556(1)
12.3 Distributed Processing and Distributed Databases
556(3)
12.4 Characteristics of Distributed Database Management Systems
559(1)
12.5 DDBMS Components
560(1)
12.6 Levels of Data and Process Distribution
561(3)
12.6a Single-Site Processing, Single-Site Data
561(1)
12.6b Multiple-Site Processing, Single-Site Data
562(1)
12.6c Multiple-Site Processing, Multiple-Site Data
563(1)
12.7 Distributed Database Transparency Features
564(1)
12.8 Distribution Transparency
565(3)
12.9 Transaction Transparency
568(5)
12.9a Distributed Requests and Distributed Transactions
568(3)
12.9b Distributed Concurrency Control
571(1)
12.9c Two-Phase Commit Protocol
571(2)
12.10 Performance and Failure Transparency
573(2)
12.11 Distributed Database Design
575(6)
12.11a Data Fragmentation
575(3)
12.11b Data Replication
578(2)
12.11c Data Allocation
580(1)
12.12 The CAP Theorem
581(2)
12.13 C.J. Date's 12 Commandments for Distributed Databases
583(1)
Summary
584(1)
Key Terms
585(1)
Review Questions
585(1)
Problems
586(3)
Chapter 13 Business Intelligence and Data Warehouses
589(68)
13.1 The Need for Data Analysis
590(1)
13.2 Business Intelligence
590(11)
13.2a Business Intelligence Architecture
592(4)
13.2b Business Intelligence Benefits
596(1)
13.2c Business Intelligence Evolution
597(3)
13.2d Business Intelligence Technology Trends
600(1)
13.3 Decision Support Data
601(5)
13.3a Operational Data versus Decision Support Data
601(3)
13.3b Decision Support Database Requirements
604(2)
13.4 The Data Warehouse
606(3)
13.4a Data Marts
609(1)
13.4b Twelve Rules That Define a Data Warehouse
609(1)
13.5 Star Schemas
609(11)
13.5a Facts
610(1)
13.5b Dimensions
610(1)
13.5c Attributes
611(2)
13.5d Attribute Hierarchies
613(2)
13.5e Star Schema Representation
615(1)
13.5f Performance-Improving Techniques for the Star Schema
616(4)
13.6 Online Analytical Processing
620(8)
13.6a Multidimensional Data Analysis Techniques
620(2)
13.6b Advanced Database Support
622(1)
13.6c Easy-to-Use End-User Interfaces
622(1)
13.6d OLAP Architecture
622(3)
13.6e Relational OLAP
625(2)
13.6f Multidimensional OLAP
627(1)
13.6g Relational versus Multidimensional OLAP
627(1)
13.7 Data Analytics
628(4)
13.7a Data Mining
629(2)
13.7b Predictive Analytics
631(1)
13.8 SQL Analytic Functions
632(7)
13.8a The ROLLUP Extension
633(1)
13.8b The CUBE Extension
634(2)
13.8c Materialized Views
636(3)
13.9 Data Visualization
639(6)
13.9a The Need for Data Visualization
640(2)
13.9b The Science of Data Visualization
642(2)
13.9c Understanding the Data
644(1)
Summary
645(1)
Key Terms
646(1)
Review Questions
647(1)
Problems
648(9)
Chapter 14 Big Data and NoSQL
657(34)
14.1 Big Data
658(6)
14.1a Volume
660(1)
14.1b Velocity
661(1)
14.1c Variety
662(1)
14.1d Other Characteristics
663(1)
14.2 Hadoop
664(8)
14.2a HDFS
665(2)
14.2b MapReduce
667(2)
14.2c Hadoop Ecosystem
669(3)
14.3 NoSQL
672(8)
14.3a Key-Value Databases
673(1)
14.3b Document Databases
674(1)
14.3c Column-Oriented Databases
675(2)
14.3d Graph Databases
677(2)
14.3e Aggregate Awareness
679(1)
14.4 NewSQL Databases
680(1)
14.5 Working with Document Databases Using MongoDB
680(4)
14.5a Importing Documents in MongoDB
682(1)
14.5b Example of a MongoDB Query Using find()
683(1)
14.6 Working with Graph Databases Using Neo4j
684(4)
14.6a Creating Nodes in Neo4j
685(1)
14.6b Retrieving Node Data with MATCH and WHERE
686(1)
14.6c Retrieving Relationship Data with MATCH and WHERE
686(2)
Summary
688(1)
Key Terms
689(1)
Review Questions
690(1)
Part 5: Databases and the Internet 691(42)
Chapter 15 Database Connectivity and Web Technologies
692(41)
15.1 Database Connectivity
693(11)
15.1a Native SQL Connectivity
694(1)
15.1b ODBC, DAO, and RDO
695(2)
15.1c OLE-DB
697(2)
15.1d ADO.NET
699(4)
15.1e Java Database Connectivity (JDBC)
703(1)
15.2 Database Internet Connectivity
704(11)
15.2a Web-to-Database Middleware: Server-Side Extensions
705(2)
15.2b Web Server Interfaces
707(1)
15.2c The Web Browser
708(1)
15.2d Client-Side Extensions
709(1)
15.2e Web Application Servers
710(1)
15.2f Web Database Development
711(4)
15.3 Extensible Markup Language (XML)
715(7)
15.3a Document Type Definitions (DTD) and XML Schemas
717(2)
15.3b XML Presentation
719(2)
15.3c XML Applications
721(1)
15.4 Cloud Computing Services
722(8)
15.4a Cloud Implementation Types
725(1)
15.4b Characteristics of Cloud Services
725(1)
15.4c Types of Cloud Services
726(1)
15.4d Cloud Services: Advantages and Disadvantages
727(2)
15.4e SQL Data Services
729(1)
Summary
730(1)
Key Terms
731(1)
Review Questions
731(1)
Problems
732(1)
Part 6: Database Administration 733(49)
Chapter 16 Database Administration and Security
734(48)
16.1 Data as a Corporate Asset
735(1)
16.2 The Need for a Database and Its Role in an Organization
736(2)
16.3 Introduction of a Database: Special Considerations
738(1)
16.4 The Evolution of Database Administration
739(4)
16.5 The Database Environment's Human Component
743(14)
16.5a The DBA's Managerial Role
745(5)
16.5b The DBA's Technical Role
750(7)
16.6 Security
757(4)
16.6a Security Policies
758(1)
16.6b Security Vulnerabilities
758(2)
16.6c Database Security
760(1)
16.7 Database Administration Tools
761(6)
16.7a The Data Dictionary
762(2)
16.7b Case Tools
764(3)
16.8 Developing a Data Administration Strategy
767(1)
16.9 The DBA's Role in the Cloud
768(1)
16.10 The DBA at Work: Using Oracle for Database Administration
769(8)
16.10a Oracle Database Administration Tools
770(1)
16.10b Ensuring That the RDBMS Starts Automatically
770(2)
16.10c Creating Tablespaces and Datafiles
772(2)
16.10d Managing Users and Establishing Security
774(2)
16.10e Customizing the Database Initialization Parameters
776(1)
Summary
777(2)
Key Terms
779(1)
Review Questions
779(3)
Glossary 782(11)
Index 793