The practitioner's blueprint for logical and physical database design:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Englewood Cliffs, NJ
Prentice-Hall
1986
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XIII, 317 S. graph. Darst. |
| ISBN: | 0136942679 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV002301288 | ||
| 003 | DE-604 | ||
| 005 | 20130722 | ||
| 007 | t | ||
| 008 | 890928s1986 d||| |||| 00||| eng d | ||
| 020 | |a 0136942679 |9 0-13-694267-9 | ||
| 035 | |a (OCoLC)12810371 | ||
| 035 | |a (DE-599)BVBBV002301288 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-91 |a DE-739 | ||
| 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 651f |2 stub | ||
| 100 | 1 | |a Vesely, Eric G. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a The practitioner's blueprint for logical and physical database design |c Eric Garrigue Veseley |
| 264 | 1 | |a Englewood Cliffs, NJ |b Prentice-Hall |c 1986 | |
| 300 | |a XIII, 317 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a Database design | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a System design | |
| 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 Datenbank |0 (DE-588)4011119-2 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 1 | |5 DE-604 | |
| 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=001512405&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-001512405 | ||
Datensatz im Suchindex
| _version_ | 1804116762142179328 |
|---|---|
| adam_text | The Practitioner s
Blueprint For Logical
and Physical
Database Design
Eric Garrigue Vesely
Principal, The Analyst Workbench
Visiting Lecturer, Institute of Systems Science
National University of Singapore
PRENTICE-HALL, Englewood Cliffs, NJ 07632
Contents
Foreword
Acknowledgments
Caveat
XII
xiii
xiv
Chapter 1 Overview of Design Philosophy
Logical Database 1
Physical Database 7
Summary 9
Chapter 2 Design Philosophy Rationale
Data Correctness 11
Data Security 11
Minimal Cover 11
User Views 12
Stable Portable Logical Database 12
Responsive Physical Database 12
Data Independence 12
v
vi Contents
Application Independence 13
Elimination of Programmer Navigation 13
Logical Records 14
Fourth-Generation Languages 14
Real Dollar Savings 15
Summary 15
Chapter 3 Defining the Application Boundary 16
Definition 16
Entity Diagram 16
User Verification
Automated Tools
Summary 18
Chapter 4
Definition 19
New Applications
Existing Programs
Summary 35
Chapter 5
Definition 36
All Input Data Elements Are Used 36
Forgotten Data Elements (User Verification) 42
Existing Cobol Programs 43
Automated Tools 43
Summary 43
Chapter 6 Entity Type Analysis 44
Definition 44
Identification 45
Data Diagrams 45
Existing Programs 46
Automated Tools 47
The subtle Trap 47
Summary 47
Data Collection 19
Data Verification 36
Contents
Chapter 7 Data Clustering
Definition 48
Global Assignment by Entity Type 48
Automated Tools 52
Summary 52
Chapter 8 Normalization
Definition 53
Codd Relational Notation 53
First Normal Form 54
Second Normal Form 63
Third Normal Form 73
Fourth Normal Form 80
The Practical Way to Perform Normalization 88
Automated Tools 90
Caveat 90
Chapter 9 Optimization
Definition 91
Identical Keys 91
The Failure to Combine 92
Subset/Superset 93
The Actual Combination Process 93
The Hidden Key Problem Revisited 93
Automated Tools 95
Chapter 10 Generalization
Definition 96
Reducing Data Element Names to Generic Names
Combining Relations with Identical Generic Keys
Role Identification 98
Determining the Primary Key 98
Nonunique Roles 99
Should Generalization Be Performed? 100
Summary 101
Automated Tools 101
viii Contents
Chapter 11 Blueprint for Devising the Logical
Database 102
Chapter 12 Graphic Models 104
Definition 104
Types 104
Converting Relational Notation to a Graphic Model 106
Automated Tools 118
Chapter 13 Foreign Keys 119
Definition 119
Identifying Foreign Keys 119
Augmenting Grahic Model 120
Identifying Subsets of Foreign Keys 120
Automated Tools 121
Chapter 14 Secondary Keys 122
Definition 122
Deriving Secondary Keys 122
Determining Value and Priority of Secondary Keys 123
Augmenting Graphic Model 123
Identifying Subsets of Secondary Keys 124
Automated Tools 124
Summary 124
Chapter 15 Logical Records 125
Definition 125
Deriving Logical Records 126
Automated Tools 128
Summary 129
Chapter 16 Logical Database Verification 130
Definition 130
Relational Algebra 130
Revisiting the Graphic Model 136
Usability Operators 137
Semantic Disintegrity 137
Contents ix
Relational Calculus 137
Automated Tools 138
Chapter 17 Statistical Information 139
Definition 139
Table Information 139
Transaction Path 140
Augmenting Graphic Model 142
Automated Tools 1 42
Chapter 18 The Logical Database 143
Definition 143
Stable 144
Advantages 145
Portable 145
Dual DBMS Strategy 145
User Views 146
Automated Tools 146
Summary 146
Chapter 19 The Role of the Data Dictionary
in Logical Database Design 147
Definition 147
Types 147
Data Element (Attribute) Naming Standards 151
Automated Tools 158
Chapter 20 Physical Database 159
Definition 159
Physical Types 165
Pointers 168
Components 169
Classification of Selected DBMSs 170
Chapter 21 First-Cut Executable Physical Model 186
Definition 186
General Rules for Converting Logical Database to Physical
Storage Types 186
Automated Tools 194
X Contents
Chapter 22 Response Timing of Logical Records
and Transactions 196
Definition 196
Dynamic Logical Database 196
Logical Records 197
Logical Transaction Paths 197
System Values 197
Page Blocking 197
Results 197
Automated Tools 200
Chapter 23 Skewing Physical Model to Achieve
User Response Requirements 201
Definition 201
Basic Skewing Rules 201
What If Modeling 203
Automated Tools 203
Chapter 24 Eliminating Programmer Navigation 204
Definition 204
Rationale 204
Implementaion 205
Caveat 205
Summary 206
Chapter 25 Summary 207
Appendix A Class Scheduling Application
of Logic University 209
Appendix B Additional Reading Material Provided
by Vendors 211
JSD Technical Summary (Michael
Jackson Systems Ltd ) 213
PSL/PSA: An Information Modeling
Tool (Hasan H Sayani) 225
Entity Multityping (Ken Winter
Database Design) 235
Contents xi
Programming Machine/Standard
Solutions: Application 4—Data Name
Rationalization and Building the Data
Dictionary (Adpac Corp ) 240
A Data Element Naming Convention
(Jim Odell) 260
DATA DESIGNER User Guide
Introduction (Database Design,
Inc ) 264
A Database Design and Evaluation
Workbench: Preliminary Report
(Computer Corporation of
America) 268
Appendix C Vendor List 276
Glossary 278
Bibliography 308
Index 313
|
| any_adam_object | 1 |
| author | Vesely, Eric G. |
| author_facet | Vesely, Eric G. |
| author_role | aut |
| author_sort | Vesely, Eric G. |
| author_variant | e g v eg egv |
| building | Verbundindex |
| bvnumber | BV002301288 |
| 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 651f |
| ctrlnum | (OCoLC)12810371 (DE-599)BVBBV002301288 |
| 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>01521nam a2200421 c 4500</leader><controlfield tag="001">BV002301288</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20130722 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">890928s1986 d||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0136942679</subfield><subfield code="9">0-13-694267-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)12810371</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV002301288</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-91</subfield><subfield code="a">DE-739</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 651f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Vesely, Eric G.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">The practitioner's blueprint for logical and physical database design</subfield><subfield code="c">Eric Garrigue Veseley</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">XIII, 317 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="4"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">System design</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">Datenbank</subfield><subfield code="0">(DE-588)4011119-2</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">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</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=001512405&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-001512405</subfield></datafield></record></collection> |
| id | DE-604.BV002301288 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T15:43:39Z |
| institution | BVB |
| isbn | 0136942679 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-001512405 |
| oclc_num | 12810371 |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM DE-739 |
| owner_facet | DE-91 DE-BY-TUM DE-739 |
| physical | XIII, 317 S. graph. Darst. |
| publishDate | 1986 |
| publishDateSearch | 1986 |
| publishDateSort | 1986 |
| publisher | Prentice-Hall |
| record_format | marc |
| spelling | Vesely, Eric G. Verfasser aut The practitioner's blueprint for logical and physical database design Eric Garrigue Veseley Englewood Cliffs, NJ Prentice-Hall 1986 XIII, 317 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Database design Database management System design Datenbank (DE-588)4011119-2 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 gnd rswk-swf Datenbank (DE-588)4011119-2 s DE-604 Datenbankentwurf (DE-588)4127613-9 s HEBIS Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=001512405&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Vesely, Eric G. The practitioner's blueprint for logical and physical database design Database design Database management System design Datenbank (DE-588)4011119-2 gnd Datenbankentwurf (DE-588)4127613-9 gnd |
| subject_GND | (DE-588)4011119-2 (DE-588)4127613-9 |
| title | The practitioner's blueprint for logical and physical database design |
| title_auth | The practitioner's blueprint for logical and physical database design |
| title_exact_search | The practitioner's blueprint for logical and physical database design |
| title_full | The practitioner's blueprint for logical and physical database design Eric Garrigue Veseley |
| title_fullStr | The practitioner's blueprint for logical and physical database design Eric Garrigue Veseley |
| title_full_unstemmed | The practitioner's blueprint for logical and physical database design Eric Garrigue Veseley |
| title_short | The practitioner's blueprint for logical and physical database design |
| title_sort | the practitioner s blueprint for logical and physical database design |
| topic | Database design Database management System design Datenbank (DE-588)4011119-2 gnd Datenbankentwurf (DE-588)4127613-9 gnd |
| topic_facet | Database design Database management System design Datenbank Datenbankentwurf |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=001512405&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT veselyericg thepractitionersblueprintforlogicalandphysicaldatabasedesign |