Atjaunināt sīkdatņu piekrišanu

Essentials of Database Management [Mīkstie vāki]

3.38/5 (24 ratings by Goodreads)
, ,
  • Formāts: Paperback / softback, 416 pages, height x width x depth: 100x100x100 mm, weight: 100 g
  • Izdošanas datums: 11-Oct-2013
  • Izdevniecība: Pearson
  • ISBN-10: 0133405680
  • ISBN-13: 9780133405682
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 188,43 €*
  • * Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena
  • Šī grāmata vairs netiek publicēta. Jums tiks paziņota lietotas grāmatas cena.
  • Daudzums:
  • Ielikt grozā
  • Pievienot vēlmju sarakstam
Essentials of Database ManagementPalielināt
  • Formāts: Paperback / softback, 416 pages, height x width x depth: 100x100x100 mm, weight: 100 g
  • Izdošanas datums: 11-Oct-2013
  • Izdevniecība: Pearson
  • ISBN-10: 0133405680
  • ISBN-13: 9780133405682
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9780133405682.html
Keywords:
Readers who want an up-to-date overview of database development and management.
Focusing on the topics that leading database practitioners say are most important, Essentials of Database Management presents a concise overview designed to ensure practical success for database professionals.

Built upon the strong foundation of Modern Database Management, currently in its eleventh edition, the new Essentials of Database Management is ideal for a less-detailed approach. Like its comprehensive counterpart, it guides readers into the future by presenting research that could reveal the “next big thing” in database management. And it features up-to-date coverage in the areas undergoing rapid change due to improved managerial practices, database design tools and methodologies, and database technology.
Preface xix
Part I The Context of Database Management
1(42)
An Overview of Part One
1(1)
Chapter 1 The Database Environment and Development Process
2(41)
Learning Objectives
2(1)
Introduction
2(2)
Basic Concepts and Definitions
4(3)
Data
4(1)
Data Versus Information
5(1)
Metadata
6(1)
Traditional File Processing Systems
7(1)
Disadvantages of File Processing Systems
7(1)
Program-Data Dependence
7(1)
Duplication of Data
8(1)
Limited Data Sharing
8(1)
Lengthy Development Times
8(1)
Excessive Program Maintenance
8(1)
The Database Approach
8(14)
Data Models
8(1)
Entities
8(1)
Relationships
9(1)
Relational Databases
10(1)
Database Management Systems
10(1)
Advantages of the Database Approach
11(1)
Program-Data Independence
11(1)
Planned Data Redundancy
11(1)
Improved Data Consistency
11(1)
Improved Data Sharing
11(1)
Increased Productivity of Application Development
12(1)
Enforcement of Standards
12(1)
Improved Data Quality
12(1)
Improved Data Accessibility and Responsiveness
13(1)
Reduced Program Maintenance
13(1)
Improved Decision Support
13(1)
Cautions About Database Benefits
13(1)
Costs and Risks of the Database Approach
13(1)
New, Specialized Personnel
14(1)
Installation and Management Cost and Complexity
14(1)
Conversion Costs
14(1)
Need for Explicit Backup and Recovery
14(1)
Organizational Conflict
14(1)
Components of the Database Environment
14(2)
The Database Development Process
16(1)
Systems Development Life Cycle
17(1)
Planning---Enterprise Modeling
18(1)
Planning---Conceptual Data Modeling
18(1)
Analysis---Conceptual Data Modeling
18(1)
Design---Logical Database Design
18(1)
Design---Physical Database Design and Definition
19(1)
Implementation---Database Implementation
19(1)
Maintenance---Database Maintenance
19(1)
Alternative Information Systems (IS) Development Approaches
20(1)
Three-Schema Architecture for Database Development
21(1)
Evolution of Database Systems
22(2)
The Range of Database Applications
24(4)
Personal Databases
25(1)
Two-Tier Client/Server Databases
25(1)
Multitier Client/Server Databases
26(1)
Enterprise Applications
26(2)
Developing a Database Application for Pine Valley Furniture Company
28(15)
Database Evolution at Pine Valley Furniture Company
29(1)
Project Planning
30(1)
Analyzing Database Requirements
30(2)
Designing the Database
32(3)
Using the Database
35(1)
Administering the Database
36(1)
Future of Databases at Pine Valley
36(1)
Summary
37(1)
Key Terms
38(1)
Review Questions
38(1)
Problems and Exercises
39(1)
References
40(1)
Further Reading
40(1)
Web Resources
41(2)
Part II Database Analysis
43(76)
An Overview of Part Two
43(2)
Chapter 2 Modeling Data in the Organization
45(48)
Learning Objectives
45(1)
Introduction
45(2)
The E-R Model: An Overview
47(3)
Sample E-R Diagram
47(2)
E-R Model Notation
49(1)
Modeling the Rules of the Organization
50(3)
Data Names and Definitions
50(1)
Data Names
51(1)
Data Definitions
51(1)
Good Data Definitions
51(2)
Modeling Entities and Attributes
53(9)
Entities
53(1)
Entity Type Versus Entity Instance
53(1)
Entity Type Versus System Input, Output, or User
54(1)
Strong Versus Weak Entity Types
55(1)
Naming and Defining Entity Types
55(2)
Attributes
57(1)
Required Versus Optional Attributes
57(1)
Simple Versus Composite Attributes
58(1)
Single-Valued Versus Multivalued Attributes
59(1)
Stored Versus Derived Attributes
59(1)
Identifier Attribute
59(2)
Naming and Defining Attributes
61(1)
Modeling Relationships
62(16)
Basic Concepts and Definitions in Relationships
63(1)
Attributes on Relationships
63(2)
Associative Entities
65(1)
Degree of a Relationship
66(1)
Unary Relationship
67(1)
Binary Relationship
67(1)
Ternary Relationship
68(1)
Attributes or Entity?
69(2)
Cardinality Constraints
71(1)
Minimum Cardinality
71(1)
Maximum Cardinality
72(1)
Some Examples of Relationships and Their Cardinalities
72(1)
A Ternary Relationship
73(1)
Modeling Time-Dependent Data
74(1)
Modeling Multiple Relationships Between Entity Types
75(1)
Naming and Defining Relationships
76(2)
E-R Modeling Example: Pine Valley Furniture Company
78(2)
Database Processing at Pine Valley Furniture
80(13)
Showing Product Information
81(1)
Showing Product Line Information
81(1)
Showing Customer Order Status
82(1)
Summary
83(1)
Key Terms
84(1)
Review Questions
84(1)
Problems and Exercises
85(7)
References
92(1)
Further Reading
92(1)
Web Resources
92(1)
Chapter 3 The Enhanced E-R Model
93(26)
Learning Objectives
93(1)
Introduction
93(1)
Representing Supertypes and Subtypes
94(6)
Basic Concepts and Notation
94(1)
An Example of a Supertype/Subtype Relationship
95(1)
Attribute Inheritance
96(1)
When to Use Supertype/Subtype Relationships
97(1)
Representing Specialization and Generalization
97(1)
Generalization
98(1)
Specialization
99(1)
Combining Specialization and Generalization
100(1)
Specifying Constraints in Supertype/Subtype Relationships
100(6)
Specifying Completeness Constraints
101(1)
Total Specialization Rule
101(1)
Partial Specialization Rule
101(1)
Specifying Disjointness Constraints
101(1)
Disjoint Rule
102(1)
Overlap Rule
102(1)
Defining Subtype Discriminators
102(1)
Disjoint Subtypes
103(1)
Overlapping Subtypes
103(2)
Defining Supertype/Subtype Hierarchies
105(1)
An Example of a Supertype/Subtype Hierarchy
105(1)
Summary of Supertype/Subtype Hierarchies
106(1)
EER Modeling Example: Pine Valley Furniture Company
106(4)
Packaged Data Models
110(9)
A Revised Data Modeling Process with Packaged Data Models
110(2)
Summary of Prepackaged Data Models
112(1)
Summary
112(1)
Key Terms
113(1)
Review Questions
113(1)
Problems and Exercises
114(2)
References
116(1)
Further Reading
117(1)
Web Resources
117(2)
Part III Database Design
119(70)
An Overview of Part Three
119(2)
Chapter 4 Logical Database Design and the Relational Model
121(45)
Learning Objectives
121(1)
Introduction
121(1)
The Relational Data Model
122(4)
Basic Definitions
122(1)
Relational Data Structure
123(1)
Relational Keys
123(1)
Properties of Relations
124(1)
Removing Multivalued Attributes from Tables
124(1)
Sample Database
124(2)
Integrity Constraints
126(5)
Domain Constraints
126(1)
Entity Integrity
126(2)
Referential Integrity
128(1)
Creating Relational Tables
129(1)
Well-Structured Relations
130(1)
Transforming EER Diagrams into Relations
131(13)
Step 1 Map Regular Entities
132(1)
Composite Attributes
132(1)
Multivalued Attributes
133(1)
Step 2 Map Weak Entities
133(1)
When to Create a Surrogate Key
134(1)
Step 3 Map Binary Relationships
135(1)
Map Binary One-to-Many Relationships
135(1)
Map Binary Many-to-Many Relationships
135(1)
Map Binary One-to-One Relationships
136(1)
Step 4 Map Associative Entities
137(1)
Identifier Not Assigned
137(1)
Identifier Assigned
138(1)
Step 5 Map Unary Relationships
139(1)
Unary One-to-Many Relationships
139(1)
Unary Many-to-Many Relationships
139(2)
Step 6 Map Ternary (and n-ary) Relationships
141(1)
Step 7 Map Supertype/Subtype Relationships
141(2)
Summary of EER-to-Relational Transformations
143(1)
Introduction to Normalization
144(4)
Steps in Normalization
145(1)
Functional Dependencies and Keys
146(1)
Determinants
146(1)
Candidate Keys
146(2)
Normalization Example: Pine Valley Furniture Company
148(5)
Step 0 Represent the View in Tabular Form
148(1)
Step 1 Convert to First Normal Form
149(1)
Remove Repeating Groups
149(1)
Select the Primary Key
149(1)
Anomalies in 1NF
150(1)
Step 2 Convert to Second Normal Form
150(1)
Step 3 Convert to Third Normal Form
151(1)
Removing Transitive Dependencies
152(1)
Determinants and Normalization
152(1)
Merging Relations
153(13)
An Example
154(1)
View Integration Problems
154(1)
Synonyms
154(1)
Homonyms
155(1)
Transitive Dependencies
155(1)
Supertype/Subtype Relationships
156(1)
Summary
156(1)
Key Terms
157(1)
Review Questions
157(1)
Problems and Exercises
158(7)
References
165(1)
Further Reading
165(1)
Web Resources
165(1)
Chapter 5 Physical Database Design and Performance
166(23)
Learning Objectives
166(1)
Introduction
166(1)
The Physical Database Design Process
167(2)
Physical Database Design As a Basis for Regulatory Compliance
168(1)
Designing Fields
169(2)
Choosing Data Types
169(1)
Coding Techniques
170(1)
Handling Missing Data
171(1)
Denormalizing Data
171(4)
Denormalization
172(1)
Opportunities For and Types of Denormalization
172(2)
Denormalize With Gaution
174(1)
Designing Physical Database Files
175(7)
File Organizations
176(2)
Sequential File Organizations
178(1)
Indexed File Organizations
179(1)
Hashed File Organizations
180(2)
Designing Controls for Files
182(1)
Using and Selecting Indexes
182(2)
Creating a Unique Key Index
182(1)
Creating a Secondary (Nonunique) Key Index
183(1)
When to Use Indexes
183(1)
Designing a Database for Optimal Query Performance
184(5)
Summary
185(1)
Key Terms
185(1)
Review Questions
186(1)
Problems and Exercises
186(2)
References
188(1)
Further Reading
188(1)
Web Resources
188(1)
Part IV Implementation
189(164)
An Overview of Part Four
189(2)
Chapter 6 Introduction to SQL
191(41)
Learning Objectives
191(1)
Introduction
191(1)
Origins of the SQL Standard
192(2)
The SQL Environment
194(5)
Defining a Database in SQL
199(4)
Generating SQL Database Definitions
199(1)
Creating Tables
200(2)
Creating Data Integrity Controls
202(1)
Changing Table Definitions
202(1)
Removing Tables
203(1)
Inserting, Updating, and Deleting Data
203(2)
Deleting Database Contents
205(1)
Updating Database Contents
205(1)
Internal Schema Definition in RDBMSs
205(2)
Creating Indexes
206(1)
Processing Single Tables
207(25)
Clauses of the SELECT Statement
207(2)
Using Expressions
209(1)
Using Functions
210(3)
Using Wildcards
213(1)
Using Comparison Operators
213(1)
Using Null Values
214(1)
Using Boolean Operators
214(2)
Using Ranges for Qualification
216(1)
Using Distinct Values
217(2)
Using IN and NOT IN with Lists
219(1)
Sorting Results: The ORDER BY Clause
219(1)
Categorizing Results: The GROUP BY Clause
220(1)
Qualifying Results by Categories: The HAVING Clause
221(2)
Using and Defining Views
223(2)
Summary
225(1)
Key Terms
226(1)
Review Questions
226(1)
Problems and Exercises
227(3)
References
230(1)
Further Reading
230(1)
Web Resources
231(1)
Chapter 7 Advanced SQL
232(36)
Learning Objectives
232(1)
Introduction
232(1)
Processing Multiple Tables
233(17)
Equi-Join
234(1)
Natural Join
235(1)
Outer Join
236(2)
Sample Join Involving Four Tables
238(1)
Self-Join
239(2)
Subqueries
241(5)
Correlated Subqueries
246(1)
Using Derived Tables
247(1)
Combining Queries
248(2)
Tips for Developing Queries
250(3)
Guidelines for Better Query Design
252(1)
Ensuring Transaction Integrity
253(2)
Data Dictionary Facilities
255(1)
Triggers and Routines
256(5)
Triggers
256(2)
Routines
258(1)
Example Routine in Oracle's PL/SQL
259(2)
Embedded SQL and Dynamic SQL
261(7)
Summary
262(1)
Key Terms
263(1)
Review Questions
263(1)
Problems and Exercises
264(3)
References
267(1)
Further Reading
267(1)
Web Resources
267(1)
Chapter 8 Database Application Development
268(32)
Learning Objectives
268(1)
Introduction
268(1)
Client/Server Architectures
269(2)
Databases in a Two-Tier Architecture
271(4)
A VB.NET Example
272(2)
A Java Example
274(1)
Three-Tier Architectures
275(3)
Web Application Components
278(1)
Databases in Three-Tier Applications
278(5)
A JSP Web Application
279(3)
An ASP.NET Example
282(1)
Key Considerations in Three-Tier Applications
283(5)
Stored Procedures
284(1)
Transactions
285(1)
Database Connections
285(1)
Key Benefits of Three-Tier Applications
285(2)
Cloud Computing and Three-Tier Applications
287(1)
Extensible Markup Language (XML)
288(5)
Storing XML Documents
290(1)
Retrieving XML Documents
290(3)
Displaying XML Data
293(1)
XML and Web Services
293(7)
Summary
297(1)
Key Terms
297(1)
Review Questions
298(1)
Problems and Exercises
298(1)
References
299(1)
Further Reading
299(1)
Web Resources
299(1)
Chapter 9 Data Warehousing
300(53)
Learning Objectives
300(1)
Introduction
300(2)
Basic Concepts of Data Warehousing
302(4)
A Brief History of Data Warehousing
303(1)
The Need for Data Warehousing
303(1)
Need For a Company-Wide View
303(3)
Need to Separate Operational and Informational Systems
306(1)
Data Warehouse Architectures
306(8)
Independent Data Mart Data Warehousing Environment
306(2)
Dependent Data Mart and Operational Data Store Architecture: A Three-Level Approach
308(2)
Logical Data Mart and Real-Time Data Warehouse Architecture
310(2)
Three-Layer Data Architecture
312(1)
Role of the Enterprise Data Model
313(1)
Role of Metadata
313(1)
Some Characteristics of Data Warehouse Data
314(3)
Status Versus Event Data
314(1)
Transient Versus Periodic Data
315(1)
An Example of Transient and Periodic Data
315(1)
Transient Data
315(1)
Periodic Data
316(1)
Other Data Warehouse Changes
317(1)
The Derived Data Layer
317(14)
Characteristics of Derived Data
318(1)
The Star Schema
318(1)
Fact Tables and Dimension Tables
319(1)
Example Star Schema
320(1)
Surrogate Key
321(1)
Grain of the Fact Table
322(1)
Duration of the Database
322(1)
Size of the Fact Table
323(1)
Modeling Date and Time
324(1)
Multiple Fact Tables
324(1)
Hierarchies
325(3)
Slowly Changing Dimensions
328(1)
Determining Dimensions and Facts
329(2)
Big Data and Columnar Databases
331(1)
If You Knew SQL Like I NoSQL
332(1)
The User Interface
333(8)
Role of Metadata
334(1)
SQL OLAP Querying
334(1)
Online Analytical Processing (OLAP) Tools
335(1)
Slicing a Cube
336(1)
Drill-Down
336(1)
Summarizing More than Three Dimensions
337(1)
Data Visualization
338(1)
Business Performance Management and Dashboards
338(1)
Data-Mining Tools
339(1)
Data-Mining Techniques
340(1)
Data-Mining Applications
340(1)
Data Governance and Data Quality
341(12)
Data Governance
341(1)
Managing Data Quality
342(1)
Characteristics of Quality Data
343(1)
Summary
344(1)
Key Terms
345(1)
Review Questions
345(1)
Problems and Exercises
346(4)
References
350(1)
Further Reading
351(1)
Web Resources
351(2)
Glossary of Acronyms 353(2)
Glossary of Terms 355(6)
Index 361