Outline of databases

This article or section is in a state of significant expansion or restructuring. You are welcome to assist in its construction by editing it as well. If this article or section has not been edited in several days, please remove this template.
If you are the editor who added this template and you are actively editing, please be sure to replace this template with {{in use}} during the active editing session. Click on the link for template parameters to use. This article was last edited by The Transhumanist (talk | contribs) 13 years ago. (Update timer)

The following outline is provided as an overview of and topical guide to databases:

Databases –

What type of thing is databases?

Databases can be described as all of the following:

Branches of databases

History of databases

General databases concepts

Databases organizations

Databases publications

Persons influential in databases

References

External links

This outline displayed as a mindmap, at wikimindmap.com

v t e Wikipedia outlines
General reference Culture and the arts Geography and places Health and fitness History and events Mathematics and logic Natural and physical sciences People and self Philosophy and thinking Religion and belief systems Society and social sciences Technology and applied sciences

v t e Database
Main	Requirements Theory Models Database management system Machine Server Application Connection datasource DSN Administrator Lock Types Tools
Languages	Data definition Data manipulation Query information retrieval
Security	Activity monitoring Audit Forensics Negative database
Design	Entities and relationships Normalization Refactoring
Programming	Abstraction layer Object-relational mapping
Management	Virtualization Tuning caching Migration Preservation Integrity
See also	Database-centric architecture Intelligent database Two-phase locking Locks with ordered sharing Load file Publishing Halloween Problem Log shipping
Book Category WikiProject

v t e Database management systems
Database models Database normalization Database storage Distributed DBMS Federated database system Referential integrity Relational algebra Relational calculus Relational database Relational DBMS Relational model Object-relational database Transaction processing
Concepts	Database ACID CRUD Null Candidate key Foreign key Primary key Superkey Surrogate key Armstrong's axioms NoSQL
Objects	Relation table column row View Transaction Log Trigger Index Stored procedure Cursor Partition
Components	Concurrency control Data dictionary JDBC ODBC Query language Query optimizer Query plan
Functions	Administration and automation Query optimization Replication
Database products Object-oriented comparison Relational comparison Document-oriented

v t e Database models
Models	Flat Hierarchical Dimensional model Network Relational Entity-relationship Graph Object-oriented Entity-attribute-value model
Other models	Associative Concept-oriented Multidimensional Semantic Star schema XML database
Implementations	Flat file Deductive Document-oriented Object-relational Temporal XML data stores Triplestores

Data warehouse

Creating the data warehouse

Concepts	Database Dimension Dimensional modeling Fact OLAP Star schema Aggregate
Variants	Anchor Modeling Column-oriented DBMS Data Vault Modeling HOLAP MOLAP ROLAP Operational data store
Elements	Data dictionary/Metadata Data mart Sixth normal form Surrogate key
Fact	Fact table Early-arriving fact Measure
Dimension	Dimension table Degenerate Slowly changing
Filling	Extract-Transform-Load (ETL) Extract Transform Load

Using the data warehouse

Concepts	Business intelligence Dashboard Data mining Decision support system (DSS) OLAP cube
Languages	Data Mining Extensions (DMX) MultiDimensional eXpressions (MDX) XML for Analysis (XMLA)
Tools	Business intelligence tools Reporting software Spreadsheet

People	Bill Inmon Ralph Kimball
Products	Comparison of OLAP Servers Data warehousing products and their producers