A First Course in Database Systems
Pearson Education (US) (Verlag)
978-0-13-861337-2 (ISBN)
- Titel erscheint in neuer Auflage
- Artikel merken
The worlds of database systems: the evolution of database systems; the architecture of a DBMS; the future of database systems; outline of the book. Database modelling: introduction of ODL; entity-relationship diagrams; design principles; subclasses; the modelling of constraints; weak entity sets; models of historical interest. The relationship data model: basic of the relational model from ODL; designs to relational designs; from E/R diagrams to relational designs; converting subclass structures to relations; functional dependencies; rules about functional dependencies; design of rational database schemas; multivalued dependencies; an example database schema. Operations in the relational model: an algebra of relational operations; a logic for relations; from relational algebra to datalog; recursive computations; constraints on relations; relational operations on bags; other extensions of the relational model. The database language SQL: simple queries in SQL; queries involving more than on e relation; subqueries; supplicates; aggregation database modifications; defining a relation schema in SQL; view definitions; Null values and outerjoints; recursion in SQL3. Active elements in SQL: declaring keys in SQL; referential integrity and foreign keys; value constraints; global constraints; modification of constraints; event-condition-action rules in SQL3. System aspects of SQL: SQL in a programming environment; transactions in SQL; the SQL environment; security and user authorization in SQL2. Object oriented query languages: query-related features of ODL; introduction to OQL; additional forms of OQL; expressions; object assignment and creation in OQL; tuple objects in SQL3; value-ADT's; comparison of ODL/PQL and SQL3; approaches.
| Erscheint lt. Verlag | 2.4.1997 |
|---|---|
| Zusatzinfo | illustrations |
| Verlagsort | Upper Saddle River |
| Sprache | englisch |
| Maße | 178 x 235 mm |
| Gewicht | 885 g |
| Themenwelt | Mathematik / Informatik ► Informatik ► Datenbanken |
| Informatik ► Software Entwicklung ► Objektorientierung | |
| ISBN-10 | 0-13-861337-0 / 0138613370 |
| ISBN-13 | 978-0-13-861337-2 / 9780138613372 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
