User:Bert Niehaus/Books/Advances in relational databases

Advances in relational databases

 * Introduction
 * Data management
 * Database
 * Database system
 * Database management system
 * Types of DBMS
 * Data store
 * Technical Information Project


 * Introduction to Data Modeling
 * Data modeling
 * Data model
 * Database model
 * Database design
 * Conceptual schema
 * Data structure diagram
 * Hierarchical database model
 * Network model
 * Navigational database


 * ERD
 * Entity-relationship model
 * Has-a
 * Many-to-many
 * Enhanced Entity-Relationship Model
 * Weak entity
 * Associative Entities
 * Structured-Entity-Relationship-Model
 * Barker's Notation
 * Peter Chen


 * Relational schema
 * Relational model
 * Relational database
 * Relational database management system
 * Logical data model
 * Logical schema
 * Relation
 * Table
 * Tuple
 * Row
 * Attribute domain
 * Candidate key
 * Unique key
 * Natural key
 * Key field
 * Compound key
 * Foreign key
 * Persistent Object Identifier
 * Cardinality
 * Recordset
 * Superkey
 * Integrity constraints
 * Check Constraint
 * Propagation constraint
 * Transition constraint
 * Wide and narrow data
 * Universal relation assumption
 * Reference table
 * Junction table
 * Nested set model
 * Information schema
 * Codd's 12 rules
 * Edgar F. Codd


 * Relational algebra
 * Relational algebra
 * Projection
 * Rename
 * Selection
 * Generalized selection
 * Range query
 * Monotonic query
 * Recursive join
 * Relvar
 * Relational calculus
 * Tuple relational calculus


 * Overview
 * Query language
 * Data Definition Language
 * Varchar
 * Data Manipulation Language
 * Create, read, update and delete
 * SQL
 * SQL-92
 * SQL:1999
 * SQL:2003
 * SQL:2008
 * SQL:2011
 * Data
 * Metadata


 * Database objects
 * Table
 * Column
 * Field
 * Row
 * Data type


 * Statements
 * Select
 * Result set
 * Synonym
 * Alias
 * Insert
 * Update
 * Merge
 * Delete
 * Join
 * Set operations
 * Commit
 * Rollback
 * Truncate


 * Views
 * View
 * Materialized view


 * FB Query Lang
 * Facebook Query Language


 * Databases programming
 * Active database
 * Open Database Connectivity
 * Java Database Connectivity
 * ADO.NET


 * Other DBMS
 * MySQL
 * SQLite


 * Normal Form
 * Data redundancy
 * Database normalization
 * Functional dependency
 * Armstrong's axioms
 * Transitive dependency
 * Superkey
 * First normal form
 * Second normal form
 * Third normal form
 * Boyce–Codd normal form
 * Lossless-Join Decomposition
 * Join dependency
 * Multivalued dependency
 * Fourth normal form
 * Fifth normal form
 * Sixth normal form
 * Denormalization
 * Domain/key normal form
 * Single Source of Truth
 * Single version of the truth
 * Principle of Orthogonal Design


 * Transaction management
 * Database transaction
 * Transaction processing
 * Concurrency control
 * Transaction Control Language
 * ACID
 * Atomicity
 * Isolation
 * Durability
 * Atomic commit
 * Schedule
 * Serializability
 * Precedence graph
 * Serializability theory
 * Read–write conflict
 * Write–read conflict
 * Write–write conflict
 * Lock
 * Record locking
 * Multiple granularity locking
 * Two-phase locking
 * Readers–writer lock
 * Blind write
 * Conservative two-phase locking
 * Strong strict two-phase locking
 * Index locking
 * Snapshot isolation
 * Non-lock concurrency control
 * Commitment ordering
 * Long-running transaction
 * Timestamp-based concurrency control
 * Pseudoconversational transaction
 * Thomas write rule
 * Global concurrency control
 * Global serializability
 * Modular concurrency control
 * Multiversion concurrency control
 * Optimistic concurrency control
 * Autocommit
 * Transaction log
 * Savepoint
 * No-force
 * Non-blocking algorithm
 * Data recovery
 * Point-in-time recovery
 * Redo log
 * Extreme transaction processing
 * In-database processing
 * Locks with ordered sharing
 * Nested transaction
 * Transaction processing system
 * Transaction processing systems
 * Transaction server
 * Priority inversion
 * Priority ceiling protocol
 * Priority inheritance


 * Query optimization and indexing
 * Query optimization
 * Query optimizer
 * Query plan
 * Index
 * Partial index
 * Expression index
 * Reverse index
 * Bitmap index
 * Inverted index
 * Sargable
 * V-optimal histograms
 * Cardinality
 * Online aggregation


 * Distributed DB
 * Very large database
 * Big data
 * XLDB
 * Secondary database server
 * Centralized database
 * Distributed database
 * Distributed database management system
 * Distributed file system
 * Distributed data store
 * Heterogeneous Database System
 * Simple Sloppy Semantic Database
 * Distributed transaction
 * Network transparency
 * Long-lived transaction
 * Distributed concurrency control
 * Consistency model
 * Distributed Transaction Coordinator
 * Two-phase commit protocol
 * Three-phase commit protocol
 * Xeround
 * Vector-field consistency
 * Storage area network
 * Partition
 * Shared nothing architecture
 * Shard
 * Quorum


 * Physical design
 * Physical data model
 * Physical schema
 * Storage model
 * Storage block
 * Tablespace
 * Database tuning
 * Database dump
 * Spindling