Database: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Stub}}
{{Stub}}
{{Under construction}}
 
== Definition ==
 
{{quotation|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).}} ([http://en.wikipedia.org/wiki/Database Wikipedia], retrieved 22:30, 12 September 2007 (MEST)).


The goal of this (future) article is threefold (for now):
The goal of this (future) article is threefold (for now):
Line 6: Line 9:
* Point to other articles in this Wiki
* Point to other articles in this Wiki
* Show where in educational technology various kinds of databases are being used
* Show where in educational technology various kinds of databases are being used
See also: [[web application framework]], [[web service]], [[portalware]]


== A guide to Wikipedia's database articles ==
== A guide to Wikipedia's database articles ==


; General
(by no means complete, these are just some important entry points)
 
===  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/List_of_database_models List of database models]
: [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/Data_model Data model] (short overview)
 
:: [http://en.wikipedia.org/wiki/Relational_model Relational mode]
:: [http://en.wikipedia.org/wiki/Relational_model Relational model] (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]
:: 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] (can query XML data in a way)
 
:: 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
 
:: [http://en.wikipedia.org/wiki/Hierarchical_model Hierarchical model]
::: [http://en.wikipedia.org/wiki/LDAP Lightweight Directory Access Protocol] (LDAP)
 
:: [http://en.wikipedia.org/wiki/Object-relational_model Object-relational model]
 
:: [http://en.wikipedia.org/wiki/Object_model Object model]
 
:: '''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 42: Line 66:


:: [http://en.wikipedia.org/wiki/XML_database XML database]
:: [http://en.wikipedia.org/wiki/XML_database XML database]
:: Simple / special purpose
::: eXist
 
:: [http://en.wikipedia.org/wiki/Nosql NoSQL] (A whole range of non SQL databases, in particular so-called key-value stores)
 
:: LDAP
::: [http://en.wikipedia.org/wiki/List_of_LDAP_software List of LDAP software]
::: [http://en.wikipedia.org/wiki/Directory_service Directory Service]
 
:: '''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)
:: '''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/Serialization Serialization] to files in some programming languages
:: [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]
:: Client-side (don't know where to put these)
::: [http://developers.sun.com/javadb/index.jsp JavaDB], HSQL, etc. (quite heavy)
::: [http://code.google.com/p/trimpath/wiki/TrimQuery TrimQuery] and Trimpath [http://code.google.com/p/trimpath/wiki/JavaScriptTemplates JS templates]
=== Related issues ===
Databases are an important component in [http://en.wikipedia.org/wiki/Web_application webapplication]s and are integrated within [[web application framework]]s
* [http://en.wikipedia.org/wiki/Web_application_frameworks Web application framework]
* [http://en.wikipedia.org/wiki/Comparison_of_web_application_frameworks Comparison of web application frameworks]
* [http://en.wikipedia.org/wiki/List_of_web_application_frameworks List of web application frameworks]
== In this Wiki ==
Entries related to databases:
* [[SQL]]
** [[MySQL]]
** [[WAMP]] and [[LAMP]] (The X/Apache/MySQL bundles)
* [[LDAP]]
* [[XML database]]
== 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.
* [[List of web 2.0 applications|Web 2.0]] services such as [http://base.google.com/ Gogglebase] are easy ways to store simple data. E.g. for student projects.
== Links ==
* [https://highlyscalable.wordpress.com/2012/03/01/nosql-data-modeling-techniques/ NoSQL Data Modeling Techniques] by  Ilya Katsov, 2012.


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

Latest revision as of 10:40, 20 October 2016

Draft

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

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)
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

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

Related issues

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

In this Wiki

Entries related to databases:

In education

Links

Retrieved from "https://edutechwiki.unige.ch/mediawiki/index.php?title=Database&oldid=60744"