Database

From EduTech Wiki
Jump to: navigation, search

This article or section is a stub. A stub is an entry that did not yet receive substantial attention from editors, and as such does not yet contain enough information to be considered a real article. In other words, it is a short or insufficient piece of information and requires additions.

Draft

1 Definition

“In computer science, a database is a structured collection of records or data that is stored in a computer system so that a computer program or person using a query language can consult it to answer queries. The records retrieved in answer to queries are information that can be used to make decisions. The computer program used to manage and query a database is known as a database management system (DBMS).” (Wikipedia, retrieved 22:30, 12 September 2007 (MEST)).

The goal of this (future) article is threefold (for now):

  • List some useful Wikipedia resources on general database issues
  • Point to other articles in this Wiki
  • Show where in educational technology various kinds of databases are being used

See also: web application framework, web service, portalware

2 A guide to Wikipedia's database articles

(by no means complete, these are just some important entry points)

2.1 General

Database: History, Overview of Database models, Technical internals, Overview of Database applications

2.2 Models and query languages

Database models: Overview of flat, hierarchical, network, relational and object models
Data model (short overview)
List of database models
Query language (short table)
Relational model (the model)
Relational database (the model again)
SQL
XML databases and files
XQuery (to query XML data and XML databases)
XQuery Update Facility (Stub)
XML data and files
XSLT
XPath
XPointer
E4X (a ECMAScript/ActionScript extension)
Document Object Model), SAX, etc.
SPARQL (to query RDF)
Hierarchical model
Lightweight Directory Access Protocol (LDAP)
Object-relational model
Object model
Flat file
Regular expression

2.3 Technology

Database management system
Relational database management system (RDBMS)
Comparison of relational database management systems
MySQL
Microsoft SQL Server
Object-relational database (ORDBMS)
Comparison of object-relational database management systems
Object database OODBMS]
List of object-oriented database management systems
XML database
eXist
NoSQL (A whole range of non SQL databases, in particular so-called key-value stores)
LDAP
List of LDAP software
Directory Service
Simple
FileMaker
Special purpose applications such as reference managers with their own storage engine
Flat file database (can implement various models)
Single file
SQLLite
SQL Server Compact (Microsoft)
Serialization to files in some programming languages
Database engines (Low level, i.e. DBMS are built on top)
MyISAM (used by MySQL)
InnoDB (used by MySQL)
BerkeleyDB
dbm
Client-side (don't know where to put these)
JavaDB, HSQL, etc. (quite heavy)
TrimQuery and Trimpath JS templates

2.4 Related issues

Databases are an important component in webapplications and are integrated within web application frameworks

3 In this Wiki

Entries related to databases:

4 In education

5 Links