Fundamentals of Database Management Systems

  • Share this:
Share with a friend
Sign into your email account to send this page to a friend:
Outlook or Apple Mail
or other default program

Save $25 when you open a Walmart® Credit Card and spend $75 today.*

*Offer subject to credit approval
Learn More
or Apply Now

Advertisement
Advertisement

Fundamentals of Database Management Systems

Format:  Hardcover,

395 pages

Publisher: John Wiley & Sons Inc

Publish Date: Dec 2011

ISBN-13: 9780470624708

ISBN-10: 0470624701

Buy from Walmart

Shipping & Pickup
Online
$156.06

In stock for:

  • Store information not available.

 Buy from Marketplace

Shipping & Additional Information

Book Information

The following content was provided by the publisher.
Gillenson's new edition of "Fundamentals of Database Management Systems" provides concise coverage of the fundamental topics necessary for a deep understanding of the basics. In this issue, there is more emphasis on a practical approach, with new "your turn" boxes and much more coverage in a separate supplement on how to implement databases with Access.

In every chapter, the author covers concepts first, then show how they're implemented in continuing case(s.) "Your Turn" boxes appear several times throughout the chapter to apply concepts to projects. And "Concepts in Action" boxes contain examples of concepts used in practice. This pedagogy is easily demonstrable and the text also includes more hands-on exercises and projects and a standard diagramming style for the data modeling diagrams. Furthermore, revised and updated content and organization includes more coverage on database control issues, earlier coverage of SQL, and new coverage on data quality issues.

Specifications

Publisher: John Wiley & Sons Inc
Publish Date: Dec 2011
ISBN-13: 9780470624708
ISBN-10: 0470624701
Format: Hardcover
Number of Pages: 395
Shipping Weight (in pounds): 2.0
Product in Inches (L x W x H): 8.0 x 9.75 x 0.75
Walmart No.: 9780470624708

Chapter outline

