1 option
Database management systems / ITL Education Solutions Limited, Research and Development Wing.
- Format:
- Book
- Author/Creator:
- Limited, ITL, author.
- ITL Education Solutions, Research and Development Wing, author.
- Series:
- Express learning series.
- Express learning series
- Language:
- English
- Subjects (All):
- Database management.
- Physical Description:
- 1 online resource (1 v.) : ill.
- Edition:
- 1st edition
- Place of Publication:
- New Delhi, India : Pearson, 2012.
- System Details:
- text file
- Summary:
- 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 have been designed as one-stop references for students to understand and master the subjects by themselves.
- Contents:
- 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
- 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
- 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 domain calculus
- 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
- Chapter 6: Relational Database Design
- 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
- Chapter 8: Query Processing and Optimization
- Cost analysis
- Cost analysis.
- Variation of the hash join technique
- Chapter 9: Introduction to Transaction Processing
- Chapter 10: Concurrency Control Techniques
- Multiversion timestamp ordering
- Multiversion two-phase locking
- Chapter 11: Database Recovery System
- Recovery techniques based on deferred update
- Recovery techniques based on immediate update
- Chapter 12: Database Security
- Accidental threats
- Malicious or intentional threats
- Managing user accounts
- Database audit
- 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)
- Chapter 14: Data Warehousing, OLAP, and Data Mining
- Chapter 15: Information Retrieval
- Limitations of the vector space model
- 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
- Index.
- Notes:
- Includes index.
- Description based on online resource; title from PDF title page (Safari, viewed Aug. 29, 2012).
- ISBN:
- 9788131797600
- 8131797600
- OCLC:
- 809536682
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.