Business database systems:
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Harlow ; Munich [u.a.]
Addison-Wesley
2008
|
| Ausgabe: | 1. publ. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis Inhaltsverzeichnis |
| Beschreibung: | Includes bibliographical references (p. [556]-557) and index |
| Beschreibung: | xxv, 566 p. Ill. 24 cm |
| ISBN: | 1405874376 9781405874373 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV035729708 | ||
| 003 | DE-604 | ||
| 005 | 20091107 | ||
| 007 | t | ||
| 008 | 090917s2008 a||| |||| 00||| eng d | ||
| 010 | |a 2008013992 | ||
| 020 | |a 1405874376 |c pbk. : £39,99 |9 1-4058-7437-6 | ||
| 020 | |a 9781405874373 |c pbk. : £39,99 |9 978-1-4058-7437-3 | ||
| 035 | |a (OCoLC)214935330 | ||
| 035 | |a (DE-599)GBV56294074X | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-473 | ||
| 050 | 0 | |a HF5548.2 | |
| 082 | 0 | |a 005.74 |2 22 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 100 | 1 | |a Connolly, Thomas |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Business database systems |c Thomas Connolly ; Carolyn Begg ; Richard Holowczak |
| 250 | |a 1. publ. | ||
| 264 | 1 | |a Harlow ; Munich [u.a.] |b Addison-Wesley |c 2008 | |
| 300 | |a xxv, 566 p. |b Ill. |c 24 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes bibliographical references (p. [556]-557) and index | ||
| 650 | 0 | |a Business / Databases | |
| 650 | 0 | |a Database management | |
| 650 | 0 | |a Database design | |
| 650 | 0 | |a Management information systems | |
| 650 | 4 | |a Wirtschaft | |
| 650 | 4 | |a Business |v Databases | |
| 650 | 4 | |a Database design | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Management information systems | |
| 650 | 0 | 7 | |a Datenbankentwurf |0 (DE-588)4127613-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 0 | 1 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Begg, Carolyn E. |e Verfasser |4 aut | |
| 700 | 1 | |a Holowczak, Richard |e Sonstige |4 oth | |
| 856 | 4 | |m DE-601 |q pdf/application |u http://www.gbv.de/dms/bowker/toc/9781405874373.pdf |3 Inhaltsverzeichnis | |
| 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=018006322&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-018006322 | ||
Datensatz im Suchindex
| _version_ | 1804140009009184768 |
|---|---|
| adam_text | Brief contents
Guided Tour
xvi
Preface
xviii
Part I Background
1
1
Introduction
3
2
The relational model
32
3
SQL and QBE
46
4
The database system development lifecycle
83
Part II Database analysis and design techniques
99
5
Fact-finding
101
6
Entity-relationship modeling
131
7
Enhanced
ER
modeling
152
8
Normalization
162
Part III Database design methodology
179
9
Conceptual database design
181
10
Logical database design
208
11
Physical database design
236
Part IV Current and emerging trends
269
12
Database administration and security
271
13
Professional, legal, and ethical issues in data management
289
14
Transaction management
309
viii
Brief contents
15
eCommerce
and database systems
332
16
Distributed and mobile DBMSs
370
17
Object DBMSs
411
18
Business intelligence
443
Appendices
A The Buyer user view for StayHome Online Rentals
461
В
Second case study
-
PerfectPets
463
С
Alternative data modeling notations
468
D
Summary of the database design methodology
475
E
Advanced SQL
482
F
Guidelines for choosing indexes
496
G
Guidelines for denormalization
505
H
Object-oriented concepts
513
I Common data models
521
Glossary
536
References
556
Index
558
Contents
Guided
Tour
Preface
xvi
xviii
Part I Background
Chapter
1
Introduction
Preview
Learning objectives
1.1
Examples of the use of database systems
1.2
Database approach
1.3
Database design
1.4
Historical perspective of database system development
1.5
Three-level ANSI-SPARC architecture
1.6
Functions of a DBMS
1.7
Advantages and disadvantages of the database approach
Chapter summary
Review questions
Exercises
Chapter
2
The relational model
Preview
Learning objectives
2.1
Brief history of the relational model
2.2
What is a data model?
2.3
Terminology
2.4
Relational integrity
2.5
Relational languages
Chapter summary
Review questions
Exercises
3
3
4
6
14
16
20
25
28
29
30
31
32
32
32
33
34
34
39
43
44
45
45
Contents
Chapter
3
SQL and QBE
Preview
Learning objectives
3.1
Structured Query Language (SQL)
3.2
Data manipulation
3.3
Query-By-Example (QBE)
Chapter summary
Review questions
Exercises
Chapter
4
The database system development lifecycle
Preview
Learning objectives
4.1
The software crisis
4.2
The information systems lifecycle
4.3
The database system development lifecycle
4.4
Database planning
4.5
System definition
4.6
Requirements collection and analysis
4.7
Database design
4.8
DBMS selection
4.9
Application design
4.10
Prototyping
4.11
Implementation
4.12
Data conversion and loading
4.13
Testing
4.14
Operational maintenance
Chapter summary
Review questions
46
46
46
46
49
70
77
78
79
83
83
83
83
84
85
85
87
88
91
91
92
94
94
95
95
96
96
97
Part II Database analysis and design techniques
Chapter
5
Fact-finding
Preview
Learning objectives
5.1
When are fact-finding techniques used?
5.2
What facts are collected?
5.3
Fact-finding techniques
99
101
101
101
102
102
103
Contents
XI
5.4 The StayHome Online
Rentals case study
Chapter summary
Review questions
Exercise
Chapter
6
Entity-relationship modeling
Preview
Learning objectives
6.1
Entities
6.2
Relationships
6.3
Attributes
6.4
Strong and weak entities
6.5
Multiplicity constraints on relationships
6.6
Attributes on relationships
6.7
Design problems with
ER
models
Chapter summary
Review questions
Exercises
Chapter
7
Enhanced
ER
modeling
Preview
Learning objectives
7.1
Specialization/generalization
Chapter summary
Review questions
Exercises
Chapter
8
Normalization
Preview
Learning objectives
8.1
Introduction
8.2
Data redundancy and update anomalies
8.3
First
normal form (1NF)
8.4
Second normal form (2NF)
8.5
Third normal form (3NF)
Chapter summary
Review questions
Exercises
108
129
130
130
131
131
132
132
133
135
138
138
145
146
149
150
151
152
152
152
153
159
159
160
162
162
162
163
163
166
167
169
174
174
175
XII
Contents
Part III Database design methodology
179
Chapter
9
Conceptual database design
181
Preview
181
Learning objectives
181
9.1
Introduction to the database design methodology
181
9.2
Overview of the database design methodology
183
9.3
Step
1:
Conceptual database design methodology
184
Chapter summary
204
Review questions
204
Exercises
205
Chapter
10
Logical database design
208
Preview
208
Learning objectives
208
10.1
Step
2:
Map
ER
model to tables
208
Chapter summary
231
Review questions
231
Exercises
231
Chapter
11
Physical database design
236
Preview
236
Learning objectives
236
11.1
Comparison of logical and physical database design
· 237
11.2
Overview of the physical database design methodology
237
11.3
Step
3:
Translate the logical database design for the target DBMS
238
11.4
Step
4:
Choose file organizations and indexes
248
11.5
Step
5:
Design user views
252
11.6
Step
6:
Design security mechanisms
254
11.7
Step
7:
Consider the introduction of controlled redundancy
258
11.8
Step
8:
Monitor and tune the operational system
260
Chapter summary
265
Review questions
266
Exercises
266
Part IV Current and emerging trends
Chapter
12
Database administration and security
Preview
Learning objectives
269
271
271
271
Contents
xiii
12.1 Data
administration
and database administration
271
12.2
Database security
274
Chapter summary
286
Review questions
287
Exercises
288
Chapter
13
Professional, legal, and ethical issues in data management
289
Preview
289
Learning objectives
289
13.1
Defining legal and ethical issues in information technology
290
13.2
Legislation and its impact on the IT function
292
13.3
Establishing a culture of legal and ethical data stewardship
298
13.4
Intellectual property
303
Chapter summary
307
Review questions
307
Exercises
308
Chapter
14
Transaction management
309
Preview
309
Learning objectives
309
14.1
Transaction support
310
14.2
Concurrency control
312
14.3
Database recovery
322
Chapter summary
329
Review questions
330
Exercises
330
Chapter
15
eCommerce
and database systems
332
Preview
332
Learning objectives
332
15.1
eCommerce
333
15.2
Web-database integration
341
15.3
Web-database integration technologies
343
15.4
extensible Markup Language (XML)
350
15.5
XML-related technologies
359
15.6
XML query languages
360
15.7
Database integration in
eCommerce
systems
363
Chapter summary
368
Review questions
369
Exercises
369
xiv
Contents
Chapter
16
Distributed and mobile DBMSs
Preview
Learning objectives
16.1
DDBMS concepts
16.2
Distributed relational database design
16.3
Transparencies in a DDBMS
16.4
Date s
12
rules for a DDBMS
16.5
Replication servers
16.6
Mobile databases
Chapter summary
Review questions
Exercises
Chapter
17
Object DBMSs
Preview
Learning objectives
17.1
Advanced database applications
17.2
Weaknesses of relational DBMSs (RDBMSs)
17.3
Storing objects in a relational database
17.4
Object-oriented DBMSs (OODBMSs)
17.5
Object-relational DBMSs (ORDBMSs)
Chapter summary
Review questions
Exercises
Chapter
18
Business intelligence
Preview
Learning objectives
18.1
Business intelligence (Bl)
18.2
Data warehousing
18.3
Online analytical processing
(OLAP)
18.4
Data mining
Chapter summary
Review questions
Exercises
370
370
371
371
378
388
397
399
403
405
407
407
411
411
412
412
415
417
419
429
439
441
441
443
443
443
444
444
450
454
459
460
460
Appendix A The Buyer user view for StayHome Online Rentals
Appendix
В
Second case study
-
PerfectPets
Appendix
С
Alternative data modeling notations
461
463
468
Contents
XV
Appendix D
Summary of the database design methodology
475
Appendix
E
Advanced SQL
482
Appendix
F
Guidelines for choosing indexes
496
Appendix
G
Guidelines for denormalization
505
Appendix
H
Object-oriented concepts
513
Appendix I Common data models
521
Glossary
536
References
556
Index
558
Supporting^ resources
Visit www.pearsoaed.co.uk/connolly
tö
find valuable online resources.
Companion Website for students
■
Lecture slides
■
An implementation of the StayHome Online Rentals database system in
Microsoft Access®
■
An SQL script for each common .data
.
model
descfibeÖ ia^A^p^nÖjxi
tè/.ereate
the
corresponding set of
baseiabfés for
the database system^^-i: ·; , :: ;:
;::.)::·:.
: ·. ,/,·. ■...
■
An SQL script to create^ •implementation of the
ЉгѓЏ&Ш&ШшеаШе
Ptysiem
:: :
For instructors
:..,,;;;■.;:.. :.. :
::
. ■ . : -
.^■-^•■^^■^ ■■■■^i v
■,. ;. ■■/;[
■
■
Additional
čase.: stuďfe^^. atÄ^ii^säSffW^^ W ^
■.•aofţrtţons
Also: The
.^BJEfufearíy
!
rr^tínts^nee^íV^C^Äi^iliä i&ari
:
VVSörteäplter
íprövítciös. Wvö
following
■
Search;toôl:to : h;el|í;
Іо^ЩеЩАоіЙс
Items of
ipóntsrit
■
E-mail
гоеУІШ
and
piÄwfei^ôte tóvserjcí rešyfte
Of:
ç
■
Online
.
help-and-
support
.^èssisi
·!
|
| any_adam_object | 1 |
| author | Connolly, Thomas Begg, Carolyn E. |
| author_facet | Connolly, Thomas Begg, Carolyn E. |
| author_role | aut aut |
| author_sort | Connolly, Thomas |
| author_variant | t c tc c e b ce ceb |
| building | Verbundindex |
| bvnumber | BV035729708 |
| callnumber-first | H - Social Science |
| callnumber-label | HF5548 |
| callnumber-raw | HF5548.2 |
| callnumber-search | HF5548.2 |
| callnumber-sort | HF 45548.2 |
| callnumber-subject | HF - Commerce |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)214935330 (DE-599)GBV56294074X |
| 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 |
| edition | 1. publ. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02117nam a2200553 c 4500</leader><controlfield tag="001">BV035729708</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20091107 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">090917s2008 a||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2008013992</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1405874376</subfield><subfield code="c">pbk. : £39,99</subfield><subfield code="9">1-4058-7437-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781405874373</subfield><subfield code="c">pbk. : £39,99</subfield><subfield code="9">978-1-4058-7437-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)214935330</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV56294074X</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</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">HF5548.2</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</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">Connolly, Thomas</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Business database systems</subfield><subfield code="c">Thomas Connolly ; Carolyn Begg ; Richard Holowczak</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. publ.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Harlow ; Munich [u.a.]</subfield><subfield code="b">Addison-Wesley</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xxv, 566 p.</subfield><subfield code="b">Ill.</subfield><subfield code="c">24 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="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references (p. [556]-557) and index</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business / Databases</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Management information systems</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Wirtschaft</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business</subfield><subfield code="v">Databases</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">Management information systems</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="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</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="1"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-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">Begg, Carolyn E.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Holowczak, Richard</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="m">DE-601</subfield><subfield code="q">pdf/application</subfield><subfield code="u">http://www.gbv.de/dms/bowker/toc/9781405874373.pdf</subfield><subfield code="3">Inhaltsverzeichnis</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=018006322&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-018006322</subfield></datafield></record></collection> |
| id | DE-604.BV035729708 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T21:53:09Z |
| institution | BVB |
| isbn | 1405874376 9781405874373 |
| language | English |
| lccn | 2008013992 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-018006322 |
| oclc_num | 214935330 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG |
| owner_facet | DE-473 DE-BY-UBG |
| physical | xxv, 566 p. Ill. 24 cm |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | Addison-Wesley |
| record_format | marc |
| spelling | Connolly, Thomas Verfasser aut Business database systems Thomas Connolly ; Carolyn Begg ; Richard Holowczak 1. publ. Harlow ; Munich [u.a.] Addison-Wesley 2008 xxv, 566 p. Ill. 24 cm txt rdacontent n rdamedia nc rdacarrier Includes bibliographical references (p. [556]-557) and index Business / Databases Database management Database design Management information systems Wirtschaft Business Databases Datenbankentwurf (DE-588)4127613-9 gnd rswk-swf Datenbankverwaltung (DE-588)4389357-0 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 s Datenbankverwaltung (DE-588)4389357-0 s DE-604 Begg, Carolyn E. Verfasser aut Holowczak, Richard Sonstige oth DE-601 pdf/application http://www.gbv.de/dms/bowker/toc/9781405874373.pdf Inhaltsverzeichnis Digitalisierung UB Bamberg application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018006322&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Connolly, Thomas Begg, Carolyn E. Business database systems Business / Databases Database management Database design Management information systems Wirtschaft Business Databases Datenbankentwurf (DE-588)4127613-9 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| subject_GND | (DE-588)4127613-9 (DE-588)4389357-0 |
| title | Business database systems |
| title_auth | Business database systems |
| title_exact_search | Business database systems |
| title_full | Business database systems Thomas Connolly ; Carolyn Begg ; Richard Holowczak |
| title_fullStr | Business database systems Thomas Connolly ; Carolyn Begg ; Richard Holowczak |
| title_full_unstemmed | Business database systems Thomas Connolly ; Carolyn Begg ; Richard Holowczak |
| title_short | Business database systems |
| title_sort | business database systems |
| topic | Business / Databases Database management Database design Management information systems Wirtschaft Business Databases Datenbankentwurf (DE-588)4127613-9 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| topic_facet | Business / Databases Database management Database design Management information systems Wirtschaft Business Databases Datenbankentwurf Datenbankverwaltung |
| url | http://www.gbv.de/dms/bowker/toc/9781405874373.pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=018006322&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT connollythomas businessdatabasesystems AT beggcarolyne businessdatabasesystems AT holowczakrichard businessdatabasesystems |
Es ist kein Print-Exemplar vorhanden.
Inhaltsverzeichnis