HOME > 상세정보

상세정보

Data management : an organizational perspective

Data management : an organizational perspective (2회 대출)

자료유형
단행본
개인저자
Watson, Richard T.
서명 / 저자사항
Data management : an organizational perspective / Richard T. Watson.
발행사항
New York :   John Wiley & Sons, Inc.,   1996.  
형태사항
xx, 568 p. : ill. ; 24 cm.
ISBN
0471305340
서지주기
Including bibliographical references and index.
일반주제명
Organizations memory technologists --Data modeling.
000 00647camuuu200193 a 4500
001 000000923036
005 19990121093902.0
008 970221s1996 nyua b 001 0 eng d
020 ▼a 0471305340
040 ▼a 244002 ▼c 244002
049 0 ▼l 151037322 ▼l 151037323
082 0 4 ▼a 005.7406 ▼2 20
090 ▼a 005.7406 ▼b W341d
100 1 ▼a Watson, Richard T.
245 1 0 ▼a Data management : ▼b an organizational perspective / ▼c Richard T. Watson.
260 ▼a New York : ▼b John Wiley & Sons, Inc., ▼c 1996.
300 ▼a xx, 568 p. : ▼b ill. ; ▼c 24 cm.
504 ▼a Including bibliographical references and index.
650 0 ▼a Organizations memory technologists ▼a Data modeling.

소장정보

No. 소장처 청구기호 등록번호 도서상태 반납예정일 예약 서비스
No. 1 소장처 세종학술정보원/과학기술실/ 청구기호 005.7406 W341d 등록번호 151037322 도서상태 대출가능 반납예정일 예약 서비스 C
No. 2 소장처 세종학술정보원/과학기술실/ 청구기호 005.7406 W341d 등록번호 151037323 도서상태 대출가능 반납예정일 예약 서비스 C

컨텐츠정보

목차


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



관련분야 신착자료

Ramamurthy, Bina (2021)