Database Management Systems

By R.S.V Aparajitha., M. Kavitha, M. Kavitha, T. Monisha, T. Pavithra, R. Vinoth. 2010

728 citations recorded by the source corpus.

Database Management Systems Introduction Data Models Relational Model Entity-Relationship (E/R) Model Key-Value Model Entity-Relationship (E/R) Model Relationships Subclasses Constraints Converting ER to Relational Model Functional Dependencies (FD) FD Properties Closure Algorithm Superkeys & Minimal Basis Schema Normalization Decomposition Lossless-Join & Chase Algorithm Dependency Preserving Boyce-Codd Normal Form (BCNF) Third Normal Form (3NF) Relational Algebra Basic Operators Derived Operators Extended RA Syntax Data Storage Buffer Manager File Organization Page Organization Record Format Index Structures Indexing Basics Hash Tables B+ Trees Bitmaps & Bitslices Supporting SQL Operators External Sorting Selection Operator Projection Operator Join Operator Aggregation Operation Query Optimizer Annotated RA Trees Optimization Plans Cost Estimation Transaction Management Definition of Transactions The "ACID" Principle Write-Ahead Logging (WAL) Transaction Concurrency

Subfields: Computer Networks and Communications, Information Systems and Management, ML Systems & Hardware