Difference between revisions of "Template:Databases"

From blackwiki
Jump to navigation Jump to search
imported>Nicomece
m (Added Sharding in Functions.)
 
(132 intermediate revisions by 86 users not shown)
Line 1: Line 1:
<!--
+
{{Navbox
In oracle, There is no table having column defined as primary key instead it is using sequences. But i could not find any table either it it DBA% or ALL%,
+
| title    = [[Database|Database management system]]s
where the foreign keys are stored.
+
| name      = Databases
 +
| state = {{{state<includeonly>|</includeonly>}}}
 +
| bodyclass = hlist
  
    E    Since this template affects many articles, you may wish to discuss changes on the talk page first.
+
| group1 = Types
 +
| list1  =
 +
*[[Object database|Object-oriented]]
 +
**[[Comparison of object database management systems|comparison]]
 +
*[[Relational_database|Relational]]
 +
**[[List of relational database management systems|list]]
 +
**[[Comparison of relational database management systems|comparison]]
 +
*[[Key-value_database|Key-value]]
 +
*[[Column-oriented DBMS|Column-oriented]]
 +
**[[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]]
  
-->
+
| group2 = Concepts
{| align="center" class="toccolours" cellspacing="0" width="95%" style="text-align:center"
+
| list2  =
|-
+
*[[Database]]
|colspan="2" style="background-color:#ccccff"| '''Topics in [[database management system]]s (DBMS)''' ({{Tnavbar|Databases|plain=1|nodiv=1}})
+
*[[ACID]]
|-
+
*[[Armstrong's axioms]]
|colspan="2" style="font-size:small; border-bottom:1px solid #ccccff"|
+
*[[Codd's_12_rules|Codd's 12 rules]]
''Concepts''<br />
+
*[[CAP theorem]]
[[Database]]&nbsp;•
+
*[[Create, read, update and delete|CRUD]]
[[Database models]]&nbsp;•
+
*[[Null (SQL)|Null]]
[[Database storage structures|Database storage]]&nbsp;•
+
*[[Candidate key]]
[[Relational model]]&nbsp;•
+
*[[Foreign key]]
[[Distributed database management system|Distributed&nbsp;DBMS]]&nbsp;•
+
*[[Superkey]]
[[ACID]]&nbsp;•
+
*[[Surrogate key]]
[[Null (SQL)|Null]]<br>
+
*[[Unique key]]
[[Relational database]]&nbsp;•
+
 
[[Relational algebra]]&nbsp;•
+
| group3 = Objects
[[Relational calculus]]&nbsp;•
+
| list3  =
[[Database normalization]]&nbsp;•
+
*[[Relation (database)|Relation]]
[[Referential integrity]]&nbsp;•
+
**[[Table (database)|table]]
[[Relational database management system|Relational&nbsp;DBMS]]&nbsp;<br>
+
**[[Column (database)|column]]
[[Primary key]], [[Foreign key]], [[Surrogate key]], [[Superkey]], [[Candidate key]]&nbsp;
+
**[[Row (database)|row]]
|-
+
*[[View (SQL)|View]]
|style="font-size:small; width:50%; vertical-align:top; border-right:1px solid #ccccff"|
+
*[[Database transaction|Transaction]]
''Objects''<br />
+
*[[Transaction log]]
[[Database trigger|Trigger]]&nbsp;•
+
*[[Database trigger|Trigger]]
[[View (database)|View]]&nbsp;•
+
*[[Database index|Index]]
[[Table (database)|Table]]&nbsp;•
+
*[[Stored procedure]]
[[Cursor (databases)|Cursor]]&nbsp;•
+
*[[Cursor (databases)|Cursor]]
[[Transaction log|Log]]&nbsp;•
+
*[[Partition (database)|Partition]]
[[Database transaction|Transaction]]&nbsp;•
+
 
[[Index (database)|Index]]&nbsp;<br>
+
| group4 = Components
[[Stored procedure]]&nbsp;•
+
| list4  =
[[Partition (database)|Partition]]
+
*[[Concurrency control]]
|style="font-size:small; width:50%; vertical-align:top"|
+
*[[Data dictionary]]
''Topics in [[SQL]]''<br />
+
*[[Java Database Connectivity|JDBC]]
[[Select (SQL)|Select]]&nbsp;•
+
*[[XQuery API for Java|XQJ]]
[[Insert (SQL)|Insert]]&nbsp;•
+
*[[Open Database Connectivity|ODBC]]
[[Update (SQL)|Update]]&nbsp;•
+
*[[Query language]]
[[Merge (SQL)|Merge]]&nbsp;•
+
*[[Query optimization|Query optimizer]]
[[Delete (SQL)|Delete]]&nbsp;•
+
*[[Query Rewriting|Query rewriting system]]
[[Join (SQL)|Join]]&nbsp;•
+
*[[Query plan]]
[[Union (SQL)|Union]]&nbsp;•
+
 
[[Create (SQL)|Create]]&nbsp;•
+
| group5 = Functions
[[Drop (SQL)|Drop]]<br>&nbsp;
+
| list5  =
[[Begin work (SQL)|Begin work]]&nbsp;•
+
* [[Database administration|Administration]]
[[Commit (SQL)|Commit]]&nbsp;•
+
* [[Query optimization]]
[[Rollback (SQL)|Rollback]]&nbsp;•
+
* [[Replication (computing)#DATABASE|Replication]]
[[Truncate (SQL)|Truncate]]&nbsp;•
+
*[[Shard_(database_architecture)|Sharding]]
[[Alter (SQL)|Alter]]
+
 
|-
+
| group6 = Related topics
|colspan="2" style="background-color:#ccccff"| '''Implementations of database management systems'''
+
| list6  =  
|-
+
*[[Database model]]s
|colspan="2" style="font-size:small; width:50%; vertical-align:top; border-bottom:1px solid #ccccff"|
+
*[[Database normalization]]
''Types of implementations''<br />
+
*[[Database storage structures|Database storage]]
[[Relational database|Relational]]&nbsp;•
+
*[[Distributed database]]
[[Flat file database|Flat&nbsp;file]]&nbsp;•
+
*[[Federated database system]]
[[Deductive database|Deductive]]&nbsp;•
+
*[[Referential integrity]]
[[Dimensional database|Dimensional]]&nbsp;•
+
*[[Relational algebra]]
[[Hierarchical model|Hierarchical]]&nbsp;•
+
*[[Relational calculus]]
[[Object database|Object&nbsp;oriented]]&nbsp;•
+
*[[Relational database]]
[[Object-relational database|Object&nbsp;relational]]&nbsp;•
+
*[[Relational model]]
[[Temporal database|Temporal]]&nbsp;•
+
*[[Object-relational database]]
[[XML database|XML&nbsp;data&nbsp;stores]]
+
*[[Transaction processing]]
|-
+
 
|style="font-size:small; width:50%; vertical-align:top; border-right:1px solid #ccccff"|
+
| below =
''Database products''<br />
+
*{{Icon|Category}} [[:Category:Database_management_systems|Category]]
[[List of object-oriented database management systems|Object-oriented]] ([[Comparison of object-relational database management systems|comparison]])&nbsp;•
+
*{{Icon|Outline}} [[Outline_of_databases|Outline]]
[[List of relational database management systems|Relational]] ([[Comparison of relational database management systems|comparison]])
+
*{{icon|WikiProject}} [[Wikipedia:WikiProject_Databases|WikiProject]]
|style="font-size:small; width:50%; vertical-align:top"|
+
 
''Components''<br />
+
}}{{main other|{{#ifeq:{{{cat}}}|no||[[Category:Database management systems]]}}}}<noinclude>
[[Query language]]&nbsp;•
+
[[Category:Computing navigational boxes]]
[[Query optimizer]]&nbsp;•
+
[[Category:Software navbox templates]]
[[Query plan]]&nbsp;•
+
[[Category:Database management systems|·]]
[[Open Database Connectivity|ODBC]]&nbsp;•
+
[[Category:Databases|·management systems]]
[[Java Database Connectivity|JDBC]]
 
|}<noinclude>
 
[[Category:Database management systems|*]]
 
[[Category:Computing templates|Databases]]
 
[[de:Template:Databases]]
 
[[no:Mal:Databaser]]
 
[[ru:Template:Databases]]
 
[[zh:Template:Database]]
 
 
</noinclude>
 
</noinclude>

Latest revision as of 21:25, 19 April 2020