Database: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
Line 11: Line 11:
(by no means complete, these are just some important entry points)
(by no means complete, these are just some important entry points)


; General
===  General ===
:[http://en.wikipedia.org/wiki/Database Database]: History, Overview of Database models, Technical internals, Overview of Database applications
:[http://en.wikipedia.org/wiki/Database Database]: History, Overview of Database models, Technical internals, Overview of Database applications


; Models and query languages
=== Models and query languages ===
 
: [http://en.wikipedia.org/wiki/Database_models Database models]: Overview of flat, hierarchical, network, relational and object models
: [http://en.wikipedia.org/wiki/Database_models Database models]: Overview of flat, hierarchical, network, relational and object models
: [http://en.wikipedia.org/wiki/Data_model Data model] (short overview)
: [http://en.wikipedia.org/wiki/Data_model Data model] (short overview)


: [http://en.wikipedia.org/wiki/Query_language Query language] (short table)
: [http://en.wikipedia.org/wiki/Query_language Query language] (short table)
:: [http://en.wikipedia.org/wiki/Relational_model Relational model]
:: [http://en.wikipedia.org/wiki/Relational_model Relational model] (the model)
:: [http://en.wikipedia.org/wiki/Relational_database Relational database] (the model)
:: [http://en.wikipedia.org/wiki/Relational_database Relational database] (the model again)
::: [http://en.wikipedia.org/wiki/SQL SQL]
::: [http://en.wikipedia.org/wiki/SQL SQL]


Line 34: Line 35:
::: [http://en.wikipedia.org/wiki/Document_Object_Model Document Object Model]), [http://en.wikipedia.org/wiki/Simple_API_for_XML SAX], etc.
::: [http://en.wikipedia.org/wiki/Document_Object_Model Document Object Model]), [http://en.wikipedia.org/wiki/Simple_API_for_XML SAX], etc.
::: [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]


:: '''Flat file'''
:: '''Flat file'''
::: [http://en.wikipedia.org/wiki/Regular_expression Regular expression]
::: [http://en.wikipedia.org/wiki/Regular_expression Regular expression]


; Technology
=== Technology ===
: [http://en.wikipedia.org/wiki/Database_management_system Database management system]
: [http://en.wikipedia.org/wiki/Database_management_system Database management system]


Line 54: Line 57:
::: eXist
::: eXist


:: '''Simple / special purpose'''
:: '''Simple'''
::: [http://en.wikipedia.org/wiki/FileMaker FileMaker]
::: [http://en.wikipedia.org/wiki/FileMaker FileMaker]
::: Special purpose applications such as [[reference manager]]s with their own storage engine


:: [http://en.wikipedia.org/wiki/Flat_file_database Flat file database] (can implement various models)
:: [http://en.wikipedia.org/wiki/Flat_file_database Flat file database] (can implement various models)

Revision as of 20:52, 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)
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
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