Difference between revisions of "Template:Databases"

From blackwiki
Jump to navigation Jump to search
imported>Nicomece
m (Added Sharding in Functions.)
 
(227 intermediate revisions by more than 100 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%"
+
| list2  =  
|- bgcolor="#ccccff"
+
*[[Database]]
| align="center" | '''Topics in [[database management system]]s (DBMS)''' ({{Tnavbar|Databases|plain=1|nodiv=1}})
+
*[[ACID]]
|-
+
*[[Armstrong's axioms]]
| align="center" style="font-size: small" |
+
*[[Codd's_12_rules|Codd's 12 rules]]
''Concepts'' <br>
+
*[[CAP theorem]]
[[Database]] | [[Database model]] [[Relational database|Relational database]] | [[Relational model]] |
+
*[[Create, read, update and delete|CRUD]]
[[Relational algebra]] [[Primary key]] - [[Foreign key]] - [[Surrogate key]] - [[Superkey]] - [[Candidate key]]<br> [[Database normalization]] | [[Referential integrity]] | [[Relational database management system|Relational DBMS]] |
+
*[[Null (SQL)|Null]]
[[Distributed database management system|Distributed DBMS]] | [[ACID]]
+
*[[Candidate key]]
 +
*[[Foreign key]]
 +
*[[Superkey]]
 +
*[[Surrogate key]]
 +
*[[Unique key]]
  
{| width="100%" cellspacing=0 cellpadding=2 border=0 |
+
| group3 = Objects
|- class="toccolours" style="font-size: small"
+
| list3  =  
| width="50%" align="center" style="vertical-align:top; border-top: 1px solid #ccccff; border-right: 1px solid #ccccff" |
+
*[[Relation (database)|Relation]]
''Objects''<br>
+
**[[Table (database)|table]]
[[Database trigger|Trigger]] | [[View (database)|View]] |
+
**[[Column (database)|column]]
[[Table (database)|Table]] | [[Cursor (databases)|Cursor]] | [[Transaction log|Log]] | [[Database transaction|Transaction]] |
+
**[[Row (database)|row]]
[[Index (database)|Index]] | [[Stored procedure]] | [[Partition (database)|Partition]]
+
*[[View (SQL)|View]]
| width="50%" align="center" style="vertical-align:top; border-top: 1px solid #ccccff" |
+
*[[Database transaction|Transaction]]
''Topics in [[SQL]]'' <br>
+
*[[Transaction log]]
[[Select (SQL)|Select]] |
+
*[[Database trigger|Trigger]]
[[Insert (SQL)|Insert]] |
+
*[[Database index|Index]]
[[Update (SQL)|Update]] |
+
*[[Stored procedure]]
[[Merge (SQL)|Merge]] |
+
*[[Cursor (databases)|Cursor]]
[[Delete (SQL)|Delete]] |
+
*[[Partition (database)|Partition]]
[[Join (SQL)|Join]] |
+
 
[[Union (SQL)|Union]] |
+
| group4 = Components
[[Create (SQL)|Create]] |
+
| list4  =  
[[Drop (SQL)|Drop]]<br>
+
*[[Concurrency control]]
|}
+
*[[Data dictionary]]
|- bgcolor="#ccccff"
+
*[[Java Database Connectivity|JDBC]]
| align="center" | '''Implementations of database management systems'''
+
*[[XQuery API for Java|XQJ]]
|-
+
*[[Open Database Connectivity|ODBC]]
| align="center" style="font-size: small" |
+
*[[Query language]]
{| width="100%" cellspacing=0 cellpadding=2 border=0 |
+
*[[Query optimization|Query optimizer]]
|- class="toccolours" style="font-size: small"
+
*[[Query Rewriting|Query rewriting system]]
| width="50%" align="center" style="vertical-align:top; border-top: 1px solid #ccccff; border-right: 1px solid #ccccff" |
+
*[[Query plan]]
''Types of implementations''<br>
+
 
[[Relational database|Relational]] | [[Flat file database|Flat file]] | [[Deductive database|Deductive]] | [[Dimensional database|Dimensional]] | [[Hierarchical model|Hierarchical]] | [[Object database|Object oriented]] | [[Temporal database|Temporal]] | [[XML database | XML data stores]]<br>
+
| group5 = Functions
<br>''Products''<Br>
+
| list5  =
[[Apache Derby]] | [[Berkeley DB]] | [[Caché (software)|Caché]] | [[db4o]] | [[dBASE]] | [[Firebird (database server)|Firebird]] | [[H2 (DBMS)|H2]] | [[Helix (database)|Helix]] | [[IBM DB2|DB2]] | [[Informix|Informix]] | [[Ingres]] | [[InterBase]] | [[Linter SQL RDBMS|Linter]] | [[Microsoft SQL Server]] | [[Microsoft Access]] | [[MySQL]] | [[Virtuoso Universal Server|OpenLink Virtuoso]] | [[Oracle database|Oracle]] | [[Oracle Rdb|Oracle Rdb]] | [[PostgreSQL]] | [[SQLite]] | [[Sybase IQ]] | [[Adaptive Server Enterprise|Sybase]] | [[Teradata]] | [[TimesTen]] | [[Visual FoxPro]] | [[Comparison of relational database management systems|Comparison - relational]] | [[Comparison of object-relational database management systems|Comparison - object-relational]]  
+
* [[Database administration|Administration]]
| width="50%" align="center" style="vertical-align:top; border-top: 1px solid #ccccff" |
+
* [[Query optimization]]
''Components''<br>
+
* [[Replication (computing)#DATABASE|Replication]]
[[Query language]] | [[Query optimizer]] | [[Query plan]] |
+
*[[Shard_(database_architecture)|Sharding]]
[[Open Database Connectivity|ODBC]] |
+
 
[[Java Database Connectivity|JDBC]]
+
| group6 = Related topics
<br>''Lists'' <br>
+
| list6  =
[[List of object-oriented database management systems]]
+
*[[Database model]]s
<br>[[List of relational database management systems]]
+
*[[Database normalization]]
|}
+
*[[Database storage structures|Database storage]]
|}
+
*[[Distributed database]]
<noinclude>
+
*[[Federated database system]]
[[Category:Database management systems|*]]
+
*[[Referential integrity]]
[[de:Template:Databases]]
+
*[[Relational algebra]]
[[ru:Template:Databases]]
+
*[[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