Database Design, Query Formulation, and Administration

Using Oracle and PostgreSQL
Ninth Auflage
ISBN: 979-8-3488-5764-6
Verlag: SAGE Publications

Buch, Englisch, 936 Seiten, Format (B × H): 216 mm x 279 mm

Author Michael Mannino equips students with the necessary tools to grasp the fundamental concepts of database management and guides them in honing their skills to solve both basic and advanced problems.

Autoren/Hrsg.

Mannino, Michael

Inhaltsverzeichnis

Preface
Part 1: Introduction to Database Environments
Chapter 1: Introduction to Database Management
Learning Objectives
Overview
1.1 Database Characteristics
1.2 Features of Database Management Systems
1.3 Development of Database Technology and Market Structure
1.4 Architectures of Database Management Systems
1.5 Organizational Impacts of Database Technology
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Chapter 2: Introduction to Database Development
Learning Objectives
Overview
2.1 Information Systems
2.2 Goals of Database Development
2.3 Database Development Process
2.4 Tools for Database Development
Review Concepts
Questions
Problems
References for Further Study
Part 2: Defining and Using SQL Databases
Chapter 3: The Relational Data Model in the SQL Standard
Learning Objectives
Overview
3.1 Basic Elements
3.2 Integrity Rules
3.3 Operators of Relational Algebra
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 3.A: CREATE TABLE Statements for the University Database Tables
Appendix 3.B: SQL Syntax Summary
Appendix 3.C: Generation of Unique Values for Primary Keys
Chapter 4: Basic Query Formulation with SQL
Learning Objectives
Overview
4.1 Background
4.2 Simplified Syntax and University Database
4.3 SELECT Statement Examples for Single Table Problems
4.4 SELECT Statement Examples for Joins, Grouping, and Ordering
4.5 Conceptual Evaluation Process for SELECT Statements
4.6 Traditional Set Operators and Modification Statements
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 4.A: SQL Syntax Summary
Appendix 4.B: Syntax Differences among Major DBMS Products
Appendix 4.C: NL2SQL for Chapter 4 Examples
Chapter 5: Intermediate Query Formulation with SQL
Learning Objectives
Overview
5.1 Problem Solving Guidelines for Query Formulation
5.2 Join Examples for Typical Join Patterns
5.3 Atypical Join Patterns
5.4 Errors, Coding Practices, and Refinements to the Query Formulation Process
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 5.A: SQL Syntax Summary
Appendix 5.B: University Database Tables
Appendix 5.C: Oracle Syntax Errors on Self-Join Problems
Appendix 5.D: NL2SQL for Chapter 5 Examples
Part 3: Data Modeling
Chapter 6: Understanding Entity Relationship Diagrams
Learning Objectives
Overview
6.1 Introduction to Entity Relationship Diagrams
6.2 Understanding Relationships
6.3 Classification in the Entity Relationship Model
6.4 Notation Summary and Diagram Rules
6.5 Comparison to Other Notations
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Chapter 7: Developing Data Models for Business Databases
Learning Objectives
Overview
7.1 Analyzing Business Data Modeling Problems
7.2 Refinements to an ERD
7.3 Finalizing an ERD
7.4 Converting an ERD to a Table Design
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Part 4: SQL Database Design
Chapter 8: Normalization Concepts and Processes
Learning Objectives
Overview
8.1 Overview of Relational Database Design
8.2 Basic Normal Forms
8.3 Refining M-Way Relationships
8.4 Higher Level Normal Forms
8.5 Practical Concerns about Normalization
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Chapter 9: Physical Database Design
Learning Objectives
Overview
9.1 Overview of Physical Database Design
9.2 Inputs of Physical Database Design
9.3 File Structures
9.4 Query Optimization
9.5 Index Selection
9.6 Additional Choices in Physical Database Design
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Part 5: Advanced Query Formulation
Chapter 10: Advanced Matching Problems with SQL
Learning Objectives
Overview
10.1 Outer Join Problems
10.2 Nested Queries
10.3 Membership Exceptions based on the Difference Operator
10.4 Containment Exceptions Based on the Division Operator
10.5 Summary and Common Table Expressions
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 10.A: SQL Syntax Summary
Appendix 10.B: NL2SQL for Chapter 10 Examples
Chapter 11: Derived Tables, Null Values, and Hierarchical Queries
Learning Objectives
Overview
11.1 Background for Views
11.2 Using Views for Retrieval and Update
11.3 Materialized Views
11.4 Null Value Considerations
11.5 Hierarchical Queries
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 11.A: SQL Syntax Summary
Appendix 11.B: SQL Statements for the Employee2 Table
Appendix 11.C: Null-Aware Query Practices
Appendix 11.D: NL2SQL for Chapter 11 Examples
Chapter 12: Stored Procedures and Triggers
Learning Objectives
Overview
12.1 Database Programming Languages and PL/SQL
12.2 Stored Procedures
12.3 Triggers
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 12.A: SQL Syntax Summary
Appendix 12.B: PostgreSQL Triggers and Trigger Functions
Appendix 12.C: NL2SQL for Chapter 12 Trigger Examples
Part 6: Data Warehouse Processing
Chapter 13: Data Warehouse Concepts and Management
Overview
13.1 Basic Concepts
13.2 Management of Data Warehouse Development
13.2 Management of Data Warehouse Development
13.3 Data Warehouse Examples
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Chapter 14: Conceptual Design of Data Warehouses
Learning Objectives
Overview
14.1 Multidimensional Representation of Data
14.2 SQL Data Modeling Patterns for Data Warehouses
14.3 Summarizability Problems and Patterns
14.4 Schema Integration and Design Methodologies
Closing Thoughts
Review Concepts
Questions
Problems
Practice Mini Case Study for Schema Integration
References for Further Study
Appendix 14.A: Details of the Schema Integration Problem
Appendix 14.B: Solution for the Schema Integration Problem
Chapter 15: Data Integration Concepts, Practices, and Emerging Alternatives
Learning Objectives
Overview
15.1 Data Integration Concepts
15.2 Data Cleaning Techniques
15.3 Data Integration Tools
15.4 Data Integration for Data Lakes
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 15.A: CREATE TABLE Statements for Section 15.3.5
Appendix 15.B: CREATE TABLE Statements for Chapter Problems
Chapter 16: Query Formulation for Data Warehouses and Data Lakes
Learning Objectives
Overview
16.1 SQL Extensions for Subtotal Operators
16.2 SQL Extensions for Analytic Functions
16.3 Query Formulation to Generate Data Mining Input
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 16.A: Data Warehouse Examples for Section 16.3
Appendix 16.B: NL2SQL for Chapter 16 Examples
Part 7 Managing Database Environments
Chapter 17: Data and Database Administration
Learning Objectives
Overview
17.1 Organizational Context for Managing Databases
17.2 Tools of Database Administration
17.3 Processes for Database Specialists
17.4 Managing Database Environments
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 17.A: SQL Syntax Summary
Chapter 18: Transaction Management
Learning Objectives
Overview
18.1 Basics of Database Transactions
18.2 Concurrency Control
18.3 Recovery Management
18.4 Transaction Design Issues and Examples
18.5 Tools for Transaction Design
18.6 Workflow Management
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 18.A: SQL Syntax Summary
Chapter 19: Distributed Processing, Parallel Database Processing, and Distributed Databases
Learning Objectives
Overview
19.1 Overview of Distributed Processing and Distributed Data
19.2 Database Architectures for Distributed Processing
19.3 Parallel Database Processing
19.4 Architectures for Distributed Database Management Systems
19.5 Transparency for Distributed Database Processing
19.6 Distributed Database Processing
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Chapter 20: DBMS Extensions for Object-Relational and NoSQL Databases
Learning Objectives
Overview
20.1 Motivation for Object Database Management
20.2 Object-Relational Features in the SQL Standard
20.3 Object-Relational Features in Oracle
20.4 Overview of NoSQL Database Management
20.5 Database Definition and Manipulation with Couchbase N1QL
Closing Thoughts
Review Concepts
Questions
Problems
References for Further Study
Appendix 20.A: INSERT Statements for N1QL
Appendix 20.B: Object-Relational Features in PostgreSQL
Glossary of Terms
Bibliography

Über Autor(innen)

Mannino, Michael
Michael V. Mannino has been involved with database technology since 1978, when he began graduate studies at the University of Arizona. He has taught database management since 1983 at several major universities (University of Florida, University of Texas at Austin, University of Washington, and University of Colorado Denver). His audiences included undergraduate information technology students, graduate information technology students, MBA students, and doctoral students, as well as hundreds of thousands of Coursera learners. He has also been active in database research with publications in major journals of the IEEE (Transactions on Knowledge and Data Engineering and Transactions on Software Engineering), ACM (Communications, Journal of Data and Information Quality, Transactions on Management Information Systems, and Computing Surveys), and INFORMS (INFORMS Journal on Computing and Information Systems Research). His research includes several popular survey and tutorial articles as well as many papers presenting original research. Practical results of his research have been incorporated into Chapter 13 on management of data warehouse development, especially the design and implementation of the educational game, Emerge2Maturity, for providing insights about data warehouse maturity in organizations.