Book:Databases

From Wikipedia, the free encyclopedia
Jump to: navigation, search
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 ]

Databases[edit]

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


Data Modeling[edit]

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
Life cycle of a relational database
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


SQL and Other Query Languages[edit]

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

Technologies[edit]

Databases Programming
Active database
Open Database Connectivity
Java Database Connectivity
Meta-SQL
ADO.NET


Other DBMS
MySQL
SQLite


Advances in Relational Databases[edit]

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