Verfügbarkeit: An advanced course in database systems

An advanced course in database systems: beyond relational databases

Gespeichert in:

Bibliographische Detailangaben
1. Verfasser:	Dietrich, Suzanne W. (VerfasserIn)
Format:	Buch
Sprache:	English
Veröffentlicht:	Upper Saddle River, NJ Pearson/Prentice Hall 2005
Schriftenreihe:	An Alan R. Apt book
Schlagworte:	aRelational databases aObject-oriented databases Objektorientierung Relationale Datenbank
Online-Zugang:	Inhaltsverzeichnis
Beschreibung:	Includes bibliographical references and index
Beschreibung:	XVII, 302 S.
ISBN:	0130428981

Internformat

MARC


LEADER	00000nam a2200000zc 4500
001	BV019626980
003	DE-604
005	20071115
007	t
008	041209s2005 xxu \|\|\|\| 00\|\|\| eng d
010			\|a 2004054883
020			\|a 0130428981 \|9 0-13-042898-1
035			\|a (OCoLC)55877288
035			\|a (DE-599)BVBBV019626980
040			\|a DE-604 \|b ger \|e aacr
041	0		\|a eng
044			\|a xxu \|c US
049			\|a DE-384 \|a DE-703
050		0	\|a QA76.9.D3
082	0		\|a 005.75/6 \|2 22
084			\|a ST 270 \|0 (DE-625)143638: \|2 rvk
100	1		\|a Dietrich, Suzanne W. \|e Verfasser \|4 aut
245	1	0	\|a An advanced course in database systems \|b beyond relational databases \|c Suzanne W. Dietrich and Susan D. Urban
264		1	\|a Upper Saddle River, NJ \|b Pearson/Prentice Hall \|c 2005
300			\|a XVII, 302 S.
336			\|b txt \|2 rdacontent
337			\|b n \|2 rdamedia
338			\|b nc \|2 rdacarrier
490	0		\|a An Alan R. Apt book
500			\|a Includes bibliographical references and index
650		4	\|a aRelational databases
650		4	\|a aObject-oriented databases
650	0	7	\|a Objektorientierung \|0 (DE-588)4346172-4 \|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 Relationale Datenbank \|0 (DE-588)4049358-1 \|D s
689	0	1	\|a Objektorientierung \|0 (DE-588)4346172-4 \|D s
689	0		\|5 DE-604
700	1		\|a Urban, Susan D. \|e Sonstige \|4 oth
856	4	2	\|m GBV Datenaustausch \|q application/pdf \|u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=012956207&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA \|3 Inhaltsverzeichnis
999			\|a oai:aleph.bib-bvb.de:BVB01-012956207

Datensatz im Suchindex

