Database management systems
Express Learning is a series of books designed as quick reference guides to important undergraduate computer courses. The organized and accessible format of these books allows students to learn important concepts in an easy-to-understand, question-and-answer format. These portable learning tools hav...
| Autor principal: | |
|---|---|
| Autores Corporativos: | , |
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
New Delhi, India :
Pearson
2012.
|
| Edición: | 1st edition |
| Colección: | Express learning series.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629635306719 |
Tabla de Contenidos:
- Cover
- Contents
- Preface
- Chapter 1: Database System
- Multiple-choice Questions
- Answers
- Chapter 2: Conceptual Modeling
- Mapping cardinalities
- Participation constraint
- Entity types versus attributes
- Binary versus ternary relationship
- Structural diagrams
- Behavioural diagrams
- Multiple-choice Questions
- Answers
- Chapter 3: Relational Model
- Domain integrity
- Entity integrity
- Referential integrity
- Semantic integrity
- Insert operation
- Delete operation
- Update operation
- Representation of weak entity types
- Representation of composite and multivalued attributes
- Representation of generalization
- Representation of aggregation
- Multiple-choice Questions
- Answers
- Chapter 4: Relational Algebra and Calculus
- Queries in relational algebra
- Queries in tuple calculus
- Queries in domain relational calculus
- Expression in relational algebra
- Expression in tuple calculus
- Expression in domain calculus
- Queries in relational algebra
- Queries in tuple calculus
- Queries in domain calculus
- Multiple-choice Questions
- Answers
- Chapter 5: Structured Query Language
- Adding an attribute
- Modifying an attribute
- Dropping an attribute
- Adding a constraint
- Dropping a constraint
- Renaming an attribute
- Renaming a relation
- Multiple-choice Questions
- Answers
- Chapter 6: Relational Database Design
- Multiple-choice Questions
- Answers
- Chapter 7: Data Storage and Indexing
- Primary storage
- Secondary storage
- Tertiary storage
- Fixed-length records
- Variable-length Records
- Advantages
- Disadvantages
- Extendible hashing
- Linear hashing
- Types of single-level indexes
- Partitioned hashing
- Grid files
- Multiple-choice Questions
- Answers
- Chapter 8: Query Processing and Optimization
- Cost analysis
- Cost analysis.
- Variation of the hash join technique
- Multiple-choice Questions
- Answers
- Chapter 9: Introduction to Transaction Processing
- Multiple-choice Questions
- Answers
- Chapter 10: Concurrency Control Techniques
- Multiversion timestamp ordering
- Multiversion two-phase locking
- Multiple-choice Questions
- Answers
- Chapter 11: Database Recovery System
- Recovery techniques based on deferred update
- Recovery techniques based on immediate update
- Multiple-choice Questions
- Answers
- Chapter 12: Database Security
- Accidental threats
- Malicious or intentional threats
- Managing user accounts
- Database audit
- Multiple-choice Questions
- Answers
- Chapter 13: Database System Architecture
- Single lock manager
- Distributed lock manager
- Primary copy
- Majority locking
- Wait-for graph
- Time-out based technique
- Two-phase commit (2PC)
- Multiple-choice Questions
- Answers
- Chapter 14: Data Warehousing, OLAP, and Data Mining
- Multiple-choice Questions
- Answers
- Chapter 15: Information Retrieval
- Limitations of the vector space model
- Multiple-choice Questions
- Answers
- Chapter 16: Miscellaneous Questions
- Features of PostgreSQL
- Features of Oracle
- Features of Microsoft SQL server
- Features of IBM DB2
- Object definition language
- Object query language
- Multiple-choice Questions
- Answers
- Index.
