Relational database technology:
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
New York u.a.
Springer
1986
|
| Series: | Texts and monographs in computer science
|
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XI, 259 S. graph. Darst. |
| ISBN: | 038796276X 354096276X |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV000656477 | ||
| 003 | DE-604 | ||
| 005 | 20171017 | ||
| 007 | t | ||
| 008 | 871103s1986 xxud||| |||| 00||| eng d | ||
| 016 | 7 | |a 860925404 |2 DE-101 | |
| 020 | |a 038796276X |9 0-387-96276-X | ||
| 020 | |a 354096276X |9 3-540-96276-X | ||
| 035 | |a (OCoLC)13092178 | ||
| 035 | |a (DE-599)BVBBV000656477 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c XD-US | ||
| 049 | |a DE-12 |a DE-91G |a DE-384 |a DE-92 |a DE-739 |a DE-355 |a DE-20 |a DE-19 |a DE-703 |a DE-521 |a DE-634 |a DE-83 |a DE-188 | ||
| 050 | 0 | |a QA76.9.D3A48 1986 | |
| 082 | 0 | |a 005.75/6 |2 19 | |
| 082 | 0 | |a 005.75/6 19 | |
| 084 | |a QH 500 |0 (DE-625)141607: |2 rvk | ||
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 084 | |a DAT 651f |2 stub | ||
| 084 | |a 28 |2 sdnb | ||
| 100 | 1 | |a Alagić, Suad |d 1946- |e Verfasser |0 (DE-588)174097921 |4 aut | |
| 245 | 1 | 0 | |a Relational database technology |c Suad Alagić |
| 264 | 1 | |a New York u.a. |b Springer |c 1986 | |
| 300 | |a XI, 259 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Texts and monographs in computer science | |
| 650 | 4 | |a Bases de données - Gestion | |
| 650 | 4 | |a Bases de données relationnelles | |
| 650 | 4 | |a SGBD | |
| 650 | 4 | |a base donnée relationnelle | |
| 650 | 4 | |a base donnée répartie | |
| 650 | 4 | |a conception base donnée | |
| 650 | 4 | |a intégrité base donnée | |
| 650 | 4 | |a Relational databases | |
| 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 | |8 1\p |5 DE-604 | |
| 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=000409381&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-000409381 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
Record in the Search Index
| _version_ | 1804115104150585344 |
|---|---|
| adam_text | CONTENTS
INTRODUCTION 1
1 MODELING APPLICATION ENVIRONMENTS 1
2 RELATIONAL MODEL 5
3 RELATIONAL DATABASE SYSTEM 11
4 RELATIONAL TECHNOLOGY 17
CHAPTER 1
DATA MODEL
20
1 RELATIONAL MODEL OF DATA 20
1.1 RELATIONAL REPRESENTATION OF ENTITIES 20
1.2 RELATIONAL ALGEBRA 24
1.3 RELATIONAL QUERY LANGUAGES 29
2 LOGICAL DEPENDENCIES 36
2.1 FUNCTIONAL DEPENDENCIES 36
2.2 MULTIVALUED DEPENDENCIES 41
2.3 JOIN DEPENDENCIES 47
3 HIERARCHICAL AND NETWORK MODELS 48
3.1 UNNORMALIZED RELATIONAL SCHEMAS 48
3.2 NETWORK MODEL 51
EXERCISES: GROUP BY CLAUSE; SET FUNCTION; ENTITY
RELATIONSHIP DIAGRAMS; GENERALIZED JOINS; M: N RELATIONSHIPS;
LOSSLESS JOINS 56
BIBLIOGRAPHICAL NOTES 63
CHAPTER 2
LOGICAL DESIGN
64
1 NORMAL FORMS 64
1.1 SECOND NORMAL FORM (2NF) 65
HTTP://D-NB.INFO/860925404
X
CONTENTS
1.2 THIRD NORMAL FORM (3NF) 68
1.3 BOYCE-CODD NORMAL FORM (BCNF) 72
1.4 FOURTH NORMAL FORM (4NF) 75
1.5 PROJECTION/JOIN NORMAL FORM (PJNF) 79
2 ABSTRACTIONS 82
2.1 UNNORMALIZED RELATIONAL MODEL 82
2.2 AGGREGATION 84
2.3 GENERALIZATION 88
3 DESIGN METHODOLOGY 92
3.1 EXTENDED RELATIONAL MODEL 92
3.2 RELATIONAL DATABASE PROGRAMMING ENVIRONMENT 95
3.3 CONCEPTUAL MODELING 107
EXERCISES: VIEWS; TYPES OF DATABASE ENTITIES; GENERALIZATION;
ASSOCIATIONS; AGGREGATION; CHARACTERIZATION; COVER AGGREGATION;
TAXONOMIC DESIGN METHODOLOGY; EXCEPTION MODELING;
EXCEPTION HANDLING 118
BIBLIOGRAPHICAL NOTES 130
CHAPTER 3
STRUCTURAL DESIGN
131
1 RELATIONAL IMAGES 131
2 DECOMPOSITION OF UNARY QUERIES 135
3 DECOMPOSITION OF BINARY QUERIES 141
4 OPTIMIZATION OF BINARY QUERIES 146
5 DECOMPOSITION OF QUERIES WITH SET OPERATORS 149
6 RELATIONAL REPRESENTATION OF RELATIONS AND THEIR IMAGES 152
7 DECOMPOSITION OF DATA MANIPULATION STATEMENTS 153
8 STRUCTURE OF IMAGES 156
EXERCISES: LINKS; NETWORK STRUCTURES; DECOMPOSITION OF N-ARY
QUERIES; OPTIMIZATION OF QUERY EXPRESSIONS; PROPERTIES OF THE
RELATIONAL OPERATORS; B*-TREES 162
BIBLIOGRAPHICAL NOTES 172
CHAPTER 4
DATA INTEGRITY
173
1 TRANSACTIONS AND INTEGRITY OF DATA 173
2 CONCURRENT EXECUTIONS OF TRANSACTIONS 175
3 LOCKING PROTOCOLS ~ 179
4 LOGICAL LOCKS 188
5 RESTORING A CONSISTENT DATABASE STATE 197
EXERCISES: ASSERTIONS; TRANSACTIONS; TRIGGERS; TREE PROTOCOL;
HIERARCHICAL LOCKING PROTOCOL 205
BIBLIOGRAPHICAL NOTES 210
CHAPTER 5
DISTRIBUTED TECHNOLOGY
212
1 ARCHITECTURE OF DATABASE SYSTEMS 212
2 DISTRIBUTED EXECUTIONS AND INTEGRITY 216
CONTENTS
XI
3 DISTRIBUTED QUERY PROCESSING 222
4 DISTRIBUTED UPDATING 231
EXERCISES: FRAGMENTATION; TRANSACTION STRUCTURE; INTEGRITY
CONSTRAINTS AND DATA DISTRIBUTION; GENERALIZATION AND
FRAGMENTATION; MULTIDATABASE SYSTEMS; CATALOG MANAGEMENT;
OBJECT NAMING 237
BIBLIOGRAPHICAL NOTES 244
REFERENCES
245
INDEX
249
I
|
| any_adam_object | 1 |
| author | Alagić, Suad 1946- |
| author_GND | (DE-588)174097921 |
| author_facet | Alagić, Suad 1946- |
| author_role | aut |
| author_sort | Alagić, Suad 1946- |
| author_variant | s a sa |
| building | Verbundindex |
| bvnumber | BV000656477 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3A48 1986 |
| callnumber-search | QA76.9.D3A48 1986 |
| callnumber-sort | QA 276.9 D3 A48 41986 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | QH 500 ST 270 |
| classification_tum | DAT 651f |
| ctrlnum | (OCoLC)13092178 (DE-599)BVBBV000656477 |
| dewey-full | 005.75/6 005.75/619 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/6 005.75/6 19 |
| dewey-search | 005.75/6 005.75/6 19 |
| dewey-sort | 15.75 16 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02184nam a2200577 c 4500</leader><controlfield tag="001">BV000656477</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20171017 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">871103s1986 xxud||| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">860925404</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">038796276X</subfield><subfield code="9">0-387-96276-X</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">354096276X</subfield><subfield code="9">3-540-96276-X</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)13092178</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV000656477</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="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">XD-US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-12</subfield><subfield code="a">DE-91G</subfield><subfield code="a">DE-384</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-739</subfield><subfield code="a">DE-355</subfield><subfield code="a">DE-20</subfield><subfield code="a">DE-19</subfield><subfield code="a">DE-703</subfield><subfield code="a">DE-521</subfield><subfield code="a">DE-634</subfield><subfield code="a">DE-83</subfield><subfield code="a">DE-188</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D3A48 1986</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/6</subfield><subfield code="2">19</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/6 19</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QH 500</subfield><subfield code="0">(DE-625)141607:</subfield><subfield code="2">rvk</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="084" ind1=" " ind2=" "><subfield code="a">28</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Alagić, Suad</subfield><subfield code="d">1946-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)174097921</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Relational database technology</subfield><subfield code="c">Suad Alagić</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York u.a.</subfield><subfield code="b">Springer</subfield><subfield code="c">1986</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XI, 259 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="490" ind1="0" ind2=" "><subfield code="a">Texts and monographs in computer science</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données - Gestion</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données relationnelles</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SGBD</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">base donnée relationnelle</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">base donnée répartie</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">conception base donnée</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">intégrité base donnée</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">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="8">1\p</subfield><subfield code="5">DE-604</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=000409381&sequence=000001&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-000409381</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield></record></collection> |
| id | DE-604.BV000656477 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T15:17:18Z |
| institution | BVB |
| isbn | 038796276X 354096276X |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-000409381 |
| oclc_num | 13092178 |
| open_access_boolean | |
| owner | DE-12 DE-91G DE-BY-TUM DE-384 DE-92 DE-739 DE-355 DE-BY-UBR DE-20 DE-19 DE-BY-UBM DE-703 DE-521 DE-634 DE-83 DE-188 |
| owner_facet | DE-12 DE-91G DE-BY-TUM DE-384 DE-92 DE-739 DE-355 DE-BY-UBR DE-20 DE-19 DE-BY-UBM DE-703 DE-521 DE-634 DE-83 DE-188 |
| physical | XI, 259 S. graph. Darst. |
| publishDate | 1986 |
| publishDateSearch | 1986 |
| publishDateSort | 1986 |
| publisher | Springer |
| record_format | marc |
| series2 | Texts and monographs in computer science |
| spelling | Alagić, Suad 1946- Verfasser (DE-588)174097921 aut Relational database technology Suad Alagić New York u.a. Springer 1986 XI, 259 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Texts and monographs in computer science Bases de données - Gestion Bases de données relationnelles SGBD base donnée relationnelle base donnée répartie conception base donnée intégrité base donnée Relational databases 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 1\p DE-604 DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=000409381&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Alagić, Suad 1946- Relational database technology Bases de données - Gestion Bases de données relationnelles SGBD base donnée relationnelle base donnée répartie conception base donnée intégrité base donnée Relational databases Relationales Datenbanksystem (DE-588)4130535-8 gnd Relationale Datenbank (DE-588)4049358-1 gnd |
| subject_GND | (DE-588)4130535-8 (DE-588)4049358-1 |
| title | Relational database technology |
| title_auth | Relational database technology |
| title_exact_search | Relational database technology |
| title_full | Relational database technology Suad Alagić |
| title_fullStr | Relational database technology Suad Alagić |
| title_full_unstemmed | Relational database technology Suad Alagić |
| title_short | Relational database technology |
| title_sort | relational database technology |
| topic | Bases de données - Gestion Bases de données relationnelles SGBD base donnée relationnelle base donnée répartie conception base donnée intégrité base donnée Relational databases Relationales Datenbanksystem (DE-588)4130535-8 gnd Relationale Datenbank (DE-588)4049358-1 gnd |
| topic_facet | Bases de données - Gestion Bases de données relationnelles SGBD base donnée relationnelle base donnée répartie conception base donnée intégrité base donnée Relational databases Relationales Datenbanksystem Relationale Datenbank |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=000409381&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT alagicsuad relationaldatabasetechnology |