Inside relational databases with examples in Access:
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
[London]
Springer
2007
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XIV, 371 S. |
| ISBN: | 1846283949 9781846283949 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV021998326 | ||
| 003 | DE-604 | ||
| 005 | 20070531 | ||
| 007 | t | ||
| 008 | 061019s2007 |||| 00||| eng d | ||
| 020 | |a 1846283949 |9 1-84628-394-9 | ||
| 020 | |a 9781846283949 |9 978-1-84628-394-9 | ||
| 035 | |a (OCoLC)70987390 | ||
| 035 | |a (DE-599)BVBBV021998326 | ||
| 040 | |a DE-604 |b ger | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-706 |a DE-1051 |a DE-573 | ||
| 050 | 0 | |a QA76.9.D32 | |
| 082 | 0 | |a 005.7565 |2 22 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 100 | 1 | |a Whitehorn, Mark |d 1953- |e Verfasser |0 (DE-588)115568719 |4 aut | |
| 245 | 1 | 0 | |a Inside relational databases with examples in Access |c Mark Whitehorn and Bill Marklyn |
| 264 | 1 | |a [London] |b Springer |c 2007 | |
| 300 | |a XIV, 371 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 630 | 0 | 4 | |a Microsoft Access |
| 650 | 4 | |a Relational databases | |
| 650 | 0 | 7 | |a Relationale Datenbank |0 (DE-588)4049358-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Access 2007 |0 (DE-588)7564284-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Relationale Datenbank |0 (DE-588)4049358-1 |D s |
| 689 | 0 | 1 | |a Access 2007 |0 (DE-588)7564284-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Marklyn, Bill |d 1960- |e Verfasser |0 (DE-588)115568735 |4 aut | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015212954&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-015212954 | ||
Datensatz im Suchindex
| _version_ | 1804135973368365056 |
|---|---|
| adam_text | Contents
Preface xiii
Chapter 1 • Introduction 1
Who are we? 1
What is a database? 2
Databases vs. Database Management Systems 3
Relational Database Management Systems 3
Why this book? 4
Who should read this book? 5
Organization of the book 6
Some ground rules 7
Downloading files from the Website 8
Acknowledgements 8
We don t have problems ... 9
Outroduction 9
Part 1 A simple, single table database 11
Chapter 2 • Introduction to Part 1 13
Tables 13
Queries/Views 14
Forms 14
Reports 15
Chapter 3 • Tables 17
Rows columns records fields 18
Building a table 22
Types of data 23
Meaningful operations 24
Excluding certain errors 26
Making storage more efficient 26
Making data recall more rapid 28
Field size 28
General notes on table design 29
Chapter 4 • Queries/Views 36
Queries usually find subsets of the data 36
Queries, answer tables and base tables finally defined properly
and closure mentioned briefly 37
Summarizing data 42
Other useful queries 42
Graphical querying tools 43
SQL and Views 44
Chapter 5 • Forms 45
Multiple forms per table 48
Text boxes can be made read only 49
Text boxes don t have to present data from just one field 49
It isn t necessary for each field in a table to appear on the form 51
Controlling data entry 51
Use of forms can be controlled 51
Forms can be web pages 51
Summary 52
Chapter 6 • Reports 54
Chapter 7 • Summary of Part 1 56
Part 2 A multi table database 59
Chapter 8 • Introduction to Part 2 61
Chapter 9 • Serious problems with Single tables 62
Redundant data 63
Typographical errors 63
Modifying data 64
Summary 65
Chapter 10 • Multiple tables eure serious problems 67
Redundant data 69
Typographical errors 72
Modifying data 72
Chapter 11 • Making multiple tables work together 73
Databases are designed to model the real world 74
Chapter 12 • Getting the data into the correct tables 75
Not normalization (and not ER modeling either) 77
Object identification 78
Chapter 13 • Relationships in the real world 81
One to many 81
One to one 82
Many to many 82
None 82
Mapping real world relationships to tables 83
Chapter 14 • How are relationships modeled? 84
Primary keys 86
Foreign keys 91
Summary so far 92
Joins 93
General lessons about joins 106
Chapter 15 • Revisiting the big four the synergy begins 112
Closure 112
Tables 115
Queries (and a bit on forms) 116
Forms 123
Reports 124
Chapter 16 • Integrity 127
Data integrity is it worth the effort? 127
Types of data integrity error (and some eures) 128
Declarative and procedural referential integrity 134
Nulls in foreign keys 139
These options in context 142
Other integrity issues 143
Integrity where should you set it? 143
Chapter 17« Summary of Part 2 146
Part 3 Database Design Architecture 147
Chapter 18 • Database design 149
Designing databases user, logical and physical modeis 149
The Logical model overview 151
More about the logical model 152
CASE tools 154
Summary so far 158
The final big advantage of CASE tools 158
More about the differences between the Logical and Physical
modeis 160
Reality check 162
Normalization can help 162
Reverse engineering 163
Methodologies 164
Summary of design modeis 164
Chapter 19 • The seven layers of wisdom 165
The seven layers of wisdom 165
Chapter 20 • Database architecture 168
Default Architecture in Access 168
Access PC front end data on file Server 168
Client server (or two tier) architecture 171
Three tier architecture (also known as multi tier) 173
Web based applications 174
Choosing a database architecture 176
What comes next 177
Part 4 Related database topics 179
Chapter 21 • What exactly is a relational database? 181
Do multiple tables a relational database make? 181
Chapter 22 Triggers and stored procedures 183
Triggers 183
Stored procedures 187
Summary triggers and stored procedures 189
Chapter 23 • Transactions, logs, backup, locking and
concurrency 190
Transactions 190
Logs 191
Locking 197
Concurrency 199
Row locking and page locking 199
Access and the features described in this chapter 200
Answers from earlier 200
Chapter 24 • Codd s rules 201
Codd s rules 201
Economy vs. readability 201
A little background 202
The rules themselves 202
Summary 213
Chapter 25 • Normalization 215
A first look at normalization 215
First normal form (first level of normalization): INF 216
Second normal form (second level of normalization): 2NF 218
Third normal form (third level of normalization): 3NF 220
Summary so far 221
Adding some definitions 222
Summary (again) 231
Chapter 26 • More about normalization 233
Higher normal forms 233
Normalization doesn t automatically remove all
redundancy 237
Summary 242
Chapter 27 • The System tables 244
Chapter 28 • More on queries: data manipulation 246
Relational Operators 246
Summary 256
Chapter 29 • SQL 258
SELECT and FROM 261
DISTINCT 262
WHERE 262
Conditions 263
ORDER BY 267
Wildcards 270
Sub queries 271
Built in functions 272
GROUP BY collecting Information 276
GROUP BY...HAVING collecting specific information 282
Working with multiple tables 285
Inner (Natural) joins 290
Outer joins 291
UNION 293
SELECT summary 296
INSERT 297
UPDATE 300
DELETE 302
A question (and a free SQL diagnostic tool) 303
Summary 306
Chapter 30 • Domains 307
Chapter 31 • What does null mean? 309
Chapter 32 • Primary keys 313
Candidate keys 315
Part 5 Speeding up your database 317
Chapter 33 • Hardware considerations 319
CPUs 320
Memory 320
Disks 322
Data volume vs. disk capacity 322
Don t put all your eggs in one basket 323
Chapter 34 • Indexing 324
Indexing techniques 324
Applying indexes which fields/columns should be
indexed? 333
Intelligent use of indexes 337
Chapter 35 • More on optimization 338
Query optimization 338
Update statistics 339
Query analysis 340
Writing good SQL code 342
Chapter 36 • Denormalization 344
Mirroring tables 345
Splitting tables 346
Redundant data 348
Repeating groups (breaking INF) 349
Derived columns 351
Summary 352
Appendix 1 • GUIs, macros and control languages 353
Creating a very simple user interface 353
Other languages SQL 362
Index 365
|
| adam_txt |
Contents
Preface xiii
Chapter 1 • Introduction 1
Who are we? 1
What is a database? 2
Databases vs. Database Management Systems 3
Relational Database Management Systems 3
Why this book? 4
Who should read this book? 5
Organization of the book 6
Some ground rules 7
Downloading files from the Website 8
Acknowledgements 8
We don't have problems . 9
Outroduction 9
Part 1 A simple, single table database 11
Chapter 2 • Introduction to Part 1 13
Tables 13
Queries/Views 14
Forms 14
Reports 15
Chapter 3 • Tables 17
Rows columns records fields 18
Building a table 22
Types of data 23
Meaningful operations 24
Excluding certain errors 26
Making storage more efficient 26
Making data recall more rapid 28
Field size 28
General notes on table design 29
Chapter 4 • Queries/Views 36
Queries usually find subsets of the data 36
Queries, answer tables and base tables finally defined properly
and closure mentioned briefly 37
Summarizing data 42
Other useful queries 42
Graphical querying tools 43
SQL and Views 44
Chapter 5 • Forms 45
Multiple forms per table 48
Text boxes can be made read only 49
Text boxes don't have to present data from just one field 49
It isn't necessary for each field in a table to appear on the form 51
Controlling data entry 51
Use of forms can be controlled 51
Forms can be web pages 51
Summary 52
Chapter 6 • Reports 54
Chapter 7 • Summary of Part 1 56
Part 2 A multi table database 59
Chapter 8 • Introduction to Part 2 61
Chapter 9 • Serious problems with Single tables 62
Redundant data 63
Typographical errors 63
Modifying data 64
Summary 65
Chapter 10 • Multiple tables eure serious problems 67
Redundant data 69
Typographical errors 72
Modifying data 72
Chapter 11 • Making multiple tables work together 73
Databases are designed to model the real world 74
Chapter 12 • Getting the data into the correct tables 75
Not normalization (and not ER modeling either) 77
Object identification 78
Chapter 13 • Relationships in the real world 81
One to many 81
One to one 82
Many to many 82
None 82
Mapping real world relationships to tables 83
Chapter 14 • How are relationships modeled? 84
Primary keys 86
Foreign keys 91
Summary so far 92
Joins 93
General lessons about joins 106
Chapter 15 • Revisiting the big four the synergy begins 112
Closure 112
Tables 115
Queries (and a bit on forms) 116
Forms 123
Reports 124
Chapter 16 • Integrity 127
Data integrity is it worth the effort? 127
Types of data integrity error (and some eures) 128
Declarative and procedural referential integrity 134
Nulls in foreign keys 139
These options in context 142
Other integrity issues 143
Integrity where should you set it? 143
Chapter 17« Summary of Part 2 146
Part 3 Database Design Architecture 147
Chapter 18 • Database design 149
Designing databases user, logical and physical modeis 149
The Logical model overview 151
More about the logical model 152
CASE tools 154
Summary so far 158
The final big advantage of CASE tools 158
More about the differences between the Logical and Physical
modeis 160
Reality check 162
Normalization can help 162
Reverse engineering 163
Methodologies 164
Summary of design modeis 164
Chapter 19 • The seven layers of wisdom 165
The seven layers of wisdom 165
Chapter 20 • Database architecture 168
Default Architecture in Access 168
Access PC front end data on file Server 168
Client server (or two tier) architecture 171
Three tier architecture (also known as multi tier) 173
Web based applications 174
Choosing a database architecture 176
What comes next 177
Part 4 Related database topics 179
Chapter 21 • What exactly is a relational database? 181
Do multiple tables a relational database make? 181
Chapter 22 Triggers and stored procedures 183
Triggers 183
Stored procedures 187
Summary triggers and stored procedures 189
Chapter 23 • Transactions, logs, backup, locking and
concurrency 190
Transactions 190
Logs 191
Locking 197
Concurrency 199
Row locking and page locking 199
Access and the features described in this chapter 200
Answers from earlier 200
Chapter 24 • Codd's rules 201
Codd's rules 201
Economy vs. readability 201
A little background 202
The rules themselves 202
Summary 213
Chapter 25 • Normalization 215
A first look at normalization 215
First normal form (first level of normalization): INF 216
Second normal form (second level of normalization): 2NF 218
Third normal form (third level of normalization): 3NF 220
Summary so far 221
Adding some definitions 222
Summary (again) 231
Chapter 26 • More about normalization 233
Higher normal forms 233
Normalization doesn't automatically remove all
redundancy 237
Summary 242
Chapter 27 • The System tables 244
Chapter 28 • More on queries: data manipulation 246
Relational Operators 246
Summary 256
Chapter 29 • SQL 258
SELECT and FROM 261
DISTINCT 262
WHERE 262
Conditions 263
ORDER BY 267
Wildcards 270
Sub queries 271
Built in functions 272
GROUP BY collecting Information 276
GROUP BY.HAVING collecting specific information 282
Working with multiple tables 285
Inner (Natural) joins 290
Outer joins 291
UNION 293
SELECT summary 296
INSERT 297
UPDATE 300
DELETE 302
A question (and a free SQL diagnostic tool) 303
Summary 306
Chapter 30 • Domains 307
Chapter 31 • What does null mean? 309
Chapter 32 • Primary keys 313
Candidate keys 315
Part 5 Speeding up your database 317
Chapter 33 • Hardware considerations 319
CPUs 320
Memory 320
Disks 322
Data volume vs. disk capacity 322
Don't put all your eggs in one basket 323
Chapter 34 • Indexing 324
Indexing techniques 324
Applying indexes which fields/columns should be
indexed? 333
Intelligent use of indexes 337
Chapter 35 • More on optimization 338
Query optimization 338
Update statistics 339
Query analysis 340
Writing good SQL code 342
Chapter 36 • Denormalization 344
Mirroring tables 345
Splitting tables 346
Redundant data 348
Repeating groups (breaking INF) 349
Derived columns 351
Summary 352
Appendix 1 • GUIs, macros and control languages 353
Creating a very simple user interface 353
Other languages SQL 362
Index 365 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Whitehorn, Mark 1953- Marklyn, Bill 1960- |
| author_GND | (DE-588)115568719 (DE-588)115568735 |
| author_facet | Whitehorn, Mark 1953- Marklyn, Bill 1960- |
| author_role | aut aut |
| author_sort | Whitehorn, Mark 1953- |
| author_variant | m w mw b m bm |
| building | Verbundindex |
| bvnumber | BV021998326 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D32 |
| callnumber-search | QA76.9.D32 |
| callnumber-sort | QA 276.9 D32 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)70987390 (DE-599)BVBBV021998326 |
| dewey-full | 005.7565 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7565 |
| dewey-search | 005.7565 |
| dewey-sort | 15.7565 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01558nam a2200409zc 4500</leader><controlfield tag="001">BV021998326</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20070531 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">061019s2007 |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1846283949</subfield><subfield code="9">1-84628-394-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781846283949</subfield><subfield code="9">978-1-84628-394-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)70987390</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV021998326</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-706</subfield><subfield code="a">DE-1051</subfield><subfield code="a">DE-573</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D32</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7565</subfield><subfield code="2">22</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">Whitehorn, Mark</subfield><subfield code="d">1953-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)115568719</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Inside relational databases with examples in Access</subfield><subfield code="c">Mark Whitehorn and Bill Marklyn</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[London]</subfield><subfield code="b">Springer</subfield><subfield code="c">2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIV, 371 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="630" ind1="0" ind2="4"><subfield code="a">Microsoft Access</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Relationale Datenbank</subfield><subfield code="0">(DE-588)4049358-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Access 2007</subfield><subfield code="0">(DE-588)7564284-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Relationale Datenbank</subfield><subfield code="0">(DE-588)4049358-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Access 2007</subfield><subfield code="0">(DE-588)7564284-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Marklyn, Bill</subfield><subfield code="d">1960-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)115568735</subfield><subfield code="4">aut</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ 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=015212954&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-015212954</subfield></datafield></record></collection> |
| id | DE-604.BV021998326 |
| illustrated | Not Illustrated |
| index_date | 2024-07-02T16:11:09Z |
| indexdate | 2024-07-09T20:49:01Z |
| institution | BVB |
| isbn | 1846283949 9781846283949 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-015212954 |
| oclc_num | 70987390 |
| open_access_boolean | |
| owner | DE-706 DE-1051 DE-573 |
| owner_facet | DE-706 DE-1051 DE-573 |
| physical | XIV, 371 S. |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Springer |
| record_format | marc |
| spelling | Whitehorn, Mark 1953- Verfasser (DE-588)115568719 aut Inside relational databases with examples in Access Mark Whitehorn and Bill Marklyn [London] Springer 2007 XIV, 371 S. txt rdacontent n rdamedia nc rdacarrier Microsoft Access Relational databases Relationale Datenbank (DE-588)4049358-1 gnd rswk-swf Access 2007 (DE-588)7564284-0 gnd rswk-swf Relationale Datenbank (DE-588)4049358-1 s Access 2007 (DE-588)7564284-0 s DE-604 Marklyn, Bill 1960- Verfasser (DE-588)115568735 aut HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015212954&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Whitehorn, Mark 1953- Marklyn, Bill 1960- Inside relational databases with examples in Access Microsoft Access Relational databases Relationale Datenbank (DE-588)4049358-1 gnd Access 2007 (DE-588)7564284-0 gnd |
| subject_GND | (DE-588)4049358-1 (DE-588)7564284-0 |
| title | Inside relational databases with examples in Access |
| title_auth | Inside relational databases with examples in Access |
| title_exact_search | Inside relational databases with examples in Access |
| title_exact_search_txtP | Inside relational databases with examples in Access |
| title_full | Inside relational databases with examples in Access Mark Whitehorn and Bill Marklyn |
| title_fullStr | Inside relational databases with examples in Access Mark Whitehorn and Bill Marklyn |
| title_full_unstemmed | Inside relational databases with examples in Access Mark Whitehorn and Bill Marklyn |
| title_short | Inside relational databases with examples in Access |
| title_sort | inside relational databases with examples in access |
| topic | Microsoft Access Relational databases Relationale Datenbank (DE-588)4049358-1 gnd Access 2007 (DE-588)7564284-0 gnd |
| topic_facet | Microsoft Access Relational databases Relationale Datenbank Access 2007 |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015212954&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT whitehornmark insiderelationaldatabaseswithexamplesinaccess AT marklynbill insiderelationaldatabaseswithexamplesinaccess |