Data Management: Databases & Organizations, Fifth Edition

Front Cover, Data Management: Databases & Organizations, Fifth Edition by Richard T. Watson

Front Cover, Data Management: Databases & Organizations, Fifth Edition by Richard T. Watson (The Univ. of Georgia), August 2005, ©2006, 978-0-471-71536-8. GGA Image ID # 1720467faf

From the Back Cover

Data modeling and SQL -- these are the data management skills that are in demand in today's job market. That's why Richard Watson's Fifth Edition of Data Management: Databases and Organizations offers in-depth, fully integrated coverage of data modeling and SQL, and a broad managerial perspective.

Updated with the latest developments in the field, the Fifth Edition will help you design and create relational databases, formulate complex SQL queries, understand OLAP, use SQL with Java, learn how to use XML, and prepare yourself for the real world of data managment.

New Features of the Fifth Edition:

  • A new chapter on embeddeed SQL in Java and JDBC
  • A section on multidemensional expressions (MDX)
  • New material on content management systems (CMS) and wiki technology
  • Greater focus on MySQL
  • Increased coverage of mandatory and optional elements in data modeling

Table of Contents

The Managerial Perspective

Managing Data

  1. Individual data management
  2. Organizational data management
  3. Components of organizational memory
  4. Problems with data management systems
  5. A brief history of data management systems
  6. Data, information, and knowledge
  7. The challenge

Information

  1. A historical perspective
  2. A brief history of information systems
  3. Information characteristics
  4. Information and organizational change
  5. Change information
  6. Information and managerial work
  7. Information delivery systems
  8. Knowledge
  9. Data Modeling and SQL

The Single Entity

  1. The relational model
  2. Getting started
  3. Modeling a single-entity database
  4. Creating a single-table database

The One-to-Many Relationship

  1. Relationships
  2. Creating a database with a l :m relationship
  3. Querying a two-table database

The Many-to-Many Relationship

  1. The many-to-many relationship
  2. Creating a relational database with an m:m relationship
  3. Querying an m:m relationship

One-to-One and Recursive Relationships

  1. Modeling a one-to-one relationship
  2. Mapping a one-ta-one relationship
  3. Mapping a one-ta-many recursive relationship
  4. Querying a one-to-one relationship
  5. Querying a recursive relationship
  6. Modeling a one-ta-one recursive relationship
  7. Mapping a one-to-one recursive relationship
  8. Querying a one-to-one recursive relationship
  9. Modeling a many-to-many recursive relationship
  10. Mapping a many-ta-many recursive relationship
  11. Querying a many-to-many recursive relationship

Data Modeling

  1. Modeling
  2. Data modeling
  3. The building blocks
  4. Data model quality
  5. Quality improvement
  6. Meaningful identifiers
  7. The seven habits of highly effective data modelers
  8. Reference: Basic Structures
  9. One entity
  10. Two entities
  11. Another entity's identifier as part of the identifier

Normalization and Other Data Modeling Methods

  1. Normalization
  2. Other data modeling methods

The Relational Model and Relational Algebra

  1. Data structures
  2. Integrity rules
  3. Manipulation languages
  4. A primitive set of relational operators
  5. A fully relational database

SQL

  1. Data definition
  2. Data manipulation
  3. SQL routines
  4. Triggers
  5. Nulls-much ado about missing information
  6. Security
  7. The catalog
  8. Natural language processing
  9. Connectivity and ODBC
  10. Embedded SQL
  11. The future of SQL
  12. Reference: SQL Playbook
  13. The power of SQL

Database Architectures and Implementations

Data Structure and Storage

  1. Data structures
  2. Data coding stanards
  3. Data storage devces
  4. Data compression
  5. Comparative analysis

Data Processing Architectures

  1. Introduction
  2. Client/server fundamentals
  3. Client/server-the second generation
  4. Distributed database
  5. Distributed data access
  6. Distributed database design

Object-Oriented Data Management

  1. UML
  2. Historical Development
  3. Key 00 concepts
  4. Why OO?
  5. Objects and information system modeling
  6. The 00 and relational paradigms
  7. Mapping objects to a relational database
  8. Persistent objects
  9. Object-oriented database management systems
  10. Directions

Spatial and Temporal Data Management

  1. Introduction
  2. Managing spatial data
  3. Managing temporal data

Organizational Memory Technologies

Organizational Intelligence Technologies

  1. The data warehouse
  2. Exploiting data stores
  3. OLAP
  4. Multidimensional expressions (MDX)
  5. Data mining

The Web and Data Management

  1. Information presentation
  2. Web site management
  3. Content management systems
  4. Wiki
  5. Web browser-to-DBMS server connectivity

SQL and Java

  1. JDBC
  2. Using SQL within Java

XMl: Managing Data Exchange

  1. EDI
  2. SGML
  3. XML
  4. Conclusion

Managing Organizational Memory

Data Integrity

  1. Transaction management
  2. Protecting existence
  3. Maintaining data quality
  4. Ensuring confidentiality

Data Administration

  1. Introduction
  2. Management of the database environment
  3. Data administration
  4. Database management systems (DBMSs)
  5. Groupware
  6. Data integration
  7. Organizing data administration

U-Commerce and Data Management

  1. Introduction
  2. U-commerce
  3. A conceptual framework for u-commerce
  4. Implications
  5. Photo Credits
  6. Index

About the Author

Richard T. Watson is currently the J. Rex Fuqua Distinguished Chair for Internet Strategy in the Department of MIS at the University of Georgia's Terry College of Business._ He is also the Director of the Center for Information Systems Leadership._ Watson received his B Sc and Dip Comp from the University of Western Australia, and he received his Ph.D. from the University of Minnesota._ He is a visiting professor at Agder University College(Kristiansand, Norway), and Fudan University (Shanghai, China). Watson has published around 100 refereed articles, written or edited more than 10 books (including a data management textbook).

He has served as a senior editor for MIS Quarterly and was co-conference chair forr ICIS2004. He is currently the President of the Association for Information Systems._ His current research interests are u-commerce, net-based customer service systems, open source, and information systems leadership. He collaborates with researchers in several countries, including Australia, Brazil, Canada, China, France, Germany, Italy, Norway, and Singapore.

Library of Congress Catalog Listing

  • Personal name: Watson, Richard Thomas
  • Main title: Data management : databases and organizations / Richard T. Watson.
  • Edition: 5th ed.
  • Published/Created: Hoboken, NJ : J. Wiley, c2006.
  • Description: xvii, 619 p. : ill. ; 25 cm.
  • ISBN: 9780471715368 (alk. paper); 0471715360 (alk. paper)
  • LC classification: QA76.9.D3 W375 2006
  • LC Subjects: Database management; Databases
  • Notes: Includes bibliographical references and index.
  • LCCN: 2005283593
  • Dewey class no.: 005.74
  • Type of material: Book

 

Return to Top of Page

Reference Library
GG Archives

Support This Site - The Future of Our Past

Reference Book Library

Music

Improve Your Family History Through Illustrations

Make Your Family History More Readable Through Illustrations From the GG Archives