Modern database management:
Gespeichert in:
| Vorheriger Titel: | MacFadden, Fred R. Database management |
|---|---|
| Hauptverfasser: | , |
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Redwood City, Calif. u.a.
Benjamin/Cummings
1994
|
| Ausgabe: | 4. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XXV, 597 S. graph. Darst. |
| ISBN: | 0805360476 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV009619569 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 940531s1994 d||| |||| 00||| eng d | ||
| 020 | |a 0805360476 |9 0-8053-6047-6 | ||
| 035 | |a (OCoLC)28708791 | ||
| 035 | |a (DE-599)BVBBV009619569 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-29T |a DE-11 | ||
| 050 | 0 | |a QA76.9.D3 | |
| 082 | 0 | |a 005.74 |2 20 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 100 | 1 | |a McFadden, Fred R. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Modern database management |c Fred R. McFadden ; Jeffrey A. Hoffer |
| 250 | |a 4. ed. | ||
| 264 | 1 | |a Redwood City, Calif. u.a. |b Benjamin/Cummings |c 1994 | |
| 300 | |a XXV, 597 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 7 | |a Databanken |2 gtt | |
| 650 | 4 | |a Database management | |
| 650 | 0 | 7 | |a Organisation |0 (DE-588)4043774-7 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbank |0 (DE-588)4011119-2 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbanksystem |0 (DE-588)4113276-2 |2 gnd |9 rswk-swf |
| 655 | 7 | |8 1\p |0 (DE-588)4123623-3 |a Lehrbuch |2 gnd-content | |
| 689 | 0 | 0 | |a Datenbank |0 (DE-588)4011119-2 |D s |
| 689 | 0 | 1 | |a Datenbanksystem |0 (DE-588)4113276-2 |D s |
| 689 | 0 | 2 | |a Organisation |0 (DE-588)4043774-7 |D s |
| 689 | 0 | |8 2\p |5 DE-604 | |
| 689 | 1 | 0 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 1 | |8 3\p |5 DE-604 | |
| 700 | 1 | |a Hoffer, Jeffrey A. |e Verfasser |4 aut | |
| 780 | 0 | 0 | |i Bis 3. Auflage |a MacFadden, Fred R. |t Database management |
| 856 | 4 | 2 | |m GBV Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=006357663&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-006357663 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 2\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 3\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
Datensatz im Suchindex
| _version_ | 1804123959523803136 |
|---|---|
| adam_text | MODERN DATABASE MANAGEMENT FOURTH EDITION FRED R. MCFADDEN * JEFFREY A.
HOFFER R( ) THE BENJAMIN/CUMMINGS PUBLISHING COMPANY INC. REDWOOD CITY,
CALIFORNIA * MENLO PARK, CALIFORNIA READING, MASSACHUSETTS * NEW YORK *
DON MILLS, ONTARIO WOKINGHAM, U.K. * AMSTERDAM * BONN * SYDNEY SINGAPORE
* TOKYO * MADRID * SAN JUAN DETAIIED TABLE OF CONTENTS PREFACE V PART I
THE CONTEXT OF DATAHASE DEVELOPMENT 2 SEARS, ROEBUCK AND CO. LEVERAGING
THE VALUE OF DATA CHAPTER 1 THE DATABASE ENVIRONMENT 5 LEARNING
OBJECTIVES 5 INTRODUCTION 5 INFORMATION RESOURCE MANAGEMENT 6 DATA
VERSUS INFORMATION 7 DATABASES 8 IMPLEMENTING INFORMATION RESOURCE
MANAGEMENT 9 TYPES OF DATABASES 9 CENTRALIZED DATABASES 9 DISTRIBUTED
DATABASES 11 CASE EXAMPLE: PINE VALLEY FURNITURE COMPANY 13 ]KE~*I
BUSINESS BACKGROUND 13 J R T J MANUAL INFORMATION SYSTEMS 15 I NL^L FILE
PROCESSING SYSTEMS 16 FILE PROCESSING SYSTEMS AT PINE VALLEY FURNITURE
16 DISADVANTAGES OF FILE PROCESSING SYSTEMS 18 *K - ! THE DATABASE
APPROACH 20 ^_ |FEJ DATA-DRIVEN VERSUS PROCESS-DRIVEN DESIGN 20 1*_U^B
DATABASE APPROACH FOR PINE VALLEY FURNITURE 21 IMPLEMENTING THE
RELATIONAL DATABASE 24 BENEFITS OF THE DATABASE APPROACH 25 COSTS OF THE
DATABASE APPROACH 28 COMPONENTS OF THE DATABASE ENVIRONMENT 29 SUMMARY
30 CHAPTER REVIEW 31 KEY TERMS 31 XV XVI DETAILED TABLE OF CONTENTS
REVIEW QUESTIONS 31 PROBLEMS AND EXERCISES REFERENCES 33 32 CHAPTER 2 A
DATABASE APPLICATION FOR PINE VALLEY FURNITURE LEARNING OBJECTIVES 35
YR*I INTRODUCTION 35 MJ_ THE DEVELOPMENT OF A DATABASE APPLICATION 36
I ^NDL THE CONCEPTUAL DATA MODEL FOR PINE VALLEY FURNITURE 39
TRANSACTION PROCESSING REQUIREMENTS FOR PINE VALLEY FURNITURE 40 *RR*I
PRODUCT AND CUSTOMER DATA ENTRY 41 JK K I CUSTOMER ORDER ENTRY 43 I
NLRIB MANAGEMENT INFORMATION REQUIREMENTS FOR PINE VALLEY FURNITURE 46
DATABASE DEFINITION IN DBASE IV 49 TABLE DEFINITIONS 50 PROCESSING
TRANSACTIONS IN DBASE IV 53 PRODUCT AND CUSTOMER TRANSACTIONS 54 ORDER
TRANSACTION 59 PROCESSING INFORMATION REQUESTS IN DBASE IV 61
INTRODUCTION TO SQL 61 SIMPLE QUERIES AT PINE VALLEY FURNITURE 62 REPORT
WRITER FEATURES FOR DATABASE PROCESSING 66 SUMMARY 69 CHAPTER REVIEW 70
KEY TERMS 70 REVIEW QUESTIONS 70 PROBLEMS AND EXERCISES 70 REFERENCES 71
35 CHAPTER 3 THE DATABASE DEVELOPMENT PROCESS 73 LEARNING OBJECTIVES 73
INTRODUCTION 73 A FRAMEWORK FOR INFORMATION SYSTEMS ARCHITECTURE
OVERVIEW OF THE FRAMEWORK 75 EVOLUTION THROUGH THE FRAMEWORK 77 ROLE OF
METHODOLOGIES AND TOOLS 78 INFORMATION ENGINEERING METHODOLOGY 79 ^*R*I
PHASES IN INFORMATION ENGINEERING 80 RFCJ PLANNING 81 |_3Q( STRATEGIE
PLANNING FACTORS 82 CORPORATE PLANNING OBJECTS 82 MGZ *I ENTERPRISE
MODEL 84 LJI^B STEPS IN ANALYSIS 87 MTX*I ANALYSIS EXAMPLE: PINE VALLEY
FURNITURE 89 L_U^H DATABASE DESIGN 93 PROCESS DESIGN 95 IMPLEMENTATION
96 74 DETAILED TABLE OF CONTENTS XVUE M STRATEGIE INFORMATION SYSTEMS
PLANNING 97 THE IMPORTANCE OF STRATEGIE IS PLANNING 98 PLANNING
PREREQUISITES 98 THE PLANNING METAMODEL 99 PLANNING MATRICES 100
BENEFITS OF CASE TOOLS IN PLANNING 102 THE ROLE OF A REPOSITORY 203 CASE
EXAMPLE: MOUNTAIN VIEW COMMUNITY HOSPITAL 203 IDENTIFYING THE BUSINESS
ENVIRONMENT 104 UNDERSTANDING THE BUSINESS DIRECTION 104 EXISTING
INFORMATION SYSTEMS 105 CRITICAL SUCCESS FACTORS 106 ENTERPRISE MODELING
107 THE ENTITY-RELATIONSHIP DIAGRAM 109 THE FUNCTION-VERSUS-ENTITY-TYPE
MATRIX 110 STRATEGY FORMULATION 112 FINAL REPORT 113 PITFALLS IN
STRATEGIE IS PLANNING 113 SUMMARY 114 CHAPTER REVIEW 115 KEY TERMS 225
REVIEW QUESTIONS 225 PROBLEMS AND EXERCISES 116 REFERENCES 227 PART II
DATA MODELING AND DATABASE DESIGN 120 IBM CANADA REAL-TIME PROCESS
MONITORING AND CONTROL CHAPTER 4 THE ENTITY-RELATIONSHIP MODEL 723
LEARNING OBJECTIVES 223 INTRODUCTION 223 INTRODUCTION TO THE E-R MODEL
224 ENTITIES 226 ATTRIBUTES 227 CANDIDATE KEYS AND PRIMARY KEYS 227
MULTIVALUED ATTRIBUTES 128 RELATIONSHIPS 128 DEGREE OF A RELATIONSHIP
229 GERUNDS 232 CARDINALITIES IN RELATIONSHIPS 234 MODELING MULTIVALUED
ATTRIBUTES 236 REPEATING GROUPS 237 MODELING TIME-DEPENDENT DATA 239
GENERALIZATION 242 SUBTYPES AND SUPERTYPES 242 INHERITANCE 244 EXCLUSIVE
SUBTYPES 244 NONEXCLUSIVE SUBTYPES 145 BUSINESS RULES 246 DOMAINS 246
XVUEI DETAILED TABLE OF CONTENTS M TRIGGERING OPERATIONS 148 LOCATING
BUSINESS RULES 148 AN EXAMPLE OF E-R MODELING 149 VACATION PROPERTY
RENTAIS 149 CASE EXAMPLE: MOUNTAIN VIEW COMMUNITY HOSPITAL 153 DEFINE
DATABASE SCOPE 155 SELECT LOGICAL DESIGN METHODOLOGY 155 IDENTIFY USER
VIEWS 155 MODEL DATA STRUCTURE AND CONSTRAINTS 156 BUILD CONCEPTUAL DATA
MODEL 161 SUMMARY 162 CHAPTER REVIEW 163 KEY TERMS 163 REVIEW QUESTIONS
163 PROBLEMS AND EXERCISES 163 REFERENCES 266 M CHAPTER 5 THE
OBJECT-ORIENTED DATA MODEL 767 LEARNING OBJECTIVES 167 INTRODUCTION 167
INTRODUCTION TO THE OBJECT-ORIENTED DATA MODEL 168 CORE CONCEPTS 168
TYPICAL PRODUCTS AND APPLICATIONS 170 OBJECTS 272 OBJECT CLASSES AND
INSTANCES 172 IDENTIFYING AND DESCRIBING OBJECTS 172 EXAMPLE: CUSTOMER
ORDER 174 CONNECTING OBJECTS 175 GENERALIZATION 276 GENERALIZATION
HIERARCHY 176 INHERITANCE 176 VARIATIONS ON GENERALIZATION HIERARCHIES
179 EXAMPLE: VACATION PROPERTY RENTALS 180 ASSEMBLY STRUCTURES 183
EXPLICIT ASSEMBLY STRUCTURE 184 METHODS 185 TYPES OF METHODS 186 MESSAGE
CONNECTIONS 186 MESSAGES 187 EXAMPLE: CUSTOMER ORDER 188 EXAMPLE:
VACATION PROPERTY RENTALS 189 CASE EXAMPLE: MOUNTAIN VIEW COMMUNITY
HOSPITAL 292 SUMMARY 292 CHAPTER REVIEW 295 KEY TERMS 195 REVIEW
QUESTIONS 195 PROBLEMS AND EXERCISES 195 REFERENCES 198 CHAPTER 6
LOGICAL DESIGN AND THE RELATIONAL MODEL LEARNING OBJECTIVES 299
INTRODUCTION 299 199 DETAILED TABLE OF CONTENTS XIX M LOGICAL DATABASE
DESIGN 200 TYPES OF LOGICAL DATABASE MODELS 200 OVERVIEW OF LOGICAL
DATABASE DESIGN 203 THE RELATIONAL DATA MODEL 205 RELATIONS 205
PROPERTIES OF RELATIONS 206 WELL-STRUCTURED RELATIONS 208 CONCEPTS OF
NORMALIZATION 209 STEPS IN NORMALIZATION 220 FUNCTIONAL DEPENDENCE AND
KEYS 210 THE BASIC NORMAL FORMS 212 FIRST NORMAL FORM 212 SECOND NORMAL
FORM 222 THIRD NORMAL FORM 222 AN EXAMPLE 226 NORMALIZING SUMMARY DATA
220 ADDITIONAL NORMAL FORMS 222 BOYCE-CODD NORMAL FORM 222 FOURTH NORMAL
FORM 224 FIFTH NORMAL FORM 225 DOMAIN-KEY NORMAL FORM (DK/NF) 225
TRANSFORMING E-R DIAGRAMS TO RELATIONS 225 REPRESENT ENTITIES 226
REPRESENT RELATIONSHIPS 226 MERGING RELATIONS 232 AN EXAMPLE 232 VIEW
INTEGRATION PROBLEMS 232 CASE EXAMPLE: MOUNTAIN VIEW COMMUNITY HOSPITAL
234 TRANSFORMING THE E-R DIAGRAM TO RELATIONS 235 NORMALIZING THE
RELATIONS 236 SUMMARY 237 CHAPTER REVIEW 237 KEY TERMS 237 REVIEW
QUESTIONS 238 PROBLEMS AND EXERCISES 238 REFERENCES 242 CHAPTER 7 M
PHYSICAL DATABASE DESIGN 243 LEARNING OBJECTIVES 243 INTRODUCTION 243
THE PHYSICAL DATABASE DESIGN PROCESS 244 DATA VOLUME AND USAGE ANALYSIS
245 DATA VOLUME ANALYSIS 245 DATA USAGE ANALYSIS 246 DATA DISTRIBUTION
STRATEGY 248 BASIC DATA DISTRIBUTION STRATEGIES 248 AN EXAMPLE OF DATA
DISTRIBUTION 249 FILE ORGANIZATION 253 SEQUENTIAL FILE ORGANIZATION 254
LNDEXED FILE ORGANIZATIONS 255 INDEXES 255 PRIMARY KEY INDEXES 256 XX
DETAILED TABLE OF CONTENTS INDEXES FOR NONKEY ATTRIBUTES 257 CLUSTERING
INDEXES 258 TREES 259 BALANCED TREES 261 WHEN TO USE INDEXES 262
INTEGRITY CONSTRAINTS 263 REFERENTIAL INTEGRITY RULES 264 ENFORCING
REFERENTIAL INTEGRITY 265 DENORMALIZATION 266 HIERARCHICAL AND NETWORK
DATA MODELS 267 HIERARCHICAL DATA MODEL 267 NETWORK DATA MODEL 268
MAPPING TO A NETWORK DATA MODEL 270 MAPPING TO A HIERARCHICAL MODEL 273
SUMMARY 274 CHAPTER REVIEW 275 KEY TERMS 275 REVIEW QUESTIONS 275
PROBLEMS AND EXERCISES 276 REFERENCES 27 & PART IM RELATIONAL DATABASE
IMPLEMENTATION 280 TACO BELL CORPORATION MANAGING INFORMATION OVERLOAD M
CHAPTER 8 M H SQL: A STANDARD FOR DATABASE PROCESSING LEARNING
OBJECTIVES 283 INTRODUCTION 283 SQL: A STANDARD FOR RELATIONAL SYSTEMS
284 RELATIONAL DATA DEFINITION IN SQL 286 DATA TYPES 286 DATA DEFINITION
COMMANDS 288 VIEW DEFINITION 290 INTERNAL SCHEMA DEFINITION IN RDBMSS
292 DATA INTEGRITY CONTROLS 293 DATA DICTIONARY FACILITIES 295 DATA
RETRIEVAL AND MANIPULATION IN SQL 296 GENERAL STRUCTURE OF SQL CALCULUS
296 BASIC SQL RETRIEVAL COMMAND STRUCTURE 297 MULTIPLE TABLE OPERATIONS
IN SQL 301 EQUI-JOIN 302 NATURAL JOIN 302 OUTER JOIN 302 TABLE NAME
ABBREVIATIONS 303 JOINING BY SUBQUERIES 303 CORRELATED SUBQUERIES 305
QUALIFIED SUBQUERIES 305 OTHER MULTIPLE-TABLE OPERATIONS 307 DATA
MAINTENANCE IN SQL 308 ADDING DATA TO A TABLE 310 DELETING DATABASE
CONTENTS 311 CHANGING DATABASE CONTENTS 311 MODIFYING DATA THROUGH A
VIEW 312 283 DETAILED TABLE OF CONTENTS XXI TRANSACTION INTEGRITY
FACILITIES SUMMARY 314 CHAPTER REVIEW 326 KEY TERMS 316 REVIEW QUESTIONS
316 PROBLEMS AND EXERCISES 326 REFERENCES 329 322 CHAPTER 9 IMPLEMENTING
A DBASE IV DATABASE 327 LEARNING OBJECTIVES 322 INTRODUCTION 322 THE
STRUCTURE AND COMPONENTS OF PC RELATIONAL SYSTEMS 322 RELATIONAL PC-DBMS
STYLES 323 DBASE: A STANDARD FOR PC RELATIONAL SYSTEMS 324 DBASE
TERMINOLOGY AND CONCEPTS 325 DATABASE DEFINITION IN DBASE 326 DATA TYPES
326 ADDITIONAL TABLE DEFINITION FEATURES 327 INDEX DEFINITION IN DBASE
328 DATA DICTIONARY FACILITIES 331 SUMMARY OF DATABASE DEFINITION
COMMANDS 332 DATA RETRIEVAL AND MANIPULATION IN DBASE IV 332 FILTERS 333
SINGLE-TABLE COMMANDS 333 BUILT-IN FUNCTIONS 337 SORTING A FILE 338
MULTIPLE-TABLE OPERATIONS IN DBASE IV 339 THE JOIN COMMAND 340 SET
RELATION COMMAND 342 OTHER MULTIPLE-TABLE OPERATIONS 343 VIEW QUERIES
346 DATA MAINTENANCE IN DBASE IV 348 ADDING DATA TO A TABLE 34G DELETING
DATABASE CONTENTS 348 CHANGING DATABASE CONTENTS 349 MAINTAINING
TRANSACTION INTEGRITY 351 WRITING DBASE PROGRAMS 352 MACROS 352
USER-DEFINED FUNCTIONS 353 PROCEDURES 355 SUMMARY 357 CHAPTER REVIEW 357
KEY TERMS 357 REVIEW QUESTIONS 358 PROBLEMS AND EXERCISES 358 REFERENCES
360 CHAPTER 10 QUERY-BY-EXAMPLE: IMPLEMENTING A PARADOX 4.0 DATABASE 361
LEARNING OBJECTIVES INTRODUCTION 362 362 XXUE DETAILED TABLE OF CONTENTS
THE HISTORY AND IMPORTANCE OF QBE 362 QBE AND END-USER COMPUTING 362
QBE: THE BASICS 363 PARADOX AND QBE TERMINOLOGY 363 OVERVIEW OF A
PARADOX SCREEN 365 DATABASE DEFINITION IN PARADOX 366 DATA DEFINITION
SCREEN 366 INDEX DEFINITION IN PARADOX 367 DATA INTEGRITY CONTROL 369
DATA DICTIONARY FACILITIES 371 SUMMARY OF DATA DEFINITION COMMANDS 372
SIMPLE DATA RETRIEVAL IN QBE AND PARADOX 372 SINGLE-TABLE DISPLAYS 372
SINGLE-TABLE QUERIES 373 SELECTING QUALIFIED RECORDS 374 SUMMARY OF
SINGLE-TABLE QUERIES 379 MULTIPLE-TABLE OPERATIONS IN QBE AND PARADOX
380 JOIN 380 SETS 383 OTHER MULTIPLE-TABLE OPERATIONS 386 SUMMARY OF
MULTIPLE-TABLE OPERATIONS 386 DATA MAINTENANCE IN QBE AND PARADOX 387
DATA MAINTENANCE OPERATIONS IN QUERIES 387 DATA MAINTENANCE MENUE
COMMANDS 389 TRANSACTION INTEGRITY FACILITIES OF PARADOX 389 OTHER
PARADOX CAPABILITIES 389 SUMMARY 390 CHAPTER REVIEW 390 KEY TERMS 390
REVIEW QUESTIONS 390 PROBLEMS AND EXERCISES 391 REFERENCES 392 CHAPTER
11 ADVANCED FEATURES AND GRAPHICAL INTERFACES FOR PC DATABASE SYSTEMS
393 LEARNING OBJECTIVES 393 » R*I INTRODUCTION 393 J^FC J DATA ENTRY AND
DISPLAY FORMS 394 L31^B DBASE FORMS FOR INPUT AND OUTPUT 394 PARADOX
FORMS FOR DATA INPUT AND OUTPUT 399 MULTIFORMS IN PARADOX 400 *BL |
GENERATING CUSTOM REPORTS 403 WJKJ DBASE IV REPORT GENERATOR 403 I* 3I^B
PARADOX REPORT GENERATOR 405 DATABASE SYSTEMS FOR MICROSOFT WINDOWS 409
THE WINDOWS ENVIRONMENT FOR DATABASE PROCESSING 410 LINKING WITH OTHER
APPLICATIONS 411 FORMS 412 QUERIES 414 DATA MODELING 415 SUMMARY 419
CHAPTER REVIEW 420 DETAILED TABLE OF CONTENTS XXUEI KEY TERMS 420 REVIEW
QUESTIONS 420 PROBLEMS AND EXERCISES 420 REFERENCES 421 *** PART IV
DATA ADMINISTRATION AND DISTRIBUTED DATABASES 422 APPLE COMPUTER, INC.
DISTRIBUTED DATABASES FOR DISTRIBUTED CONTROL G CHAPTER 12 DATA
ADMINISTRATION 425 - - } LEARNING OBJECTIVES 425 JT& INTRODUCTION 425
DATA ADMINISTRATION FUNCTIONS 426 DATA ADMINISTRATION, DATABASE
ADMINISTRATION, AND DATA STEWARDS 427 FUNCTIONS OF DATA AND DATABASE
ADMINISTRATION 427 ORGANIZING THE DATA ADMINISTRATION FUNCTION 431 DATA
ADMINISTRATION TOOLS 433 REPOSITORIES 433 CASE TOOLS 435 DATABASE
MANAGEMENT SYSTEMS 437 CONCURRENCY CONTROL 441 THE PROBLEM OF LOST
UPDATES 441 LOCKING MECHANISMS 442 VERSIONING 445 DATABASE SECURITY 447
VIEWS 447 AUTHORIZATION RULES 448 USER-DEFINED PROCEDURES 449 ENCRYPTION
449 AUTHENTICATION SCHEMES 450 DATABASE RECOVERY 450 BASIC RECOVERY
FACILITIES 450 RECOVERY AND RESTART PROCEDURES 451 TYPES OF DATABASE
FAILURE 454 HANDLING MISSING OR ERRONEOUS DATA 455 SUMMARY 457 CHAPTER
REVIEW 458 KEY TERMS 458 REVIEW QUESTIONS 459 PROBLEMS AND EXERCISES 459
REFERENCES 462 CHAPTER 13 CLIENT/SERVER AND DISTRIBUTED DATABASES 463
LEARNING OBJECTIVES 463 INTRODUCTION 463 LOCAL AREA NETWORKS 464 FILE
SERVERS 464 LIMITATIONS OF FILE SERVERS 465 CLIENT/SERVER ARCHITECTURE
466 FUNCTIONS OF THE CLIENT AND SERVER 467 XXIV DETAILED TABLE OF
CONTENTS W CLIENT/SERVER ADVANTAGES 468 ISSUES IN CLIENT/SERVER DATABASE
DESIGN 468 SURVEY OF SERVERS FOR CLIENT/SERVER DATABASES 468 SURVEY OF
FRONT-END APPLICATION DEVELOPMENT AND API TOOLS 469 DISTRIBUTED
DATABASES 470 OBJECTIVES AND TRADE-OFFS 470 OPTIONS FOR A DISTRIBUTED
NETWORK 471 OPTIONS FOR DISTRIBUTING A DATABASE 473 DISTRIBUTED DBMS 477
LOCATION TRANSPARENCY 478 REPLICATION TRANSPARENCY 479 FAILURE
TRANSPARENCY 480 COMMIT PROTOCOL 481 CONCURRENCY TRANSPARENCY 481 QUERY
OPTIMIZATION 482 EVOLUTION OF DISTRIBUTED DBMS 484 SUMMARY 484 CHAPTER
REVIEW 486 KEY TERMS 486 REVIEW QUESTIONS 487 PROBLEMS AND EXERCISES 487
REFERENCES 488 PART V LEGACY DATABASE SYSTEMS 490 MCDONNELL DOUGLAS
CORPORATION MANUFACTURING SUPPORT WITH IMS R H I ^ J ^ ^ CHAPTER 14
HIERARCHICAL DATABASE SYSTEMS 493 _JJF ~ I LEARNING OBJECTIVES 493
^ ** I M INTRODUCTION 493 IMS PHYSICAL DATABASES 494 PDBR OCCURRENCES
494 DATABASE DESCRIPTION 495 IMS LOGICAL DATABASES 496 EXAMPLE LDBRS 497
PROGRAM COMMUNICATION BLOCK 497 PROGRAM SPECIFICATION BLOCK 498 IMS
INTERNAL MODELS 498 OVERVIEW OF IMS INTERNAL MODEL 499 HSAM 499 HISAM
500 HDAMANDHIDAM 501 SPECIFYING THE INTERNAL MODEL 503 IMS DATA
MANIPULATION 503 GET UNIQUE (GU) 504 GET NEXT (GN) 504 GET NEXT WITHIN
PARENT (GNP) 505 GET HOLD (GH) 506 REPLACEMENT (REPL) 506 DELETION
(DLET) 506 INSERTION (ISRT) 507 ADVANCED IMS FEATURES 507 LOGICAL
DATABASES 507 SECONDARY INDEXING 510 DETAILED TABLE OF CONTENTS XXV M
CASE EXAMPLE: MOUNTAIN VIEW COMMUNITY HOSPITAL DATABASE DEFINITION 511
DATABASE MANIPULATION 522 SUMMARY 513 CHAPTER REVIEW 523 KEY TERMS 523
REVIEW QUESTIONS 514 PROBLEMS AND EXERCISES 514 REFERENCES 516 511
CHAPTER 15 NETWORK AND CODASYL IMPLEMENTATIONS 577 LEARNING OBJECTIVES
517 INTRODUCTION 517 INTRODUCTION TO CODASYL DBTG GUIDELINES 519 DBMS
OPERATION 529 P R I A CODASYL DATABASE 522 JR ^ 1 DBTG LANGUAGES 522 I
NFJL DBTG SCHEMA DDL: THE CONCEPTUAL /INTERNAL DATABASE 523 AREAS OR
REALMS 525 | ~T~ RECORDS 526 ^U/^M RELATIONSHIP DEFINITIONS: SETS 531
WM } DBTG SUBSCHEMA DDL: EXTERNAL DATABASES 545 COBOL DML: RETRIEVING
AND MAINTAINING DATA 546 CURRENCY INDICATORS 547 DATA RETRIEVAL 550 DATA
MAINTENANCE AND CONTROL 553 LOGICAL RECORD PROCESSING IN IDMS 557
NETWORK DATABASE DESIGN ISSUES AND ADVANCED TOPICS 557 RECORD PLACEMENT
CONTROL 558 RECORD DATA ELEMENTS 558 SETS 560 DEVICE MEDIA CONTROL
LANGUAGE 561 NONPROCEDURAL ACCESS: QUERY AND NATURAL LANGUAGES 561 QUERY
LANGUAGES 562 NATURAL LANGUAGES 562 SUMMARY 564 CHAPTER REVIEW 564 KEY
TERMS 564 REVIEW QUESTIONS 564 PROBLEMS AND EXERCISES 565 REFERENCES 566
APPENDICES 567 A*CODD S 12 RULES FOR A TRULY RELATIONAL SYSTEM 567 B*AN
OVERVIEW OF PC-RDBMSS 573 GLOSSARY OF TERMS 577 GLOSSARY OF ACRONYMS 585
INDEX 587
|
| any_adam_object | 1 |
| author | McFadden, Fred R. Hoffer, Jeffrey A. |
| author_facet | McFadden, Fred R. Hoffer, Jeffrey A. |
| author_role | aut aut |
| author_sort | McFadden, Fred R. |
| author_variant | f r m fr frm j a h ja jah |
| building | Verbundindex |
| bvnumber | BV009619569 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 |
| callnumber-search | QA76.9.D3 |
| callnumber-sort | QA 276.9 D3 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)28708791 (DE-599)BVBBV009619569 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 4. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02152nam a2200529 c 4500</leader><controlfield tag="001">BV009619569</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">940531s1994 d||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0805360476</subfield><subfield code="9">0-8053-6047-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)28708791</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV009619569</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-29T</subfield><subfield code="a">DE-11</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">20</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">McFadden, Fred R.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Modern database management</subfield><subfield code="c">Fred R. McFadden ; Jeffrey A. Hoffer</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">4. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Redwood City, Calif. u.a.</subfield><subfield code="b">Benjamin/Cummings</subfield><subfield code="c">1994</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXV, 597 S.</subfield><subfield code="b">graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Databanken</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Organisation</subfield><subfield code="0">(DE-588)4043774-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbank</subfield><subfield code="0">(DE-588)4011119-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="655" ind1=" " ind2="7"><subfield code="8">1\p</subfield><subfield code="0">(DE-588)4123623-3</subfield><subfield code="a">Lehrbuch</subfield><subfield code="2">gnd-content</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbank</subfield><subfield code="0">(DE-588)4011119-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Organisation</subfield><subfield code="0">(DE-588)4043774-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="8">2\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">3\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Hoffer, Jeffrey A.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="780" ind1="0" ind2="0"><subfield code="i">Bis 3. Auflage</subfield><subfield code="a">MacFadden, Fred R.</subfield><subfield code="t">Database management</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">GBV Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=006357663&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-006357663</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">3\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield></record></collection> |
| genre | 1\p (DE-588)4123623-3 Lehrbuch gnd-content |
| genre_facet | Lehrbuch |
| id | DE-604.BV009619569 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T17:38:03Z |
| institution | BVB |
| isbn | 0805360476 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-006357663 |
| oclc_num | 28708791 |
| open_access_boolean | |
| owner | DE-29T DE-11 |
| owner_facet | DE-29T DE-11 |
| physical | XXV, 597 S. graph. Darst. |
| publishDate | 1994 |
| publishDateSearch | 1994 |
| publishDateSort | 1994 |
| publisher | Benjamin/Cummings |
| record_format | marc |
| spelling | McFadden, Fred R. Verfasser aut Modern database management Fred R. McFadden ; Jeffrey A. Hoffer 4. ed. Redwood City, Calif. u.a. Benjamin/Cummings 1994 XXV, 597 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Databanken gtt Database management Organisation (DE-588)4043774-7 gnd rswk-swf Datenbank (DE-588)4011119-2 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf Datenbanksystem (DE-588)4113276-2 gnd rswk-swf 1\p (DE-588)4123623-3 Lehrbuch gnd-content Datenbank (DE-588)4011119-2 s Datenbanksystem (DE-588)4113276-2 s Organisation (DE-588)4043774-7 s 2\p DE-604 Datenbankverwaltung (DE-588)4389357-0 s 3\p DE-604 Hoffer, Jeffrey A. Verfasser aut Bis 3. Auflage MacFadden, Fred R. Database management GBV Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=006357663&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 2\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 3\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | McFadden, Fred R. Hoffer, Jeffrey A. Modern database management Databanken gtt Database management Organisation (DE-588)4043774-7 gnd Datenbank (DE-588)4011119-2 gnd Datenbankverwaltung (DE-588)4389357-0 gnd Datenbanksystem (DE-588)4113276-2 gnd |
| subject_GND | (DE-588)4043774-7 (DE-588)4011119-2 (DE-588)4389357-0 (DE-588)4113276-2 (DE-588)4123623-3 |
| title | Modern database management |
| title_auth | Modern database management |
| title_exact_search | Modern database management |
| title_full | Modern database management Fred R. McFadden ; Jeffrey A. Hoffer |
| title_fullStr | Modern database management Fred R. McFadden ; Jeffrey A. Hoffer |
| title_full_unstemmed | Modern database management Fred R. McFadden ; Jeffrey A. Hoffer |
| title_old | MacFadden, Fred R. Database management |
| title_short | Modern database management |
| title_sort | modern database management |
| topic | Databanken gtt Database management Organisation (DE-588)4043774-7 gnd Datenbank (DE-588)4011119-2 gnd Datenbankverwaltung (DE-588)4389357-0 gnd Datenbanksystem (DE-588)4113276-2 gnd |
| topic_facet | Databanken Database management Organisation Datenbank Datenbankverwaltung Datenbanksystem Lehrbuch |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=006357663&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT mcfaddenfredr moderndatabasemanagement AT hofferjeffreya moderndatabasemanagement |