GG Archives Website - Link to Homepage

Data Management: Databases & Organizations, Fifth Edition

Data Management: Databases & Organizations, Fifth Edition

Richard T. Watson (The Univ. of Georgia)
August 2005, ©2006


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

  1. 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
  2. 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
  3. The Single Entity
    1. The relational model
    2. Getting started
    3. Modeling a single-entity database
    4. Creating a single-table database
  4. The One-to-Many Relationship
    1. Relationships
    2. Creating a database with a l :m relationship
    3. Querying a two-table database
  5. 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
  6. 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
  7. 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
  8. Normalization and Other Data Modeling Methods
    1. Normalization
    2. Other data modeling methods
  9. 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
  10. 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

  1. Data Structure and Storage
    1. Data structures
    2. Data coding stanards
    3. Data storage devces
    4. Data compression
    5. Comparative analysis
  2. 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
  3. 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
  4. Spatial and Temporal Data Management
    1. Introduction
    2. Managing spatial data
    3. Managing temporal data

Organizational Memory Technologies

  1. Organizational Intelligence Technologies
    1. The data warehouse
    2. Exploiting data stores
    3. OLAP
    4. Multidimensional expressions (MDX)
    5. Data mining
  2. 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
  3. SQL and Java
    1. JDBC
    2. Using SQL within Java
  4. XMl: Managing Data Exchange
    1. EDI
    2. SGML
    3. XML
    4. Conclusion

Managing Organizational Memory

  1. Data Integrity
    1. Transaction management
    2. Protecting existence
    3. Maintaining data quality
    4. Ensuring confidentiality
  2. 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
  3. 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

LC control no.: 2005283593
Type of material: Book (Print, Microform, Electronic, etc.)
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-13: 9780471715368 (alk. paper)
ISBN-10: 0471715360 (alk. paper)
Subjects: Database management.
Notes: Includes bibliographical references and index.
LC classification: QA76.9.D3 W375 2006
Dewey class no.: 005.74


Return to Top of Page

Reference Books | GG Archives Library

Reference Book Titles