Synopses & Reviews
Get the data management skills that are in demand!
Today's organizations are seeking graduates who can design and create relational databases, formulate complex SQL queries, understand database architectures and their managerial implications, and keep up with the latest information technologies and database developments.
That's why Richard Watson's 4th Edition of Data Management: Databases and Organizations emphasizes the core data management skills you'll need as you enter the workforce. Featuring in-depth, fully integrated coverage of data modeling and SQL, and a broad managerial perspective, the text throughly prepares you for the real world of data management.
New Features of the 4th Edition:
- New chapter on future directions, including u-commerce
- Chapter on XML revised to include data schemas
- Additional coverage of SQL-99, including GROUP BY extensions, SQL routines (stored procedures and functions), and triggers
- New material on data integration and data quality
- New Material on spatial and temporal databases
- Skill builders embedded within each chapter that encourage you to practice what you've just learned
- All SQL code rewritten to improve readibility and syntax learning.
Synopsis
Wanted: Expert Data Modeling and SQL Skills… Inquire Within.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 Organizationsoffers 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 management.
New Features of the Fifth Edition:
- A new chapter on embedded SQL in Java and JDBC
- A section on multidimensional 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
Synopsis
Now in a completely updated and revised Fourth Edition, this highly readable book emphasizes the core data management skills needed to succeed in today's business environment. The book presents a real-world, management perspective and offers fully integrated coverage of data modeling and SQL.
* New chapter on future directions, including u-commerce.
* New material on data integration, data quality, and data schemas.
* Includes reference sections on data modeling and SQL.
* Presents the "big picture" of data management.
About the Author
Richard T. Watsonis 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 Quarterlyand 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.
Table of Contents
The Managerial Perspective.
1. Managing Data.
2. Information.
Data Modeling and SQL.
3. The Single Entity.
4. The One-to-Many Relationship.
5. The Many-to-Many Relationship.
6. One-to-One and Recursive Relationships.
7. Data Modeling.
Basic Structures.
8. Normalization and Other Data Modeling Methods.
9. The Relational Model and Relational Algebra.
10. SQL.
SQL Playbook.
Database Architectures and Implementations.
11. Data Structure and Storage.
12. Data Processing Architectures.
13. Object-Oriented Data Management.
14. Spatial and Temporal Data Management.
Organizational Memory Technologies.
15. Organizational Intelligence Technologies.
16. The Web and Data Management.
17. XML: Managing Data Exchange.
Managing Organizational Memory.
18. Data Integrity.
19. Data Administration.
20. U-Commerce and Data Management.
Photo Credits.
Index.