Verfügbarkeit: Modern database management | Technische Universität München

Modern database management:

Gespeichert in:

Bibliographische Detailangaben
Vorheriger Titel:	MacFadden, Fred R. Database management
Beteiligte Personen:	McFadden, Fred R. (VerfasserIn), Hoffer, Jeffrey A. (VerfasserIn)
Format:	Buch
Sprache:	Englisch
Veröffentlicht:	Redwood City, Calif. u.a. Benjamin/Cummings 1994
Ausgabe:	4. ed.
Schlagwörter:	Databanken Database management Organisation Datenbank Datenbankverwaltung Datenbanksystem Lehrbuch
Links:	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
Umfang:	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 xx 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
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
943	1		\|a oai:aleph.bib-bvb.de:BVB01-006357663

Datensatz im Suchindex

_version_	1819324155363852288
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 YRI 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 RRI 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 ^RI 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 MTXI 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 » RI 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 ACODD S 12 RULES FOR A TRULY RELATIONAL SYSTEM 567 BAN 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>02153nam 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 xx 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="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><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-006357663</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-12-20T09:39:20Z
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
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

Verfügbarkeit

‌

Inhaltsverzeichnis