Database: Difference between revisions
Jump to navigation
Jump to search
m (using an external editor) |
m (using an external editor) |
||
| Line 8: | Line 8: | ||
== A guide to Wikipedia's database articles == | == A guide to Wikipedia's database articles == | ||
(by no means complete, these are just some important entry points) | |||
; General | ; General | ||
| Line 14: | Line 16: | ||
; 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/Query_language Query language] (short table) | : [http://en.wikipedia.org/wiki/Query_language Query language] (short table) | ||
: [http://en.wikipedia.org/wiki/ | :: [http://en.wikipedia.org/wiki/Relational_model Relational model] | ||
:: [http://en.wikipedia.org/wiki/ | :: [http://en.wikipedia.org/wiki/Relational_database Relational database] (the model) | ||
::: [http://en.wikipedia.org/wiki/SQL SQL] | ::: [http://en.wikipedia.org/wiki/SQL SQL] | ||
:: XML | |||
:: [http://en.wikipedia.org/wiki/XML XML] databases and files | |||
::: [http://en.wikipedia.org/wiki/XQuery XQuery] (to query XML data and XML databases) | ::: [http://en.wikipedia.org/wiki/XQuery XQuery] (to query XML data and XML databases) | ||
::: [http://en.wikipedia.org/wiki/XQuery_Update_Facility XQuery Update Facility] (Stub) | ::: [http://en.wikipedia.org/wiki/XQuery_Update_Facility XQuery Update Facility] (Stub) | ||
::: [http://en.wikipedia.org/wiki/XSLT XSLT] | |||
:: XML data and files | |||
::: [http://en.wikipedia.org/wiki/XSLT XSLT] | |||
:::: [http://en.wikipedia.org/wiki/XPath XPath] | :::: [http://en.wikipedia.org/wiki/XPath XPath] | ||
:::: [http://en.wikipedia.org/wiki/XPointer XPointer] | :::: [http://en.wikipedia.org/wiki/XPointer XPointer] | ||
::: [http://en.wikipedia.org/wiki/E4X E4X] (a ECMAScript/ActionScript extension) | |||
::: [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) | ||
:: Flat file | |||
:: '''Flat file''' | |||
::: [http://en.wikipedia.org/wiki/Regular_expression Regular expression] | ::: [http://en.wikipedia.org/wiki/Regular_expression Regular expression] | ||
| Line 42: | Line 52: | ||
:: [http://en.wikipedia.org/wiki/XML_database XML database] | :: [http://en.wikipedia.org/wiki/XML_database XML database] | ||
:: Simple / special purpose | ::: eXist | ||
:: '''Simple / special purpose''' | |||
::: [http://en.wikipedia.org/wiki/FileMaker FileMaker] | ::: [http://en.wikipedia.org/wiki/FileMaker FileMaker] | ||
:: [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) | ||
:: '''Single file''' | |||
::: [http://www.sqlite.org/ SQLLite] | ::: [http://www.sqlite.org/ SQLLite] | ||
::: [http://en.wikipedia.org/wiki/SQL_Server_Compact_2005_Edition SQL Server Compact] (Microsoft) | |||
:: [http://en.wikipedia.org/wiki/Database_engine Database engines] (Low level, i.e. DBMS are built on top) | |||
::: [http://en.wikipedia.org/wiki/MyISAM MyISAM] (used by MySQL) | |||
::: [http://en.wikipedia.org/wiki/InnoDB InnoDB] (used by MySQL) | |||
::: [http://en.wikipedia.org/wiki/BerkeleyDB BerkeleyDB] | |||
::: [http://en.wikipedia.org/wiki/Dbm dbm] | |||
[[Category: Technologies]] | [[Category: Technologies]] | ||
[[Category: Databases]] | [[Category: Databases]] | ||
Revision as of 20:45, 12 September 2007
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
- Relational database (the model)
- XML databases and files
- XQuery (to query XML data and XML databases)
- XQuery Update Facility (Stub)
- XML databases and files
- Flat file
- Technology
- Database management system
- XML database
- eXist
- XML database
- Simple / special purpose
- Flat file database (can implement various models)
- Single file
- SQLLite
- SQL Server Compact (Microsoft)
- Single file
- Database engines (Low level, i.e. DBMS are built on top)
- MyISAM (used by MySQL)
- InnoDB (used by MySQL)
- BerkeleyDB
- dbm
- Database engines (Low level, i.e. DBMS are built on top)