상세정보

Complete coverage of database management with the correct balance of business and technical material for the MIS professional. This book covers the technical aspects of database design and implementation, with an equal emphasis on the "why" and "how" of the management of databases, and the managerial uses and philosophy behind databases.

정보제공 :

CONTENTS

Preface = ⅶ

Section 1 The Managerial Perspective = 1

 Chapter 1 Organizational Memory = 5

  Learning objectives = 5

  Introduction = 5

  Individual memory systems = 6

  Organizational memory = 9

  Components of organizational memory = 15

  Problems with organizational memory = 26

  Data, information, and knowledge = 28

  The challenge = 30

  Summary = 31

  Key terms and concepts = 32

  References and additional readings = 32

  Exercises = 32

 Chapter 2 Information = 35

  Learning objectives = 35

  Introduction = 35

  A historical perspective = 36

  Information characteristics = 37

  Information and organizational change = 40

  Information and managerial work = 47

  Information delivery systems = 49

  Summary = 55

  Key terms and concepts = 56

  References and additional readings = 56

  Exercises = 57

  Case questions = 58

Section 2 Data Modeling and SQL = 59

 Chapter 3 The Single Entity = 61

  Learning objectives = 61

  The Expenditioner = 61

  Introduction = 61

  Modeling a single entity database = 62

  Creating a single table database = 63

  Querying a single table database = 68

  Summary = 85

  Key terms and concepts = 85

  Exercises = 85

 Chapter 4 The One-to-Many Relationship = 89

  Learning objectives = 89

  The Expeditioner = 89

  Relations = 89

  Creating a database with a one-to-many relationship = 91

  Querying a two-table database = 95

  Summary = 104

  Key terms and concepts = 105

  Exercises = 105

 Chapter 5 The Many-to-Many Relationship = 108

  Learning Objectives = 108

  The Expeditioner = 108

  The many-to-many relationship = 109

  Creating a relational database with a many-to-many relationship = 111

  Querying a many-to-many relationship = 113

  Summary = 121

  Key terms and concepts = 121

  Exercises = 121

 Chapter 6 One-to-One and Recursive Relationships = 124

  Learning Objectives = 124

  The Expeditioner = 124

  Modeling the one-to-one relationship = 125

  Mapping a one-to-one relationship = 126

  Mapping a recursive relationship = 126

  Querying a one-to-one relationship = 128

  Querying a recursive relationship = 128

  The Expeditioner = 132

  Modeling a one-to-one recursive relationship = 132

  Mapping a one-to-one recursive relationship = 133

  Querying a one-to-one recursive relationship = 133

  The Expeditioner = 135

  Modeling a many-to-many recursive relatiionship = 135

  Mapping a many-to-many recursive relatiionship = 136

  Querying a many-to-many recursive relatiionship = 137

  Summary = 139

  Key terms and concepts = 139

  Exercises = 139

 Chapter 7 Data Modeling = 142

  Introduction = 142

  The building blocks = 142

  Data model quality = 146

  Quality inprovement = 147

  Entity types = 159

  Data modeling hints = 162

  Normalization = 168

  Other data modeling methods = 179

  Summary = 180

  Key terms and concepts = 181

  References and additional readings = 181

  Exercises = 181

 Chapter 8 Basic Structures and the Relational Model = 185

  One entity = 185

  Two entities = 189

  Relationship descriptors as identifiers = 191

  Exercises = 196

 Chapter 9 SQL = 198

  Learning objectives = 198

  Introduction = 198

  Data definition = 199

  Data manipulation = 211

  Nulls - much ado about missing information = 223

  Security = 223

  Synonyms = 226

  The catalog = 226

  Embedded SQL = 227

  Summary = 231

  Key terms and concepts = 232

  References and additional readings = 233

  Exercises = 233

 Chapter 10 The SQL Playbook = 235

  1. A slow full toss = 236

  2. Skinning a cat = 236

  3. Another full toss = 238

  4. Subracting from all = 238

  5. Dividing = 239

  6. At least some number = 240

  7. A friendly IN for an SQL traveler = 240

  8. Joining a table with itself = 240

  9. A combination of subtract from all and a self-join = 241

  10. Self-join with GROUP BY = 241

  11. A self-join with two matching conditions = 241

  12. Averaging with grouping = 242

  13. Self-join with a GROUP BY and COUNT = 242

  14. An IN with GROUP BY and COUNT = 242

  15. A self-join with some conditions = 243

  16. Making comparisons = 243

  17. An IN with GROUP BY and SUM = 243

  18. A double divide! = 244

  19. A slam dunk = 245

  20. A 6-inch putt for a birdie = 245

  21. Making the count = 245

  22. Minus and divide = 245

  23. Drivision with copies = 246

  24. A difficult pairing = 247

  25. Two divides and an intersection = 247

  26. A divide with a matching condition = 248

  27. Restricted divide = 248

  28. A NOT IN variation on divide = 249

  29. All and only = 249

  30. Divide with an extra condition = 250

  31. At least some count = 250

  32. Double divide withh a restriction = 250

  33. Triple divide with a restriction = 251

  34. An easy one count = 252

  35. The only one = 252

  36. At least some number = 253

  37. A three-table join = 253

  38. Using Not IN like NOT EXISTS = 253

  39. Minus after grouping = 254

  40. Something to all = 254

  41. Intersection (AND) = 254

  42. Union (OR) = 255

  43. Intersection/union = 255

  44. Averaging with a condition = 256

  45. Averaging with grouping = 256

  46. Averaging with a join, condition, and grouping = 256

  47. Averaging with multiple joins = 256

  48. Complex counting = 257

  49. summing with joins and conditions = 257

  50. Summing with joins, conditions, and grouping = 257

  51. Advanced summing = 258

  52. Comparing to the average with a join = 258

  53. Comparing to the average with a product = 359

  54. Averaging with multiple grouping = 259

  55. More than the average with grouping = 259

  56. The simplest average = 260

  57. Difference from the average = 260

  58. Averaging with multiple joins, multiple grouping, and a condition = 260

  59. Detailed averaging = 261

  60. Counting averaging = 261

  61. No Booleans = 261

  Summary = 262

  Key terms and concepts = 262

  Exercises = 262

  Appendix - Data for Tables = 265