_version_	1804132993690763264
adam_text	AN ADVANCED COURSE IN DATABASE SYSTEMS BEYOND RELATIONAL DATABASES SUZANNE W. DIETRICH AND SUSAN D. URBAN ARIZONA STUTE UNIVERSITY UPPER SADDLE RIVER, NEW JERSEY 07458 CONTENTS ...................... 2.4.2 AGGREGATION ASSOCIATIONS 55 2.4.3 COMPOSITION ASSOCIATIONS ...................... 55 2.4.4 QUALIFIED ASSOCIATIONS ........................ 56 2.4.5 THE XOR CONSTRAINT ON ASSOCIATIONS ................. 57 2.4.6 CHECKPOINT: ADDITIONAL FORMS OF ASSOCIATION ........... 58 2.5 REALIZATION AND INTERFACE CLASSES ...................... 61 2.6 CHECKPOINT .................................. 63 2.7 BIBLIOGRAPBIC REFERENCES ........................... 63 3 THE SQL STANDARD: ADVANCED RELATIONAL FEATURES 67 3.1 REVIEW OF DATA DEFINITION AND DATA MANIPULATION . ............ 68 3.1.1 DATA DEFINITION LANGNAGE ...................... 69 3.1.2 DATA MANIPULATION LANGUAGE: INSERTING. DELETING. .......................... AND UPDATING DATA 75 3.1.3 VIEWS ................................. 76 3.1.4 ASSESTIONS ............................... 78 3.1.5 CHECKPOINT: DDL. DML. VIEWS. AND ASSESTIONS .......... 79 3.2 SQL-INVOKED ROUTINES ............................ 84 3.3 PERSISTENT STORED MODULES .......................... 86 3.4 ACTIVE CAPAHILITY WITH TRIGGERS ....................... 92 ................................ 3.5 EMHEDDED SQL 96 3.6 DYNAMIC SQL ................................. 97 .............................. 3.7 CALL-LEVEL INTERFACE 98 3.8 CHECKPOINT .................................. 99 3.9 BIBLIOGRAPHIC REFERENCES ........................... 101 4 MAPPING OBJECT-ORIENTED CONCEPTUAL MODELS TO THE RELATIONAL DATA MODEL 103 4.1 NOTATION AND TERMINOLOGY .......................... 104 4.2 CLASSES .................................... 105 4.3 ASSOCIATIONS .................................. 106 4.3.1 BIDIRECTIONAL BINARY ASSOCIATIONS .................. 107 4.3.2 PARTICIPATION AND MULTIPLICITY CONSTRAINTS .............. 109 ........................ 4.3.3 RECURSIVE ASSOCIATIONS 112 .......................... 4.3.4 N-ARY ASSOCIATIONS 113 ......... 4.3.5 NAVIGATION OF UNIDIRECTIONAL BINARY ASSOCIATIONS 114 4.3.6 WEAK ENTITIES AND IDENTIFYING RELATIONSHIPS ............ 116 ................ 4.3.7 CHECKPOINT: CLASSES AND ASSOCIATIONS 118 4.4 CLASS HIERARCHIES ............................... 119 ................... 4.4.1 CREATING A TABLE FOR EACH CLASS 121 ................ 4.4.2 CREATING A TABLE FOR SUBCLASSES ONLY 123 ....................... 4.4.3 FLATTENING THE HIERARCHY 124 4.4.4 SPECIALIZATION CONSTRAINTS ...................... 126 .................... 4.4.5 CHECKPOINT: CLASS HIERARCHIES 128 4.5 SHARED SUBCLASSES ............................... 131 4.6 CATEGORIES ................................... 132 IND WEB ACCESS TO RELATIONAL DATABASES IEMIEW AND ARCHITECTURE . . . . . . . . . -~ - . --.. - VIII CONTENTS .................... 7.6 THE ODMG OBJECT QUERY LANGUAGE 195 ........................... 7.6.1 PATH EXPRESSIONS 199 ................ 7.6.2 OQL EXPRESSIONS AND QUERY RESULTS 200 ................. 7.6.3 SET MEMBERSHIP AND QUANTIFICATION 202 ............................... 7.6.4 ORDERING 203 .......................... 7.6.5 USING COLLECTIONS 203 ...................... 7.6.6 AGGREGATION AND GROUPING 204 .......................... 7.6.7 CHECKPOINT: OQL 205 .................................. 7.7 CHECKPOINT 206 ........................... 7.8 BIBLIOGRAPBIC REFERENCES 210 8 THE SQL STANDARD: OBJECT-RELATIONAL FEATURES 211 .......................... 8.1 BUILT-IN CONSTMCTED TYPES 213 .............................. 8.1.1 ROWTYPES 213 ........................ 8.1.2 ARRAYS AS COLLECTIONS 214 .............. 8.1.3 CHECKPOINT: BUILT-IN CONSTMCTED TYPES 215 .............................. 8.2 USER-DEFINED QPES 216 ............................ 8.2.1 DISTINCT TYPES 217 ........................... 8.2.2 STMCTURED TYPES 218 .................. 8.2.3 CHECKPOINT: USER-DEFINED TYPES 222 ................................. 8.3 TYPED TABLES 222 ......................... 8.4 TYPE AND TABLE HIERARCHIES 225 ..................... 8.5 A CLOSER LOOK AT TABLE HIERARCHIES 227 ............... 8.5.1 INSERTING ROWS INTO A TABLE HIERARCHY 227 ..................... 8.5.2 QUERYING A TABLE HIERARCHY 228 ............... 8.5.3 DELETING ROWS FROM A TABLE HIERARCHY 228 ................ 8.5.4 UPDATING ROWS IN A TABLE HIERARCHY 230 ................ 8.5.5 CHECKPOINT: TYPED TABLE HIERARCBIES 231 ............................... 8.6 REFERENCE TYPES 232 ................... 8.6.1 SCOPES AND REFERENCE CHECKING 234 ...................... 8.6.2 QUERYING REFERENCE TYPES 234 8.7 MAPPING TO THE SQL STANDARD .......................... OBJECT-RELATIONAL FEATURES 235 ................ 8.7.1 CLASSES, ATTRIBUTES, AND ASSOCIATIONS 235 8.7.2 CHECKPOINT: OBJECT-RELATIONAL MAPPING OF CLASSES, ..................... AITRIBUTES, AND ASSOCIATIONS 243 ........................... 8.7.3 CLASS HIERARCHIES 247 .............................. 8.7.4 CATEGORIES 247 .................................. 8.8 CHECKPOINT 248 ........................... 8.9 BIBLIOGRAPHIE REFERENCES 252 9 CASE STUDIES: RELATIONAL. OBJECT.RELATIONA1. AND OBJECT-ORIENTED DATABASE IMPLEMENTATIONS 253 9.1 ORACLE: RELATIONAL DATABASE MAPPINGS ................... 254 .................... 9.1.1 CONSTRAINTS OF THE APPLICATION 254 CONTENTS IX 9.1.2 STORED PROCEDURES .......................... 258 9.1.3 TRIGGERS ................................ 259 9.2 ORACLE: OBJECT-RELATIONAL DATAHASE MAPPINGS ............... 261 9.2.1 OBJECT QPES ............................. 263 9.2.2 OBJECT TABLES ............................. 267 9.2.3 REFERENCE TYPES ........................... 267 9.2.4 INHERITANCE .............................. 269 9.2.5 VARRAYS AND NESTED TABLES AS COUECTIONS .............. 271 9.2.6 ACCESSING VARRAYS AND NESTED TABLES ................ 273 9.2.7 MAINTAINING INVERSE RELATIONSHIPS .................. 276 9.3 OBJECTIVITYDB: OBJECT-ORIENTED DATABASE MAPPINGS ............ 277 9.3.1 ACCESSING AN OBJECTIVITYDB DATABASE ............... 277 9.3.2 PERSISTENTE-CAPABLE CLASSES ..................... 282 9.3.3 RELATIONSHIPS FOR IMPLEMENTING ASSOCIATIONS ............ 285 9.3.4 ADDITIONAL FEATURES FOR IMPLEMENTING ASSOCIATIONS ........ 289 9.4 CHECK1 ............ 291 9.5 BIBLIOP ............ 292 BIBLIOGRAPHJ INDEX
any_adam_object	1
author	Dietrich, Suzanne W.
author_facet	Dietrich, Suzanne W.
author_role	aut
author_sort	Dietrich, Suzanne W.
author_variant	s w d sw swd
building	Verbundindex
bvnumber	BV019626980
callnumber-first	Q - Science
callnumber-label	QA76
callnumber-raw	QA76.9.D3
callnumber-search	QA76.9.D3
callnumber-sort	QA 276.9 D3
callnumber-subject	QA - Mathematics
classification_rvk	ST 270
ctrlnum	(OCoLC)55877288 (DE-599)BVBBV019626980
dewey-full	005.75/6
dewey-hundreds	000 - Computer science, information, general works
dewey-ones	005 - Computer programming, programs, data, security
dewey-raw	005.75/6
dewey-search	005.75/6
dewey-sort	15.75 16
dewey-tens	000 - Computer science, information, general works
discipline	Informatik
format	Book
fullrecord	<?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01692nam a2200445zc 4500</leader><controlfield tag="001">BV019626980</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20071115 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">041209s2005 xxu \|\|\|\| 00\|\|\| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2004054883</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0130428981</subfield><subfield code="9">0-13-042898-1</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)55877288</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV019626980</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="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-384</subfield><subfield code="a">DE-703</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/6</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">Dietrich, Suzanne W.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">An advanced course in database systems</subfield><subfield code="b">beyond relational databases</subfield><subfield code="c">Suzanne W. Dietrich and Susan D. Urban</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Upper Saddle River, NJ</subfield><subfield code="b">Pearson/Prentice Hall</subfield><subfield code="c">2005</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVII, 302 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="490" ind1="0" ind2=" "><subfield code="a">An Alan R. Apt book</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">aRelational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">aObject-oriented databases</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Objektorientierung</subfield><subfield code="0">(DE-588)4346172-4</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">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">Objektorientierung</subfield><subfield code="0">(DE-588)4346172-4</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">Urban, Susan D.</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">GBV 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=012956207&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-012956207</subfield></datafield></record></collection>
id	DE-604.BV019626980
illustrated	Not Illustrated
indexdate	2024-07-09T20:01:39Z
institution	BVB
isbn	0130428981
language	English
lccn	2004054883
oai_aleph_id	oai:aleph.bib-bvb.de:BVB01-012956207
oclc_num	55877288
open_access_boolean
owner	DE-384 DE-703
owner_facet	DE-384 DE-703
physical	XVII, 302 S.
publishDate	2005
publishDateSearch	2005
publishDateSort	2005
publisher	Pearson/Prentice Hall
record_format	marc
series2	An Alan R. Apt book
spelling	Dietrich, Suzanne W. Verfasser aut An advanced course in database systems beyond relational databases Suzanne W. Dietrich and Susan D. Urban Upper Saddle River, NJ Pearson/Prentice Hall 2005 XVII, 302 S. txt rdacontent n rdamedia nc rdacarrier An Alan R. Apt book Includes bibliographical references and index aRelational databases aObject-oriented databases Objektorientierung (DE-588)4346172-4 gnd rswk-swf Relationale Datenbank (DE-588)4049358-1 gnd rswk-swf Relationale Datenbank (DE-588)4049358-1 s Objektorientierung (DE-588)4346172-4 s DE-604 Urban, Susan D. Sonstige oth GBV Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=012956207&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis
spellingShingle	Dietrich, Suzanne W. An advanced course in database systems beyond relational databases aRelational databases aObject-oriented databases Objektorientierung (DE-588)4346172-4 gnd Relationale Datenbank (DE-588)4049358-1 gnd
subject_GND	(DE-588)4346172-4 (DE-588)4049358-1
title	An advanced course in database systems beyond relational databases
title_auth	An advanced course in database systems beyond relational databases
title_exact_search	An advanced course in database systems beyond relational databases
title_full	An advanced course in database systems beyond relational databases Suzanne W. Dietrich and Susan D. Urban
title_fullStr	An advanced course in database systems beyond relational databases Suzanne W. Dietrich and Susan D. Urban
title_full_unstemmed	An advanced course in database systems beyond relational databases Suzanne W. Dietrich and Susan D. Urban
title_short	An advanced course in database systems
title_sort	an advanced course in database systems beyond relational databases
title_sub	beyond relational databases
topic	aRelational databases aObject-oriented databases Objektorientierung (DE-588)4346172-4 gnd Relationale Datenbank (DE-588)4049358-1 gnd
topic_facet	aRelational databases aObject-oriented databases Objektorientierung Relationale Datenbank
url	http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=012956207&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA
work_keys_str_mv	AT dietrichsuzannew anadvancedcourseindatabasesystemsbeyondrelationaldatabases AT urbansusand anadvancedcourseindatabasesystemsbeyondrelationaldatabases

Verfügbarkeit

Es ist kein Print-Exemplar vorhanden.

Fernleihe Bestellen Achtung: Nicht im THWS-Bestand! Inhaltsverzeichnis

MARC

Datensatz im Suchindex

Es ist kein Print-Exemplar vorhanden.

Ähnliche Einträge