Database

Draft

This article or section is currently under construction

In principle, someone is working on it and there should be a better version in a not so distant future.
If you want to modify this page, please discuss it with the person working on it (see the "history")

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

A guide to Wikipedia's database articles

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

General

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

Models and query languages

Database models: Overview of flat, hierarchical, network, relational and object models

Data model (short overview)

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)

Lightweight Directory Access Protocol (LDAP)

Flat file

Regular expression

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

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)

Database engines (Low level, i.e. DBMS are built on top)

MyISAM (used by MySQL)

InnoDB (used by MySQL)

BerkeleyDB

dbm

In education

• Portalware such as Learning management systems or learning object repositories are usually implemented with an RDBMS (e.g. MySQL). Open source platforms mostly use a LAMP/WAMP architecture
• XML databases so far a thinly spread, since education always is slow to keep up with latest trends.
• Many client-side applications such as reference managers or teacher productivity tools use various single file systems, sometimes just a flat file.