Difference between revisions of "Template:Databases"

From blackwiki
Jump to navigation Jump to search
imported>TommyG
(rv. feel free to add it when there's an actual article.)
imported>Fred Bradstadt
m (cleanup)
Line 1: Line 1:
 
{| align="center" class="toccolours" cellspacing="0" width="95%" style="text-align:center"
 
{| align="center" class="toccolours" cellspacing="0" width="95%" style="text-align:center"
 
|-
 
|-
|colspan="2" style="background-color:#ccccff"| '''Topics in [[database management system]]s (DBMS)''' ({{Tnavbar|Databases|plain=1|nodiv=1}})
+
!colspan="2" style="background-color:#ccccff"| Topics in [[database management system]]s (DBMS) ({{Tnavbar|Databases|plain=1|nodiv=1}})
 
|-
 
|-
|colspan="2" style="font-size:small; border-bottom:1px solid #ccccff"|
+
|colspan="2" style="border-bottom:1px solid #ccccff"|
 
''Concepts''<br />
 
''Concepts''<br />
 
[[Database]]&nbsp;•
 
[[Database]]&nbsp;•
Line 11: Line 11:
 
[[Distributed database management system|Distributed&nbsp;DBMS]]&nbsp;•
 
[[Distributed database management system|Distributed&nbsp;DBMS]]&nbsp;•
 
[[ACID]]&nbsp;•
 
[[ACID]]&nbsp;•
[[Null (SQL)|Null]]<br>
+
[[Null (SQL)|Null]]<br />
 
[[Relational database]]&nbsp;•
 
[[Relational database]]&nbsp;•
 
[[Relational algebra]]&nbsp;•
 
[[Relational algebra]]&nbsp;•
Line 17: Line 17:
 
[[Database normalization]]&nbsp;•
 
[[Database normalization]]&nbsp;•
 
[[Referential integrity]]&nbsp;•
 
[[Referential integrity]]&nbsp;•
[[Relational database management system|Relational&nbsp;DBMS]]&nbsp;<br>
+
[[Relational database management system|Relational&nbsp;DBMS]]&nbsp;<br />
[[Primary key]], [[Foreign key]], [[Surrogate key]], [[Superkey]], [[Candidate key]]&nbsp;
+
[[Primary key]], [[Foreign key]], [[Surrogate key]], [[Superkey]], [[Candidate key]]
 
|-
 
|-
|style="font-size:small; width:50%; vertical-align:top; border-right:1px solid #ccccff"|
+
|style="width:50%; vertical-align:top; border-right:1px solid #ccccff"|
 
''Objects''<br />
 
''Objects''<br />
 
[[Database trigger|Trigger]]&nbsp;•
 
[[Database trigger|Trigger]]&nbsp;•
Line 28: Line 28:
 
[[Transaction log|Log]]&nbsp;•
 
[[Transaction log|Log]]&nbsp;•
 
[[Database transaction|Transaction]]&nbsp;•
 
[[Database transaction|Transaction]]&nbsp;•
[[Index (database)|Index]]&nbsp;<br>
+
[[Index (database)|Index]]&nbsp;<br />
 
[[Stored procedure]]&nbsp;•
 
[[Stored procedure]]&nbsp;•
 
[[Partition (database)|Partition]]
 
[[Partition (database)|Partition]]
|style="font-size:small; width:50%; vertical-align:top"|
+
|style="width:50%; vertical-align:top"|
 
''Topics in [[SQL]]''<br />
 
''Topics in [[SQL]]''<br />
 
[[Select (SQL)|Select]]&nbsp;•
 
[[Select (SQL)|Select]]&nbsp;•
Line 41: Line 41:
 
[[Union (SQL)|Union]]&nbsp;•
 
[[Union (SQL)|Union]]&nbsp;•
 
[[Create (SQL)|Create]]&nbsp;•
 
[[Create (SQL)|Create]]&nbsp;•
[[Drop (SQL)|Drop]]<br>&nbsp;
+
[[Drop (SQL)|Drop]]<br />
 
[[Begin work (SQL)|Begin work]]&nbsp;•
 
[[Begin work (SQL)|Begin work]]&nbsp;•
 
[[Commit (SQL)|Commit]]&nbsp;•
 
[[Commit (SQL)|Commit]]&nbsp;•
Line 48: Line 48:
 
[[Alter (SQL)|Alter]]
 
[[Alter (SQL)|Alter]]
 
|-
 
|-
|colspan="2" style="background-color:#ccccff"| '''Implementations of database management systems'''
+
!colspan="2" style="background-color:#ccccff"| Implementations of database management systems
 
|-
 
|-
|colspan="2" style="font-size:small; width:50%; vertical-align:top; border-bottom:1px solid #ccccff"|
+
|colspan="2" style="vertical-align:top; border-bottom:1px solid #ccccff"|
 
''Types of implementations''<br />
 
''Types of implementations''<br />
 
[[Relational database|Relational]]&nbsp;•
 
[[Relational database|Relational]]&nbsp;•
Line 62: Line 62:
 
[[XML database|XML&nbsp;data&nbsp;stores]]
 
[[XML database|XML&nbsp;data&nbsp;stores]]
 
|-
 
|-
|style="font-size:small; width:50%; vertical-align:top; border-right:1px solid #ccccff"|
+
|style="width:50%; vertical-align:top; border-right:1px solid #ccccff"|
 
''Database products''<br />
 
''Database products''<br />
 
[[List of object-oriented database management systems|Object-oriented]] ([[Comparison of object-relational database management systems|comparison]])&nbsp;•
 
[[List of object-oriented database management systems|Object-oriented]] ([[Comparison of object-relational database management systems|comparison]])&nbsp;•
 
[[List of relational database management systems|Relational]] ([[Comparison of relational database management systems|comparison]])
 
[[List of relational database management systems|Relational]] ([[Comparison of relational database management systems|comparison]])
|style="font-size:small; width:50%; vertical-align:top"|
+
|style="width:50%; vertical-align:top"|
 
''Components''<br />
 
''Components''<br />
 
[[Query language]]&nbsp;•
 
[[Query language]]&nbsp;•

Revision as of 18:45, 23 August 2007