The dynamics of data base:
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Englewood Cliffs, NJ
Prentice-Hall
1986
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XVII, 395 S. |
| ISBN: | 0132214741 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV002290659 | ||
| 003 | DE-604 | ||
| 005 | 20130613 | ||
| 007 | t | ||
| 008 | 890928s1986 |||| 00||| eng d | ||
| 020 | |a 0132214741 |9 0-13-221474-1 | ||
| 035 | |a (OCoLC)12587068 | ||
| 035 | |a (DE-599)BVBBV002290659 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-91G |a DE-739 |a DE-19 |a DE-83 | ||
| 050 | 0 | |a QA76.9.D3 | |
| 082 | 0 | |a 005.74 |2 19 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 084 | |a DAT 650f |2 stub | ||
| 100 | 1 | |a Inmon, William H. |d 1945- |e Verfasser |0 (DE-588)113317662 |4 aut | |
| 245 | 1 | 0 | |a The dynamics of data base |c W. H. Inmon ; Thomas J. Bird |
| 264 | 1 | |a Englewood Cliffs, NJ |b Prentice-Hall |c 1986 | |
| 300 | |a XVII, 395 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a Bases de données - Gestion | |
| 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 Datenbankentwurf |0 (DE-588)4127613-9 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a Datenbank |0 (DE-588)4011119-2 |D s |
| 689 | 1 | 1 | |a Organisation |0 (DE-588)4043774-7 |D s |
| 689 | 1 | |5 DE-604 | |
| 700 | 1 | |a Bird, Thomas J. |e Verfasser |4 aut | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=001505273&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-001505273 | ||
Datensatz im Suchindex
| _version_ | 1804116750334164992 |
|---|---|
| adam_text | THE DYNAMICS OF DATA BASE
W H Inmon
Coopers amp; Lybrand
Thomas J Bird, Jr
Innovative Designs
PRENTICE-HALL
Englewood Cliffs, New Jersey 07632
Contents
PREFACE xv
SECTION I
Basic Concepts
Chapter 1
THE DATA BASE ENVIRONMENT 2
Data Base Media, 4
DASD, Tapes, and Main Storage, 6
Optical Disk, 8
Data Base Environments, 9
The Operational Environment, 10
Operational Online, 10
Operational Environment—Batch, 13
Operational Environment—Mixed Online/Batch, 16
Operational Environments—Time-Sharing, 17
Decision Support Environment, 17
Decision Support Environment—Query, 19
Decision Support Environment—Relational, 19
Decision Support Environment—Inverted List, 20
Operational to DSS Download, 20
Questions, 21
Exercises, 22
vii
Chapter 2
BASIC CONCEPTS AND BASIC OPERATIONS 23
Data Transfer, 24
Activity Types, 27
Data Transfer to the Programmer, 28
Storage and Transfer Trade-offs, 33
KEYS, 34
Encryption, 35
Data Base Across Different Modes of Operation, 36
Operational Mode of Operation, 36
DSS Mode of Operation, 36
Archival Mode of Operation, 37
Development Mode of Operation, 37
Data Base Practices, 37
Truth Data Base Approach, 38
Dual Data Base Approach, 39
Summary, 40
Questions, 41
Exercises, 44
Chapter 3
DATA MANAGEMENT 45
Randomization, 43
DASD Space Available, 46
Randomization: Other Factors, 48
Randomization: Overflow, 51
Average Record Size: Variations, 54
Indexing, 56
DBMS, 56
Insertion/Deletion in an Indexed Data Base, 60
Duplicate Index Entries, 63
Hashed Indexes, 66
Single Record Blocks, 66
Alternate Indexing, 67
Indexing Randomized Data, 69
Summary, 69
Questions, 70
Exercises, 71
Chapter 4
DATA STRUCTURING 72
Hierarchical Model, 73
Inverted Data Structures, 74
Network Structure, 77
The Relational Model, 78
viii Contents
Addressing, 82
Direct Addressing, 82
Symbolic Addressing, 83
Combining Symbolic and Direct Pointers, 84
CONTENT ADDRESSABLE MEMORY, 85
Address Insertion, Deletion, 86
Higher Level Structuring, 87
Accessing Data, 89
Implied Ordering of Data Through Physical Structuring, 91
Summary, 94
Questions, 94
Exercises, 95
Chapter 5
PROGRAM EXECUTION 96
Batch Programs, 97
Online Execution of a Program, 102
Interactive Program Execution, 104
Data Base asnd Teleprocessing, 105
Online Usage of CRT, 106
Interactive Usage of CRT, 110
DEADLY EMBRACE, 116
Microprocessor Usage of CRT, 117
Syntax, 123
Data Manipulation Syntax, 123
Language and I/O, 124
Record/Set Retrievals, 124
Procedural Data Base Processing, 125
Data Definition Syntax, 130
Summary, 131
Questions, 132
Exercises, 133
Chapter 6
UTILITIES 136
Data Base Initialization, 136
Data Base Recovery, 137
Data Base Reorganization, 138
Data Base Monitoring, 141
UTILITIES: VENDOR OR INDEPENDENT SUPPLIED?, 142
The Reorganization/Recovery Environment, 143
Summary, 145
Questions, 145
Exercises, 146
Contents ix
Chapter 7
MISCELLANEOUS TOPICS 148
Integrity, 151
SELECTING A DBMS, 153
Testing, 157
Tuning, 160
Data Dictionary, 160
Questions, 161
Exercises, 162
Chapter 8
DATA BASE DESIGN 164
Different Levels of Modeling, 168
Components of Modeling, 168
Scope of Integration, 169
Dimension, 170
Data Views, 171
Entities and Relationships, 172
Definitions, 174
Midlevel Modeling, 175
Physical Model, 176
NORMALIZATION, 180
Marrying the Physical Data Model and the Process Model, 183
Using the Blueprint, 183
Physical Data Base Design, 183
General Physical Issues, 185
Operational Data Base Design, 186
Online Data Base Design, 187
Performance, 188
Online Transaction Design, 188
Data Base Design for Online Performance, 190
Data Occurrences, 190
Control Data Bases, 194
DESIGN REVIEW, 198
Application Blocking of Data, 200
General Structural Overhead, 204
Data Driven Processes, 205
General Misuse of a DBMS, 207
Proper Use of an Alternate Index, 208
Data Base Design for Availability, 208
DSS Data Base Design, 209
DSS Systems: Data Sources, 210
Information Systems Architecture and DSS Data Base Design, 211
Some DSS Specific Design Practices, 212
Summary, 213
Questions, 213
Exercises, 216
Contents
Chapter 9
DATA BASE MACHINES 218
Conventional DBMS Architecture, 219
The Communications Processor Analogy, 226
Data Base Machine DBMS Architecture, 227
Data Base Management Processor, 229
Associative Data Processor, 241
Questions, 241
Chapter 10
DISTRIBUTED DATA BASES 243
Distributed Data Base Defined, 245
Reasons for Distributing Data, 248
Scope of Distribution, 249
Terminology, 249
Inquiry Processing, 254
Update Processing, 257
Questions, 260
SECTION II
Specific DBMS Examples
Chapter 11
PRODUCTION SYSTEMS: IMS 264
Hierarchical Structures, 264
Data Base Records, 265
Segments, 267
Pointers, 270
FAST PATH, 270
Overflow, 271
Block Location, 271
Explicit Relationships, 272
DBDGEN, 274
Anatomy of a Data Base Call, 276
Call Syntax, 277
Segment Search Arguments, 279
Data Base Calls, 279
Modes of Operation, 284
Online Concepts, 286
Contents xi
Chapter 12
INVERTED FILE SYSTEM: MODEL 204 287
Table Level, 287
Record/Page Level, 289
Index Level, 290
Model 204 Design Options, 293
Updating in Model 204, 298
Building a Model 204 Data Base, 298
Model 204 Language Facilities, 302
Other Language Features, 307
Model 204 Systems Considerations, 307
Chapter 13
DECISION SUPPORT SYSTEMS: SQL 308
Physical Implementation, 308
Relational Operators, 312
User Views, 319
Physical Underpinnings of Relational Operators, 319
SQL at the System Level, 322
Chapter 14
FOURTH-GENERATION SYSTEMS: FOCUS 323
Data Base Manager, 324
Query/Update Language, 328
Report Writing and Graphics, 329
Decision Support Functions, 330
Chapter 15
DISTRIBUTED DATA BASE SYSTEMS: CICS/ISC R* 333
CICS/ISC, 333
R* 337
Chapter 16
dBASE II: A DBMS BY ASHTON-TATE FOR MICROPROCESSORS 340
Differences, 340
Similarities, 342
Using dBASE II, 342
xii Contents
SECTION III
Data Base Tutorial
Chapter 17
TUTORIAL DESCRIPTION 346
The Production Control/Shipping Interface Problem, 346
Functions, 348
Initial Load, 350
Data Insertion, 352
Data Manipulation, 354
Reports, 356
Data Integrity, 356
Archival Data, 357
Chapter 18
IMS TUTORIAL 358
Environmental Definition, 358
Data Base Identification, 359
Data Base Definition, 360
Transaction Definition, 362
BMP, 363
Batch Processing, 363
Implementation and Integration, 363
Chapter 19
MODEL 204 TUTORIAL 364
Chapter 20
SQL TUTORIAL 367
Chapter 21
FOCUS TUTORIAL 370
Contents xiii
BIBLIOGRAPHY 372
A General Data Base Bibliography, 372
Data Base Machines, 373
Relational Systems, 373
Model 204, 373
IMS, 374
DATA BASE GLOSSARY 375
IMS Terms, 386
Model 204 Terms, 386
INDEX 389
xiv Contents
|
| any_adam_object | 1 |
| author | Inmon, William H. 1945- Bird, Thomas J. |
| author_GND | (DE-588)113317662 |
| author_facet | Inmon, William H. 1945- Bird, Thomas J. |
| author_role | aut aut |
| author_sort | Inmon, William H. 1945- |
| author_variant | w h i wh whi t j b tj tjb |
| building | Verbundindex |
| bvnumber | BV002290659 |
| 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 |
| classification_tum | DAT 650f |
| ctrlnum | (OCoLC)12587068 (DE-599)BVBBV002290659 |
| 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 |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01656nam a2200445 c 4500</leader><controlfield tag="001">BV002290659</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20130613 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">890928s1986 |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0132214741</subfield><subfield code="9">0-13-221474-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)12587068</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV002290659</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-91G</subfield><subfield code="a">DE-739</subfield><subfield code="a">DE-19</subfield><subfield code="a">DE-83</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">19</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="084" ind1=" " ind2=" "><subfield code="a">DAT 650f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Inmon, William H.</subfield><subfield code="d">1945-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)113317662</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">The dynamics of data base</subfield><subfield code="c">W. H. Inmon ; Thomas J. Bird</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Englewood Cliffs, NJ</subfield><subfield code="b">Prentice-Hall</subfield><subfield code="c">1986</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVII, 395 S.</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="4"><subfield code="a">Bases de données - Gestion</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">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" 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="1" ind2="1"><subfield code="a">Organisation</subfield><subfield code="0">(DE-588)4043774-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Bird, Thomas J.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS 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=001505273&sequence=000002&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-001505273</subfield></datafield></record></collection> |
| id | DE-604.BV002290659 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T15:43:28Z |
| institution | BVB |
| isbn | 0132214741 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-001505273 |
| oclc_num | 12587068 |
| open_access_boolean | |
| owner | DE-91G DE-BY-TUM DE-739 DE-19 DE-BY-UBM DE-83 |
| owner_facet | DE-91G DE-BY-TUM DE-739 DE-19 DE-BY-UBM DE-83 |
| physical | XVII, 395 S. |
| publishDate | 1986 |
| publishDateSearch | 1986 |
| publishDateSort | 1986 |
| publisher | Prentice-Hall |
| record_format | marc |
| spelling | Inmon, William H. 1945- Verfasser (DE-588)113317662 aut The dynamics of data base W. H. Inmon ; Thomas J. Bird Englewood Cliffs, NJ Prentice-Hall 1986 XVII, 395 S. txt rdacontent n rdamedia nc rdacarrier Bases de données - Gestion Database management Organisation (DE-588)4043774-7 gnd rswk-swf Datenbank (DE-588)4011119-2 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 s DE-604 Datenbank (DE-588)4011119-2 s Organisation (DE-588)4043774-7 s Bird, Thomas J. Verfasser aut HEBIS Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=001505273&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Inmon, William H. 1945- Bird, Thomas J. The dynamics of data base Bases de données - Gestion Database management Organisation (DE-588)4043774-7 gnd Datenbank (DE-588)4011119-2 gnd Datenbankentwurf (DE-588)4127613-9 gnd |
| subject_GND | (DE-588)4043774-7 (DE-588)4011119-2 (DE-588)4127613-9 |
| title | The dynamics of data base |
| title_auth | The dynamics of data base |
| title_exact_search | The dynamics of data base |
| title_full | The dynamics of data base W. H. Inmon ; Thomas J. Bird |
| title_fullStr | The dynamics of data base W. H. Inmon ; Thomas J. Bird |
| title_full_unstemmed | The dynamics of data base W. H. Inmon ; Thomas J. Bird |
| title_short | The dynamics of data base |
| title_sort | the dynamics of data base |
| topic | Bases de données - Gestion Database management Organisation (DE-588)4043774-7 gnd Datenbank (DE-588)4011119-2 gnd Datenbankentwurf (DE-588)4127613-9 gnd |
| topic_facet | Bases de données - Gestion Database management Organisation Datenbank Datenbankentwurf |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=001505273&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT inmonwilliamh thedynamicsofdatabase AT birdthomasj thedynamicsofdatabase |