Difference between revisions of "Template:Databases"

From blackwiki
Jump to navigation Jump to search
imported>Nicomece
m (Added Sharding in Functions.)
 
(111 intermediate revisions by 74 users not shown)
Line 1: Line 1:
{{ navbox
+
{{Navbox
| title = [[Database management system]]s
+
| title     = [[Database|Database management system]]s
| name = Databases
+
| name     = Databases
| above = [[Database models]]{{·}} [[Database normalization]]{{·}} [[Database storage structures|Database storage]]{{·}} [[Distributed database management system|Distributed DBMS]]{{·}} [[Referential integrity]]{{·}} [[Relational algebra]]{{·}} [[Relational calculus]]{{·}} [[Relational database]]{{·}} [[Relational database management system|Relational DBMS]]{{·}} [[Relational model]]{{·}} [[Object-relational database]]{{·}} [[Transaction processing]]
+
| state = {{{state<includeonly>|</includeonly>}}}
 +
| bodyclass = hlist
  
| group1 = Concepts
+
| group1 = Types
| list1  = [[Database]]{{·}} [[ACID]]{{·}} [[Null (SQL)|Null]]{{·}} [[Candidate key]]{{·}} [[Foreign key]]{{·}} [[Primary key]]{{·}} [[Superkey]]{{·}} [[Surrogate key]]
+
| list1  =  
| group2 = Objects
+
*[[Object database|Object-oriented]]
| list2  = [[Database trigger|Trigger]]{{·}} [[View (database)|View]]{{·}} [[Table (database)|Table]]{{·}} [[Cursor (databases)|Cursor]]{{·}} [[Transaction log|Log]]{{·}} [[Database transaction|Transaction]]{{·}} [[Index (database)|Index]]{{·}} [[Stored procedure]]{{·}} [[Partition (database)|Partition]]
+
**[[Comparison of object database management systems|comparison]]
| group3 = [[SQL]]
+
*[[Relational_database|Relational]]
| list3  = [[Select (SQL)|Select]]{{·}} [[Insert (SQL)|Insert]]{{·}} [[Update (SQL)|Update]]{{·}} [[Merge (SQL)|Merge]]{{·}} [[Delete (SQL)|Delete]]{{·}} [[Join (SQL)|Join]]{{·}} [[Union (SQL)|Union]]{{·}} [[Create (SQL)|Create]]{{·}} [[Drop (SQL)|Drop]]{{·}} [[Begin work (SQL)|Begin work]]{{·}} [[Commit (SQL)|Commit]]{{·}} [[Rollback (SQL)|Rollback]]{{·}} [[Truncate (SQL)|Truncate]]{{·}} [[Alter (SQL)|Alter]]
+
**[[List of relational database management systems|list]]
| group4 = Implementations
+
**[[Comparison of relational database management systems|comparison]]
| list4  = [[Relational database|Relational]]{{·}} [[Flat file database|Flat file]]{{·}} [[Deductive database|Deductive]]{{·}} [[Dimensional database|Dimensional]]{{·}} [[Hierarchical model|Hierarchical]]{{·}} [[Network model|Network ]] {{·}} [[Document-oriented database|Document-oriented]]{{·}} [[Object database|Object-oriented]]{{·}} [[Object-relational database|Object-relational]]{{·}} [[Temporal database|Temporal]]{{·}} [[XML database|XML data stores]]
+
*[[Key-value_database|Key-value]]
| group5 = Components
+
*[[Column-oriented DBMS|Column-oriented]]
| list5  = [[Concurrency control]]{{·}} [[Data dictionary]]{{·}} [[Java Database Connectivity|JDBC]]{{·}} [[Open Database Connectivity|ODBC]]{{·}} [[Query language]]{{·}} [[Query optimizer]]{{·}} [[Query plan]]
+
**[[List_of_column-oriented_DBMSes|list]]
 +
*[[Document-oriented database|Document-oriented]]
 +
*[[Wide_column_store|Wide column store]]
 +
*[[Graph database|Graph]]
 +
*[[NoSQL]]
 +
*[[NewSQL]]
 +
*[[In-memory_database|In-memory]]
 +
**[[List_of_in-memory_databases|list]]
 +
*[[Multi-model_database|Multi-model]]
 +
**[[Comparison_of_multi-model_databases|comparison]]
 +
*[[Cloud_database|Cloud]]
  
| below = '''Database products''': [[List of object-oriented database management systems|Object-oriented]] ([[Comparison of object-relational database management systems|comparison]]){{·}} [[List of relational database management systems|Relational]] ([[Comparison of relational database management systems|comparison]]) {{·}} [[Document-oriented database|Document-oriented]]
+
| group2 = Concepts
 +
| list2  =
 +
*[[Database]]
 +
*[[ACID]]
 +
*[[Armstrong's axioms]]
 +
*[[Codd's_12_rules|Codd's 12 rules]]
 +
*[[CAP theorem]]
 +
*[[Create, read, update and delete|CRUD]]
 +
*[[Null (SQL)|Null]]
 +
*[[Candidate key]]
 +
*[[Foreign key]]
 +
*[[Superkey]]
 +
*[[Surrogate key]]
 +
*[[Unique key]]
  
}}<noinclude>
+
| group3 = Objects
[[Category:Database management systems|*]]
+
| list3  =
[[Category:Computing navigational boxes|{{PAGENAME}}]]
+
*[[Relation (database)|Relation]]
[[de:Template:Databases]]
+
**[[Table (database)|table]]
[[no:Mal:Databaser]]
+
**[[Column (database)|column]]
[[ru:Template:Databases]]
+
**[[Row (database)|row]]
[[zh:Template:Databases]]
+
*[[View (SQL)|View]]
 +
*[[Database transaction|Transaction]]
 +
*[[Transaction log]]
 +
*[[Database trigger|Trigger]]
 +
*[[Database index|Index]]
 +
*[[Stored procedure]]
 +
*[[Cursor (databases)|Cursor]]
 +
*[[Partition (database)|Partition]]
 +
 
 +
| group4 = Components
 +
| list4  =
 +
*[[Concurrency control]]
 +
*[[Data dictionary]]
 +
*[[Java Database Connectivity|JDBC]]
 +
*[[XQuery API for Java|XQJ]]
 +
*[[Open Database Connectivity|ODBC]]
 +
*[[Query language]]
 +
*[[Query optimization|Query optimizer]]
 +
*[[Query Rewriting|Query rewriting system]]
 +
*[[Query plan]]
 +
 
 +
| group5 = Functions
 +
| list5  =
 +
* [[Database administration|Administration]]
 +
* [[Query optimization]]
 +
* [[Replication (computing)#DATABASE|Replication]]
 +
*[[Shard_(database_architecture)|Sharding]]
 +
 
 +
| group6 = Related topics
 +
| list6  =
 +
*[[Database model]]s
 +
*[[Database normalization]]
 +
*[[Database storage structures|Database storage]]
 +
*[[Distributed database]]
 +
*[[Federated database system]]
 +
*[[Referential integrity]]
 +
*[[Relational algebra]]
 +
*[[Relational calculus]]
 +
*[[Relational database]]
 +
*[[Relational model]]
 +
*[[Object-relational database]]
 +
*[[Transaction processing]]
 +
 
 +
| below =
 +
*{{Icon|Category}} [[:Category:Database_management_systems|Category]]
 +
*{{Icon|Outline}} [[Outline_of_databases|Outline]]
 +
*{{icon|WikiProject}} [[Wikipedia:WikiProject_Databases|WikiProject]]
 +
 
 +
}}{{main other|{{#ifeq:{{{cat}}}|no||[[Category:Database management systems]]}}}}<noinclude>
 +
[[Category:Computing navigational boxes]]
 +
[[Category:Software navbox templates]]
 +
[[Category:Database management systems|·]]
 +
[[Category:Databases|·management systems]]
 
</noinclude>
 
</noinclude>

Latest revision as of 21:25, 19 April 2020