User:Bert Niehaus/Books/Advances in relational databases
 | The Wikimedia Foundation's book rendering service has been withdrawn. Please upload your Wikipedia book to one of the external rendering services. |
 | You can still create and edit a book design using the Book Creator and upload it to an external rendering service:
|
| This user book is a user-generated collection of Wikipedia articles that can be easily saved, rendered electronically, and ordered as a printed book. If you are the creator of this book and need help, see Help:Books (general tips) and WikiProject Wikipedia-Books (questions and assistance). Edit this book: Book Creator · Wikitext Order a printed copy from: PediaPress [ About ] [ Advanced ] [ FAQ ] [ Feedback ] [ Help ] [ WikiProject ] [ Recent Changes ] | ||||||||
Advances in relational databases
[edit]- 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