Book:Databases

From Wikipedia, the free encyclopedia
Jump to: navigation, search
Databases:
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. For information and help on Wikipedia books in general, see Help:Books (general tips) and WikiProject Wikipedia-Books (questions and assistance).
Download PDF ]  [ Download ODT ]  [ Download ZIM ]

Download EPUB ]  [ Open in Book Creator ]  [ Order Printed Book ]

[ About ] [ 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 (data model)
Enhanced Entity-Relationship Model
Weak entity
Associative Entities
Structured-Entity-Relationship-Model
Barker's Notation
Peter Chen
Other Data Modeling Techniques
Unified Modeling Language
The Third Manifesto
Three schema approach
White pages schema
Anchor Modeling
Bachman diagram
Bitemporal Modeling
Bitemporal data
IDEF1X
Universal Data Element Framework
Terminology model
Georelational data model
Semantic data model
Relational Model/Tasmania


Relational Schema
Relational model
Relational database
Relational database management system
Life cycle of a relational database
Logical data model
Logical schema
Relation (database)
Table (database)
Tuple
Row (database)
Attribute domain
Candidate key
Unique key
Natural key
Key field
Compound key
Foreign key
Persistent Object Identifier
Cardinality (data modeling)
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 (relational algebra)
Rename (relational algebra)
Selection (relational algebra)
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 (database)
Alias (SQL)
Insert
Update
Merge
Delete
Join
Set operations
Commit
Rollback
Truncate
Views
View (database)
Materialized view
Advanced Issues
Hierarchical query
Hint (SQL)
Extensions
SQL/CLI
SQL/JRT
SQL/MED
SQL/OLB
SQL/PSM
SQL/Schemata
StreamSQL


dBase and derived languages
DBase
Clip (compiler)
Clipper (programming language)
Dbfree
Flagship compiler
FoxPro 2
Harbour (software)
Visual FoxPro
Visual Objects
XBase
XBase++
XHarbour


Other Query Languages
QUEL query languages
Query by Example
SQR
.QL
Yahoo! query language
YQL (programming language)
YANG
WQL
Versa (query language)
SPARQL
RDF query language
Access query language
Nonprocedural language
Facebook Query Language

Technologies[edit]

Databases Programming
Active database
Database trigger
Stored procedure
PL/SQL
SQL PL
SQL programming tool
User-defined function
Cursor (databases)
SQL Problems Requiring Cursors
WxSQLite3
Database connectivity
Application programming interface
Structured Query Language Interface
Database transaction
Prepared statement
Open Database Connectivity
Java Database Connectivity
ODBC
OLE DB provider
OLE DB
UnixODBC
OpenLink ODBC Drivers
IODBC
Pool (computer science)
Connection pool
Remote Database Access
SQLJ
Native Queries
Meta-SQL
ADO.NET


Software and Tools
List of relational database management systems
Comparison of relational database management systems
Comparison of database tools
Comparison of object-relational database management systems
Transactions per second
SQL Server
Microsoft SQL Server
Microsoft SQL Server Master Data Services
Transact-SQL
WCF Data Services
Windows Internal Database
SQL Server Agent
SQL Server Compact
SQL CLR
Microsoft Transaction Server
Oracle
Database schema
Oracle Database
Oracle Exadata
Oracle Coherence
NVL
Pro*C
Tools
Toad Data Modeler
SQuirreL SQL Client
SQuirreL SQL Client Plugin API
SQLPro SQL Client
SchemaBank
Navicat
ModelRight


Other DBMS
MySQL
SQL Anywhere
SQLite
SESAM (database)
LAMP
Watcom SQL
Microsoft Access
VMDS
Superbase database
Rocket U2
PointBase
R:BASE System
REAL Server
MaxDB
Adaptive Server Enterprise
Advantage Database Server
Ingres (database)



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 (database systems)
Isolation (database systems)
Durability (database systems)
Atomic commit
Schedule (computer science)
Serializability
Precedence graph
Serializability theory
Read–write conflict
Write–read conflict
Write–write conflict
Lock (database)
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 (database)
Partial index
Expression index
Reverse index
Bitmap index
Inverted index
Sargable
V-optimal histograms
Cardinality (SQL statements)
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 (database)
Shared nothing architecture
Shard (database architecture)
Quorum (distributed computing)
Physical Design
Physical data model
Physical schema
Storage model
Storage block
Tablespace
Database tuning
Database dump
Spindling


Data Mapping and Integration Tasks
Data mapping
Semantic integration
Semantic translation
Record linkage
Metadata discovery
Schema matching
Schema crosswalk
Schema evolution
Data integration
Ontology-based data integration
Ontology merging
Parallel
MapReduce
Apache Hadoop
Pig (programming language)
H-Store
Information Security
Data control language
SQL injection

Data Warehouse[edit]

Data Warehousing
Business intelligence
Reactive business intelligence
Business analytics
Sales intelligence
Performance intelligence
Data warehouse
Data warehouse architectures
Data mart
The Kimball Lifecycle
Time variance
Federated database system
Single Source of Truth
XLeratorDB



Design
Dimension (data warehouse)
Fact (data warehouse)
Measure (data warehouse)
Fact table
Degenerate dimension
Slowly changing dimension
Star schema
Dimension table
Dimensional Fact Model
Snowflake schema
Denormalization
Single version of the truth
Transaction data
Enterprise bus matrix


OLAP
Statistical database
Online transaction processing
Operational system
Operational data store
Operational database
Online analytical processing
OLAP cube
Aggregate (data warehouse)
MOLAP
ROLAP
HOLAP
Thomsen Diagrams
Spreadmart
MultiDimensional eXpressions
OLAP Servers and Tools
Comparison of OLAP Servers
Applix
BusinessObjects OLAP Intelligence
Crystal Analysis
CubePort
Essbase
Microsoft Analysis Services
Mondrian OLAP server
OLE DB for OLAP
Oracle OLAP
Palo (OLAP database)
Panorama Software
ProClarity
SAP BI Accelerator
SAP NetWeaver Business Intelligence
NEVOD DMB
Data Transformation
Extract, transform, load
Staging (data)
Vocabulary-based transformation
Surrogate key
Variable data publishing
Semantic warehousing
Scriptella
Data Quality
Bit rot
Cleansing and Conforming Data
Data auditing
Data cleansing
Data corruption
Data integrity
Data profiling
Data quality
Data quality assessment
Data quality assurance
Data Quality Firewall
Data truncation
Data validation
Data verification
Database integrity
Database preservation
DataCleaner
Declarative Referential Integrity
Digital continuity
Digital preservation
User:TheAmazing0and1/draftdigipres
Dirty data
Entity integrity
Information quality
Link rot
One-for-one checking
Referential integrity
Soft error
Two pass verification
Validation rule

Non-Relational Databases[edit]

XML
Semi-structured data
Semi-structured model
Standard Generalized Markup Language
XML
XML database
XML Schema Language comparison
XML schema
XML validation
Xpath data model
Path expression
XQuery
XSA
XSIL
SQL/XML
Soma File
Regular Language description for XML
PureXML
List of XML schemas
Object database
Object database
Object Definition Language
Object Query Language
Object-oriented SQL
Object Exchange Model
Object-relational database
Object-relational impedance mismatch
Object-relational mapping
Polymorphic association
Polyinstantiation
Single Table Inheritance
Versant Object Database
Terminology-oriented database
Odaba
Object Data Management Group
List of object database management systems
Comparison of object database management systems
PostgreSQL
PL/pgSQL
PL/Perl
JADE (programming language)
ObjectDB
Versant Object Database
Zope Object Database


No-SQL Databases
Strozzi NoSQL (RDBMS)
NoSQL
Graph database
DEX (Graph database)
Neo4j
Sones GraphDB
Apache Cassandra
Triplestore
Keyspace (distributed data store)
Super column
UnQL
BigTable
Flat file database
Terminfo
Termcap
MultiValue
OpenInsight
Document-oriented database
MongoDB


Spatiotemporal Databases
Temporal database
RRDtool
Spatial database
Spatial query
Spatiotemporal database
Object-based spatial database
Tuple-versioning
Valid time
Transaction time
Geospatial metadata
Geographical database
Time series database
Operational historian


Special Databases
Real-time database
In-memory database
Probabilistic database
Deductive database
Deductive language
Mobile database
Mobile Transaction Models


Well Known Databases
Standard data model
Suppliers and Parts database
Internet Movie Database
YAGO (ontology)
World Wide Molecular Matrix
Voter database
VIOLIN vaccine database
Census of Governments
Management information base
Planetary Data System
Parameter Value Language
National Data Repository



Data Centers
Data center
Virtual data room
Virtual facility
Network-neutral data center
Related Technologies
Virtual directory
Virtuoso Universal Server
Workflow engine
Metadata Models
Metadata
Meta-data management
Metadatabase
Metadirectory
Metadata controller
Data element
Metadata publishing
Metadata registry
Metadata facility for Java
Object Management Group
Semantics of Business Vocabulary and Business Rules
Business Motivation Model
Business Process Definition Metamodel
Knowledge Discovery Metamodel
Resources, events, agents (accounting model)
Learning object metadata
Learning object
OGML