Inside relational databases [now including database design]
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
London [u.a.]
Springer
2001
|
| Ausgabe: | 2. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
MARC
| LEADER | 00000nam a22000008c 4500 | ||
|---|---|---|---|
| 001 | BV013757145 | ||
| 003 | DE-604 | ||
| 005 | 20010903 | ||
| 007 | t| | ||
| 008 | 010529s2001 xx ad|| |||| 00||| eng d | ||
| 016 | 7 | |a 960871527 |2 DE-101 | |
| 020 | |a 1852334010 |9 1-85233-401-0 | ||
| 035 | |a (OCoLC)635160558 | ||
| 035 | |a (DE-599)BVBBV013757145 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-29T |a DE-824 |a DE-83 |a DE-525 | ||
| 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. | ||
| 264 | 1 | |a London [u.a.] |b Springer |c 2001 | |
| 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 CD-ROM |0 (DE-588)4139307-7 |2 gnd |9 rswk-swf |
| 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 |
| 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 DNB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009405303&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-009405303 | |
Datensatz im Suchindex
| _version_ | 1820148875901534208 |
|---|---|
| adam_text |
CONTENTS
PREFACE
TO
THE
SECOND
EDITION
XL
CHAPTER
1
YY
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
6
SOME
GROUND
RULES
7
WE
DON'T
HAVE
PROBLEMS.
8
COPYING
FILE
FROM
THE
CD-ROM
8
ACKNOWLEDGEMENTS
9
PART
1
-
A
SIMPLE,
SINGLE-TABLE
DATABASE
11
CHAPTER
2
YY
INTRODUCTION
TO
PART
1
13
TABLES
1
3
FORMS
14
QUERIES
14
REPORTS
15
CHAPTER
3
YY
TABLES
16
ROWS
AND
COLUMNS
-
RECORDS
AND
FIELDS
1
7
BUILDING
A
TABLE
20
BASE
TABLES
-
NOT
DEFINED
HERE
33
CHAPTER
4
YY
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
YY
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
YY
REPORTS
52
CHAPTER
7
YY
SUMMARY
OF
PART
1
54
PART
2
-
A
MULTI-TABLE,
SINGLE-USER
DATABASE
57
CHAPTER
8
YY
INTRODUCTION
TO
PART
2
59
CHAPTER
9
YY
SERIOUS
PROBLEMS
WITH
SINGLE
TABLES
61
REDUNDANT
DATA
61
TYPOGRAPHICAL
ERRORS
62
UPDATING
DATA
63
MODIFYING
DATA
63
SUMMARY
64
CHAPTER
10
YY
MULTIPLE
TABLES
CURE
SERIOUS
PROBLEMS
66
REDUNDANT
DATA
68
TYPOGRAPHICAL
ERRORS
71
UPDATING
DATA
71
MODIFYING
DATA
71
CHAPTER
11
YY
MAKING
MULTIPLE
TABLES
WORK
TOGETHER
72
DATABASES
ARE
DESIGNED
TO
MODEL
THE
REAL
WORLD
73
CHAPTER
12
YY
GETTING
THE
DATA
INTO
THE
CORRECT
TABLES
74
NOT
NORMALIZATION
(AND
NOT
ER
MODELING
EITHER)
76
OBJECT
IDENTIFICATION
77
CHAPTER
13
YY
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
YY
HOW
ARE
RELATIONSHIPS
MODELED?
83
PRIMARY
KEYS
85
FOREIGN
KEYS
90
SUMMARY
SO
FAR
91
JOINS
92
CHAPTER
15
YY
REVISITING
THE
BIG
FOUR
-
THE
SYNERGY
BEGINS
111
TABLES
114
QUERIES
(AND
A
BIT
ON
FORMS)
115
FORMS
122
REPORTS
123
CHAPTER
16
YY
INTEGRITY
1
25
DATA
INTEGRITY
-
IS
IT
WORTH
THE
EFFORT?
1
25
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
YY
BUILDING
A
DATABASE
APPLICATION
142
BUILDING
A
DATABASE
APPLICATION
142
GUIS,
MACROS
AND
CONTROL
LANGUAGES
144
OTHER
LANGUAGES
-
SQL
152
CHAPTER
18
YY
SUMMARY
OF
PART
2
154
PART
3
-
MULTI-TABLE,
MULTI-USER
DATABASES
155
CHAPTER
19
YY
DATABASE
ARCHITECTURES
157
THE
SEVEN
LAYERS
OF
WISDOM
157
PC
FRONT
END
-
DATA
ON
FILE
SERVER
1
60
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
YY
MORE
COMPLEX
DATABASE
DESIGN
1
70
THE
USER
MODEL
1
72
THE
LOGICAL
MODEL
172
THE
PHYSICAL
MODEL
1
74
LOGICAL
AND
PHYSICAL
MODELS
IN
PRACTICE
175
SUMMARY
SO
FAR
179
THE
FINAL
BIG
ADVANTAGE
1
79
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
YY
TRIGGERS,
STORED
PROCEDURES
AND
VIEWS
186
TRIGGERS
186
STORED
PROCEDURES
190
SUMMARY
-
TRIGGERS
AND
STORED
PROCEDURES
1
92
VIEWS
193
CHAPTER
22
YY
TRANSACTIONS,
LOGS,
BACKUP,
LOCKING
AND
CONCURRENCY
197
TRANSACTIONS
197
ROLLBACK
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
PART
4
-
RELATED
DATABASE
TOPICS
209
CHAPTER
23
YY
WHAT
EXACTLY
IS
A
RELATIONAL
DATABASE?
211
DO
MULTIPLE
TABLES
A
RELATIONAL
DATABASE
MAKE?
211
ON
NAMES
AND
MISNAMES
212
CHAPTER
24
YY
CODD'S
RULES
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
YY
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
YY
THE
DATA
DICTIONARY
254
THE
DATA
DICTIONARY
254
CHAPTER
27
YY
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
DISTINCT)
316
SUMMARY
321
CHAPTER
29
YY
DOMAINS
322
CHAPTER
30
YY
INDEXING
-
SPEEDING
UP
YOUR
DATABASE
324
CHAPTER
31
YY
WHAT
DOES
NULL
MEAN?
330
CHAPTER
32
YY
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 | BV013757145 |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)635160558 (DE-599)BVBBV013757145 |
| discipline | Informatik |
| edition | 2. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a22000008c 4500</leader><controlfield tag="001">BV013757145</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20010903</controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">010529s2001 xx ad|| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">960871527</subfield><subfield code="2">DE-101</subfield></datafield><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)635160558</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV013757145</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-824</subfield><subfield code="a">DE-83</subfield><subfield code="a">DE-525</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.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">London [u.a.]</subfield><subfield code="b">Springer</subfield><subfield code="c">2001</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">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="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="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">DNB 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=009405303&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009405303</subfield></datafield></record></collection> |
| id | DE-604.BV013757145 |
| illustrated | Illustrated |
| indexdate | 2025-01-02T14:47:12Z |
| institution | BVB |
| isbn | 1852334010 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-009405303 |
| oclc_num | 635160558 |
| open_access_boolean | |
| owner | DE-29T DE-824 DE-83 DE-525 |
| owner_facet | DE-29T DE-824 DE-83 DE-525 |
| physical | XII, 345 S. Ill., graph. Darst. CD-ROM (12 cm) |
| publishDate | 2001 |
| publishDateSearch | 2001 |
| publishDateSort | 2001 |
| 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. London [u.a.] Springer 2001 XII, 345 S. Ill., graph. Darst. CD-ROM (12 cm) txt rdacontent n rdamedia nc rdacarrier CD-ROM (DE-588)4139307-7 gnd rswk-swf Relationales Datenbanksystem (DE-588)4130535-8 gnd rswk-swf Relationale Datenbank (DE-588)4049358-1 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 DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009405303&sequence=000001&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] CD-ROM (DE-588)4139307-7 gnd Relationales Datenbanksystem (DE-588)4130535-8 gnd Relationale Datenbank (DE-588)4049358-1 gnd |
| subject_GND | (DE-588)4139307-7 (DE-588)4130535-8 (DE-588)4049358-1 |
| 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 | CD-ROM (DE-588)4139307-7 gnd Relationales Datenbanksystem (DE-588)4130535-8 gnd Relationale Datenbank (DE-588)4049358-1 gnd |
| topic_facet | CD-ROM Relationales Datenbanksystem Relationale Datenbank |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009405303&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT whitehornmark insiderelationaldatabasesnowincludingdatabasedesign AT marklynbill insiderelationaldatabasesnowincludingdatabasedesign |