Preface
About the Author
Data: The New Corporate Resource
Introduction
The History of Data
The Origins of Data
Data Through the Ages
Early Data Problems Spawn Calculating Devices
Swamped with Data
Modern Data Storage Media
Data in Today's Information Systems Environment
Using Data for Competitive Advantage
Problems in Storing and Accessing Data
Data as a Corporate Resource
The Database Environment
Summary
Data Modeling
Introduction
Binary Relationships
What is a Binary Relationship?
Cardinality
Modality
More About Many-to-Many Relationships
Unary Relationships
One-to-One Unary Relationship
One-to-Many Unary Relationship
Many-to-Many Unary Relationship
Ternary Relationships
Example: The General Hardware Company
Example: Good Reading Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Summary
The Database Management System Concept
Introduction
Data Before Database Management
Records and Files
Basic Concepts in Storing and Retrieving Data
The Database Concept
Data as a Manageable Resource
Data Integration and Data Redundancy
Multiple Relationships
Data Control Issues
Data Independence
DBMS Approaches
Summary
Relational Data Retrieval: Sql
Introduction
Data Retrieval with the SQL SELECT Command
Introduction to the SQL SELECT Command
Basic Functions
Built-In Functions
Grouping Rows
The Join
Subqueries
A Strategy for Writing SQL SELECT Commands
Example: Good Reading Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Relational Query Optimizer
Relational DBMS Performance
Relational Query Optimizer Concepts
Summary
The Relational Database Model:
Introduction
Introduction
The Relational Database Concept
Relational Terminology
Primary and Candidate Keys
Foreign Keys and Binary Relationships
Data Retrieval from a Relational Database
Extracting Data from a Relation
The Relational Select Operator
The Relational Project Operator
Combination of the Relational Select and Project Operators
Extracting Data Across Multiple Relations: Data Integration
Example: Good Reading Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Summary
The Relational Database Model: Additional Concepts
Introduction
Relational Structures for Unary and Ternary Relationships
Unary One-to-Many Relationships
Unary Many-to-Many Relationships
Ternary Relationships
Referential Integrity
The Referential Integrity Concept
Three Delete Rules
Summary
Logical Database Design
Introduction
Converting E-R Diagrams into Relational Tables
Introduction
Converting a Simple Entity
Converting Entities in Binary Relationships
Converting Entities in Unary Relationships
Converting Entities in Ternary Relationships
Designing the General Hardware Co. Database
Designing the Good Reading Bookstores Database
Designing the World Music Association Database
Designing the Lucky Rent-A-Car Database
The Data Normalization Process
Introduction to the Data Normalization Technique
Steps in the Data Normalization Process
Example: General Hardware Co
Example: Good Reading Bookstores
Example: World Music Association
Example: Lucky Rent-A-Car
Testing Tables Converted from E-R Diagrams with Data Normalization
Building the Data Structure with SQL
Manipulating the Data with SQL
Summary
Physical Database Design
Introduction
Disk Storage
The Need for Disk Storage
How Disk Storage Works
File Organizations and Access Methods
The Goal: Locating a Record
The Index
Hashed Files
Inputs to Physical Database Design
The Tables Produced by the Logical Database Design Process
Business Environment Requirements
Data Characteristics
Application Characteristics
Operational Requirements: Data Security, Backup, and Recovery
Physical Database Design Techniques
Adding External Features
Reorganizing Stored Data
Splitting a Table into Multiple Tables
Changing Attributes in a Table
Adding Attributes to a Table
Combining Tables
Adding New Tables
Example: Good Reading Book Stores
Example: World Music Association
Example: Lucky Rent-A-Car
Summary
Object-Oriented Database Management
Introduction
Terminology
Complex Relationships
Generalization
Inheritance of Attributes
Operations, Inheritance of Operations, and Polymorphism
Aggregation
The General Hardware Co. Class Diagram
The Good Reading Bookstores Class Diagram
The World Music Association Class Diagram
The Lucky Rent-A-Vehicle Class Diagram
Encapsulation
Abstract Data Types
Object/Relational Database
Summary
Data Administration, Database Administration, And Data Dictionaries
Introduction
The Advantages of Data and Database Administration
Data as a Shared Corporate Resource
Efficiency in Job Specialization
Operational Management of Data
Managing Externally Acquired Databases
Managing Data in the Decentralized Environment
The Responsibilities of Data Administration
Data Coordination
Data Planning
Data Standards
Liaison to Systems Analysts and Programmers
Training
Arbitration of Disputes and Usage Authorization
Documentation and Publicity
Data's Competitive Advantage
The Responsibilities of Database Administration
DBMS Performance Monitoring
DBMS Troubleshooting
DBMS Usage and Security Monitoring
Data Dictionary Operations
DBMS Data and Software Maintenance
Database Design
Data Dictionaries
Introduction
A Simple Example of Metadata
Passive and Active Data Dictionaries
Relational DBMS Catalogs
Data Repositories
Summary
Database Control Issues: Security, Backup And Recovery, Concurrency
Introduction
Data Security
The Importance of Data Security
Types of Data Security Breaches
Methods of Breaching Data Security
Types of Data Security Measures
Backup and Recovery
The Importance of Backup and Recovery
Backup Copies and Journals
Forward Recovery
Backward Recovery
Duplicate or ''Mirrored'' Databases
Disaster Recovery
Concurrency Control
The Importance of Concurrency Control
The Lost Update Problem
Locks and Deadlock
Versioning
Summary
Client/Server Database And Distributed Database
Introduction
Client/Server Databases
Distributed Database
The Distributed Database Concept
Concurrency Control in Distributed Databases
Distributed Joins
Partitioning or Fragmentation
Distributed Directory Management
Distributed DBMSs: Advantages and Disadvantages
Summary
The Data Warehouse
Introduction
The Data Warehouse Concept
The Data is Subject Oriented
The Data is Integrated
The Data is Non-Volatile
The Data is Time Variant
The Data Must Be High Quality
The Data May Be Aggregated
The Data is Often Denormalized
The Data is Not Necessarily Absolutely Current
Types of Data Warehouses
The Enterprise Data Warehouse (EDW)
The Data Mart (DM)
Which to Choose: The EDW, the DM, or Both?
Designing a Data Warehouse
Introduction
General Hardware Co. Data Warehouse
Good Reading Bookstores Data Warehouse
Lucky Rent-A-Car Data Warehouse
What About a World Music Association Data Warehouse?
Building a Data Warehouse
Introduction
Data Extraction
Data Cleaning
Data Transformation
Data Loading
Using a Data Warehouse
On-Line Analytic Processing
Data Mining
Administering a Data Warehouse
Challenges in Data Warehousing
Summary
Databases And The Internet
Introduction
Database Connectivity Issues
Expanded Set of Data Types
Database Control Issues
Performance
Availability
Scalability
Security and Privacy
Data Extraction into XML
Summary
Index

Book description

Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics necessary for a deep understanding of the basics. In this issue, there is more emphasis on a practical approach, with new "your turn" boxes and much more coverage in a separate supplement on how to implement databases with Access.

In every chapter, the author covers concepts first, then show how they're implemented in continuing case(s.) "Your Turn" boxes appear several times throughout the chapter to apply concepts to projects.

And "Concepts in Action" boxes contain examples of concepts used in practice. This pedagogy is easily demonstrable and the text also includes more hands-on exercises and projects and a standard diagramming style for the data modeling diagrams. Furthermore, revised and updated content and organization includes more coverage on database control issues, earlier coverage of SQL, and new coverage on data quality issues.

Customer Product Reviews

 

Gifting Plans

Financing Offers

Enjoy Great Financing!

Make the most of your shopping experience with the Walmart Discover® or Walmart Credit Card.

Save $25 when you open a Walmart® Credit Card and spend $75 today.*

*Offer subject to credit approval

Learn More or Apply Now

No Payments + No Interest if Paid in Full in 6 Months!
Enjoy no payments for 6 months. You'll have 6 months with no payments, and no interest if paid in full within 6 months on orders over $250. Otherwise, interest will be charged from the original date of purchase. Bill Me Later is the quick, easy, secure way to buy online without using your credit card. Simply select Bill Me Later at checkout. Subject to credit approval.

See Terms