Database: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
Line 36: Line 36:
::: [http://en.wikipedia.org/wiki/SPARQL SPARQL] (to query RDF)
::: [http://en.wikipedia.org/wiki/SPARQL SPARQL] (to query RDF)


:: [http://en.wikipedia.org/wiki/LDAP LDAP]
:: [http://en.wikipedia.org/wiki/LDAP Lightweight Directory Access Protocol] (LDAP)


:: '''Flat file'''
:: '''Flat file'''
Line 56: Line 56:
:: [http://en.wikipedia.org/wiki/XML_database XML database]
:: [http://en.wikipedia.org/wiki/XML_database XML database]
::: eXist
::: eXist
:: LDAP
::: [http://en.wikipedia.org/wiki/List_of_LDAP_software List of LDAP software]
::: [http://en.wikipedia.org/wiki/Directory_service Directory Service]


:: '''Simple'''
:: '''Simple'''
Line 72: Line 76:
::: [http://en.wikipedia.org/wiki/BerkeleyDB BerkeleyDB]
::: [http://en.wikipedia.org/wiki/BerkeleyDB BerkeleyDB]
::: [http://en.wikipedia.org/wiki/Dbm dbm]
::: [http://en.wikipedia.org/wiki/Dbm dbm]
== In education ==
* [[Portalware]] such as [[Learning management system]]s or [[Learning object repository| learning object repositories]] are usually implemented with an RDBMS (e.g. MySQL). Open source platforms mostly use a [[LAMP]]/[[WAMP]] architecture
* [[XML database]]s so far a thinly spread, since education always is slow to keep up with latest trends.
* Many client-side applications such as [[reference manager]]s or [[teacher productivity tool]]s use various single file systems, sometimes just a flat file.


[[Category: Technologies]]
[[Category: Technologies]]
[[Category: Databases]]
[[Category: Databases]]

Revision as of 21:03, 12 September 2007

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