Data Management: Databases & Organizations, Fifth Edition
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
- Individual data management
- Organizational data management
- Components of organizational memory
- Problems with data management systems
- A brief history of data management systems
- Data, information, and knowledge
- The challenge
Information
- A historical perspective
- A brief history of information systems
- Information characteristics
- Information and organizational change
- Change information
- Information and managerial work
- Information delivery systems
- Knowledge
- Data Modeling and SQL
The Single Entity
- The relational model
- Getting started
- Modeling a single-entity database
- Creating a single-table database
The One-to-Many Relationship
- Relationships
- Creating a database with a l :m relationship
- Querying a two-table database
The Many-to-Many Relationship
- The many-to-many relationship
- Creating a relational database with an m:m relationship
- Querying an m:m relationship
One-to-One and Recursive Relationships
- Modeling a one-to-one relationship
- Mapping a one-ta-one relationship
- Mapping a one-ta-many recursive relationship
- Querying a one-to-one relationship
- Querying a recursive relationship
- Modeling a one-ta-one recursive relationship
- Mapping a one-to-one recursive relationship
- Querying a one-to-one recursive relationship
- Modeling a many-to-many recursive relationship
- Mapping a many-ta-many recursive relationship
- Querying a many-to-many recursive relationship
Data Modeling
- Modeling
- Data modeling
- The building blocks
- Data model quality
- Quality improvement
- Meaningful identifiers
- The seven habits of highly effective data modelers
- Reference: Basic Structures
- One entity
- Two entities
- Another entity's identifier as part of the identifier
Normalization and Other Data Modeling Methods
- Normalization
- Other data modeling methods
The Relational Model and Relational Algebra
- Data structures
- Integrity rules
- Manipulation languages
- A primitive set of relational operators
- A fully relational database
SQL
- Data definition
- Data manipulation
- SQL routines
- Triggers
- Nulls-much ado about missing information
- Security
- The catalog
- Natural language processing
- Connectivity and ODBC
- Embedded SQL
- The future of SQL
- Reference: SQL Playbook
- The power of SQL
Database Architectures and Implementations
Data Structure and Storage
- Data structures
- Data coding stanards
- Data storage devces
- Data compression
- Comparative analysis
Data Processing Architectures
- Introduction
- Client/server fundamentals
- Client/server-the second generation
- Distributed database
- Distributed data access
- Distributed database design
Object-Oriented Data Management
- UML
- Historical Development
- Key 00 concepts
- Why OO?
- Objects and information system modeling
- The 00 and relational paradigms
- Mapping objects to a relational database
- Persistent objects
- Object-oriented database management systems
- Directions
Spatial and Temporal Data Management
- Introduction
- Managing spatial data
- Managing temporal data
Organizational Memory Technologies
Organizational Intelligence Technologies
- The data warehouse
- Exploiting data stores
- OLAP
- Multidimensional expressions (MDX)
- Data mining
The Web and Data Management
- Information presentation
- Web site management
- Content management systems
- Wiki
- Web browser-to-DBMS server connectivity
SQL and Java
- JDBC
- Using SQL within Java
XMl: Managing Data Exchange
- EDI
- SGML
- XML
- Conclusion
Managing Organizational Memory
Data Integrity
- Transaction management
- Protecting existence
- Maintaining data quality
- Ensuring confidentiality
Data Administration
- Introduction
- Management of the database environment
- Data administration
- Database management systems (DBMSs)
- Groupware
- Data integration
- Organizing data administration
U-Commerce and Data Management
- Introduction
- U-commerce
- A conceptual framework for u-commerce
- Implications
- Photo Credits
- 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