Inside relational databases: [now including database design]
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
London [u.a.]
Springer
2004
|
| Ausgabe: | 2. ed., 4. print. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XII, 345 S. Ill., graph. Darst. CD-ROM (12 cm) |
| ISBN: | 1852334010 |
Internformat
MARC
| LEADER | 00000nam a22000008c 4500 | ||
|---|---|---|---|
| 001 | BV035837337 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 091120s2004 ad|| |||| 00||| eng d | ||
| 020 | |a 1852334010 |9 1-85233-401-0 | ||
| 035 | |a (OCoLC)177137167 | ||
| 035 | |a (DE-599)BVBBV035837337 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-473 | ||
| 050 | 0 | |a QA76.9 | |
| 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 |b [now including database design] |c Mark Whitehorn and Bill Marklyn |
| 250 | |a 2. ed., 4. print. | ||
| 264 | 1 | |a London [u.a.] |b Springer |c 2004 | |
| 300 | |a XII, 345 S. |b Ill., graph. Darst. |e CD-ROM (12 cm) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a Relationales Datenbanksystem |0 (DE-588)4130535-8 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Relationale Datenbank |0 (DE-588)4049358-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a CD-ROM |0 (DE-588)4139307-7 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Relationales Datenbanksystem |0 (DE-588)4130535-8 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a Relationale Datenbank |0 (DE-588)4049358-1 |D s |
| 689 | 1 | |5 DE-604 | |
| 689 | 2 | 0 | |a Relationales Datenbanksystem |0 (DE-588)4130535-8 |D s |
| 689 | 2 | 1 | |a CD-ROM |0 (DE-588)4139307-7 |D s |
| 689 | 2 | |5 DE-604 | |
| 700 | 1 | |a Marklyn, Bill |d 1960- |e Verfasser |0 (DE-588)115568735 |4 aut | |
| 856 | 4 | 2 | |m Digitalisierung UB Bamberg |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018695731&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-018695731 | ||
Datensatz im Suchindex
| _version_ | 1804140803397779456 |
|---|---|
| adam_text | Contents
Preface
to the second edition
xi
Chapter
1 ·
Introduction
1
What is a database?
1
Databases vs. DataBase Management Systems
2
Relational DataBase Management Systems
2
Why this book?
4
Who should read this book?
5
Organization of the book
б
Some ground rules
7
We don t have problems...
8
Copying file from the CD-ROM
8
Acknowledgements
9
Part
1-А
simple, single-table database
11
Chapter
2 ·
Introduction to Part
1 13
Tables
13
Forms
14
Queries
14
Reports
15
Chapter
3 ·
Tables
16
Rows and columns
-
records and fields
17
Building a table
20
Base tables
-
not defined here
33
Chapter
4 ·
Forms
34
Multiple forms per table
37
Text boxes can be made read only
37
Text boxes don t have to present data from just one field
38
It isn t necessary for each field in a table to appear on the
form
40
Controlling data entry
40
Use of forms can be controlled
40
Forms can be web pages
41
Summary
41
Chapter
5 ·
Queries
43
Queries usually find subsets of the data
43
Queries, answer tables and base tables finally defined
properly and closure mentioned briefly
44
Summarizing data
49
Other useful queries
49
Graphical querying tools
50
SQL and Views
50
Chapter
6 ·
Reports
52
Chapter
7 ·
Summary of Part
1 54
Part
2-А
multi-table, single-user database
57
Chapter
8 ·
Introduction to Part
2 59
Chapter
9 ·
Serious problems with single tables
61
Redundant data
61
Typographical errors
62
Updating data
63
Modifying data
63
Summary
64
Chapter
10 ·
Multiple tables cure serious problems
66
Redundant data
68
Typographical errors
71
Updating data
71
Modifying data
71
Chapter
11 ·
Making multiple tables work together
72
Databases are designed to model the real world
71
Chapter
12 ·
Getting the data into the correct tables
74
Not normalization (and not
ER
modeling either)
76
Object identification
77
Chapter
13 ·
Relationships in the real world
80
One-to-many
80
One-to-one
81
Many-to-many
81
None
82
Mapping real world relationships to tables
82
Chapter
14 ·
How are relationships modeled?
83
Primary keys
85
Foreign keys
90
Summary so far
91
Joins
92
Chapter
15 ·
Revisiting the big four
-
the synergy begins 111
Tables
114
Queries (and a bit on forms)
115
Forms
122
Reports
123
Chapter
16 ·
Integrity
125
Data integrity
-
is it worth the effort?
125
Types of data integrity error (and some cures)
126
Other integrity issues
138
Integrity
-
where should you set it?
138
Declarative and procedural referential integrity
140
Chapter
17 ·
Building a database application
142
Building a database application
142
GUIs, macros and control languages
144
Other languages
-
SQL
152
Chapter
18 ·
Summary of Part
2 154
Part
3 -
Multi-table, multi-user databases
155
Chapter
19 ·
Database architectures
157
The seven layers of wisdom
157
PC front end
-
data on file server
160
Client-server (or two-tier) architecture
163
Three-tier architecture (also known as multi-tier)
165
Web-based applications
166
Choosing a database architecture
168
Summary
169
Chapter
20 ·
More complex database design
170
The User model
172
The Logical model
172
The Physical model
174
Logical and Physical models in practice
175
Summary so far
179
The final big advantage
179
More about the differences between the logical and
physical models
181
Reality check
183
Normalization can help
183
Reverse engineering
184
Methodologies
184
Chapter
21 ·
Triggers, stored procedures and views
186
Triggers
186
Stored procedures
190
Summary
-
triggers and stored procedures
192
Views
193
Chapter
22 ·
Transactions, logs, backup, locking and
concurrency
197
Transactions
197
RoUback
198
Roll forward
201
Locations
202
Backup strategy
202
Locking
204
Concurrency
206
Row locking and page locking
206
What comes next
207
Answers from earlier
207
Fart
4 -
Related database topics
209
Chapter
23 ·
What exactly is a relational database?
211
Do multiple tables a relational database make?
211
On names and misnames
212
Chapter
24 ·
Codd s rales
214
Why you just have to know about them
214
Economy vs. readability
215
A little background
215
The rules themselves
215
Summary
226
Chapter
25 ·
Normalization
228
Normalization
228
Functional dependency
230
First
normal form
(first level of normalization): INF
233
Second normal form (second level of normalization): 2NF
237
Third normal form (third level of normalization): 3NF
241
Summary so far
243
Why we aren t going any further
243
Normalization doesn t automatically remove all
redundancy
246
Summary
253
Chapter
26 ·
The data dictionary
254
The data dictionary
254
Chapter
27 ·
More on queries: data manipulation
256
Relational operators
256
Summary
267
Chapter
28 ·
SQL
269
SELECT and FROM
272
INSERT
307
UPDATE
309
DELETE
312
A question (and a free SQL diagnostic tool)
314
Distinctly exact (or exactly
D
ISTINCT)
316
Summary
321
Chapter
29 ·
Domains
322
Chapter
30 ·
Indexing
-
speeding up your database
324
Chapter
31 ·
What does null mean?
330
Chapter
32 ·
Primary keys
334
Glossary
337
Index
339
|
| any_adam_object | 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 | BV035837337 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9 |
| callnumber-search | QA76.9 |
| callnumber-sort | QA 276.9 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)177137167 (DE-599)BVBBV035837337 |
| discipline | Informatik |
| edition | 2. ed., 4. print. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01740nam a22004338c 4500</leader><controlfield tag="001">BV035837337</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">091120s2004 ad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1852334010</subfield><subfield code="9">1-85233-401-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)177137167</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV035837337</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-473</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9</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</subfield><subfield code="b">[now including database design]</subfield><subfield code="c">Mark Whitehorn and Bill Marklyn</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2. ed., 4. print.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">London [u.a.]</subfield><subfield code="b">Springer</subfield><subfield code="c">2004</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XII, 345 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield><subfield code="e">CD-ROM (12 cm)</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="0" ind2="7"><subfield code="a">Relationales Datenbanksystem</subfield><subfield code="0">(DE-588)4130535-8</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</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">CD-ROM</subfield><subfield code="0">(DE-588)4139307-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Relationales Datenbanksystem</subfield><subfield code="0">(DE-588)4130535-8</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">Relationale Datenbank</subfield><subfield code="0">(DE-588)4049358-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="2" ind2="0"><subfield code="a">Relationales Datenbanksystem</subfield><subfield code="0">(DE-588)4130535-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" ind2="1"><subfield code="a">CD-ROM</subfield><subfield code="0">(DE-588)4139307-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="2" 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">Digitalisierung UB Bamberg</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=018695731&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-018695731</subfield></datafield></record></collection> |
| id | DE-604.BV035837337 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T22:05:47Z |
| institution | BVB |
| isbn | 1852334010 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-018695731 |
| oclc_num | 177137167 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG |
| owner_facet | DE-473 DE-BY-UBG |
| physical | XII, 345 S. Ill., graph. Darst. CD-ROM (12 cm) |
| publishDate | 2004 |
| publishDateSearch | 2004 |
| publishDateSort | 2004 |
| publisher | Springer |
| record_format | marc |
| spelling | Whitehorn, Mark 1953- Verfasser (DE-588)115568719 aut Inside relational databases [now including database design] Mark Whitehorn and Bill Marklyn 2. ed., 4. print. London [u.a.] Springer 2004 XII, 345 S. Ill., graph. Darst. CD-ROM (12 cm) txt rdacontent n rdamedia nc rdacarrier Relationales Datenbanksystem (DE-588)4130535-8 gnd rswk-swf Relationale Datenbank (DE-588)4049358-1 gnd rswk-swf CD-ROM (DE-588)4139307-7 gnd rswk-swf Relationales Datenbanksystem (DE-588)4130535-8 s DE-604 Relationale Datenbank (DE-588)4049358-1 s CD-ROM (DE-588)4139307-7 s Marklyn, Bill 1960- Verfasser (DE-588)115568735 aut Digitalisierung UB Bamberg application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018695731&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Whitehorn, Mark 1953- Marklyn, Bill 1960- Inside relational databases [now including database design] Relationales Datenbanksystem (DE-588)4130535-8 gnd Relationale Datenbank (DE-588)4049358-1 gnd CD-ROM (DE-588)4139307-7 gnd |
| subject_GND | (DE-588)4130535-8 (DE-588)4049358-1 (DE-588)4139307-7 |
| title | Inside relational databases [now including database design] |
| title_auth | Inside relational databases [now including database design] |
| title_exact_search | Inside relational databases [now including database design] |
| title_full | Inside relational databases [now including database design] Mark Whitehorn and Bill Marklyn |
| title_fullStr | Inside relational databases [now including database design] Mark Whitehorn and Bill Marklyn |
| title_full_unstemmed | Inside relational databases [now including database design] Mark Whitehorn and Bill Marklyn |
| title_short | Inside relational databases |
| title_sort | inside relational databases now including database design |
| title_sub | [now including database design] |
| topic | Relationales Datenbanksystem (DE-588)4130535-8 gnd Relationale Datenbank (DE-588)4049358-1 gnd CD-ROM (DE-588)4139307-7 gnd |
| topic_facet | Relationales Datenbanksystem Relationale Datenbank CD-ROM |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018695731&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT whitehornmark insiderelationaldatabasesnowincludingdatabasedesign AT marklynbill insiderelationaldatabasesnowincludingdatabasedesign |