Difference between revisions of "Template:Databases"

From blackwiki
Jump to navigation Jump to search
imported>Fred Bradstadt
m (code cleanup)
imported>Thumperward
(reorganise in a more compact and future-maintainable format using template:navbox)
Line 1: Line 1:
{| class="navbox collapsible autocollapse" style="width:95%;margin-left:auto;margin-right:auto"
+
{{ navbox
|-
+
| title = [[Database management system]]s
! colspan="2" | {{tnavbar-collapsible|Topics in [[database management system]]s (DBMS)|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]]{{·}} [[Transaction processing]]
|colspan="2" style="border-bottom:1px solid #ccccff"|
+
 
''Major subtopics''<br />
+
| group1 = Concepts
[[Database models]]&nbsp;•
+
| list1  = [[Database]]{{·}} [[ACID]]{{·}} [[Null (SQL)|Null]]{{·}} [[Candidate key]]{{·}} [[Foreign key]]{{·}} [[Primary key]]{{·}} [[Superkey]]{{·}} [[Surrogate key]]
[[Database normalization]]&nbsp;•
+
| group2 = Objects
[[Database storage structures|Database storage]]&nbsp;•
+
| 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]]
[[Distributed database management system|Distributed&nbsp;DBMS]]&nbsp;•
+
| group3 = [[SQL]]
[[Referential integrity]]&nbsp;•
+
| 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]]
[[Relational algebra]]&nbsp;•
+
| group4 = Implementations
[[Relational calculus]]&nbsp;•
+
| list4  = [[Relational database|Relational]]{{·}} [[Flat file database|Flat file]]{{·}} [[Deductive database|Deductive]]{{·}} [[Dimensional database|Dimensional]]{{·}} [[Hierarchical model|Hierarchical]]{{·}} [[Object database|Object-oriented]]{{·}} [[Object-relational database|Object-relational]]{{·}} [[Temporal database|Temporal]]{{·}} [[XML database|XML data stores]]
[[Relational database]]&nbsp;•
+
| group5 = Components
[[Relational database management system|Relational&nbsp;DBMS]]&nbsp;•
+
| list5  = [[Concurrency control]]{{·}} [[Query language]]{{·}} [[Query optimizer]]{{·}} [[Query plan]]{{·}} [[Open Database Connectivity|ODBC]]{{·}} [[Java Database Connectivity|JDBC]]
[[Relational model]]&nbsp;•
+
 
[[Transaction processing]]
+
| 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]])
|-
+
 
|colspan="2" style="border-bottom:1px solid #ccccff"|
+
}}<noinclude>
''Concepts''<br />
 
[[Database]]&nbsp;•
 
[[ACID]]&nbsp;•
 
[[Null (SQL)|Null]]&nbsp;•
 
[[Candidate key]]&nbsp;•
 
[[Foreign key]]&nbsp;•
 
[[Primary key]]&nbsp;•
 
[[Superkey]]&nbsp;•
 
[[Surrogate key]]
 
|-
 
|style="width:50%; vertical-align:top; border-right:1px solid #ccccff"|
 
''Objects''<br />
 
[[Database trigger|Trigger]]&nbsp;•
 
[[View (database)|View]]&nbsp;•
 
[[Table (database)|Table]]&nbsp;•
 
[[Cursor (databases)|Cursor]]&nbsp;•
 
[[Transaction log|Log]]&nbsp;•
 
[[Database transaction|Transaction]]&nbsp;•
 
[[Index (database)|Index]]<br />
 
[[Stored procedure]]&nbsp;•
 
[[Partition (database)|Partition]]
 
|style="width:50%; vertical-align:top"|
 
''Topics in [[SQL]]''<br />
 
[[Select (SQL)|Select]]&nbsp;•
 
[[Insert (SQL)|Insert]]&nbsp;•
 
[[Update (SQL)|Update]]&nbsp;•
 
[[Merge (SQL)|Merge]]&nbsp;•
 
[[Delete (SQL)|Delete]]&nbsp;•
 
[[Join (SQL)|Join]]&nbsp;•
 
[[Union (SQL)|Union]]&nbsp;•
 
[[Create (SQL)|Create]]&nbsp;•
 
[[Drop (SQL)|Drop]]<br />
 
[[Begin work (SQL)|Begin work]]&nbsp;•
 
[[Commit (SQL)|Commit]]&nbsp;•
 
[[Rollback (SQL)|Rollback]]&nbsp;•
 
[[Truncate (SQL)|Truncate]]&nbsp;•
 
[[Alter (SQL)|Alter]]
 
|-
 
!colspan="2"| Implementations of database management systems
 
|-
 
|colspan="2" style="vertical-align:top; border-bottom:1px solid #ccccff"|
 
''Types of implementations''<br />
 
[[Relational database|Relational]]&nbsp;•
 
[[Flat file database|Flat&nbsp;file]]&nbsp;•
 
[[Deductive database|Deductive]]&nbsp;•
 
[[Dimensional database|Dimensional]]&nbsp;•
 
[[Hierarchical model|Hierarchical]]&nbsp;•
 
[[Object database|Object&nbsp;oriented]]&nbsp;•
 
[[Object-relational database|Object&nbsp;relational]]&nbsp;•
 
[[Temporal database|Temporal]]&nbsp;•
 
[[XML database|XML&nbsp;data&nbsp;stores]]
 
|-
 
|style="width:50%; vertical-align:top; border-right:1px solid #ccccff"|
 
''Database products''<br />
 
[[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]])
 
|style="width:50%; vertical-align:top"|
 
''Components''<br />
 
[[Concurrency control]]&nbsp;•
 
[[Query language]]&nbsp;•
 
[[Query optimizer]]&nbsp;•
 
[[Query plan]]&nbsp;•
 
[[Open Database Connectivity|ODBC]]&nbsp;•
 
[[Java Database Connectivity|JDBC]]
 
|}<noinclude>
 
 
[[Category:Database management systems|*]]
 
[[Category:Database management systems|*]]
 
[[Category:Computing navigational boxes|{{PAGENAME}}]]
 
[[Category:Computing navigational boxes|{{PAGENAME}}]]

Revision as of 11:26, 18 October 2007