Databases: BCA Cource
The Complete Wikipedia Guide
Please select an appropriate cover image for this book. See "Template:Saved book" for instructions."
This is a Wikipedia book, a collection of Wikipedia articles that can be easily saved, rendered electronically, and ordered as a printed book.

Edit this book: Book Creator · Wikitext
Select format to download:

PDF (A4) · PDF (Letter)

Order a printed copy from these publishers: PediaPress
About ] [ Advanced ] [ FAQ ] [ Feedback ] [ Help ] [ WikiProject ] Recent Changes ]

Contents

DatabasesEdit

Data ModelingEdit

SQL and Other Query LanguagesEdit

TechnologiesEdit

Advances in Relational DatabasesEdit

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