Database: Difference between revisions
m (using an external editor) |
m (→In education) |
||
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{Stub}} | {{Stub}} | ||
== Definition == | == 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 | {{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 10: | 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 == | ||
Line 66: | Line 67: | ||
:: [http://en.wikipedia.org/wiki/XML_database XML database] | :: [http://en.wikipedia.org/wiki/XML_database XML database] | ||
::: eXist | ::: eXist | ||
:: [http://en.wikipedia.org/wiki/Nosql NoSQL] (A whole range of non SQL databases, in particular so-called key-value stores) | |||
:: LDAP | :: LDAP | ||
Line 88: | Line 91: | ||
::: [http://en.wikipedia.org/wiki/Dbm dbm] | ::: [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 == | == In education == | ||
Line 94: | Line 117: | ||
* [[XML database]]s so far a thinly spread, since education always is slow to keep up with latest trends. | * [[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. | * 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: Databases]] | [[Category: Databases]] |
Latest revision as of 10:40, 20 October 2016
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)
- XML databases and files
- XQuery (to query XML data and XML databases)
- XQuery Update Facility (Stub)
- XML databases and files
- Flat file
Technology
- XML database
- eXist
- XML database
- NoSQL (A whole range of non SQL databases, in particular so-called key-value stores)
- Simple
- FileMaker
- Special purpose applications such as reference managers with their own storage engine
- Simple
- Flat file database (can implement various models)
- Single file
- SQLLite
- SQL Server Compact (Microsoft)
- Serialization to files in some programming languages
- 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)
- Client-side (don't know where to put these)
- JavaDB, HSQL, etc. (quite heavy)
- TrimQuery and Trimpath JS templates
- Client-side (don't know where to put these)
Related issues
Databases are an important component in webapplications and are integrated within web application frameworks
- Web application framework
- Comparison of web application frameworks
- List of web application frameworks
In this Wiki
Entries related to databases:
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.
- Web 2.0 services such as Gogglebase are easy ways to store simple data. E.g. for student projects.
Links
- NoSQL Data Modeling Techniques by Ilya Katsov, 2012.