Section 3 Database Architectures and Implementations = 271

 Chapter 11 Data Structure and Storage = 275

  Learning objectives = 275

  The Expenditioner = 275

  Introduction = 276

  Data structures = 276

  Data storage devices = 290

  Conclusion = 302

  Summary = 303

  Key terms and concepts = 304

  Exercises = 305

 Chapter 12 Data Storage and Data Processing Architectures = 307

  Learning objectives = 307

  The Expeditioner = 307

  Introduction = 307

  Client/Server = 315

  Disributed database = 319

  A hybrid architecture = 320

  Summary = 324

  Key terms and concepts = 325

  References and additional readings = 325

  Exercises = 325

 Chapter 13 The Relational Model = 327

  Learning objectives = 327

  Background = 327

  Data structures = 328

  Integrity rules = 331

  Manipulation - relational algebra = 331

  A primitive set of relational operations = 337

  A fully relational database = 337

  Summary = 341

  Key terms and concepts = 342

  References and additional readings = 343

  Exercises = 343

 Chapter 14 Hierarchical and Network Models = 344

  Learning objectives = 344

  The Expeditioner = 344

  Introduction = 345

  The hierarchical model = 346

  The network data model and CODASYL/DBTG = 355

  Data extraction = 361

  Summary = 361

  Key terms and concepts = 362

  Exercises = 362

 Chapter 15 Object-Oriented Database Management Systems = 365

  Learning objectives = 365

  Introduction = 365

  Historical development = 366

  Key OO concepts = 367

  Why OO? = 370

  Objects and information system modeling = 373

  The Expeditioner = 376

  Persistent objects = 390

  Objects-oriented database management systems = 390

  The future of ODBMS = 394

  Summary = 394

  Key terms and concepts = 395

  References and additional readings = 396

  Exercises = 396

Section 4 Organizational Memory Technologies = 399

 Chapter 16 Groupware, Hypertext, and Imaging = 401

  Learning objectives = 401

  Introduction = 401

  The Expeditioner = 401

  Groupware = 402

  The Expeditioner = 418

  Hypertext = 418

  The Expeditioner = 424

  Imaging = 425

  Summary = 431

  Key terms and concepts = 432

  References and additional readings = 433

  Exercises = 433

 Chapter 17 Internet and Information Services = 435

  Learning Objectives = 435

  Introduction = 435

  The Internet = 436

  Information services = 455

  Summary = 466

  Key terms and concepts = 466

  References and additional readings = 467

  Exercises = 467

Section 5 Managing Organizational Memory = 469

 Chapter 18 Data Integrity = 470

  Learning objectives = 470

  The Expeditioner = 470

  Introduction = 470

  Single-user and multi-user database systems = 474

  Protecting existence = 475

  Maintaining quality = 483

  Ensuring confidentiality = 490

  Summary = 499

  Key terms and concepts = 500

  References and additional readings = 501

  Exercises = 501

 Chapter 19 Data Administration = 503

  Learning objectives = 503

  The Expeditioner = 503

  Introduction = 504

  Management of the database environment = 505

  Data administration = 508

  Database Management System (DBMS) = 527

  Organizing data administration = 530

  Summary = 536

  Key terms and concepts = 536

  References and additional readings = 536

  Exercises = 537

Glossary = 539

Photo Credits = 554

Index = 555